DGMGRL Edit Configuration and Switch Over fails with Error: ORA-16627

Error Description
DGMGRL edit configuration to Max Availability and switch over command fails with following error message.
DGMGRL> edit configuration set protection mode as Maxavailability;
Error: ORA-16627: operation disallowed since no standby databases would remain to support protection mode

CRS-4638 CRS-4535 CRS-4530 CRS-4534 CRS-2674: Start of 'ora.cssd' on 'Node2' failed

Error Description
Cluster is up and running in one node but when I try to start the cluster in second node gives following error messages.
crsctl check crs command failed with following error messages.

GoldenGate ggsci command failed with error while loading shared libraries: libnnz12.so, libons.so, libclntsh.so.12.1, libclntshcore.so.12.1

Error Description
GoldenGate ggsci command invoke failed with following error message.
[oracle@Node 1 goga]$ ./ggsci
./ggsci: error while loading shared libraries: libnnz12.so: cannot open shared object file: No such file or directory
[oracle@Node 1 goga]$ ./ggsci
./ggsci: error while loading shared libraries: libons.so: cannot open shared object file: No such file or directory

GoldenGate Start Extract Command Failed with OGG-00868 ORA-01291: missing logfile

Error Description:
GoldenGate start extract command getting abend and ggserr.log log shows the following error message.
2016-09-22 12:07:42  ERROR   OGG-00868  Oracle GoldenGate Capture for Oracle, ext_pinf.prm:  Error code 1291, error message: ORA-01291: missing logfile
 (Missing Log File <unknown>. Read Position SCN: 0.34113731 (34113731)).

GoldenGate Start Extract Pump Failing / Abending with OGG-01224 TCP/IP error 111 (Connection refused)

Problem Description
GoldenGate start extract pump command getting abend and ggserr.log log shows the following error message.
2016-09-22 12:31:39  ERROR   OGG-01224  Oracle GoldenGate Capture for Oracle, pmp_dest.prm:  TCP/IP error 111 (Connection refused), endpoint: Node 1:7810.

GoldenGate GGSCI Register / Unregister Extract Failed with OGG-08221 OCI Error 28,365

Problem Description
GoldenGate GGSCI Register or Unregister Extract failed with following error.
2016-09-21 09:40:57  ERROR   OGG-08221  Cannot register or unregister EXTRACT EXT_STS because of the following SQL error: OCI Error 28,365.

GoldenGate GGSCI Register / Unregister Extract Failed with OGG-08221 OCI Error 24,034

Problem Description 
GoldenGate GGSCI Register or Unregister Extract failed with following error.
GGSCI (Node1 as PPS_OWNER@KPMUAT1) 27>register extract EXT_CPIF database

2016-09-21 14:21:51  ERROR   OGG-08221  Cannot register or unregister EXTRACT EXT_CPIF because of the following SQL error: OCI Error 24,034.

GoldenGate GGSCI Register / Unregister Extract Failed with OGG-08221 OCI Error 26,665

Problem Description:
GoldenGate GGSCI Register or Unregister Extract failed with following error.
GGSCI (Node 1 as PCS_OWNER@KPMUAT1) 10> register extract EXT_STS database

2016-09-21 14:02:11  ERROR   OGG-08221  Cannot register or unregister EXTRACT EXT_STS because of the following SQL error: OCI Error 26,665.

How Stop / Start Multiple Database Instances Under One Oracle Home in Single srvctl Command?

There are different situations (e.g: patching) to shutdown or startup multiple databases instance under one ORACLE HOME under one RAC node.  

Syntax:

Perl script (rootcrs.pl) execution failed: Can't locate Env.pm in @INC (@INC contains:

Error Description:
Perl script execution failed with following errors.
[root@Node1 install]# ./rootcrs.pl -unlock
Can't locate Env.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl

Fix IMPDP ORA-39006 ORA-39213

Problem Description
Impdp failed with following error message
[oracle]$ impdp  DIRECTORY=dmp_dir DUMPFILE=exp.dmp LOGFILE=imp.log REMAP_SCHEMA=source:target

Import: Release 12.1.0.2.0 - Production on Fri Sep 2 04:39:17 2016

Oracle SQL Query to Find Only the Directory Names of the Datafiles

SQL Query:

select substr(file_name,1,instr(file_name,'/',-1,1 )) from dba_data_files;

Example:
Datafile Names:
SQL> select file_name from dba_data_files;

Fix Opatch: Missing command :fuser Prerequisite check "CheckSystemCommandAvailable" failed.

Error Description:
Opatch failed with following error message
Missing command :fuser
Prerequisite check "CheckSystemCommandAvailable" failed.

Oracle 12c: How to Create ASM Cluster file System (ACFS) Using ASM Configuration Assistant (ASMCA)

Login to grid user and set ASM instance parameters.  
[grid@Rac1 ~]$ . oraenv
ORACLE_SID = [grid] ? +ASM1
The Oracle base has been set to /u01/app/grid
[grid@Rac1 ~]$ env|grep ORACLE

Fix: /usr/bin/ld: warning: libstdc++.so.5, needed by libsc_ca.so, not found

Opatch apply gives warning as following.
OPatch found the word "warning" in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:

Fix ORA-12712: new character set must be a superset of old character set

Problem Description:
Database character set change is erroring out with following error message.
ALTER DATABASE CHARACTER SET AL32UTF8
*
ERROR at line 1:
ORA-12712: new character set must be a superset of old character set
 

acehints.com Copyright 2011-17 All Rights Reserved | Site Map | Contact | Disclaimer | Google