Oracle

Job Queue Process use lots of memory
Hello, Now the ORACLE was often down every one week. But this issue had not happened before. And checking the system monitor log, it shows that the memory was used up. And, according to the alert log, it shows that the oracle was dead because * kkjcre1p: unable to spawn jobq slave process * Except this, there ... 5 Jan 2007 01:10

Agent 10.2.0.2 patchset install on AIX
Platform: AIX Version 5.3 patch/maintenance level 05 Installed Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit. Runing fine. Installed agent in it's own oracle home: Oracle Enterprise Manager 10g Release 10.2.0.1.0. Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved. --------... 27 Dec 2006 12:12

Client problem
I'm working with an application that uses Net8 to communicate with an Oracle server. On a particular notebook computer, I'm having a communication problem from the 8.0.6 client to the server. This machine has multiple Oracle homes for 9i and the older 8.0.6 client. The home for the 8 client is currently selecte... 15 Dec 2006 12:10

Oracle Chaining
Oracle 9i standard. Ive noticed by looking at DBA_TABLES that some tables have excessive CHAIN_CNT, the highest been 3266085 on a 45 million row table. I've set the pct_free to 35 up from 10 but the CHAIN_CNT continues to climb, is there anything else I can try ? Thx in advance ... 14 Dec 2006 15:47

Client Connection Error (TNS-12518 TNS-12560 TNS-00530)
Hello All, we have a problem connecting to an Oracle DB 10.2 in a Windows environment. In the servers listener.log I found the following errors: TNS-12518: TNS: Listener konnte Client-Verbindung nicht weitergeben TNS-12560: TNS: Fehler bei Protokolladapter TNS-00530: Protokolladapter-Fehler ... 18 Oct 2006 08:58

-1555-ORA-01555: snapshot too old: rollback segment number 7 with name "_SYSSMU7$" too small
Hi, i have this errors in an oracle 9.0.2 db, on a hp-ux system. I have read some info about this issue, i executed this query: SELECT segment_name, tablespace_name, bytes, blocks, extents FROM sys.dba_segments where tablespace_name like 'UN%'; and i obtained this results: SEGMENT_NAME,TABLESPACE_NAME,BYTES,... 13 Sep 2006 17:07

Oracle sql completed with warnings...
Hi !! I found this in the logs of my application server: org.hibernate.util.JDBCExceptionReporter SQL Warning: 17110, SQLState: null org.hibernate.util.JDBCExceptionReporter Warning: execution completed with warning How can I find the detail of the warnings in oracle ? I think I found the sql request that... 7 Jul 2006 14:42

nmeo.exe
Hi Does anybody know what the process nmeo.exe is for? I installed Oracle 10 Enterprise Edition yesterday on Windows 2000 SP4. Every time my machine starts up I get a memory address error with nmeo.exe and I have to terminate it. I have searched google groups and google web and have not found any informatio... 22 Jun 2006 08:04

10gr2 libaio.so.1 missing
I've reinstalled it at least 3 times.. each time the file is missing. When I startup I get oracleWRHS: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory ERROR: ORA-12547: TNS:lost contact I also tried compiling async_on/off with no success [WRHS@... 14 Apr 2006 21:43

oracle10g manual database cloning
Hi Gurus, I have cloned oracle10g database by manual method. Steps 1. edit trace file (save clone.sql) 2) edit init.ora for clone DB. 3) copy the datafiles,controls to respective locations. 4) startup nomount 5) sql>@clone.sql 6) sql> recover database using backup controlfile until cancel; NOW, How do I ... 18 Apr 2006 14:26