- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Database need password to access
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
тАО02-25-2002 08:58 PM
тАО02-25-2002 08:58 PM
I have a database but when I try to connect it, it show I need to input the password. Unluckily, I don't know the password.
I have "system" account password. How can I know what user name of this database, it own by which user account and how to check or change the password. I am using a Oracle 8.0.5 with Unix 11.0. Below is the screen display error:
SQL> connect mbov
Enter password:
ERROR:
ORA-01017: invalid username/password; logon denied
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-25-2002 09:05 PM
тАО02-25-2002 09:05 PM
Re: Database need password to access
# svrmgrl
SVRMGR> connect internal
SVRMGR> select username from dba_users;
SVRMGR> alter user
Replace
Hope this helps. Regards.
Steven Sim Kok Leong
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-25-2002 09:18 PM
тАО02-25-2002 09:18 PM
Re: Database need password to access
SQL> connect mbov
Enter password:
ERROR:
ORA-01017: invalid username/password; logon denied
Regards,
Jacky
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-26-2002 07:02 AM
тАО02-26-2002 07:02 AM
Re: Database need password to access
Do not start sqlplus. Go for the svrmgr ( servermanager ) in line mode. On the prompt svrmgr> you should type in :
connect internal
After this you should be able to change the user data.
Rgds
Alexander M. Ermes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-26-2002 07:03 AM
тАО02-26-2002 07:03 AM
Re: Database need password to access
In the example you gave
SQL> connect mbov
This means connect to the database as user mbov
It does not mean connect to a database called mbov
Steven has already given the commands to find the list of users in the database, and how to alter the pasword of a user.
When you have found the users and set the password of a user, you will then be able to connect as that user as follows
SQL> connect user/password
HTH,
John
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-26-2002 07:04 AM
тАО02-26-2002 07:04 AM
Re: Database need password to access
Then, you can enter one of two ways:
Via svrmgrl (as shown above) or like this:
sqlplus /
Then, you can alter the users password as shown above.
If you cannot become the oracle user or do not have membership in the oracle dba group, you need the assistance of your DBA.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-26-2002 07:05 AM
тАО02-26-2002 07:05 AM
Re: Database need password to access
1. set ORACLE_SID in the UNIX environment to the SID to be connected to (mbov).
2. Run 'sqlplus system/[password]@mbov'
Share and Enjoy! Ian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-26-2002 07:05 AM
тАО02-26-2002 07:05 AM
Re: Database need password to access
Steven has given you the correct answer. If you are logged in to the system as user oracle or a member od the dba group, you are allowed to simply do a connect internal. The 'internal' user is a special login.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-26-2002 06:24 PM
тАО02-26-2002 06:24 PM
Re: Database need password to access
Oracle Server Manager Release 3.0.5.0.0 - Production
(c) Copyright 1997, Oracle Corporation. All Rights Reserved.
Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production
PL/SQL Release 8.0.5.0.0 - Production
SVRMGR> connect internal
Connected.
SVRMGR> select username from dba_users;
select username from dba_users
*
ORA-01219: database not open: queries allowed on fixed tables/views only
Why??? Please suggest some idea.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-26-2002 06:42 PM
тАО02-26-2002 06:42 PM
Re: Database need password to access
Are you logged onto your oracle account? Is your database already started up? Try this:
# su - oracle
u1/> $ORACLE_HOME/bin/svrmgrl
SVRMGR> connect internal
SVRMGR> startup
SVRMGR> select username from dba_users;
SVRMGR> alter user
If your database is already started up, startup will fail, otherwise your database will now startup.
Hope this helps. Regards.
Steven Sim Kok Leong