topic Re: LOST ORACLE DATABASE ADMIN PASSWORD in Operating System - HP-UX

LOST ORACLE DATABASE ADMIN PASSWORD

Deanna Tran — Tue, 26 Feb 2002 21:46:23 GMT

I tried to login to sqlplus to start up the database, but i was unable to do so...
this is what i did
1.login as root
2. su - oracle
3. sqplus /nolog
4. CONNECT SYS/CHANGE_ON_INSTALL AS SYSDBA
5. give me this error message :
ERROR:
ORA-12705: invalid or unknown NLS parameter value specified

So now i need help.....
...In addition, I have read through this thread...I wasn't able to find svmgrl (server manager) in my system?...can you help me with this also???

Re: LOST ORACLE DATABASE ADMIN PASSWORD

Eric Ladner — Tue, 26 Feb 2002 21:59:31 GMT

Try this:

su - oracle
sqlplus /
alter user system identified by foo;
alter user sys identified by foo;

Also, it's svrmgrl located in $ORACLE_HOME/bin. My apologies if you typoed in the original message.

Re: LOST ORACLE DATABASE ADMIN PASSWORD

Sanjay_6 — Tue, 26 Feb 2002 22:51:27 GMT

Hi Deanna,

Try these suggestions,

http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x280acb60e503d6118ff40090279cd0f9,00.html

Hope this helps.

Regds

Re: LOST ORACLE DATABASE ADMIN PASSWORD

Deanna Tran — Wed, 27 Feb 2002 01:19:25 GMT

hi,
I am still unable to locate the svmgrl file
....i tried everythings that you have suggested still unsuccessful...

the $HOME_ORACLE/bin you said where the svmgrl file is at...I search in there ...and nothing ...was found...

Re: LOST ORACLE DATABASE ADMIN PASSWORD

SHABU KHAN — Wed, 27 Feb 2002 01:26:45 GMT

Hi,

Are you looking for the right binary as Eric pointed out .. it is svrmgrl and not svmgrl ?

-Shabu

Re: LOST ORACLE DATABASE ADMIN PASSWORD

SHABU KHAN — Wed, 27 Feb 2002 01:46:59 GMT

Hi,

svrmgrl
SVRMGR>connect internal
SVRMGR>startup

To shutdown:
SVRMGR>connect internal
SVRMGR>shutdown normal
or
SVRMGR>shutdown immediate

you could do a help at the prompt for more information
SVRMGR> help
The following are SIMPLIFIED syntax descriptions. For complete syntax
descriptions, please refer to the Oracle Server Manager User's Guide.

STARTUP [DBA] [FORCE] [PFILE=filespec] [EXCLUSIVE | SHARED]
[MOUNT dbname | OPEN dbname] [NOMOUNT]

SHUTDOWN [NORMAL | IMMEDIATE | ABORT]

MONITOR For graphical modes only, bring up a monitor

ARCHIVE LOG [START] [STOP] [LIST] [NEXT] [] [ALL] ['destination']

RECOVER { [DATABASE [MANUAL] ] | [TABLESPACE ts-name [,tsname]] }

CONNECT [username [/password] ] [INTERNAL] ['@'instance-spec]
DISCONNECT

SET options: INSTANCE, ECHO, TERMOUT, TIMING, NUMWIDTH, CHARWIDTH
SHOW LONGWIDTH, DATEWIDTH, AUTOPRINT and for SHOW: ALL, SPOOL

EXIT
REM
SQL statements can also be executed.

-Shabu

Re: LOST ORACLE DATABASE ADMIN PASSWORD

Eric Ladner — Wed, 27 Feb 2002 01:49:01 GMT

Oops.. I'm sorry. I thought you had a running database and needed to change the password for system and sys.

If you have an Oracle 8.1 or higher database, you don't need svrmgrl anyway.

To startup the database:

# su - oracle
# # Make sure your ORACLE_HOME and ORACLE_SID are set correctly
$ sqlplus internal
(It should say something about "connected to an idle instance"
SQL> startup
...
SQL> exit

I'm not sure about oracle 8.0. I can't remember off the top of my head if sqlplus was able to function like that under that level. Wouldn't hurt to try.

If it complains the database is running, do a 'shutdown abort' then a startup, but only if you have verified that there are NO database processes running (i.e. 'ps -eaf | grep ora_' returns nothing)

Re: LOST ORACLE DATABASE ADMIN PASSWORD

Deanna Tran — Wed, 27 Feb 2002 02:29:20 GMT

I echo $ORACLE_HOME and i know it is in u01 ...

this is what i did
1. echo $ORACLE_HOME/bin
2. svrmgrl
3. still can't find that

Re: LOST ORACLE DATABASE ADMIN PASSWORD

Deanna Tran — Wed, 27 Feb 2002 02:33:27 GMT

When i did ps -ef | grep ora
I saw a lot of processor running...
I currently have oracle 9i on my system...

Re: LOST ORACLE DATABASE ADMIN PASSWORD

Steven Sim Kok Leong — Wed, 27 Feb 2002 02:36:17 GMT

Hi,

Run $ORACLE_HOME/bin/svrmgrl in full:

$ $ORACLE_HOME/bin/svrmgrl

Hope this helps. Regards.

Steven Sim Kok Leong