Oracle

ORA-12514
Hello, I am trying to get a unix user (not the oracle user) to connect to a database on the same server. ORACLE_SID is correctly set to REPORT in the environment. sqlplus username/password works just fine sqlplus username/password(a)REPORT kicks out a ORA-12514: TNS:listener does not currently know of service re... 8 Jul 2008 06:56

prioritize inserts i.s.o replication
Hi all, I set up two dbs with streams replication (A and B) A gets all inserts that are replicated to B. When replication stops and is started again inserts into A lead to unacceptable commit times (20 seconds i.s.o the normal 200ms) while replication catches up at full speed. Is there a way to prioritize the ... 8 Jul 2008 04:53

Could I use user defined function in default value of a column?
I wanna add a default value which from a user defined function.But oracle raise an error. Could I do that? if I could, how? Thanks a lot Jack.Lee ... 8 Jul 2008 16:11

Oracle service in RAC
Hi there, One of our database services in 10g RAC: test PREF: test1 test2 test3 AVAIL: test4 test5 Since test1, test2 and test3 were all down, now service test is running on test4 and test5. Now test1 to test3 are back online; do I have to restart the service to make the service test relocate from test4/5 t... 7 Jul 2008 17:39

Inconsistent multi-block io
I'm on 10gR2 on AIX with ASM. have DB_FILE_MULTIBLOCK_READ_COUNT=16 in spfile. but still see different block size for "db file scattered read" ranging from 2 to 16. Can someone explain why its ranging from 2-16? Shouldn't DBRC always be followed if it's set in SPFILE? see below excerpts from 10046 trace file. ... 9 Jul 2008 11:38

Senior Oracle DBA Needed
Hi Please see below the requirement details and send me your consultants updated resume, hourly rate, availability and current location. Please do call me if you have any questions. Position: Senior Oracle DBA Skills: Oracle RAC, data-warehousing, Performance Tuning and Teradata would be a big plus Location:... 7 Jul 2008 15:35

"add databases to tree" dialog box not appearing
We are running OEM 8i on a WINDOWS 2000 box . When we click on file/add database to tree, nothing happens. It used to work. Is there some log we can look at ? Is it a WINDOWS problem rather than ORACLE ? Could anyone please advise ? Thanks ... 8 Jul 2008 15:09

ORA-01157
Hello, Have a tablespace to repair - its a new database so dataloss no problem. The guy who created it originally is "not available" I get this error: SQL> conn / as sysdba Connected. SQL> shutdown ORA-01109: database not open Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance ... 7 Jul 2008 15:35

Enterprise manager is Not Connecting to database
Hi I installed oracle 10g on my system the installation was successfull but in the enterprise manager console 1.database instance is down 2.Listener is up and running 3.Agent Connection to Instance Status Failed Details ORA-12505: TNS:listener does not currently know of SID given in connect descript... 7 Jul 2008 05:19

Differences in BULK COLLECT between 9i and 10g?
Oracle 9i 9.2.0.1.0, Windows XP Pro In playing around with the 9i on my desktop I've come across something which has me a bit baffled. In the first code segment I have a cursor where I return a row based on a database table. I then BULK COLLECT into the nested table which is defined on the database table. ... 8 Jul 2008 03:52