EBS RAC+DG RAC 切换单实例

santaclaus

EBS RAC 切换单实例1 切换前置条件
1.1 在新置服务器上安装好系统
1.2 安装好GRID软件
1.3 安装好ORACLE 软件
1.4 安装好和生产库中一样的GI补丁（一个都不能少）
1.5 安装好和生产库中一样的RDBMS补丁（一个都不能少）
2 定制切换计划
2.1 停止应用
2.2 停止监听
2.3 停止主库
2.4 停止备库
2.5 停止备库监听
2.6 停止RAC服务
2.7 检查无任何应用再续连接，检查服务停止状况，检查无SQLPLUS程序连接。
2.8 由新服务器挂存储拉起主库。
2.9 修改参数，完成主备同步。
2.10 数据库层AUTOCONFIG。
2.11 修改应用参数文件连接新主库，并AUTOCONFIG。
2.12 启动应用，测试EBS功能正常。
2.13 在旧主库上安装单实例GI,RDBMS。
2.14 停止应用。
2.15 停止新主库监听。
2.16 停止新主库。
2.17 停止备库。
2.18 停止备库监听。
2.19 检查无任何应用再续连接，检查服务停止状况，检查无SQLPLUS程序连接。
2.20 用新备库挂旧备库的存储拉起备库。
2.21 修改参数，完成DG同步。
2.22 备库无EBS应用，所以只需直接启动应用即可。
2.23 检查EBS服务功能正常。
3 主库切换单实例
3.1 COPY出主库的ASM参数文件与RDBMS的参数文件
SQL> create pfile from spfile;
File created.
3.2 停止应用
[ebsapp@gd1ebs132 ~]$ /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adstpall.sh apps/vipshop
You are running adstpall.sh version 120.10.12010000.4
The logfile for this session is located at /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adstpall.log
Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/jtffmctl.sh stop
script returned:
****************************************************
You are running jtffmctl.sh version 120.3
Shutting down Fulfillment Server for PROD on port 9307 …
jtffmctl.sh: exiting with status 0
.end std out.
.end err out.
****************************************************
Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adcmctl.sh stop
script returned:
****************************************************
You are running adcmctl.sh version 120.17.12010000.5
Shutting down concurrent managers for PROD …
ORACLE Password:
Submitted request 403408 for CONCURRENT FND SHUTDOWN
adcmctl.sh: exiting with status 0
adcmctl.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adcmctl.txt for more information …
.end std out.
.end err out.
****************************************************
Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adoafmctl.sh stop
script returned:
****************************************************
You are running adoafmctl.sh version 120.8
Stopping OPMN managed OAFM OC4J instance …
adoafmctl.sh: exiting with status 0
adoafmctl.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adoafmctl.txt for more information …
.end std out.
.end err out.
****************************************************
Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adformsctl.sh stop
script returned:
****************************************************
You are running adformsctl.sh version 120.16.12010000.3
Stopping OPMN managed FORMS OC4J instance …
adformsctl.sh: exiting with status 0
adformsctl.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adformsctl.txt for more information …
.end std out.
.end err out.
****************************************************
Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adoacorectl.sh stop
script returned:
****************************************************
You are running adoacorectl.sh version 120.13
Stopping OPMN managed OACORE OC4J instance …
adoacorectl.sh: exiting with status 0
adoacorectl.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adoacorectl.txt for more information …
.end std out.
.end err out.
****************************************************
Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adapcctl.sh stop
script returned:
****************************************************
You are running adapcctl.sh version 120.7.12010000.2
Stopping OPMN managed Oracle HTTP Server (OHS) instance …
opmnctl: stopping opmn managed processes…
adapcctl.sh: exiting with status 0
adapcctl.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adapcctl.txt for more information …
.end std out.
.end err out.
****************************************************
Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adalnctl.sh stop
script returned:
****************************************************
adalnctl.sh version 120.3
Shutting down listener process APPS_PROD.
adalnctl.sh: exiting with status 0
adalnctl.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adalnctl.txt for more information …
.end std out.
.end err out.
****************************************************
Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adopmnctl.sh stop
script returned:
****************************************************
You are running adopmnctl.sh version 120.6.12010000.5
Stopping Oracle Process Manager (OPMN) and the managed processes …
opmnctl: stopping opmn and all managed processes…
adopmnctl.sh: exiting with status 0
adopmnctl.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adopmnctl.txt for more information …
.end std out.
.end err out.
****************************************************
All enabled services on this node are stopped.
adstpall.sh:Exiting with status 0
adstpall.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adstpall.log for more information …
3.3 停止主库两节点监听
lsnrctl stop
3.4 停止主库两节点实例
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
3.5 停止备库
SQL> alter database recover managed standby database cancel;
Database altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
3.6 停止备库监听
lsnrctl stop
3.7 停止RAC服务
/u01/PROD/grid_home/bin/crsctl stop cluster –all
在两节点执行关闭HAS命令：
/u01/PROD/grid_home/bin/crsctl stop has
3.8 检查应用，GI, RDBMS已停干净
3.8.1 应用：
[ebsapp@gd1ebs132 ~]$ /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adopmnctl.sh status
You are running adopmnctl.sh version 120.6.12010000.5
Checking status of OPMN managed processes…
Unable to connect to opmn.
Opmn may not be up.
adopmnctl.sh: exiting with status 0
adopmnctl.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adopmnctl.txt for more infor
3.8.2 GI：
[root@gd1ebs132 ~]# ps -elf | grep +ASM
0 S root 24390 22691 0 80 0 – 15304 pipe_w 18:13 pts/1 00:00:00 grep +ASM
[root@gd1ebs132 ~]# ps -elf | grep d.bin
0 S root 24400 22691 0 80 0 – 15304 pipe_w 18:14 pts/1 00:00:00 grep d.bin
3.8.3 RDBMS
[root@gd1ebs132 ~]# ps -elf | grep ora_
0 S root 24408 22691 0 80 0 – 15304 pipe_w 18:14 pts/1 00:00:00 grep ora_
3.9 创建ASM参数文件
[grid@gd1ebs131 dbs]$ vi init+ASM.ora
+ASM.__large_pool_size=16777216
+ASM.asm_diskgroups=’RACOVER’,'DATA’#Manual Mount
*.asm_diskstring=’/dev/*’
*.asm_power_limit=1
*.diagnostic_dest=’/u01/PROD/grid’
*.instance_type=’asm’
*.large_pool_size=12M
*.remote_login_passwordfile=’EXCLUSIVE’
3.10 启动ASM实例
SQL> startup
ASM instance started
Total System Global Area 371617792 bytes
Fixed Size 2228504 bytes
Variable Size 344223464 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
3.11 准备主库参数文件。
[ebsdb@gd1ebs131 dbs]$ vi initPROD.ora
SPFILE=’+DATA/spfilePROD.ora’
修改参数文件：
去掉是RAC的配置
3.12 启动实例到MOUNT状态
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 1.0689E+10 bytes
Fixed Size 2237776 bytes
Variable Size 6509562544 bytes
Database Buffers 4160749568 bytes
Redo Buffers 16924672 bytes
SQL> alter database mount;
Database altered.
3.13 准备监听文件
[ebsdb@gd1ebs131 admin]$ cat listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.19.131.105)(PORT = 1521))
)
)
ADR_BASE_LISTENER = /u01/PROD/oracle2
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = /u01/PROD/oracle2/oracle_home)
(SID_NAME = PROD)
)
)
启动监听：
[ebsdb@gd1ebs131 admin]$ lsnrctl start
LSNRCTL for Linux: Version 11.2.0.3.0 – Production on 01-JUL-2013 20:37:41
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Starting /u01/PROD/oracle2/oracle_home/bin/tnslsnr: please wait…
TNSLSNR for Linux: Version 11.2.0.3.0 – Production
System parameter file is /u01/PROD/oracle2/oracle_home/network/admin/listener.ora
Log messages written to /u01/PROD/oracle2/diag/tnslsnr/gd1ebs131/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.19.131.105)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.19.131.105)(PORT=1521)))
STATUS of the LISTENER
————————
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.3.0 – Production
Start Date 01-JUL-2013 20:37:41
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/PROD/oracle2/oracle_home/network/admin/listener.ora
Listener Log File /u01/PROD/oracle2/diag/tnslsnr/gd1ebs131/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.19.131.105)(PORT=1521)))
Services Summary…
Service “PROD” has 1 instance(s).
Instance “PROD”, status UNKNOWN, has 1 handler(s) for this service…
The command completed successfully
3.14 启动备库
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 1.0689E+10 bytes
Fixed Size 2237776 bytes
Variable Size 6509562544 bytes
Database Buffers 4160749568 bytes
Redo Buffers 16924672 bytes
SQL> alter database mount standby database;
Database altered.
SQL> alter database open read only;
Database altered.
SQL> alter database recover managed standby database using current logfile disconnect from session;
Database altered.
3.15 启动主库
在启动主库时出错：
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-30012: undo tablespace ‘UNDOTBS1′ does not exist or of wrong type
Process ID: 16305
Session ID: 375 Serial number: 9
解决办法：
SQL> alter system set undo_tablespace=’UNDOTBS2′ scope=spfile;
System altered.
SQL> shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1.0689E+10 bytes
Fixed Size 2237776 bytes
Variable Size 6543116976 bytes
Database Buffers 4127195136 bytes
Redo Buffers 16924672 bytes
Database mounted.
Database opened.
3.16 检查数据库同步
3.17 数据库层AUTOCONFIG
[ebsdb@gd1ebs131 oracle_home]$ cp -r /u01/PROD/oracle/oracle_home2/appsutil .
[ebsdb@gd1ebs131 oracle_home]$
3.17.1 清除节点信息
[ebsdb@gd1ebs131 appsutil]$ sqlplus apps/vipshop
SQL*Plus: Release 11.2.0.3.0 Production on Tue Jul 2 09:03:13 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
SQL> exec fnd_conc_clone.setup_clean;
PL/SQL procedure successfully completed.
SQL> commit;
Commit complete.
3.17.2 生成XML文件
[ebsdb@gd1ebs131 bin]$ perl adbldxml.pl
Starting context file generation for db tier..
Using JVM from /u01/PROD/oracle2/oracle_home/jdk/jre/bin/java to execute java programs..
APPS Password: vipshop
The log file for this adbldxml session is located at:
/u01/PROD/oracle2/oracle_home/appsutil/log/adbldxml_07020905.log
Enter the value for Display Variable: gd1ebs131:0
Context File /u01/PROD/oracle2/oracle_home/appsutil/PROD_gd1ebs131.xml
already exists.
Overwriting Context File may cause loss of existing settings, hence
backing it up as: /u01/PROD/oracle2/oracle_home/appsutil/PROD_gd1ebs131.xml.bak
The context file has been created at:
/u01/PROD/oracle2/oracle_home/appsutil/PROD_gd1ebs131.xml
3.17.3 修改XML里RAC的配置。
3.17.4 生成NLS DATA
[ebsdb@gd1ebs131 admin]$ cd /u01/PROD/oracle2/oracle_home/nls/data/old/
[ebsdb@gd1ebs131 old]$ perl cr9idata.pl
Creating directory /u01/PROD/oracle2/oracle_home/nls/data/9idata …
Copying files to /u01/PROD/oracle2/oracle_home/nls/data/9idata…
Copy finished.
Please reset environment variable ORA_NLS10 to /u01/PROD/oracle2/oracle_home/nls/data/9idata!
[ebsdb@gd1ebs131 old]$ export ORA_NLS10=/u01/PROD/oracle2/oracle_home/nls/data/9idata
3.17.5 执行AUTOCONFIG
[ebsdb@gd1ebs131 bin]$ ./adconfig.sh
Enter the full path to the Context file: /u01/PROD/oracle2/oracle_home/appsutil/PROD_gd1ebs131.xml
Enter the APPS user password:
The log file for this session is located at: /u01/PROD/oracle2/oracle_home/appsutil/log/PROD_gd1ebs131/07021014/adconfig.log
AutoConfig is configuring the Database environment…
AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : /u01/PROD/oracle2/oracle_home
Classpath : :/u01/PROD/oracle2/oracle_home/jdbc/lib/ojdbc5.jar:/u01/PROD/oracle2/oracle_home/appsutil/java/xmlparserv2.jar:/u01/PROD/oracle2/oracle_home/appsutil/java:/u01/PROD/oracle2/oracle_home/jlib/netcfg.jar:/u01/PROD/oracle2/oracle_home/jlib/ldapjclnt11.jar
Using Context file : /u01/PROD/oracle2/oracle_home/appsutil/PROD_gd1ebs131.xml
Context Value Management will now update the Context file
Updating Context file…COMPLETED
Attempting upload of Context file and templates to database…COMPLETED
Updating rdbms version in Context file to db112
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME …
AutoConfig completed successfully.
4 应用层AUTOCONFIG
4.1 修改CONTENTXT FILE配置
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp)(HOST=gd1ebs131.vipshop.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=PROD)))
4.2 去掉负载均衡的配置
PROD
4.3 修改TNS配置
PROD=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=gd1ebs131.vipshop.com)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=PROD)
(INSTANCE_NAME=PROD)
)
)
4.4 执行应用层AUTOCONFIG
[ebsapp@gd1ebs132 scripts]$ ./adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/log/07021031/adconfig.log
AutoConfig is configuring the Applications environment…
AutoConfig will consider the custom templates if present.
Using CONFIG_HOME location : /u01/PROD/PROD/inst/apps/PROD_gd1ebs132
Classpath : /u01/PROD/PROD/apps/apps_st/comn/java/lib/appsborg2.zip:/u01/PROD/PROD/apps/apps_st/comn/java/classes
Using Context file : /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/appl/admin/PROD_gd1ebs132.xml
Context Value Management will now update the Context file
Updating Context file…COMPLETED
Attempting upload of Context file and templates to database…COMPLETED
Configuring templates from all of the product tops…
Configuring AD_TOP……..COMPLETED
Configuring FND_TOP…….COMPLETED
Configuring ICX_TOP…….COMPLETED
Configuring MSC_TOP…….COMPLETED
Configuring IEO_TOP…….COMPLETED
Configuring BIS_TOP…….COMPLETED
Configuring AMS_TOP…….COMPLETED
Configuring CCT_TOP…….COMPLETED
Configuring WSH_TOP…….COMPLETED
Configuring CLN_TOP…….COMPLETED
Configuring OKE_TOP…….COMPLETED
Configuring OKL_TOP…….COMPLETED
Configuring OKS_TOP…….COMPLETED
Configuring CSF_TOP…….COMPLETED
Configuring IGS_TOP…….COMPLETED
Configuring IBY_TOP…….COMPLETED
Configuring JTF_TOP…….COMPLETED
Configuring MWA_TOP…….COMPLETED
Configuring CN_TOP……..COMPLETED
Configuring CSI_TOP…….COMPLETED
Configuring WIP_TOP…….COMPLETED
Configuring CSE_TOP…….COMPLETED
Configuring EAM_TOP…….COMPLETED
Configuring FTE_TOP…….COMPLETED
Configuring ONT_TOP…….COMPLETED
Configuring AR_TOP……..COMPLETED
Configuring AHL_TOP…….COMPLETED
Configuring OZF_TOP…….COMPLETED
Configuring IES_TOP…….COMPLETED
Configuring CSD_TOP…….COMPLETED
Configuring IGC_TOP…….COMPLETED
AutoConfig completed successfully.
5 启动应用
[ebsapp@gd1ebs132 scripts]$ ./adstrtal.sh apps/vipshop
You are running adstrtal.sh version 120.15.12010000.3
The logfile for this session is located at /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adstrtal.log
Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adopmnctl.sh start
script returned:
****************************************************
You are running adopmnctl.sh version 120.6.12010000.5
Starting Oracle Process Manager (OPMN) …
opmnctl: opmn started.
adopmnctl.sh: exiting with status 0
adopmnctl.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adopmnctl.txt for more information …
.end std out.
.end err out.
****************************************************
Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adalnctl.sh start
script returned:
****************************************************
adalnctl.sh version 120.3
Checking for FNDFS executable.
Starting listener process APPS_PROD.
adalnctl.sh: exiting with status 0
adalnctl.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adalnctl.txt for more information …
.end std out.
.end err out.
****************************************************
Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adapcctl.sh start
script returned:
****************************************************
You are running adapcctl.sh version 120.7.12010000.2
Starting OPMN managed Oracle HTTP Server (OHS) instance …
opmnctl: opmn is already running.
opmnctl: starting opmn managed processes…
adapcctl.sh: exiting with status 0
adapcctl.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adapcctl.txt for more information …
.end std out.
.end err out.
****************************************************
Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adoacorectl.sh start
script returned:
****************************************************
You are running adoacorectl.sh version 120.13
Starting OPMN managed OACORE OC4J instance …
adoacorectl.sh: exiting with status 0
adoacorectl.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adoacorectl.txt for more information …
.end std out.
.end err out.
****************************************************
Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adformsctl.sh start
script returned:
****************************************************
You are running adformsctl.sh version 120.16.12010000.3
Starting OPMN managed FORMS OC4J instance …
Calling txkChkFormsDeployment.pl to check whether latest FORMSAPP.EAR is deployed…
Program : /u01/PROD/PROD/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkChkFormsDeployment.pl started @ Tue Jul 2 10:34:50 2013
*** Log File = /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/rgf/TXK/txkChkFormsDeployment_Tue_Jul_2_10_34_50_2013/txkChkFormsDeployment_Tue_Jul_2_10_34_50_2013.log
File “/u01/PROD/PROD/apps/tech_st/10.1.3/j2ee/forms/applications/forms/formsweb/WEB-INF/lib/frmsrv.jar” exists. Proceeding to check the size…
=============================================
*** Latest formsapp.ear has been deployed ***
=============================================
Program : /u01/PROD/PROD/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkChkFormsDeployment.pl completed @ Tue Jul 2 10:34:51 2013
Perl script txkChkFormsDeployment.pl got executed successfully
adformsctl.sh: exiting with status 0
adformsctl.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adformsctl.txt for more information …
.end std out.
*** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS
*** Log File = /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/rgf/TXK/txkChkFormsDeployment_Tue_Jul_2_10_34_50_2013/txkChkFormsDeployment_Tue_Jul_2_10_34_50_2013.log
.end err out.
****************************************************
Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adoafmctl.sh start
script returned:
****************************************************
You are running adoafmctl.sh version 120.8
Starting OPMN managed OAFM OC4J instance …
adoafmctl.sh: exiting with status 0
adoafmctl.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adoafmctl.txt for more information …
.end std out.
.end err out.
****************************************************
Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adcmctl.sh start
script returned:
****************************************************
You are running adcmctl.sh version 120.17.12010000.5
Starting concurrent manager for PROD …
Starting PROD_0702@PROD Internal Concurrent Manager
Default printer is noprint
adcmctl.sh: exiting with status 0
adcmctl.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adcmctl.txt for more information …
.end std out.
.end err out.
****************************************************
Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/jtffmctl.sh start
script returned:
****************************************************
You are running jtffmctl.sh version 120.3
Validating Fulfillment patch level via /u01/PROD/PROD/apps/apps_st/comn/java/classes
Fulfillment patch level validated.
Starting Fulfillment Server for PROD on port 9307 …
jtffmctl.sh: exiting with status 0
.end std out.
.end err out.
****************************************************
All enabled services for this node are started.
adstrtal.sh: Exiting with status 0
adstrtal.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adstrtal.log for more information …
5.1 检查应用启动情况：
[ebsapp@gd1ebs132 scripts]$ ./adopmnctl.sh status
You are running adopmnctl.sh version 120.6.12010000.5
Checking status of OPMN managed processes…
Processes in Instance: PROD_gd1ebs132.gd1ebs132.vipshop.com
———————————+——————–+———+———
ias-component | process-type | pid | status
———————————+——————–+———+———
OC4JGroup:default_group | OC4J:oafm | 3456 | Alive
OC4JGroup:default_group | OC4J:forms | 3239 | Alive
OC4JGroup:default_group | OC4J:oacore | 3070 | Alive
HTTP_Server | HTTP_Server | 3012 | Alive
adopmnctl.sh: exiting with status 0
adopmnctl.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adopmnctl.txt for more information …
5.2 检查应用页面情况
6 验证主备库同步
6.1 主库创建表
SQL> create table t234 as select * from dba_tables;
Table created.
6.2 备库查询表
SQL> desc t234;
Name Null? Type
—————————————– ——– —————————-
OWNER NOT NULL VARCHAR2(30)
TABLE_NAME NOT NULL VARCHAR2(30)
TABLESPACE_NAME VARCHAR2(30)
CLUSTER_NAME VARCHAR2(30)
IOT_NAME VARCHAR2(30)
STATUS VARCHAR2(8)
PCT_FREE NUMBER
PCT_USED NUMBER
INI_TRANS NUMBER
MAX_TRANS NUMBER
INITIAL_EXTENT NUMBER
NEXT_EXTENT NUMBER
MIN_EXTENTS NUMBER
MAX_EXTENTS NUMBER
PCT_INCREASE NUMBER
FREELISTS NUMBER
FREELIST_GROUPS NUMBER
LOGGING VARCHAR2(3)
BACKED_UP VARCHAR2(1)
NUM_ROWS NUMBER
BLOCKS NUMBER
EMPTY_BLOCKS NUMBER
AVG_SPACE NUMBER
CHAIN_CNT NUMBER
AVG_ROW_LEN NUMBER
AVG_SPACE_FREELIST_BLOCKS NUMBER
NUM_FREELIST_BLOCKS NUMBER
DEGREE VARCHAR2(40)
INSTANCES VARCHAR2(40)
CACHE VARCHAR2(20)
TABLE_LOCK VARCHAR2(8)
SAMPLE_SIZE NUMBER
LAST_ANALYZED DATE
PARTITIONED VARCHAR2(3)
IOT_TYPE VARCHAR2(12)
TEMPORARY VARCHAR2(1)
SECONDARY VARCHAR2(1)
NESTED VARCHAR2(3)
BUFFER_POOL VARCHAR2(7)
FLASH_CACHE VARCHAR2(7)
CELL_FLASH_CACHE VARCHAR2(7)
ROW_MOVEMENT VARCHAR2(8)
GLOBAL_STATS VARCHAR2(3)
USER_STATS VARCHAR2(3)
DURATION VARCHAR2(15)
SKIP_CORRUPT VARCHAR2(8)
MONITORING VARCHAR2(3)
CLUSTER_OWNER VARCHAR2(30)
DEPENDENCIES VARCHAR2(8)
COMPRESSION VARCHAR2(8)
COMPRESS_FOR VARCHAR2(12)
DROPPED VARCHAR2(3)
READ_ONLY VARCHAR2(3)
SEGMENT_CREATED VARCHAR2(3)
RESULT_CACHE VARCHAR2(7)
7 切换备库RAC为单实例与切主库同样操作