Thread 1 Cannot Allocate New Log / Sequence In Alert Log
Jul 11, 2012
I am getting the below message in my alert log
System: AIX6.1 - Oracle 11r2
GROUP# THREAD# MEMBER ARCHIVED STATUS MB
1 1 +DATA01/mydb/redolog_group1_member1 NO INACTIVE 1536
1 1 +DATA01/mydb/redolog_group1_member2 NO INACTIVE 1536
2 1 +DATA01/mydb/redolog_group2_member2 NO CURRENT 1536
2 1 +DATA01/mydb/redolog_group2_member1 NO CURRENT 1536
3 1 +DATA01/mydb/redolog_group3_member2 NO INACTIVE 1536
3 1 +DATA01/mydb/redolog_group3_member1 NO INACTIVE 1536Tue Jul 10 18:37:48 2012
[code]....
Could an increase on the redo log file sizes solve this problem? Unfortunately I do not have a test platform, where I could have tested this.
While starting up my database i am getting this error.by mistake i had moved log files, and after some time again i inserted those log files again into same directory i am getting this error.
When i open the primary database in my dataguard env,it raise error?
SQL> alter database open; alter database open * ERROR at line 1: ORA-00314: log 1 of thread 1, expected sequence# 77 doesn't match 0 ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/oracl/redo01.log'
As stated in "Determining which Oracle database session is being used by a specific Siebel user session [ID 863771.1]":
On the Oracle database side, you can query the V$SESSION table (make sure you are logged in as the tableowner) using the following WHERE clause format:
WHERE PROCESS='XXXX:YYYY'
XXXX = Server PID YYYY = Thread ID
So querying v$session, sessions opened by windows clients have in the PROCESS column values like "12345:876", where 12345=process id and 876=thread id.
Our application servers are installed in AIX, which is also multithreaded, but in the PROCESS column only process id is stored. Is there any way to find thread id?
I encountered error ORA-00338 while performing incomplete database recovery:
ORA-00283: recovery session canceled due to errors ORA-00338: log 3 of thread 1 is more recent than control file ORA-00312: online log 3 thread 1: '+DG_REDO/dbase/onlinelog/group_3.267.814820795' Recovery Manager complete.
I performed this recovery on oracle 10g, ASM database.
1. What are possible causes behind this error ORA-00338 ?
2. This error occurs at the start of media recovery, while RMAN is applying archived logs. So does RMAN apply "online REDO" logs after applying "archived" logs required for recovery or before them ?
3. How does rman come to know that online log 3 is more recent than control file ? How can I get scn of online log & control file in my environment ?
Following are few details related to checkpoint scn/change# info. I found in my environment..Before recovery:
differences of enabling thread as public or private?
lets assume that i have two threads (1, 2) for two instances (1, 2) and each of thread consists of 2 redolog groups - minimum configuration.in case i need add third node i need third thread.
what will be difference if i set this thread as public instead private?
it is necessary to allocate channel for rman back up and during rman back up what should be the state of target database me script for configuration and incremental level 1 daily back up script
and normal oracle secure incremental level bacl up script back up should be done daily
When i try to extract create statement of table i get below error message.
SQL> SQL> set heading off SQL> set pagesize 0 SQL> set long 1000000 SQL> set feedback off SQL> select 2 dbms_metadata.get_ddl( 'TABLE','CATALOG_TBL','JACK') 3 from 4 dual 5 /
ERROR:
ORA-04031: unable to allocate 104 bytes of shared memory ("shared pool",
"SELECT /*+rule*/ SYS_XMLGEN(...","SQLA^fc8f5280","qecsub : qkxrPXformQbc") ORA-06512: at "SYS.DBMS_METADATA", line 2625 ORA-06512: at "SYS.DBMS_METADATA", line 2668 ORA-06512: at "SYS.DBMS_METADATA", line 2983 ORA-06512: at "SYS.DBMS_METADATA", line 3897 ORA-06512: at "SYS.DBMS_METADATA", line 5678 ORA-06512: at line 1
Note: ---- I am executing this command from another user 'DEMO' which has got DBA privilege.
how to fix this error and extract the create table statement.
I am seeing the following error message in alert.log (ORA-04031: unable to allocate 32 bytes of shared memory ) and my database goes into hung state and wont let any new sessions to connect and old sessions just hung with no response. i have to kill the instance to come out of this problem.
I am running 11.2.0.3 on AIX and have memory_target=35GB. I would like to know what approach to take to find out the root cause of this? btw - does AWR show if memory was under pressure and what SQL's were consuming more memory just before the problem surface?
create a procedure or cursor to allocate extents to all tables with zero rows for all the user in the database.I have used the below query to check table with zero rows and no extents allocated.
select onwer,table_name,initial_extent from dba_tables where initial_extent is null order by owner; I generated the query to allocate extents by using concatenation in the above query. select 'ALTER TABLE '||table_name|| ' ALLOCATE EXTENT; ' from dba_tables where initial_extent is null order by owner;
now I want the extent allocation for such table auutomatically for aal the tables with zero rows.
I have a stored procedure which uses BULK COLLECT and the table has 16 nested tables within it. When I limit the number of rows processed it works fine, if I let it run with all the 10,000 rows I get this:
ERROR: ORA-04030: out of process memory when trying to allocate 16408 bytes (koh-kghu call ,pmuccst: adt/record)
Single Laptop Machine of 16GB RAM. Assigned 13GB to VM.
I have installed Oracle Database 11g. 11.2.00. When I try to access my application many times I received below error
• Error: “”Caused by: java.sql.SQLException: Could not retrieve datasource via JNDI url 'jdbc/oimJMSStoreDS' weblogic.jdbc.extensions.ConnectionDeadSQLExceptio n: weblogic.common.resourcepool.ResourceDeadException : Could not create pool connection. The DBMS driver exception was: ORA-00604: error occurred at recursive SQL level 3 ORA-04031: unable to allocate 352 bytes of shared memory ("shared pool","select /*+ rule */ bucket_cn...","SQLA^337fc737","qertbs:qertbIAlloca te") [code]......
Even when above error occur I have 7GB free JVM so JVM is not an Issue.
•I have updated Max Capacity of oimOperationsDB =100,oimOperdationDB, oimJMSStoreDS=80,SOADATAStore =80. But still I have error
• ERROR:: • ““Aug 30, 2012 3:24:10 PM EST> <Warning> <oracle.integration.platform.blocks.event.saq> <SOA-31013> <Error handling message (rolling back). java.sql.SQLException: ORA-04031: unable to allocate 352 bytes of shared memory ("shared pool","select /*+ rule */ bucket_cn...","SQLA^337fc737","qertbs:qertbIAlloca te") ORA-06512: at "SYS.DBMS_AQ", line 335 ORA-06512: at "DEV_SOAINFRA.EDN_DEQUEUE_OAOO_DELIVERY", line 14” [code]......
I have modified Shared_pool_size,large_pool_size. Content of my modified Pfile is as below.
o orcl.__db_cache_size=822083584 o orcl.__java_pool_size=2777216 o orcl.__large_pool_size=56777216 o orcl.__oracle_base='/home/oracle/app/oracle'#ORACLE_BASE set from environment o orcl.__pga_aggregate_target=805306368 o orcl.__sga_target=1174405120 o orcl.__shared_io_pool_size=0 o orcl.__shared_pool_size=601989888 o orcl.__streams_pool_size=0
What’s value of parameter I need to set for datastore, pfile ? (I have 13GB of memory).
Windows 2003 Server Enterprise Edition, Service Pack 2. 3.5GB RAM.Two Oracle Databases running on this server, one not heavily used. On the database i am concerned with it is 10.2.0.3.0.
I have just started to look at this database and am seeing various things in the alert log and have had user error messages as well.Initially when i started looking at this server it was running with quite a small SGA (600MB) and the memory_target_advice was saying to take it to 1000MB.(PGA is around 200MB)
In January, before i looked at it, it started to throw:
ORA-04031 unable to allocate 16 bytes of shared memory ("shared pool","........", "sql area", "tmp") These would occur regularly and mostly during nightly processes, it seems, and thus not bubbling up to users.Having switched the SGA_MAX_SIZE to 1GB a new set of errors starts to appear in the alert log:
ORA-27301: ..... Not enough storage is available to process this command ORA-27302: ..... ssthrddcr
At the same time the ORA-04031 errors start to bubble through to the users. Before i could return to the scene of the crime someone else set the SGA back to 600MB and the error messages stopped. However the ORA-04031 message start to reappear in the alert log. My questions are many and, mostly, from a lack of knowledge ;) In particular:
1. Why would increasing the SGA lead to a different memory error? I would assume this would have something to do with the amount of memory a 32bit OS will allow a single process to address but the PGA+SGA is only 1200MB.
2. How does a ORA-273xx error end up with a ORA-04031 being shown to the users? I would look at the listener log but its over 2GB!!!
We had the following error in alertlog repeatedly from 5 PM to 10 PM :
ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","SELECT VERSION FROM PSVERSIO .....Since MEMORY_TARGET is defined in spfile then shared pool is managed automatically.
I have installed Oracle 10g on my PC and create a Database on it. I wanted to connect it with PL Sql Developer with the same PC but it`s not connecting. It gives the following error "ORA-01019: unable to allocate memory in the user " And some time blank error message box.
what is the meaning of 'SBT_TAPE' in the following command in RMAN? In the following command, does it refer to a tape drive, or a hard disk backup?
allocate channel t1 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=<a backup server server name>,NSR_CLIENT=<a oracle server>,NSR_DATA_VOLUME_POOL=ORACLE ARCHIVE LOG)';
At the end of my installation I received the following error message:
Sep 11, 2010 4:20:49 PM oracle.sysman.emcp.EMConfig perform SEVERE: Failed to allocate port(s) in the specified range(s) for the following process(es): JMS [5540-5559],RMI [5520-5539],Database Control [5500-5519],EM Agent [3938] | [1830-1849] Refer to the log file at /u01/app/oracle/cfgtoollogs/dbca/orcl/emConfig.log for more details. Sep 11, 2010 4:20:49 PM oracle.sysman.emcp.EMConfig perform [code]....
I found a thread that reported a similar issue and was directed to Oracle Support Document 353843.1 . The suggestion was to adjust the /etc/hosts file, but I don't see anything wrong in the file:
[oracle@jhlinux etc]$ cat hosts # Do not remove the following line, or various programs # that require network functionality will fail. # ::1 localhost6.localdomain6 127.0.0.1 localhost.localdomain localhost 192.168.1.254 jhlinux.home.com jhlinux
I have a package when it runs, it terminates with "unable to allocate 4120 bytes of shared memory"error at a particular INSERT statement. So everytime we had this error, we had to flush the shared pool area, after which it would run without issues(for 3-4 weeks).
It had a dynamic subpartition clause framed, which made it to repharse the query every time.So to reduce this, we removed the subpartition clause(made it to static query), which did benefit of not getting shared pool error.
I would like to find the current shared pool memory usage of my program.Is there a way I could find the live consumption of shared pool area of my program(pkg).
