各位老大
RAC中如何启动CRS和数据库?
[oracle@rac1 ~]$ uname -a
Linux rac1 2.6.9-67.ELsmp #1 SMP Wed Nov 7 13:58:04 EST 2007 i686 i686 i386 GNU/Linux
节点2:
[oracle@rac2 ~]$ lsnrctl
lsnrctl: error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file: No such file or directory
[oracle@rac2 ~]$ srvctl
Exception in thread "main" java.lang.NoClassDefFoundError: oracle/ops/opsctl/OPSCTLDriver
[oracle@rac2 ~]$
节点1:
LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias
LISTENER_RAC1
Version
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date
12-AUG-2008 13:17:35
Uptime
0 days 2 hr. 22 min. 23 sec
Trace Level
off
Security
ON: Local OS Authentication
SNMP
OFF
Listener Parameter File /opt/ora10g/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /opt/ora10g/product/10.2.0/db_1/network/log/listener_rac1.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.16.90.109)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...
Service "racdb" has 1 instance(s).
Instance "racdb1", status READY, has 2 handler(s) for this service...
Service "racdbXDB" has 1 instance(s).
Instance "racdb1", status READY, has 1 handler(s) for this service...
Service "racdb_XPT" has 1 instance(s).
Instance "racdb1", status READY, has 2 handler(s) for this service...
The command completed successfully
[oracle@rac1 admin]$ srvctl config database
racdb
[oracle@rac1 admin]$ srvctl config database -d RACDB
rac1 racdb1 /opt/ora10g/product/10.2.0/db_1
rac2 racdb2 /opt/ora10g/product/10.2.0/db_1
[oracle@rac1 admin]$ srvctl status database -d RACDB
实例 racdb1 没有在 rac1 节点上运行
实例 racdb2 没有在 rac2 节点上运行
sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Aug 12 15:45:14 2008
Copyright (c) 1982, 2005, Oracle.All rights reserved.
???:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL> select * from v$active_instances;
INST_NUMBER
-----------
INST_NAME
--------------------------------------------------------------------------------
1
rac1:racdb1
SQL> select instance_name,status,host_name from v$instance;
INSTANCE_NAMESTATUS
---------------- ------------
HOST_NAME
----------------------------------------------------------------
racdb1 OPEN
rac1
[ 本帖最后由 victor1010 于 2008-8-13 09:49 编辑 ]
|