After RMAN Cloning, GG Manager abends on ORA-12154

Recently we refresh our Prodtest database from production using RMAN. now while starting the GG, i’m getting below error.

2016-05-27 19:31:12  ERROR   OGG-01668  Oracle GoldenGate Manager for Oracle, mgr.prm:  PROCESS ABENDING.
2016-05-27 19:49:26  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start mgr.
2016-05-27 19:49:27  ERROR   OGG-00664  Oracle GoldenGate Manager for Oracle, mgr.prm:  OCI Error during OCIServerAttach (status = 12154-ORA-12154: TNS:could not resolve the connect identifier specified).
2016-05-27 19:49:27  ERROR   OGG-01668  Oracle GoldenGate Manager for Oracle, mgr.prm:  PROCESS ABENDING.
bash-4.1$

Continue reading

ORA-00245: control file backup failed; target is likely on a local file system

Basically one day at work, my colleague handed over an issue related to RMAN.

 
Starting backup at 14-FEB-2016 06:02:44
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1444 instance=CXXXEU22 device type=DISK channel ORA_DISK_1: starting compressed full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 02/14/2016 06:02:46
ORA-00245: control file backup failed; target is likely on a local file system
 Continue reading 

RMAN Restore from Tape to Diff Host DBName on ASM

A little bit busy this week … my boss ask me to validate the RMAN tape backup if we can really restore it.

Note : restore database validate is not an option 🙂

Source and target are both clustered database.

Source DB: CNCXXU
Source Server : ncxxdsmwu01/ncxxdsmwu02

Target DB: NCXX2PT
Target Server : ncxxdsgtu21/ncxxdsgtu22

1. Shutdown the target database and delete all files in ASM
2. Start the database in nomount and restore the spfile.
– spfile and controlfile backup is going to disk.
– no rman catalog
Continue reading

How to : Add database to CRS

Mostly right now i’d been working on 2 node database cluster. so when doing a patching i need to stop all the database in both nodes.

someone is doing a testing on the server and created a new database but when stopping it won’t allow me.. and resulted me to stop it using sqlplus.

so i decided to add it to CRS.

[oracle@kxxxxsgtu21 ~]$ srvctl status database -d POCTEST1
PRCD-1120 : The resource for database POCTEST1 could not be found.
PRCR-1001 : Resource ora.poctest1.db does not exist
[oracle@kxxxxsgtu21 ~]$

Continue reading

How to change DBID in RAC

recently i restore a database from tape to a different host and at the same time i need to rename the database.

the dbid of my new database same from my source database. since we are using tape to backup our database i need to change the DB of our new database.

Note : DB is 2 node cluster.

Disable the cluster parameter and restart the database.
Continue reading

oracle CRS wont start after server reboot

one of our production server (part of RAC) restarted but crs worn’t start.

checking the logs.

2011-11-09 18:46:44.016: [ COMMCRS][1099135296]clsc_connect: (0x35cb500) no listener at (ADDRESS=(PROTOCOL=ipc)(KEY=OCSSD_LL_dbz30cnc_))

2011-11-09 18:46:44.017: [ CSSCLNT][4001583360]clsssInitNative: failed to connect to (ADDRESS=(PROTOCOL=ipc)(KEY=OCSSD_LL_dbz30cnc_)), rc 9

2011-11-09 18:46:44.017: [  CRSRTI][4001583360] CSS is not ready. Received status 3 from CSS. Waiting for good status ..

2011-11-09 18:46:45.197: [ COMMCRS][1099135296]clsc_connect: (0x35cb500) no listener at (ADDRESS=(PROTOCOL=ipc)(KEY=OCSSD_LL_dbz30cnc_))

2011-11-09 18:46:45.197: [ CSSCLNT][4001583360]clsssInitNative: failed to connect to (ADDRESS=(PROTOCOL=ipc)(KEY=OCSSD_LL_dbz30cnc_)), rc 9

2011-11-09 18:46:45.197: [  CRSRTI][4001583360] CSS is not ready. Received status 3 from CSS. Waiting for good status ..

2011-11-09 18:46:46.198: [    CRSD][4001583360][PANIC] CRSD exiting: Could not init the CSS context
2011-11-09 18:46:46.198: [    CRSD][4001583360] Done.


yyy01.xxx.com$ ./crsctl check crs
Failure 1 contacting Cluster Synchronization Services daemon
Cannot communicate with Cluster Ready Services
Cannot communicate with Event Manager

1. first corrective action we’ve done. is delete the lockfile in /tmp or /var/tmp

yyy01.xxx.com$ cd /var/tmp
yyy01.xxx.com$ ls -al
total 60
drwxrwxrwt  3 root root  4096 Oct 16 07:27 .
drwxr-xr-x 20 root root  4096 Oct 21  2009 ..
-rw-rw-r--  1 root root 25806 Oct 22 20:53 badlogs.log
-rw-r--r--  1 root root 10045 May 28  2010 opc_inst.log
drwxrwxrwt  2 root root  4096 Nov  9 18:07 .oracle
-rw-------  1 root root     0 Nov  9 18:07 osspi_boot.msg

after deleting the file we rebooted the server again. but did not work.

i tried to checked ip’s of both nodes and found that both can’t communicate using the PRIV ip.
ask UNIX to check and do whatever they need to do.

when UNIX team is done, they rebooted the server and the database and all of its services started.