ORA-01103: database name ‘MW’ in control file is not ‘MWTST’

This error most likely occurred when you duplicated a database and the DB_NAME parameter in spfile is not matching the one in the control file. Sometimes it so happened that after duplicating the database name in SPFILE with which you started the instance with is not matching the one in the control file. Explanation: ===================== … Continue reading ORA-01103: database name ‘MW’ in control file is not ‘MWTST’

ORA-27054: NFS file system where the file is created or resides is not mounted with correct options

This error normally occurs when you are trying to import a dump file which is residing on an NFS file system or you are copying a file from NFS filesystem onto ASM. The way to resolve the problem is to mount the NFS filesystem with the correct options. 1. Unmount the NFS file system where … Continue reading ORA-27054: NFS file system where the file is created or resides is not mounted with correct options

ORA-29701: unable to connect to Cluster Synchronization Service

Problem ------ Error on starting ASM from SQLPLUS or ASMCMD SQL> startup; ORA-01078: failure in processing system parameters ORA-29701: unable to connect to Cluster Synchronization Service SQL> exit Disconnected Solution -------- As Grid User $ crsctl start res ora.cssd CRS-2672: Attempting to start 'ora.cssd' on 'prmdb' CRS-2672: Attempting to start 'ora.diskmon' on 'prmdb' CRS-2676: Start … Continue reading ORA-29701: unable to connect to Cluster Synchronization Service

ORA-27054: NFS file system where the file is created or resides is not mounted with correct options

bash-3.2$ impdp system/***** directory=import_dir nologfile=y dumpfile=exp_swx_20092012.dmp full=y ORA-39001: invalid argument value ORA-39000: bad dump file specification ORA-31640: unable to open dump file "/USwitch/exportdump/exp_swx_20092012.dmp" for read ORA-27054: NFS file system where the file is created or resides is not mounted with correct options Additional information: 3 Additional information: 18 While trying to import a dumpfile from … Continue reading ORA-27054: NFS file system where the file is created or resides is not mounted with correct options

ORA-00257 archiver error. Connect internal only, until freed

// *Cause: The archiver process received an error while trying to archive // a redo log. If the problem is not resolved soon, the database // will stop executing transactions. The most likely cause of this // message is the destination device is out of space to store the // redo log file. // *Action: … Continue reading ORA-00257 archiver error. Connect internal only, until freed

Delete large number of records Oracle

When a large number of records neds to be deleted from a table. If you do a normal delete it will consume the UNDO tablespace. To avoid such a scenario in a production environment. You can use below procedure to commit frequently. In my opinion it is better to schedule the procedure as a daily … Continue reading Delete large number of records Oracle

ORA-00980: synonym translation is no longer valid

This error occurs when you have a public synonym defined and the object referencing or owning the synonym has been dropped or deleted. You can check for the invalid synonyms using below query. select * from dba_synonyms s where table_owner not in('SYSTEM','SYS') and db_link is null and not exists (select 1 from dba_objects o where … Continue reading ORA-00980: synonym translation is no longer valid

ORA-38753: Cannot flashback data file ; no flashback log data. ORA-01110: data file

CAUTION !!!! DO NOT DO THIS ON YOUR PRIMARY. IF YOU DO THEN YOU WOULD REQUIRE MEDIA RECOVERY ON THE DATAFILE YOU BROUGHT OFFLINE !!!   If your getting this error when you converting a Snapshot Standby Database (11gR2) back to Physical Standby Database. SQL> ALTER DATABASE CONVERT TO PHYSICAL STANDBY; ERROR at line 1: … Continue reading ORA-38753: Cannot flashback data file ; no flashback log data. ORA-01110: data file

Active Session History 11g

Even when sessions are inactive they can be executing SQL's in the background. You have to identify the SQL's which are executing. Run this query as sysdba user. If you are using RAC then replace v$active_session_history with gv$active_session_history select ash.SQL_ID , sum(decode(ash.session_state,'ON CPU',1,0)) "CPU", sum(decode(ash.session_state,'WAITING',1,0)) - sum(decode(ash.session_state,'WAITING', decode(en.wait_class, 'User I/O',1,0),0)) "WAIT" , sum(decode(ash.session_state,'WAITING', decode(en.wait_class, 'User … Continue reading Active Session History 11g

ORA-01858 a non-numeric character was found where a numeric was

Error: ORA-01858: a non-numeric character found where a digit was expected Cause: You tried to enter a date value using a specified date format, but you entered a non-numeric character where a numeric character was expected. Action: The options to resolve this Oracle error are: Check the date formats recognized by the to_date function. Correct … Continue reading ORA-01858 a non-numeric character was found where a numeric was