Do not use lsnrctl and sqlplus as SYSDBA in RAC

简介:

In later releases of Oracle RAC, the traditional DBA control tools for managing RAC databases have been deprecated, and all commands should use the svrctl utility.

lsnrctl:  Oracle 10g and beyond have deprecated the lsnrctl command utility, and all listener start and stop commands are done via svrctl.

sqlplus:  We no longer use SQL*Plus as SYSDBA to bounce a RAC node, in favor of the svrctl utility. 
For complete details on managing RAC with the svrctl commands, see the book Oracle Grid & Real Application Clusters.

Here are the new syntax differences to start and stop a RAC node instance:

/*+ starting a RAC node instance & listener: 

root> export ORACLE_SID=orcl1
root> srvctl start nodeapps -n linux1
root> srvctl start asm -n linux1
root> srvctl start instance -d orcldb -i orclnode
root> srvctl start mylistwener
root> emctl start dbconsole 

Or do it all in one command:

root>  svrctl start database -d orcldb 

-------------------------------------------------------------------------------- 

/*+ shutdown a RAC node instance & listener: 

root> export ORACLE_SID=orcl1
root> emctl stop dbconsole
root> srvctl stop instance -d orcldb -i orclnode immediate
root> srvctl stop asm -n linux1
root> srvctl stop nodeapps -n linux1
root> srvctl stop mylistener -I 2

Or do it all in one command:

 

root>  svrctl stop database -d orcldb
 
REF:http://www.dba-oracle.com/t_svrctl_lsnrctl_sqlplus_rac.htm
 

本文转自海天一鸥博客园博客,原文链接:http://www.cnblogs.com/sgsoft/archive/2010/12/24/1915510.html,如需转载请自行联系原作者
相关文章
|
6月前
|
Oracle 关系型数据库 5G
dbca ORA-27154:
dbca ORA-27154:
44 3
|
6月前
|
Oracle 关系型数据库
oracle Hanganalyze no RAC
oracle Hanganalyze no RAC
48 0
|
6月前
|
SQL Oracle 关系型数据库
[已解决]使用sqlplus连接oracle,提示ORA-01034和ORA-27101
[已解决]使用sqlplus连接oracle,提示ORA-01034和ORA-27101
119 0
|
SQL Oracle 关系型数据库
|
SQL Oracle 关系型数据库
|
SQL 关系型数据库 Oracle
Oracle sqlplus的arraysize
场景描述  开始我觉得这是个神奇的事情。u1用户的t1表共有大约1230块,但是对该表进行全表扫描的时候(select *),竟需要consistent gets接近7000次。  因为从正常的逻辑来理解,block从物理设备读取到内存,然后cpu从内存读取数据进行计算/过滤,这是一个完整的过程。
2596 0
|
SQL 存储 Oracle
关于oracle的sqlplus的另一些小技巧
执行脚本的命令在上一节已经讲过,不再重复。 sqlplus user/password@ip:port/servicename @/path/sqltest.sql; sqltest的内容及注释: --这个WHENEVER表示出现错误之后,不再继续执行,还会尽量回滚 WHENEVER SQLERROR EXIT SQL.
1345 0
|
SQL Oracle 网络协议