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 […]
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 […]
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 […]
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 […]
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/12.2.0.1/db1/bin/diagsetup, clustercheck=false, basedir=/opt/oracle/product, oraclehome=/opt/oracle/product/12.2.0.1/db1] /opt/oracle/product/12.2.0.1/db1/bin/diagsetup WARNING: java.lang.UnsatisfiedLinkError: /opt/oracle/product/12.2.0.1/db1/oui/lib/linux64/liboraInstaller.so: /opt/oracle/product/12.2.0.1/db1/oui/lib/linux64/liboraInstaller.so: 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) […]
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 12.1.0.2.0 Production on Mon Nov 27 09:08:38 2017 Copyright (c) 1982, 2014, Oracle. All rights reserved. ERROR: ORA-12545: […]
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 […]
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 […]