|
 |
datastage 无法启动服务 -->解决方法
datastage sequence 调度出现的错误问题 -->解决方法
datastage sequence 调度不起JOB 问题 -->解决方法
datastage sequence 调度失败 问题 -->解决方法
datastage sequence Job 自动失败 问题 -->解决方法
Job control process has failed. -->解决方法
datastage 字符集问题 -->解决方法
datastage VersionControl问题 -->解决方法
datastage 连接 Oracle 数据库问题 -->解决方法
|
datastage源端能连接数据库，但是job一运行就报错ORA-12154;TNS:could not resolve the connect identifier specified;
|
datastage源端能连接数据库，但是job一运行就报错ORA-12154;TNS:could not resolve the connect identifier specified
datastage在单独打开源端和目标端都能连接上数据库并能查看数据，就是单独执行datastage的job的时候就报错：
Oracle_Connector_0: The connector could not establish connection to Oracle server misorcl.
Method: OCIServerAttach, Error code: 12,154,-->解决方法
Error message ORA-12154: -->解决方法
TNS:could not resolve the connect identifier specified.
(CC_OraConnection::verifyConnection, file CC_OraConnection.cpp, line 4,390)；
|
datastage连接中断(81002)-->解决方法
|
TWS中的“Error 81002 waiting for job”-->解决方法
"Error 81002 waiting for job" in TWS, can the allowed runtime be extended?TWS中的“Error 81002 waiting for job”.
TWS 中运行的 Informatica 和 Datastage 当作业运行时间超过 4 小时 TWS 作业使用失败并出现以下错误.
|
"Error calling subroutine: *DataStage*DSR.ADMIN (Action=10); check
DataStage is set up correctly in project UV (Internal Error (39207))"
Now when I click on OK button I get another error saying
"Error calling subroutine: *DataStage*DSR_SELECT(Action=2); check
DataStage is set up correctly in project uv (The connection is
broken(81002))"
Now when I click on OK button I get another error saying
"Error calling subroutine: *DataStage*DSR.ADMIN(Action=2); check DataStge
is set up correctly in project uv (The connection is broken(81002))"
Now when I click on OK button I get another error saying
"Access on this host has been temporarily restricted to Administrators
only, until there is at least 1 project"
All these errors happen in succession.
I am not able to understand why is this happening. I am logging in is a
Administrator, I have 2 projects test and Tutorial1. I am using Redhat 6.2
server. and oracle server database.
|
ORA-12500: TNS:listener failed -->解决方法
ORA-12500: TNS:listener failed to start a dedicated server process
Cause: The process of starting up a dedicated server process failed. The
executable could not be found or the environment may be set up incorrectly.
Action: Turn on tracing at the ADMIN level and reexecute the operation. Verify
that the ORACLE Server executable is present and has execute permissions
enabled. Ensure that the ORACLE environment is specified correctly in
LISTENER.ORA. The Oracle Protocol Adapter that is being called may not be
installed on the local hard drive. Please check that the correct Protocol Adapter are
successfully linked.
|
|
12500：TNS：监听程序无法启动 -->解决方法
12500：TNS：监听程序无法启动专用服务器进程
原因：启动一个专用服务器进程进程失败。那个
可执行文件找不到或环境可能设置不正确。
行动：在后台管理级跟踪打开和重新执行该操作。验证
甲骨文服务器的可执行文件存在，并已执行权限
启用。确保在Oracle环境中正确指定
监听器。甲骨文的协议适配器被调用不得
安装在本地硬盘驱动器。请检查是正确的协议适配器
成功地联系在一起。
|
|
ORA-12203: TNS:无法与目标连接 -->解决方法
ORA-12154: TNS: 无法处理服务名 -->解决方法
|
 |
