topic Re: Database need password to access in Operating System - HP-UX

Database need password to access

Jacky Wong_1 — Tue, 26 Feb 2002 04:58:31 GMT

Dear All,
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

Re: Database need password to access

Steven Sim Kok Leong — Tue, 26 Feb 2002 05:05:47 GMT

Hi,

# svrmgrl
SVRMGR> connect internal
SVRMGR> select username from dba_users;
SVRMGR> alter user identified by "";

Replace with the username you lost the password and with the new password.

Hope this helps. Regards.

Steven Sim Kok Leong

Re: Database need password to access

Jacky Wong_1 — Tue, 26 Feb 2002 05:18:08 GMT

But I don't know the what username can connect this database "mbov". Because it only prompt to input password. Any place I can check the information of it.

SQL> connect mbov
Enter password:
ERROR:
ORA-01017: invalid username/password; logon denied

Regards,

Jacky

Re: Database need password to access

Alexander M. Ermes — Tue, 26 Feb 2002 15:02:06 GMT

Hi there.
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

Re: Database need password to access

John Strang — Tue, 26 Feb 2002 15:03:56 GMT

Hi Jacky,

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

Re: Database need password to access

Eric Ladner — Tue, 26 Feb 2002 15:04:25 GMT

To connect to oracle without the password, you have to be logged in as the owner of the database (usually oracle), or someone in the dba group.

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.

Re: Database need password to access

Ian Dennison_1 — Tue, 26 Feb 2002 15:05:13 GMT

There are a couple of methods you can use,..

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

Re: Database need password to access

A. Clay Stephenson — Tue, 26 Feb 2002 15:05:32 GMT

Hi:

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.

Re: Database need password to access

Jacky Wong_1 — Wed, 27 Feb 2002 02:24:04 GMT

But when I follow Steven's instruction. I got below error message:

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.

Re: Database need password to access

Steven Sim Kok Leong — Wed, 27 Feb 2002 02:42:09 GMT

Hi,

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 identified by "";

If your database is already started up, startup will fail, otherwise your database will now startup.

Hope this helps. Regards.

Steven Sim Kok Leong

Re: Database need password to access

Jacky Wong_1 — Wed, 27 Feb 2002 02:56:30 GMT

Dear Sir,
I already follow your instruction but still got the same error message:

# su - oracle
$ svrmgrl

SVRMGR> connect internal
Connected.
SVRMGR> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SVRMGR> select username from dba_users;
select username from dba_users
*
ORA-01219: database not open: queries allowed on fixed tables/views only
SVRMGR>

Any idea?

Re: Database need password to access

Eric Ladner — Wed, 27 Feb 2002 03:07:09 GMT

In that case, the database was not shut down correctly.

Issue a 'shutdown abort' (check a 'ps -eaf | grep ora_' first to make sure all the database processes are really dead already'). After it says database shutdown, type startup. The database should start in a few seconds, then you can try the select statement, which should work.

If none of that works, exit out of svrmgrl and

echo $ORACLE_HOME
echo $ORACLE_SID

and see if it prints stuff that looks reasonable. If not, set these environment variables first, then re-run svrmgrl. These environment variables MUST BE CORRECT.

Re: Database need password to access

Steven Sim Kok Leong — Wed, 27 Feb 2002 03:08:29 GMT

Hi,

The database is not opened. What does the below statement show:

SVRMGR> select status from v$instance;

Try shutting down (clean shutdown) and restarting (clean startup) the oracle instance:

SVRMGR> shutdown normal
SVRMGR> startup

Hope this helps. Regards.

Steven Sim Kok Leong