ORA-15655: preliminary connection+oradebug direct_access
ORA-15655: Fixed table \\”%s\\” cannot be accessed safely in prelim connection. When login to oracle using preliminary connection ( wrote about it few days ago )
Getting Oracle stack using Oradebug short_stack
To collect stack traces for debugging I normaly use on OS debuggers like (pstacke, gdb, dbx – it depends on which platform Oracle runs ) .From Oracle I would run oradebug commands dump errorstack or oradebug short_stack command.Today I will focus on oradebug short_stack
sqlplus preliminary connection..
I had a very interesting case today when database hang and I was not able to make connection.. First thing I had in mind was to generate system state dumps.In the past I used debugger but I remember that sqplus has option which makes database connection “light” meaning it doesn not create session but has limited access … Read more
ORA-03135 : Database Resident Connection Pool
Trying to setup DRCP 11g patchset 11.1.0.6 on Linux x86-64.. The pool can be configured using the PLSQL package DBMS_CONNECTION_POOL. First start connection pool ( I am using default parameters ): SQL> execute dbms_connection_pool.start_pool; PL/SQL procedure successfully completed. Then simply change tnsnames.ora and set SERVER=POOLED Let’s try to connect C:\Documents and Settings\admin>sqlplus system@demo11g … Read more
Script to show disk usage/allocation of VxVM/SEVM disk groups
I used run this script on Solaris … You can customize it e.g. ( to display certain groups only ) Usage: vxusage -a | -l | diskgroup_name
