Posts Tagged ‘Oracle ORA: Errors’

SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled

+22 SP2-0618: Cannot find the Session Identifier.  Check PLUSTRACE role is enabled SP2-0611: Error enabling STATISTICS report –Got below problem:

ORA-39001 ORA-39000 ORA-31641 ORA-27040

+21 ORA-39001 ORA-39000 ORA-31641 ORA-27040 Taking table/schema dump gets failed using EXPDP with below error: Problem: Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options ORA-39001: invalid argument value ORA-39000: bad dump file specification ORA-31641: unable to create dump file "/home/oracle/backupwk/mafsdb/expdat.dmp" […]

ORA-16826: apply service state is inconsistent with the DelayMins property

+15 DGMGRL> show configuration; Configuration – cobra Protection Mode: MaxAvailability   Databases:     cobra    – Primary database     cobradup – (*) Physical standby database       Warning: ORA-16826: apply service state is inconsistent with the DelayMins property

ORA-00270 ORA-16401

+14 Wed Nov 28 06:34:37 2012 LNS: Closing remote archive destination LOG_ARCHIVE_DEST_2: 'nsnstd' (error 1950                                             2)  (nsndb) Wed Nov 28 06:34:37 2012 Errors in file /export/home/oracle/admin/nsndb/bdump/nsndb_lns1_24654.trc: ORA-00270: error creating archive log LNS: Failed to archive log 4 thread 1 sequence 7457 (270)

ORA-19502 ORA-16055

+15 ORACLE Instance nsndb – Archival Error. Archiver continuing. Wed Nov 28 05:56:16 2012 Errors in file /export/home/oracle/admin/nsndb/bdump/nsndb_arc0_998.trc: ORA-19502: write error on file "", blockno  (blocksize=) Wed Nov 28 05:56:17 2012 FAL[server, ARC0]: FAL archive failed, see trace file. Wed Nov 28 05:56:17 2012 Errors in file /export/home/oracle/admin/nsndb/bdump/nsndb_arc0_998.trc: ORA-16055: FAL request rejected ARCH: FAL archive […]

UDI-04031 ORA-04031 ORA-06512 ORA-06512 ORA-25254

+10 UDI-04031: operation generated ORACLE error 4031 ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","SELECT job_id FROM v$datapum…","SQLA","tmp") ORA-06512: at "SYS.KUPV$FT_INT", line 2904 ORA-06512: at "SYS.KUPC$QUE_INT", line 572 ORA-25254: time-out in LISTEN while waiting for a message ORA-06512: at "SYS.DBMS_DATAPUMP", line 3263

ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

+10 ORA-01652: unable to extend temp segment by 128 in tablespace TEMP   SOL: Check the default temporary tablespace first , execute the following query: SQL> SELECT * FROM DATABASE_PROPERTIES where PROPERTY_NAME='DEFAULT_TEMP_TABLESPACE'; Now check the TEMP Tablespace used and free spaces as below: SQL> select TABLESPACE_NAME, BYTES_USED, BYTES_FREE from V$TEMP_SPACE_HEADER; TABLESPACE_NAME                BYTES_USED BYTES_FREE