- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle operation problem
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-26-2003 02:18 AM
тАО05-26-2003 02:18 AM
Re: Oracle operation problem
GReat to see you again after a long time.
Welcome back.
Expecting great answers as usual.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-26-2003 04:32 AM
тАО05-26-2003 04:32 AM
Re: Oracle operation problem
Nice to have been missed! Been kinda busy lately.
rgds
Andreas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-26-2003 05:49 PM
тАО05-26-2003 05:49 PM
Re: Oracle operation problem
I create the orapw file with orapw.
And also add
(remote_login_passwordfile = exclusive) to init
When I login SYSDBA with sys/
But I login oracle with svrmgrl(connect sys/
Why?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-26-2003 08:28 PM
тАО05-26-2003 08:28 PM
Re: Oracle operation problem
quote from above:
$ svrmgrl
SVRMGR> connect internal
Connected.
SVRMGR> connect sys/change_on_install@ora817dev
Connected.
that works OK, lets try as sysdba:
SVRMGR> connect sys/change_on_install@ora817dev as sysdba;
ORA-01017: invalid username/password; logon denied
there I got your error. My SYS password is change_on_install but the password file has yog in it. SYS is special -- sys connecting as sysdba is like internal -- you have to use the password file password!
Lets try that:
SVRMGR> connect sys/yog@ora817dev as sysdba;
Connected.
the sysdba trick is generally used to allow other NON-SYS users to connect. BTW, it is recommended that you use your OWN account that has been granted sysdba!
most probably, you are not connecting as sysdba in the DBA studio, hence the error!
i suggest, you connect using the svrmgrl and change the sys password using:
alter user sys identified by
Again, avoid using the sys account and create your own as i mentioned in my previous post.
Best Regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-26-2003 11:11 PM
тАО05-26-2003 11:11 PM
Re: Oracle operation problem
Perhaps silly, but remember to bounce your database after updating the init.ora file.
rgds
Andreas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-26-2003 11:40 PM
тАО05-26-2003 11:40 PM
Re: Oracle operation problem
there is also another point:
AFTER you created the password file you have to grant the sysdba and sysoper role to the user.
Yuo define one user in the file (user=) and his/her password (password=), after that you will have to re-grant the permission to that user.
svrmgrl> grant sysoper, sysdba to XXXXX ;
svrmgrl> commit;
HTH,
Massimo
- « Previous
-
- 1
- 2
- Next »