ORA-12162 ERROR ! help!!!!

red_yaker

[root@sun root]# su - oracle
[oracle@sun oracle]$ /opt/oracle/product/9.2.0/bin/dbstart
Database "ora9i" already started.

Database "ora9i" possibly left running when system went down (system crash?).
Notify Database Administrator.

SQL*Plus: Release 9.2.0.4.0 - Production on Tue Mar 15 16:10:36 2005

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL>; Connected.
SQL>; ORACLE instance shut down.
SQL>; Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production

SQL*Plus: Release 9.2.0.4.0 - Production on Tue Mar 15 16:10:37 2005

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL>; Connected to an idle instance.
SQL>; ORACLE instance started.

Total System Global Area  236000356 bytes
Fixed Size                   451684 bytes
Variable Size             201326592 bytes
Database Buffers           33554432 bytes
Redo Buffers                 667648 bytes
Database mounted.
Database opened.
SQL>; Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production

Database "ora9i" warm started.
Database "" already started.

Database "" possibly left running when system went down (system crash?).
Notify Database Administrator.

SQL*Plus: Release 9.2.0.4.0 - Production on Tue Mar 15 16:10:43 2005

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL>; ERROR:
ORA-12162: TNS:service name is incorrectly specified


SQL>; ORA-12162: TNS:service name is incorrectly specified
SQL>;
SQL*Plus: Release 9.2.0.4.0 - Production on Tue Mar 15 16:10:43 2005

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL>; ERROR:
ORA-12162: TNS:service name is incorrectly specified


SQL>; ORA-12162: TNS:service name is incorrectly specified
SQL>;
Database "" warm started.

Do you help me !

red_yaker

没有人能解释这个问题吗？
我自己帮自己顶一下 :em12:

sshd

do not use dbstart  to startup the database

export ORACLE_HOME=XXX
export ORACLE_SID=XXX
export PATH=$ORACLE_HOME/binPATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib

then
sqlplus '/ as sysdba'
SQL>; startup force;

red_yaker

thank you !!