I faced with those errors on 12c database. While I try to drop some tablespace it throws errors such as:

SQL> DROP TABLESPACE MY_TABLESPACE INCLUDING CONTENTS AND DATAFILES;
DROP TABLESPACE MY_TABLESPACEINCLUDING CONTENTS AND DATAFILES
*
ERROR at line 1:
ORA-01116: error in opening database file 35
ORA-01110: data file 35:
'/u01/app/oracle/product/12.1.0/dbhome_2/dbs/MY_TABLESPACE02_A.DBF'
ORA-27041: unable to open file
SVR4 Error: 2: No such file or directory
Additional information: 3

Read the rest of this entry »

Advertisements

I hit this error during try to start my ASM instance

I am working standalone  Oracle 11.2.0.1 database with ASM option on AIX 6.1.

I this error after I reboot my server.

$export ORACLE_SID=+ASM
$sqlplus "/as sysasm"
SQL> startup
 ORA-01078: failure in processing system parameters
 ORA-29701: unable to connect to Cluster Synchronization Service

Read the rest of this entry »

I face this issue while trying to take export by using data pump

My system is:

AIX:6.1
Db verison:11.2.0.3
Process: expdp

Read the rest of this entry »

I hit this error while I was trying to make 11gR2 installation on the AIX6 operating system.

/runInstaller ended by:

JVMDUMP006I Processing Dump Event “gpf”, detail “” – Please Wait.
JVMDUMP007I JVM Requesting System Dump using ‘/tmp/core.xx.dmp’
JVMDUMP010I System Dump written to /tmp/core.xx.dmp
JVMDUMP007I JVM Requesting Snap Dump using ‘/tmp/x.trc’
JVMDUMP010I Snap Dump written to /tmp/xx.trc
JVMDUMP007I JVM Requesting Java Dump using ‘/tmp/javacore.xx.txt’
JVMDUMP012E Error in Java Dump: /tmp/javacore.xx.txt
JVMDUMP013I Processed Dump Event “gpf”, detail “”.

Read the rest of this entry »

For test purpose, We need to create EBS on Oracle VM box.  After installation some of our user cant login to our new test system. To can see what happen, We just enabled java to debug console on client machines.

While We checked the end of the console We noticed those errors:

Read the rest of this entry »

For some reason, We need to compare between Test Schema objects with Prod Schema objects to can see a difference.

Its possible to do that by using am going to share one document which is using TOAD program for this purpose.

I hope you enjoy it.

How to Generate A Schema Script to Compare with Another Schema

You can hit ORA-00054: resource busy and acquire with NOWAIT specified error during some of your operations on your database such as alter some objects.

The main reason for this error is Table Level Locks(TM lock). The transaction holds two locks (Row Locks(TX) and Table Locks(TM) when the session opens. So What are those locks?

Read the rest of this entry »

This good news published in this link  Oracle database appliance (aka ODA) is one of the best appliance machines. ODA is already certified by 11g-12c EE and SE versions.

By this certification, the Hybrid Columnar Compression (HCC) functionality will be made available starting with the Database 18c release.

Read the rest of this entry »

I have this error while I try to start my listener on R12 instance whit 10g database.

While I try to start listener for my production, I have an error such as

TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Linux Error: 32: Broken pipe

Read the rest of this entry »

As you know We already on 18c version, but I still see some questions which are related performance issues and how We can use Statpack reports.

Its available since  Oracle 8i, I want to share some Metalink documents which covers what is Statspack report, How We can install&run and read it, Purpose of usage Statspack reports

Read the rest of this entry »

Advertisements
Advertisements