You are currently browsing the category archive for the ‘Oracle Database&EBS General’ category.

In Our RAC databases I noticed  EMON process consuming CPU. OEM graph like below:

111111

Read the rest of this entry »

I faced with this error message on 18c RAC database.

Error message is:

ORA-12012: error on auto execute of job “SYS”.”ORA$AT_SA_SPC_SY_10909″
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at “SYS.DBMS_ADVISOR”, line 201
ORA-06512: at “SYS.DBMS_SPACE”, line 2563
ORA-06512: at “SYS.DBMS_SPACE”, line 2643

Read the rest of this entry »

I have 12.0.1.2 node RAC system on Linux 64 bit.

I had some e-mails from our developer team about database connection problems. They got “ORA-12541: TNS:no listener” error message.

I started to investigate issue by checking current status of services by using below command:

crsctl stat res -t

I noticed that SCAN_LISTENER service status were UNKNOWN.

Read the rest of this entry »

In Our 18.3 RAC database, I noticed that below error in alertlog file.

Errors in file /u01/app/oracle/diag/rdbms/sid/instance1/trace/instance1_j002_11339.trc:
ORA-12012: error on auto execute of job "ORACLE_OCM"."MGMT_CONFIG_JOB_2_1"
ORA-29280: invalid directory path
ORA-06512: at "ORACLE_OCM.MGMT_DB_LL_METRICS", line 2436
ORA-06512: at line 1

Seed database was most likely not created right by package dbms_stats.init_package not being ran.

Dbms_stats.init_package creates statistics advisor. This procedure is executed during database creation. If something went wrong during database creation,(for example, init_package is not called for some reason), this kind of errors may be seen in alert log when auto job tries to execute.

So than what is the solution. Here are the steps

Read the rest of this entry »

In this post I will explain how We can install and use TFA. Oracle Trace File Analyzer (TFA) provides a number of diagnostic tools in a single bundle, making it easy to gather diagnostic information about the Oracle database and clusterware, which in turn helps with problem resolution when dealing with Oracle Support.

In many case Oracle will some output using this tool for your Service Requests.

First We need to download latest TFA version from Metalink. Please follow TFA Collector – TFA with Database Support Tools Bundle (Doc ID 1513912.1)

Read the rest of this entry »

How we can check Our Dbs is running with spfile or pfile. Here is the some method to can find your file locations etc.
1. By using SqlPlus, Let us check your db started via spfile or pfile
$ sqlplus / as sysdba

 Read the rest of this entry »

While you are trying to truncate table you can hit ORA-02266: error.

In this post I am going to make demo and share solution steps.

I assume that We have 2 tables. Test and Test2. Those table have relation between each other.

Let us try to truncate test table first

Read the rest of this entry »

I faced with that errors our 12c database. With those errors MRP process has been stopped at standby database and GAP started to increased

Complete errors are:

Reading datafile '/xxx/datafile/ts_1.dbf' for corruption at rdba: 0x08d6e9fd (file 35, block 1501693)
Reread (file 35, block 1501693) found same corrupt data (logically corrupt)
Sat Jan 18 17:43:50 2020
ERROR: ORA-00756 detected lost write of a data block
Slave exiting with ORA-756 exception
Sat Jan 18 17:43:50 2020
Errors in file /u01/app/oracle/diag/rdbms/sid/sid/trace/sid_pr01_74757.trc:
ORA-00756: recovery detected a lost write of a data block
ORA-10567: Redo is inconsistent with data block (file# 35, block# 1501693, file offset is 3711934464 bytes)
ORA-10564: tablespace TS
ORA-01110: data file 35: '/xxx/datafile/ts_1'
ORA-10561: block type 'TRANSACTION MANAGED INDEX BLOCK', data object# 102109
Sat Jan 18 17:43:50 2020
Recovery Slave PR01 previously exited with exception 756

Read the rest of this entry »

Start with Oracle Database 12c says, Oracle said goodbye Database Console which came with Oracle 10gR1 Version

10g was used OC4J and 11g was used weblogic. Also We were using emctl/emca commands to manage those systems.

12c brings a new tool called Database Express.

The DB Express runs entirely with pl/sql code within the XDB schema. It’s XDB that leverages its features to enable a web-based console, and it’s embedded by default in the database.

Read the rest of this entry »

If your export size volume is huge than you may need to split export files instead of a single FS. In this case, We need to use the multiple directories feature of EXPDP or IMPDP utility.

By using this feature, We can create multiple dump files in multiple directories and distribute our logical export to different directories on the operating system.

In my case, my DB version in 11.2.0.4 and my os is Linux 6

So here is the demo:

Read the rest of this entry »