Oracle

DBMS_AQ
I am trying some sample about oracle AQ. But I run into some trouble. When I try to create a procedure in SQLPLUS using the following script: CREATE OR REPLACE PROCEDURE New_enqueue( Queue_name IN VARCHAR2, Payload IN RAW , Correlation IN VARCHAR2 := ... 14 Feb 2005 19:19

Upgrade issue? Can't start/stop oracle if non dba started it
Hi, recently upgraded from Oracle 8.1.7 to 9.2 on Solaris 9 and I'm having some problems. One of our applications won't start if I start Oracle as an oracle dba (gid is dba). There seems to be some issue there If I start Oracle is a member of the dba group but has a different active group the application will ... 14 Feb 2005 19:18

constraint disable (no)validate
Hello What is the difference between: CONSTAINT DISABLE VALIDATE and CONSTAINT DISABLE NOVALIDATE ? Does NOVALIDATE keeps indexes associated with constraint and VALIDATE remove them ? Are there any other differences ? Thanx Michal ... 14 Feb 2005 19:18

Viewing a Table's Fragmentation
Is there a way with Oracle Enterprise Manager to view a given tablespace's level of fragmentation? ... 14 Feb 2005 19:18

OEM, Or10
Is there still only the web interface for Oracle 10, OEM? I don't like it, and would much prefer the other interface! ... 14 Feb 2005 19:18

10g installation on Suse SLES 9 - failed
All, I have a fresh install of SLES-9 fully patched on 32 bit Intel server. (30 day trial, downloaded). orarun has been installed (orarun-1.8-109.5.i586.rpt from CD All requirements are met as per Oracle documentation. During 'Linking Oracle Net Required Support Files 10.1.0.3.0' I get an 'Error in invokin... 14 Feb 2005 19:18

TNS-12541 No Listener Error
Hi, I am receiving a 12541 error trying to connect to an oracle listener on redhat linux. When I do an lsnrctl status it shows that the listener is running (I also did an lsof -i to verify that the port was being used by tnslsnr). When I connect via sqlplus and run show parameter service_name it displays my SID... 14 Feb 2005 19:18

ORA-00060 "deadlock detected" not written to log files
Hi all, From what I've read ORA-00060 is written to alertSID.log (in BACKGROUND_DUMP_DEST) and trace file (in USER_DUMP_DEST). I don't see Oracle doing that in our environment...Our java apps. pick these errors. Is there a parameter or anything needs to be set for Oracle to write the deadlock error? RDBMS Ve... 14 Feb 2005 19:18

ORA-12546: TNS:permission denied / telnet: socket: Permission denied
I just want to share my tricky problem we had today. We noticed users not able to login to SQL plus or telnet from them box. Everything else was working fine. You can ftp / login / rlogin etc. Nothing was changed and no new software was installed. We rebooted the server that did not help. Finally we found that i... 14 Feb 2005 19:18

Oracle 10g Installation
Hello Friends, Having a linux box running Red Hat Enterprise ES version 3 for AMD64/EMT64. Hardware is Dell PowerEdge 2850 with two Xeon 3GHz processors (supporting EMT64). Upon installing Linux x86-64, netca and dbca failed. As advised, I made sure that my IP is static (looking at the ifcgf-eth0 files BOOTPRO... 14 Feb 2005 19:18