- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Lost Oracle administrator username and passwor...
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
тАО01-07-2002 11:20 PM
тАО01-07-2002 11:20 PM
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-07-2002 11:29 PM
тАО01-07-2002 11:29 PM
Solution- login as root
- su - oracle
- svrmgrl
- connect interal
- and change password
(if you have a password file which disallows connect internal, you can recreate the password file when logged on as oracle)
regards,
Thierry.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-07-2002 11:38 PM
тАО01-07-2002 11:38 PM
Re: Lost Oracle administrator username and password that run on Unix system
Thanks for your reply.But when I logon oracle by su username, do I need to provide password at the same time? Thanks for your help.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-08-2002 12:03 AM
тАО01-08-2002 12:03 AM
Re: Lost Oracle administrator username and password that run on Unix system
su - oracle
(don't need password)
export ORACLE_SID=
svrmgrl
connect internal
alter user system identified by
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-08-2002 12:06 AM
тАО01-08-2002 12:06 AM
Re: Lost Oracle administrator username and password that run on Unix system
That is what Thierry is explaining.
Login as root.
issue
#passwd oracle
to change the password
or
#su - oracle
to change to oracle.
As this is super user you do not need permissions.
10 points to Thierry
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-08-2002 12:53 AM
тАО01-08-2002 12:53 AM
Re: Lost Oracle administrator username and password that run on Unix system
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-08-2002 01:14 AM
тАО01-08-2002 01:14 AM
Re: Lost Oracle administrator username and password that run on Unix system
Try using the changed password to connect either using sqldba or sqlplus.
I suppose you realised you had forgotten your password only after attempting an oracle connection right?
Hope this helps. Regards.
Steven Sim Kok Leong
Brainbench MVP for Unix Admin
http://www.brainbench.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-08-2002 07:48 PM
тАО01-08-2002 07:48 PM
Re: Lost Oracle administrator username and password that run on Unix system
login into oracle user.
echo $ORACLE_SID(test your ORACLE_SID)
$svrmgrl
SVRMGR>connect internal
The oracle administrator users are sys and system
to find the usernames
SVRMGR>select username from dba_users;
SVRMGR>alter user system identified by "
The ouput will be "statement processed"
Then you can connect using the user 'system'.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-09-2002 09:05 PM
тАО01-09-2002 09:05 PM
Re: Lost Oracle administrator username and password that run on Unix system
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-09-2002 09:38 PM
тАО01-09-2002 09:38 PM
Re: Lost Oracle administrator username and password that run on Unix system
Here is the Oracle export/import FAQ:
http://www.orafaq.com/faqiexp.htm
For purpose of backup and restoration of Oracle databases, personally I prefer omniback which is more secure (encryption) and fast (software compression).
Hope this helps. Regards.
Steven Sim Kok Leong
Brainbench MVP for Unix Admin
http://www.brainbench.com