abhishektripathydba / troubleshooting-scripts Goto Github PK

Tanel's Oracle Troubleshooting Scripts
--------------------------------------

Here is scripts and tools used at Tanel's Oracle Troubleshooting seminars
 from  http://tech.e2sn.com/oracle-scripts-and-tools/

See also Tanel Poder's blog 
 http://blog.tanelpoder.com/2011/03/24/an-index-of-my-tpt-scripts/

1. Create directories for temporary files:
   mkdir -p ~/tpt/log

2. Set up environment:
   SQLPATH = ~/tpt
   export SQLPATH

3. Unarchive sql-scripts to apropriate directory:
   mkdir ~/poder
   tar zxvf http://files.e2sn.com/scripts/tpt_public_unixmac.tar.gz -C ~/poder

4. Create you own $HOME/login.sql file:
   @poder/login.sql
   --
   -- you can put your own login scripts here 
   --


Now you can use scripts from Oracle SQL*Plus:

username@servername:~$ sqlplus /nolog

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> conn db_user/db_pwd@db

Connected to:
Oracle Database 10g Release ...

SQL> @poder/help [ --list | script_name ]
         --list      - list all available scripts with short descriptions
         script_name - get help for specific script


Project is hosted on SourceForge: http://sourceforge.net/projects/oracledba

 -- Sergey Kryazhevskikh <[email protected]>