Problem:
On Windows 2008, the R12.1 instance has become flaky, not allowing connections and responding slowly.
Solution:
Tweak the IRPStackSize registry parameter, or change the memory allocated to user processes using the BCDEDIT Windows command.
Tag Archives: Alert Log
ORA-27300: OS system dependent operation:CreateThread failed with status: 8
Posted by Vasudev Seeram
on August 9, 2012
No comments
ORA-1688: unable to extend table SYS.WRH$_ACTIVE_SESSION_HISTORY partition WRH$_ACTIVE_3395507964_562
Posted by Vasudev Seeram
on July 19, 2012
1 comment
Problem:
Checked alert log file and saw the following errors:
ORA-1688: unable to extend table SYS.WRH$_ACTIVE_SESSION_HISTORY partition WRH$_ACTIVE_3395507964_562 by 128 in tablespace SYSAUX MMON Flush encountered SYSAUX out of space error(1688). MMON (emergency) purge of WR snapshots (546) and older ORA-1688: unable to extend table SYS.WRH$_ACTIVE_SESSION_HISTORY partition WRH$_ACTIVE_3395507964_562 by 128 in tablespace SYSAUX MMON Flush encountered SYSAUX out of space error(1688). MMON (emergency) purge - nothing to purge, pgsid=0.
Solution:
Add a new datafile to the SYSAUX tablespace.
Internal Server Error
Posted by Vasudev Seeram
on December 4, 2008
No comments
Problem:
Internal Server Error when trying to log in to Oracle Applications
Solution:
Ran out of tablespace. Checked alert log to tablespaces to extend.
Insufficient privileges for current operation
Posted by Vasudev Seeram
on December 2, 2008
No comments
Problem:
When logging on to HRMS Production instance as SYSADMIN, the following message is displayed:
You have insufficient privileges for the current operation
Solution:
Log on to the HRMS Production server. Check the alert log for any ORA errors by issuing the following commands:
[applmgr@ebusiness /]$ [applmgr@ebusiness bdump]$ cd /u0/oracle/proddb/9.2.0/admin/PROD_ebusiness/bdump/ [applmgr@ebusiness bdump]$ tail alert_PROD.log Current log# 2 seq# 33933 mem# 1: /u0/oracle/proddata/log02b.dbf Tue Dec 2 09:46:30 2008 Completed checkpoint up to RBA [0x848d.2.10], SCN: 0x056d.102174e9 Tue Dec 2 10:00:40 2008 Beginning log switch checkpoint up to RBA [0x848e.2.10], SCN: 0x056d.1021d85e Thread 1 advanced to log sequence 33934 Current log# 1 seq# 33934 mem# 0: /u0/oracle/proddata/log01a.dbf Current log# 1 seq# 33934 mem# 1: /u0/oracle/proddata/log01b.dbf Tue Dec 2 10:15:50 2008 ORA-1654: unable to extend index ICX.ICX_SESSIONS_N1 by 35 in tablespace ICXX [applmgr@ebusiness bdump]$ [applmgr@ebusiness 9.2.0]$ sqlplus apps/******** SQL*Plus: Release 9.2.0.3.0 - Production on Tue Dec 2 10:25:25 2008 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.3.0 - Production SQL> desc dba_data_files Name Null? Type ----------------------------------------- -------- ---------------------------- FILE_NAME VARCHAR2(513) FILE_ID NUMBER TABLESPACE_NAME VARCHAR2(30) BYTES NUMBER BLOCKS NUMBER STATUS VARCHAR2(9) RELATIVE_FNO NUMBER AUTOEXTENSIBLE VARCHAR2(3) MAXBYTES NUMBER MAXBLOCKS NUMBER INCREMENT_BY NUMBER USER_BYTES NUMBER USER_BLOCKS NUMBER SQL> select tablespace_name, file_name, bytes/1024/1024 from dba_data_files where tablespace_name = 'ICXX'; TABLESPACE_NAME FILE_NAME BYTES/1024/1024 --------------- ------------------------------ --------------- ICXX /u0/oracle/proddata/icxx01.dbf 20 SQL> alter tablespace icxx add datafile '/u0/oracle/proddata/icxx02.dbf' size 20M; alter tablespace icxx add datafile '/u0/oracle/proddata/icxx02.dbf' size 20M * ERROR at line 1: ORA-01031: insufficient privileges SQL> connect system/******** Connected. SQL> alter tablespace icxx add datafile '/u0/oracle/proddata/icxx02.dbf' size 20M; Tablespace altered. SQL> select tablespace_name, file_name, bytes/1024/1024 from dba_data_files where tablespace_name = 'ICXX'; TABLESPACE_NAME FILE_NAME BYTES/1024/1024 --------------- ------------------------------ --------------- ICXX /u0/oracle/proddata/icxx01.dbf 20 ICXX /u0/oracle/proddata/icxx02.dbf 20
Log on to SYSADMIN and confirm that the issue no longer exists.
Recent Comments