主要诉求:想用原有rac环境再建一个db
创建成功后可以通过sqlplus的方式启动数据库,但crs不能动态识别库状态
[oracle@host01 bin]$ export ORACLE_SID=RACDB_1
[oracle@host01 bin]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Mon Aug 19 21:33:37 2019
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 196681728 bytes
Fixed Size 1343864 bytes
Variable Size 134221448 bytes
Database Buffers 58720256 bytes
Redo Buffers 2396160 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
[oracle@host01 bin]$ ./crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ACFS.dg
ONLINE ONLINE host01
ONLINE ONLINE host02
ora.DATA.dg
ONLINE ONLINE host01
ONLINE ONLINE host02
ora.FRA.dg
ONLINE ONLINE host01
ONLINE ONLINE host02
ora.LISTENER.lsnr
ONLINE ONLINE host01
ONLINE ONLINE host02
ora.asm
ONLINE ONLINE host01 Started
ONLINE ONLINE host02 Started
ora.gsd
OFFLINE OFFLINE host01
OFFLINE OFFLINE host02
ora.net1.network
ONLINE ONLINE host01
ONLINE ONLINE host02
ora.ons
ONLINE ONLINE host01
ONLINE ONLINE host02
ora.registry.acfs
ONLINE ONLINE host01
ONLINE ONLINE host02
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE host02
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE host02
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE host01
ora.ai.db
1 ONLINE ONLINE host01 Open
2 ONLINE ONLINE host02 Open
ora.cvu
1 ONLINE ONLINE host01
ora.host01.vip
1 ONLINE ONLINE host01
ora.host02.vip
1 ONLINE ONLINE host02
ora.oc4j
1 ONLINE ONLINE host01
ora.racdb.db
1 ONLINE OFFLINE Instance Shutdown
2 ONLINE OFFLINE Instance Shutdown
ora.scan1.vip
1 ONLINE ONLINE host02
ora.scan2.vip
1 ONLINE ONLINE host02
ora.scan3.vip
1 ONLINE ONLINE host01
使用srvctl命令启动后:
[oracle@host01 bin]$ srvctl start database -d RACDB
PRCR-1079 : Failed to start resource ora.racdb.db
CRS-2643: The server pool(s) where resource 'ora.racdb.db' could run have no servers
找了很长时间crsctl和srvctl没有找到启动srvpool的命令
查看监听信息:
Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File /u01/app/grid/diag/tnslsnr/host01/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.0.2.113)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.0.2.101)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.0.2.103)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "RACDB" has 2 instance(s).
Instance "RACDB", status UNKNOWN, has 1 handler(s) for this service...
Instance "RACDB_1", status READY, has 2 handler(s) for this service...
Service "RACDBXDB" has 1 instance(s).
Instance "RACDB_1", status READY, has 1 handler(s) for this service...
Service "ai" has 3 instance(s).
Instance "ai", status UNKNOWN, has 1 handler(s) for this service...
Instance "ai1", status READY, has 2 handler(s) for this service...
Instance "ai2", status READY, has 1 handler(s) for this service...
Service "aiXDB" has 2 instance(s).
Instance "ai1", status READY, has 1 handler(s) for this service...
Instance "ai2", status READY, has 1 handler(s) for this service...
The command completed successfully
----------------------------------------
远程连接没问题:
[oracle@edbjr2p1 admin]$ sqlplus sys/oracle@racdb as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Mon Aug 19 22:30:15 2019
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> sho parameter name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert string
db_name string RACDB
db_unique_name string RACDB
global_names boolean FALSE
instance_name string RACDB_1
lock_name_space string
log_file_name_convert string
processor_group_name string
service_names string RACDB
SQL> !hostname
edbjr2p1
请问,如何让crs动态识别库状态信息