Gavinsoorma.com



How to create a RAC One Node Database Launch DBCA [oracle@rac02 ~]$ . oraenvORACLE_SID = [oracle] ? racdbThe Oracle base has been set to /acfs_oh/app/oracle[oracle@rac02 ~]$ dbcaAdd entry to /etc/oratab[oracle@rac02 ~]$ vi /etc/orataborcl:/acfs_oh/product/12.2.0/dbhome_1:NView the cluster configuration details via SRVCTL [oracle@rac02 ~]$ . oraenvORACLE_SID = [orcl] ? The Oracle base has been changed from /home/oracle to /acfs_oh/app/oracle[oracle@rac02 ~]$ srvctl config database -d orclDatabase unique name: orclDatabase name: orclOracle home: /acfs_oh/product/12.2.0/dbhome_1Oracle user: oracleSpfile: +DATA/ORCL/PARAMETERFILE/spfile.281.971600915Password file: +DATA/ORCL/PASSWORD/pwdorcl.269.971600539Domain: localdomainStart options: openStop options: immediateDatabase role: PRIMARYManagement policy: AUTOMATICServer pools: Disk Groups: DATAMount point paths: /acfs_ohServices: oggdbType: RACOneNodeOnline relocation timeout: 30Instance name prefix: orclCandidate servers: rac02,rac01OSDBA group: dbaOSOPER group: dbaDatabase instances: orcl_1CSS critical: noCPU count: 0Memory target: 0Maximum memory: 0Default network number for database services: Database is administrator managed[oracle@rac02 ~]$Relocate the database[oracle@rac02 ~]$ srvctl status database -d orclInstance orcl_1 is running on node rac02Online relocation: INACTIVE[oracle@rac02 ~]$ srvctl relocate database -d orcl -n rac01[root@rac01 ~]# su - oracleLast login: Sat Mar 24 09:56:36 WST 2018[oracle@rac01 ~]$ . oraenvORACLE_SID = [oracle] ? racdbThe Oracle base has been set to /acfs_oh/app/oracle[oracle@rac01 ~]$ srvctl status database -d orclInstance orcl_2 is running on node rac01Online relocation: ACTIVESource instance: orcl_1 on rac02Destination instance: orcl_2 on rac01[oracle@rac01 ~]$[oracle@rac01 ~]$ srvctl status database -d orclInstance orcl_2 is running on node rac01Online relocation: INACTIVE ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download