Oracle

DBMS_OLAP
Hi! I couldn't find anything about DBMS_OLAP installation. Nothing in $ORACLE_HOME/rdbms/admin. I run 9i Release 9.2.0.1.0 under AIX 5.2. Could anyone help ? ... 15 Nov 2005 15:49

Database Connection Control
Hi All, I recently encountered the following bug with my Oracle 9.2.0.6 production database. Bug 1725012 -- ORA-600 [TTCGCSHND-1] CONNECTING FROM 817 CLIENT TO 9I USING THIN DRIVER (JDBC) One of an inactive client, installed with 8i JDBC thin driver, wake up at one time and tried to connect to the productio... 15 Nov 2005 14:46

Planning to install 10G RAC
Hi there, just couple of guestions :) We are planning to install 10G RAC on Sun Solaris But what is your recommendations why to use Oracle Cluster (CRS) or why to use other "o/s cluster" why to start using ASM or why other filesystem All links are welcomed with joy :) Cheers and thank you Kalle ... 15 Nov 2005 16:52

Pmon & SMOn
Hi Friends, I am just confused between PMON & SMON relating to Rollback transaction. There are documents saying that PMON is responsible for Rolling back the uncommitted transactions upon recovery after crash or instance failure. But also read that SMON is responsible for crash recovery , which i think involv... 14 Nov 2005 09:01

Trouble opening up a DB after removing a dbf manually
Dear Oracle Masters, I have deleted a file through unix (BOBBY_TBSP.dbf ) because it was corrupted and now my oracle instance does not start up, using my username and password: -bash-3.00$ sqlplus testdb/testdb SQL*Plus: Release 9.2.0.6.0 - Production on Thu Nov 10 10:48:21 2005 Copyright (c) 1982, 2002, Or... 11 Nov 2005 00:29

Recovery time
We are currently trying to test our backup/restore/recover procedures at work. We are new to RMAN and I am new to Oracle. On small databases we have been able to use RMAN along with Veritas to backup to tape and restore/recover a database. We have now moved the same scripts to attempt the procedures on a product... 10 Nov 2005 20:20

Sqlplus timeout
Hi, My application is doing a select a a view. I have a Bash script which run Sqlplus using a .sql file. the query is done in this file. I don't know how the view has been created, how it compute the rows... it's another application. I have no control over it. I just need my script not to exit in timeout ... 9 Nov 2005 21:42

How do I view CLOB in Dbvisualizer?
I'm using DBVISUALIZER. How can I edit the contents of a CLOB/BLOB column that is originally text? Thanks for your help. ... 13 Nov 2005 14:21

Strange SQL
My VB application accesses the database via ADO and it seems that ADO (or is it the trace utility??) performs some weird SQL statements, which slows down the overall performance of the database. All these statements look like select * from (select null TABLE_CATALOG, ac.owner TABLE_SCHEMA, ac.table_name TABLE_... 12 Nov 2005 20:12

ORA-00600
Any body knows what is this: ORA-00600: internal error code, arguments: [kksscl-inf-inl-loop], [1500], [2], [9], [65], [65], [], [] ORA-00600: internal error code, arguments: [kksscl-inf-inl-loop], [1500], [1], [1], [23], [23], [], [] ORA-00600: internal error code, arguments: [kksscl-inf-inl-loop], [1500], [1], ... 9 Nov 2005 21:42