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 26,665
Problem Description:
GoldenGate GGSCI Register or Unregister Extract failed with following error.
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
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.
Perl script (rootcrs.pl) execution failed: Can't locate Env.pm in @INC (@INC contains:
Error Description:
Perl script execution failed with following errors.
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