|
ORA-00311: cannot read header from archived log -->解决方法
ORA-00334: archived log: +DATA/ -->解决方法
ORA-15081 failed to submit an I/O operation to a disk -->解决方法
ORA-27072: File I/O error -->解决方法
Linux-x86_64 Error: 5: Input/output error -->解决方法
Error in file /u01/app/oracle/diag/rdbms -->解决方法
ORA-00202: control file: +DATA -->解决方法
ORA-15081: failed to submit an I/O operation to a disk -->解决方法
ORA-27072: File I/O error -->解决方法
Linux-x86_64 Error: 5: Input/output error -->解决方法
|
|
 |
|
CRS-0184: Cannot communicate with the CRS daemon-->解决方法 |
+ASM1 CRS-0184: Cannot communicate with the CRS daemon-->解决方法 |
+ASM2 CRS-0184: Cannot communicate with the CRS daemon-->解决方法 |
|
Grid 1$ CRS-0184: Cannot communicate with the CRS daemon-->解决方法 |
Grid 2$ CRS-0184: Cannot communicate with the CRS daemon-->解决方法 |
Oracle RAC ASM1 CRS-0184: Cannot communicate with the CRS daemon-->解决方法 |
Oracle RAC ASM2 CRS-0184: Cannot communicate with the CRS daemon-->解决方法 |
|
CRS-2672: Attempting to start 'ora.asm' on 'TTTTDB2'
CRS-2676: Start of 'ora.asm' on 'TTTTDB2' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'TTTTDB2'
CRS-2676: Start of 'ora.crsd' on 'TTTTDB2' succeeded
|
|
CRS-4124: Oracle HighAvailability Services startup failed，数据恢复技术服务-->解决方法 |
|
|
Start of `ora.ttttdb.db` on member `TTTTDB1` failed.
Attempting to stop `ora.ttttdb.db` on member `TTTTDB1`
Start of `ora.oc4j` on member `TTTTDB2` succeeded.
Start of `ora.ttttdb.db` on member `TTTTDB2` succeeded.
Stop of `ora.ttttdb.db` on member `TTTTDB1` succeeded.
Attempting to stop `ora.LISTENER.lsnr` on member `TTTTDB1`
Stop of `ora.LISTENER.lsnr` on member `TTTTDB1` succeeded.
Attempting to stop `ora.TTTTDB1.vip` on member `TTTTDB1`
Stop of `ora.TTTTDB1.vip` on member `TTTTDB1` succeeded.
CRS-2632: There are no more servers to try to place resource 'ora.ttttdb.db' on that would satisfy its placement policy
CRS-0223: Resource 'ora.CRS.dg' has placement error.
CRS-0223: Resource 'ora.NDATA.dg' has placement error.
CRS-0223: Resource 'ora.NFRA.dg' has placement error.
CRS-0223: Resource 'ora.asm' has placement error.
CRS-2660: Resource 'ora.gsd' or all of its instances are disabled
CRS-0223: Resource 'ora.net1.network' has placement error.
CRS-0223: Resource 'ora.ons TTTTDB1 1' has placement error.
CRS-0223: Resource 'ora.ons TTTTDB2 1' has placement error.
CRS-0223: Resource 'ora.registry.acfs' has placement error.
CRS-0223: Resource 'ora.TTTTDB1.ASM1.asm' has placement error.
CRS-2660: Resource 'ora.TTTTDB1.gsd' or all of its instances are disabled
CRS-0223: Resource 'ora.TTTTDB2.ASM2.asm' has placement error.
CRS-2660: Resource 'ora.TTTTDB2.gsd' or all of its instances are disabled
CRS-0223: Resource 'ora.ttttdb.db 1 1' has placement error.
|
|
TTTTDB1:/home/grid$crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.CRS.dg ora....up.type OFFLINE OFFLINE TTTTDB1 -->解决方法
ora....ER.lsnr ora....er.type OFFLINE OFFLINE TTTTDB2
ora....N1.lsnr ora....er.type OFFLINE OFFLINE TTTTDB2
ora.DATA.dg ora....up.type OFFLINE OFFLINE TTTTDB1 -->解决方法
ora.FRA1.dg ora....up.type OFFLINE OFFLINE TTTTDB1 -->解决方法
ora.asm ora.asm.type OFFLINE OFFLINE TTTTDB1
ora.cvu ora.cvu.type OFFLINE OFFLINE TTTTDB2
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora....network ora.....type OFFLINE OFFLINE TTTTDB1
ora.oc4j ora.oc4j.type OFFLINE OFFLINE TTTTDB2
ora.ons ora.ons.type OFFLINE OFFLINE TTTTDB1
ora....ry.acfs ora....fs.type OFFLINE OFFLINE TTTTDB1
ora.scan1.vip ora....ip.type OFFLINE OFFLINE TTTTDB2
ora....SM1.asm application OFFLINE OFFLINE TTTTDB1
ora....B1.lsnr application OFFLINE OFFLINE
ora....db1.gsd application OFFLINE OFFLINE
ora....db1.ons application OFFLINE OFFLINE TTTTDB1
ora....db1.vip ora....t1.type OFFLINE OFFLINE
ora....SM2.asm application OFFLINE OFFLINE TTTTDB2
ora....B2.lsnr application OFFLINE OFFLINE TTTTDB2
ora....db2.gsd application OFFLINE OFFLINE
ora....db2.ons application OFFLINE OFFLINE TTTTDB2
ora....db2.vip ora....t1.type OFFLINE OFFLINE TTTTDB2
ora.ttttdb.db ora....se.type OFFLINE ONLINE TTTTDB2
TTTTDB1:/home/grid$
|
|
TTTTDB2:/home/grid$crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.CRS.dg ora....up.type OFFLINE OFFLINE TTTTDB1 -->解决方法
ora....ER.lsnr ora....er.type OFFLINE OFFLINE TTTTDB2
ora....N1.lsnr ora....er.type OFFLINE OFFLINE TTTTDB2
ora.DATA.dg ora....up.type OFFLINE OFFLINE TTTTDB1 -->解决方法
ora.FRA1.dg ora....up.type OFFLINE OFFLINE TTTTDB1 -->解决方法
ora.asm ora.asm.type OFFLINE OFFLINE TTTTDB1
ora.cvu ora.cvu.type OFFLINE OFFLINE TTTTDB2
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora....network ora.....type OFFLINE OFFLINE TTTTDB1
ora.oc4j ora.oc4j.type OFFLINE OFFLINE TTTTDB2
ora.ons ora.ons.type OFFLINE OFFLINE TTTTDB1
ora....ry.acfs ora....fs.type OFFLINE OFFLINE TTTTDB1
ora.scan1.vip ora....ip.type OFFLINE OFFLINE TTTTDB2
ora....SM1.asm application OFFLINE OFFLINE TTTTDB1
ora....B1.lsnr application OFFLINE OFFLINE
ora....db1.gsd application OFFLINE OFFLINE
ora....db1.ons application OFFLINE OFFLINE TTTTDB1
ora....db1.vip ora....t1.type OFFLINE OFFLINE
ora....SM2.asm application OFFLINE OFFLINE TTTTDB2
ora....B2.lsnr application OFFLINE OFFLINE TTTTDB2
ora....db2.gsd application OFFLINE OFFLINE
ora....db2.ons application OFFLINE OFFLINE TTTTDB2
ora....db2.vip ora....t1.type OFFLINE OFFLINE TTTTDB2
ora.ttttdb.db ora....se.type OFFLINE ONLINE TTTTDB2
TTTTDB2:/home/grid$
|
|
TTTTDB1:/home/grid$
CRS-5702: Resource 'ora.CRS.dg' is already running on 'TTTTDB1'
CRS-5702: Resource 'ora.NDATA.dg' is already running on 'TTTTDB1'
CRS-5702: Resource 'ora.NFRA.dg' is already running on 'TTTTDB1'
CRS-5702: Resource 'ora.asm' is already running on 'TTTTDB1'
CRS-2501: Resource 'ora.gsd' is disabled
CRS-5702: Resource 'ora.net1.network' is already running on 'TTTTDB1'
CRS-5702: Resource 'ora.registry.acfs' is already running on 'TTTTDB1'
CRS-5702: Resource 'ora.asm' is already running on 'TTTTDB1'
CRS-2501: Resource 'ora.gsd' is disabled
CRS-5702: Resource 'ora.asm' is already running on 'TTTTDB1'
CRS-2501: Resource 'ora.gsd' is disabled
CRS-5017: The resource action "ora.ttttdb.db start" encountered the following error:
|
|
[root@rac1 bin]# ./crsctlstart crs
CRS-4124: Oracle HighAvailability Services startup failed. (错误) -->解决方法
CRS-4000: Command Startfailed, or completed with errors. -->解决方法
[root@rac2 bin]#./crsctl check crs
CRS-4638: Oracle High AvailabilityServices is OFFLINE
CRS-4535: Cannot communicate with ClusterReady Services
CRS-4530: Communications failure contactingCluster Synchronization Services daemon
CRS-4534: Cannotcommunicate with Event Manager
[root@rac1 bin]# ./crsctlstart cluster -all
CRS-5702: Resource 'ora.crsd' is alreadyrunning on 'rac1'
CRS-5702: Resource 'ora.crsd' is alreadyrunning on 'rac2'
[root@rac2 u01]# sh crs_stat.sh
Name Target State Host
------------------------------ ------------------- -------
ora.DATA.dg OFFLINE OFFLINE rac1
ora.FRA.dg OFFLINE OFFLINE rac1
ora.LISTENER.lsnr OFFLINE OFFLINE rac1
ora.LISTENER_SCAN1.lsnr OFFLINE OFFLINE rac2
ora.OCRVOTING.dg OFFLINE OFFLINE rac1
ora.asm OFFLINE OFFLINE rac1
ora.dave.db OFFLINE OFFLINE
ora.eons OFFLINE OFFLINE rac1
ora.gsd OFFLINE OFFLINE
ora.net1.network OFFLINE OFFLINE rac1
ora.oc4j OFFLINE OFFLINE
ora.ons OFFLINE OFFLINE rac1
ora.rac1.ASM1.asm OFFLINE OFFLINE rac1
ora.rac1.LISTENER_RAC1.lsnr OFFLINE OFFLINE rac1
ora.rac1.gsd OFFLINE OFFLINE
ora.rac1.ons OFFLINE OFFLINE rac1
ora.rac1.vip OFFLINE OFFLINE rac1
ora.rac2.ASM2.asm OFFLINE OFFLINE rac2
ora.rac2.LISTENER_RAC2.lsnr OFFLINE OFFLINE rac2
ora.rac2.gsd OFFLINE OFFLINE
ora.rac2.ons OFFLINE OFFLINE rac2
ora.rac2.vip OFFLINE OFFLINE rac2
ora.scan1.vip OFFLINE OFFLINE rac2
|
|
CRS-2765:Resource 'ora.cssdmonitor' has failed on server 'TTTTDB1'.
[ohasd(4259970)]CRS-2765:Resource 'ora.cssdmonitor' has failed on server 'TTTTDB1'.
2023-02-18 11:52:53.722
[ohasd(4259970)]CRS-2767:Resource state recovery not attempted for 'ora.diskmon' as its target state is OFFLINE
|
|
[ohasd(4259970)]CRS-2767:Resource state recovery not attempted for 'ora.diskmon' as its target state is OFFLINE
[cssd(5439522)]CRS-1714:Unable to discover any voting files, retrying discovery in 15 seconds;
Details at (:CSSNM00070:)in /u01/app/product/11.2.0/grid/log/TTTTDB1/cssd/ocssd.log
[cssd(5439522)]CRS-1714:Unable to discover any voting files, retrying discovery in 15 seconds;
Details at (:CSSNM00070:) in /u01/app/product/11.2.0/grid/log/TTTTDB1/cssd/ocssd.log
[cssd(5439522)]CRS-1714:Unable to discover any voting files, retrying discovery in 15 seconds;
Details at (:CSSNM00070:) in /u01/app/product/11.2.0/grid/log/TTTTDB1/cssd/ocssd.log
|
|
[ohasd(4259970)]CRS-2767:Resource state recovery not attempted for 'ora.diskmon' as its target state is OFFLINE
[cssd(5439522)]CRS-1714:Unable to discover any voting files, retrying discovery in 15 seconds;
Details at (:CSSNM00070:) in /u01/app/product/11.2.0/grid/log/TTTTDB2/cssd/ocssd.log
[cssd(5439522)]CRS-1714:Unable to discover any voting files, retrying discovery in 15 seconds;
Details at (:CSSNM00070:) in /u01/app/product/11.2.0/grid/log/TTTTDB2/cssd/ocssd.log
[cssd(5439522)]CRS-1714:Unable to discover any voting files, retrying discovery in 15 seconds;
Details at (:CSSNM00070:) in /u01/app/product/11.2.0/grid/log/TTTTDB2/cssd/ocssd.log
|
|
TTTTDB1:~>
CRS-4638:Oracle High Availability Servicesis online
CRS-4535:Cannotcommunicate with ClusterReady Services -->解决方法
CRS-4530:Communications failure contacting Cluster Synchronization Services daemon
CRS-4534:Cannotcommunicate with EventManager
|
|
TTTTDB1:/home/grid$
CRS-4638: Oracle High Availability Services is online
CRS-4535: Cannot communicate with Cluster Ready Services -->解决方法
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
TTTTDB1:/home/grid$
|
|
TTTTDB1:/home/grid$
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.asm
1 OFFLINE OFFLINE Instance Shutdown
ora.cluster_interconnect.haip
1 ONLINE ONLINE TTTTDB1
ora.crf
1 ONLINE ONLINE TTTTDB1
ora.crsd
1 ONLINE OFFLINE -->解决方法
ora.cssd
1 ONLINE ONLINE TTTTDB1
ora.cssdmonitor
1 ONLINE ONLINE TTTTDB1
ora.ctssd
1 ONLINE ONLINE TTTTDB1 ACTIVE:0
ora.diskmon
1 OFFLINE OFFLINE -->解决方法
ora.drivers.acfs
1 ONLINE ONLINE TTTTDB1
ora.evmd
1 ONLINE ONLINE TTTTDB1
ora.gipcd
1 ONLINE ONLINE TTTTDB1
ora.gpnpd
1 ONLINE ONLINE TTTTDB1
ora.mdnsd
1 ONLINE ONLINE TTTTDB1
TTTTDB1:/home/grid$
|
|
TTTTDB2:/home/grid$
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.asm
1 OFFLINE OFFLINE Instance Shutdown
ora.cluster_interconnect.haip
1 ONLINE ONLINE TTTTDB2
ora.crf
1 ONLINE ONLINE TTTTDB2
ora.crsd
1 ONLINE OFFLINE -->解决方法
ora.cssd
1 ONLINE ONLINE TTTTDB2
ora.cssdmonitor
1 ONLINE ONLINE TTTTDB2
ora.ctssd
1 ONLINE ONLINE TTTTDB2 ACTIVE:0
ora.diskmon
1 OFFLINE OFFLINE -->解决方法
ora.drivers.acfs
1 ONLINE ONLINE TTTTDB2
ora.evmd
1 ONLINE ONLINE TTTTDB2
ora.gipcd
1 ONLINE ONLINE TTTTDB2
ora.gpnpd
1 ONLINE ONLINE TTTTDB2
ora.mdnsd
1 ONLINE ONLINE TTTTDB2
TTTTDB2:/home/grid$
|
|
TTTTDB1:~> crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online -->解决方法
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
|
|
TTTTDB2:/home/grid$crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4535: Cannot communicate with Cluster Ready Services -->解决方法
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
TTTTDB1:/home/grid$
|
|
SQL> select name,state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
CRS MOUNTED
DATA1 CONNECTED -->解决方法
FRA1 CONNECTED -->解决方法
|
|
TTTTDB1:/u01/app/11.2.0/grid/bin$
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED NORMAL N 512 4096 1048576 15362 14434 5120 3657 0 Y CRSDG/
MOUNTED CONNECTED N 512 4096 1048576 2024000 170044 0 585022 0 N DATA1/
TTTTDB1:/u01/app/11.2.0/grid/bin$
|
|
TTTTDB1:/u01/app/11.2.0/grid/bin$
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED NORMAL N 512 4096 1048576 15362 14434 5120 3657 0 Y CRSDG/
MOUNTED NORMAL N 512 4096 1048576 2024000 170044 0 585022 0 N DATA/
TTTTDB1:/u01/app/11.2.0/grid/bin$
|
|
TTTTDB1:/home/oracle$sqlplus /nolog
SQL*Plus: Release 11.2.0.3.0 Production on 星期一 1月 6 23:24:26 2023
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORA-01102: cannot mount database in EXCLUSIVE mode -->解决方法
SQL>
|
|
TTTTDB2:/home/oracle$sqlplus /nolog
SQL*Plus: Release 11.2.0.3.0 Production on 星期一 1月 6 23:24:26 2023
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORA-01102: cannot mount database in EXCLUSIVE mode -->解决方法
SQL>
|
|
错误：ORA-01102: cannot mount database in EXCLUSIVE mode -->解决方法
|
|
TTTTDB1 >startup
ORACLE instance started.
Total System Global Area 941600768 bytes
Fixed Size 1348860 bytes
Variable Size 549456644 bytes
Database Buffers 385875968 bytes
Redo Buffers 4919296 bytes
ORA-01102: cannot mount database in EXCLUSIVE mode
|
|
TTTTDB2 >startup
ORACLE instance started.
Total System Global Area 941600768 bytes
Fixed Size 1348860 bytes
Variable Size 549456644 bytes
Database Buffers 385875968 bytes
Redo Buffers 4919296 bytes
ORA-01102: cannot mount database in EXCLUSIVE mode
|
|
MMNL started with pid=16, OS id=20451
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /u01/app/oracle
ALTER DATABASE MOUNT
sculkget: failed to lock /u01/app/oracle/product/11.2.0/db1/dbs/ exclusive
sculkget: lock held by PID: 17127
ORA-09968: unable to lock file
Linux Error: 11: Resource temporarily unavailable
Additional information: 17127
ORA-1102 signalled during: ALTER DATABASE MOUNT...
|
|
ora.ttttdb.db
1 ONLINE ONLINE TTTTDB1 Open
2 ONLINE OFFLINE Instance Shutdown -->解决方法
|
|
ora.ttttdb.db
1 ONLINE ONLINE TTTTDB2 Open
2 ONLINE OFFLINE Instance Shutdown -->解决方法
|
|
TTTTDB1:>
Oracle RAC 集群启动实例 PRCR-1079、CRS-5017、ORA-01102 cannot mount database in EXCLUSIVE mode
RAC环境：Oracle 11g R2 RAC集群 在做异机恢复时，通过srvctl start database -d 命令启动数据实例，
遇到ORA-01102 cannot mount database in EXCLUSIVE mode错误.导致只有一个节点能起来.另 一个节点启动数据库失败.
ORA-01102 cannot mount database in EXCLUSIVE mode -->解决方法
|
|
TTTTDB2:>
Oracle RAC 集群启动实例 PRCR-1079、CRS-5017、ORA-01102 cannot mount database in EXCLUSIVE mode
RAC环境：Oracle 11g R2 RAC集群 在做异机恢复时，通过srvctl start database -d 命令启动数据实例，
遇到ORA-01102 cannot mount database in EXCLUSIVE mode错误.导致只有一个节点能起来.另 一个节点启动数据库失败.
ORA-01102 cannot mount database in EXCLUSIVE mode -->解决方法
|
|
TTTTDB1:/home/grid$crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.CRS.dg ora....up.type ONLINE ONLINE TTTTDB1
ora....ER.lsnr ora....er.type ONLINE ONLINE TTTTDB1
ora....N1.lsnr ora....er.type ONLINE ONLINE TTTTDB2
ora.DATA1.dg ora....up.type ONLINE ONLINE TTTTDB1
ora.FRA1.dg ora....up.type ONLINE ONLINE TTTTDB1
ora.asm ora.asm.type ONLINE ONLINE TTTTDB1
ora.cvu ora.cvu.type ONLINE ONLINE TTTTDB2
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora....network ora....rk.type ONLINE ONLINE TTTTDB1
ora.oc4j ora.oc4j.type ONLINE ONLINE TTTTDB2
ora.ons ora.ons.type ONLINE ONLINE TTTTDB1
ora....ry.acfs ora....fs.type ONLINE ONLINE TTTTDB1
ora.scan1.vip ora....ip.type ONLINE ONLINE TTTTDB2
ora....SM1.asm application ONLINE ONLINE TTTTDB1
ora....B1.lsnr application ONLINE ONLINE TTTTDB1
ora....db1.gsd application OFFLINE OFFLINE
ora....db1.ons application ONLINE ONLINE TTTTDB1
ora....db1.vip ora....t1.type ONLINE ONLINE TTTTDB1
ora....SM2.asm application ONLINE ONLINE TTTTDB2
ora....B2.lsnr application ONLINE ONLINE TTTTDB2
ora....db2.gsd application OFFLINE OFFLINE
ora....db2.ons application ONLINE ONLINE TTTTDB2
ora....db2.vip ora....t1.type ONLINE ONLINE TTTTDB2
ora.ttttdb.db ora....se.type ONLINE ONLINE TTTTDB1
TTTTDB1:/home/grid$
|
|
TTTTDB2:/home/grid$crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.CRS.dg ora....up.type ONLINE ONLINE TTTTDB1
ora....ER.lsnr ora....er.type ONLINE ONLINE TTTTDB1
ora....N1.lsnr ora....er.type ONLINE ONLINE TTTTDB2
ora.DATA1.dg ora....up.type ONLINE ONLINE TTTTDB1
ora.FRA1.dg ora....up.type ONLINE ONLINE TTTTDB1
ora.asm ora.asm.type ONLINE ONLINE TTTTDB1
ora.cvu ora.cvu.type ONLINE ONLINE TTTTDB2
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora....network ora....rk.type ONLINE ONLINE TTTTDB1
ora.oc4j ora.oc4j.type ONLINE ONLINE TTTTDB2
ora.ons ora.ons.type ONLINE ONLINE TTTTDB1
ora....ry.acfs ora....fs.type ONLINE ONLINE TTTTDB1
ora.scan1.vip ora....ip.type ONLINE ONLINE TTTTDB2
ora....SM1.asm application ONLINE ONLINE TTTTDB1
ora....B1.lsnr application ONLINE ONLINE TTTTDB1
ora....db1.gsd application OFFLINE OFFLINE
ora....db1.ons application ONLINE ONLINE TTTTDB1
ora....db1.vip ora....t1.type ONLINE ONLINE TTTTDB1
ora....SM2.asm application ONLINE ONLINE TTTTDB2
ora....B2.lsnr application ONLINE ONLINE TTTTDB2
ora....db2.gsd application OFFLINE OFFLINE
ora....db2.ons application ONLINE ONLINE TTTTDB2
ora....db2.vip ora....t1.type ONLINE ONLINE TTTTDB2
ora.ttttdb.db ora....se.type ONLINE ONLINE TTTTDB1
TTTTDB2:/home/grid$
|
|
中国·北京 重庆 联系方式：
|
|
|
