Database Blog

Oracle 12c Common User & Local User

Common Users       Common user must be created in CDB only.      When we create a common user must give C## as prefix      The user…

Read More

Datapatch apply on 12c Databases after patch

Datapatch apply steps on 12c Databases after patch- Run the below steps to apply datapatch for all the databases running on 12C RDBMS home. Set environment . oraenv 12c_DBname Sqlplus…

Read More

Untitled

EXCLUDE=STATISTICS Or EXCLUDE=INDEX_STATISTICS During Datapump Import Still Analyzes The Indexes APPLIES TO: Oracle Database – Enterprise Edition – Version 10.2.0.1 and later SYMPTOMS: You are using Data Pump import (impdp)…

Read More

Untitled

While Accessing Public Synonym Getting Error ORA-1775: looping chain of synonyms APPLIES TO: Oracle Database – Enterprise Edition – Version 11.2.0.3 and later SYMPTOMS: User created a public synonym with…

Read More

Untitled

DataPump Import Results In ORA-39001 Invalid Argument Value ORA-1775 Looping Chain Of Synonyms APPLIES TO: Oracle Database – Enterprise Edition – Version 10.2.0.2 and later SYMPTOMS: When running DataPump import…

Read More

Untitled

DBMS_NETWORK_ACL_ADMIN.CREATE_ACL Worked But Nothing In Dba_network_acls APPLIES TO: Oracle Database – Enterprise Edition – Version 11.2.0.2 and later SYMPTOMS: Nothing in the dba_network_acl_privileges view after creating ACL. Created ACL list as below.…

Read More

Untitled

Different Results Between QUERY Parameter Used With EXP/EXPDP and SQL*Plus APPLIES TO: Oracle Database – Enterprise Edition – Version 10.1.0.2 to 11.2.0.3 [Release 10.1 to 11.2] SYMPTOMS: You try to…

Read More

View running processes in Oracle DB

View running processes in Oracle DB This will show you a list of all running processes: SET LINESIZE 200SET PAGESIZE 200SELECT PROCESS pid, sess.process, sess.status, sess.username, sess.schemaname, sql.sql_text FROM v$session…

Read More

Untitled

DELETE/REMOVE Non Executing Datapump Jobs Step 1:- Normally, we can run the below query to find the datapump jobs and get their status:- SQL> SET lines 150 pages 999 COL…

Read More

Start / Stop / Relocate SCAN listener in Oracle 11gR2 RAC

Start/ Stop / Relocate SCAN listener in Oracle 11gR2 RAC1) Check listener status ( login to grid home)a) Check the cluster resource status $ crsctl stat res -tverify the output…

Read More