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 »

Advertisements

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 »

I hit this error while running the catupgrd.sql script during 10gR2 32 bit to 10G 64 bit on Windows Operating System.

I was moving my 10.2.0.2 database from windows 2003-32 bit to windows2008-64 bit. As a mention, My source DB version is 10.2.0.2 and my target server database version is 10.2.0.4 which is certified with the win2008-64 bit.

Read the rest of this entry »

I face this error message while I try to move my archive logs from one mount point to other and register my archive logs to Oracle 11gR1 database(11.1.0.7.0) on OEL 5.5 x-86-64.

I had some space problem and I need to move my archive logs from mount point /u01 to /u02. After the copy process, my archive logs manually from /u01 to /u02. I try to register them to my Oracle11gR1 database (11.1.0.7.0) as follow:

Read the rest of this entry »

Advertisements
Advertisements