KBHS-00712: ORA-29024 received from local HTTP service during backup in RAC Oracle cloud

KBHS-00712: ORA-29024 received from local HTTP service during backup in RAC Oracle cloud The backup of Oracle RAC DBaaS may fail during manual as well automatic backup. If you manually invoke following command,The backup may not get successful. Login to opc. [opc@pocracdemo1 ~]$ raccli describe job 17 {   “requestStatus” : “SUCCESS”,   “jobStatus” : “FAILURE”,   “message” : “Failed […]

ORA-01111: name for data file is unknown – rename to correct file

Error in dataguard alert log/start managed recovery process:- SYS@XXX>alter database recover managed standby database; alter database recover managed standby database * ERROR at line 1: ORA-00283: recovery session canceled due to errors ORA-01111: name for data file 61 is unknown – rename to correct file ORA-01110: data file 61: ‘/u01/app/oracle/product/12.1.0/db_1/dbs/UNNAMED00061’ ORA-01157: cannot identify/lock data file 61 – see DBWR trace […]

Undo Advisor help to estimate the undo tablespace size and undo retention to avoid ORA-1555

Prepare by: Nurullah Sharif Scope: Undo Advisor   Undo Advisor help to estimate the undo tablespace size and also advise of undo retention. SQL> @db NAME      OPEN_MODE ——— ——————– COLLPROD  READ WRITE   Undo retention is 900 sec which 15 min SQL> sho parameter undo NAME                                 TYPE        VALUE ———————————— ———– —————————— undo_management                      string      AUTO undo_retention                       integer     900 undo_tablespace                      string      UNDOTBS2 […]

Oracle time stamp showing wrong timezone connecting TNS remote

Time stamp problem:- sqlplus system/****@ORCL SQL>alter session set nls_date_format=’dd-mm-yyyy hh:mi:ss’; SQL>select instance_name from v$instance; SQL>select   sysdate,   current_timestamp,   systimestamp,   localtimestamp from   dual; The above query will show different time . How to Fix:- 1.1                               Stop the apps and DB cluster/HAS. su – root cd /orasw/app/grid/product/11.2.0/grid/bin ./crsctl stop crs –f su – grid cd /orasw/app/grid/product/11.2.0/grid/bin ./crsctl stop […]

Error undefined symbol: JNU_ThrowByName during oracle 12c R2 installation

We faced this error during Oracle12cR2 installation. During our installation of oracle 12.2 in new home on existing Oracle 11g installation,we faced the error   LOG INFO: Executing [/opt/oracle/product/, clustercheck=false, basedir=/opt/oracle/product, oraclehome=/opt/oracle/product/] /opt/oracle/product/ WARNING: java.lang.UnsatisfiedLinkError: /opt/oracle/product/ /opt/oracle/product/ undefined symbol: JNU_ThrowByName WARNING:        at java.lang.ClassLoader$NativeLibrary.load(Native Method) WARNING:        at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1941) WARNING:        at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1824) WARNING:        at java.lang.Runtime.load0(Runtime.java:809) WARNING:        at java.lang.System.load(System.java:1086) WARNING:        at java.lang.ClassLoader$NativeLibrary.load(Native Method) […]

ORA-12545: Connect failed because target host or object does not exist using SERVICE_NAME in tnsnames.ora

Today I observed that we were getting following error when we were going to connect using SERVICE_NAME from (DR site) to new exadata server. The connection was working fine with SID in tnsnames.ora to individual instances. [oracle@XXX admin]$ sqlplus dba/XXX@PROD_CDV SQL*Plus: Release Production on Mon Nov 27 09:08:38 2017 Copyright (c) 1982, 2014, Oracle. All rights reserved. ERROR: ORA-12545: […]

Oracle database instance recovery is taking too much time after shutdown immediate

1.We were going to open DB after shutdown immediate but it went hang.In alert log , we could only notice following message for 40 minutes.   Completed: ALTER DATABASE MOUNT Tue Oct 31 01:08:39 2017 ALTER DATABASE OPEN Beginning crash recovery of 1 threadsparallel recovery started with 9 processes Started redo scanTue Oct 31 01:08:58 2017 Completed redo scan read […]

Troubleshoot connection issue using standalone jdbc driver to oracle

Hi All Please download following file from Google drive and keep in unix directory say /home/oracle https://drive.google.com/open?id=0B8-3R318F39hQUJOcnVPMUdrNzg The files to be downloaded:- Please use ojdbc7.jar downloaded for 12c.For 11g,you can use ojdbc6.jar.   Please provide execute permissions Now you can test connection using below:- [oracle@SBJ1ITESBDBV01 ~]$ sh sqlScript_new.sh 2017-10-26 09:45:53.0 Please note you may get following error if you use […]