oracle 9.2 RAC rhel4.6
如果不用svrctl command
admin文档里有说sqlplus 可以启动各个节点的instance
通过以下方式:
-----------------------------------------------------
SET INSTANCE DB1;
CONNECT / AS SYSDBA;
STARTUP PFILE=$ORACLE_HOME/dbs/initsid.ora
DISCONNECT;
-----------------------------------------------------------
但是我出错了。
请问应该怎么设置,是否和验证方式和密码文件配置有误会。
[php]
[oracle@linux2 ~]$ lsnodes
linux2
linux1
[oracle@linux2 ~]$ sqlplus /nolog
SQL*Plus: Release 9.2.0.4.0 - Production on Tue Aug 26 20:38:35 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> set instance orcl1
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
SQL> conn / as sysdba
ERROR:
ORA-01031: insufficient privileges
SQL> conn sys/manager as sysdba
Connected.
SQL> select instance_name from v$instance;
INSTANCE_NAME
----------------
orcl1
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
ORA-12519: TNS:no appropriate service handler found
SQL> disc
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
SQL> set instance orcl1
ERROR:
ORA-12519: TNS:no appropriate service handler found
ERROR:
ORA-12519: TNS:no appropriate service handler found
[/php]