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.

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.

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.

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.

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

Labels

Oracle (578) General (60) Unix (47) Script (41) Blog (23) OCI (3) SQL* Loader (3) Datapump (2) Software (1)
DBA Tips
 

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