LOST ORACLE DATABASE ADMIN PASSWORD

[Deanna Tran]

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???

[Eric Ladner]

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.

[Sanjay_6]

Hi Deanna,

Try these suggestions,

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

Hope this helps.

Regds

[Deanna Tran]

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

[SHABU KHAN]

Hi,

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

-Shabu

[SHABU KHAN]

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

[Eric Ladner]

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)

[Deanna Tran]

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

[Deanna Tran]

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

[Steven Sim Kok Leong]

Hi,

Run $ORACLE_HOME/bin/svrmgrl in full:

$ $ORACLE_HOME/bin/svrmgrl

Hope this helps. Regards.

Steven Sim Kok Leong