sqldir not install in 10.2.0.4
| Question ID: 3764 | |
| Created By: | 2009-SEP-23 08:29:33 [Amrismail2000] |
| Updated By: | 2009-SEP-30 11:49:01 [Vitaliy] |
| Status: | Open |
| Severity: | Normal |
| Read Only: | No |
|
10500
2009-SEP-23 08:29:33
|
||||
|
hi i try to install sqldir on linux test server and if it good i will run it on a production server so i need the install in detail not like what i found .some steps not working so help me as you can thanks Amr
[edited by: Vitaliy at 11:23 (CST) on Sep. 23, 2009]
|
10501
2009-SEP-23 11:24:39
|
||||
|
I'll put something together for 10.2.0.4 give me few days
|
10505
2009-SEP-24 11:52:29
|
||||
|
thanks for your concern Amr
|
10512
2009-SEP-28 02:44:37
|
||||
|
Hi I’m still waiting Thanks Amr
|
10526
2009-SEP-30 01:52:31
|
||||
|
Here are the instructions for 10.2.0.4: ## ## 1) create SQLDIR directory and move/extract sqldir_dreq.tar ## dbaconsole.yourdomain.com.10GR2-> mkdir sqldir dbaconsole.yourdomain.com.10GR2-> mv sqldir_dreq.tar ./sqldir dbaconsole.yourdomain.com.10GR2-> cd ./sqldir/ dbaconsole.yourdomain.com.10GR2-> ls -l total 216 -rw-r--r-- 1 oracle oinstall 214016 Sep 29 23:08 sqldir_dreq.tar dbaconsole.yourdomain.com.10GR2-> tar xvf sqldir_dreq.tar sqldir/ sqldir/bin/ sqldir/bin/dirlist.bat sqldir/bin/dirlist.sh sqldir/bin/groups.cfg sqldir/bin/groups.cfg.ALL.SEED sqldir/bin/sqldir sqldir/bin/sqldir.exe sqldir/bin/sqldir.list sqldir/bin/sqldir.list.UNIX.SEED sqldir/bin/sqldir.list.WIN.SEED sqldir/bin/sqldir_ddl.log sqldir/bin/sqldir_ddl.sql sqldir/bin/sqldir_grp.sql sqldir/bin/sqldir_LINUX sqldir/bin/sqldir_txt.sql sqldir/bin/TEMPLATE.sql sqldir/doc/ sqldir/doc/readme.doc sqldir/log/ sqldir/sql/ sqldir/sql/u_prompt.sql sqldir/sql/x_banner.sql sqldir/sql/x_db_name.sql sqldir/sql/x_dir.sql sqldir/sql/x_dir_share.sql sqldir/sql/x_dir_start.sql dbaconsole.yourdomain.com.10GR2-> ## ## 2) since we are on linux rename sqldir executable ## dbaconsole.yourdomain.com.10GR2-> cd sqldir/bin dbaconsole.yourdomain.com.10GR2-> mv sqldir_LINUX sqldir dbaconsole.yourdomain.com.10GR2-> dbaconsole.yourdomain.com.10GR2-> ls -lta total 136 drwxr-xr-x 2 oracle oinstall 4096 Sep 29 23:09 . drwxr-xr-x 6 oracle oinstall 4096 Feb 27 2007 .. -rwxr-xr-x 1 oracle oinstall 23361 Feb 11 2004 sqldir -rwxr-xr-x 1 oracle oinstall 36864 Feb 11 2004 sqldir.exe -rwxr-xr-x 1 oracle oinstall 15435 Nov 10 2001 sqldir_ddl.log -rwxr-xr-x 1 oracle oinstall 723 Nov 10 2001 sqldir_ddl.sql -rwxr-xr-x 1 oracle oinstall 8464 Nov 10 2001 sqldir_grp.sql -rwxr-xr-x 1 oracle oinstall 3178 Nov 10 2001 sqldir_txt.sql -rwxr-xr-x 1 oracle oinstall 4046 Nov 9 2001 sqldir.list -rwxr-xr-x 1 oracle oinstall 569 Nov 9 2001 groups.cfg -rwxr-xr-x 1 oracle oinstall 282 Nov 9 2001 TEMPLATE.sql -rwxr-xr-x 1 oracle oinstall 705 Nov 5 2001 dirlist.sh -rwxr-xr-x 1 oracle oinstall 569 Nov 5 2001 groups.cfg.ALL.SEED -rwxr-xr-x 1 oracle oinstall 3909 Nov 5 2001 sqldir.list.UNIX.SEED -rwxr-xr-x 1 oracle oinstall 849 Nov 5 2001 dirlist.bat -rwxr-xr-x 1 oracle oinstall 4064 Nov 5 2001 sqldir.list.WIN.SEED dbaconsole.yourdomain.com.10GR2-> ## ## 3) download http://kb.dbatoolz.com/ex/uploads/4388.sql.tar ## and extract it into sqldir/sql dbaconsole.yourdomain.com.10GR2-> cd ../sql dbaconsole.yourdomain.com.10GR2-> pwd /u01/app/oracle/sqldir/sqldir/sql dbaconsole.yourdomain.com.10GR2-> ls -l total 24 -rwxr-xr-x 1 oracle oinstall 865 Nov 10 2001 u_prompt.sql -rwxr-xr-x 1 oracle oinstall 600 Nov 5 2001 x_banner.sql -rwxr-xr-x 1 oracle oinstall 878 Nov 5 2001 x_db_name.sql -rwxr-xr-x 1 oracle oinstall 1990 Nov 5 2001 x_dir_share.sql -rwxr-xr-x 1 oracle oinstall 3328 Nov 9 2001 x_dir.sql -rwxr-xr-x 1 oracle oinstall 722 Nov 5 2001 x_dir_start.sql dbaconsole.yourdomain.com.10GR2-> dbaconsole.yourdomain.com.10GR2-> cd ../ dbaconsole.yourdomain.com.10GR2-> pwd /u01/app/oracle/sqldir/sqldir dbaconsole.yourdomain.com.10GR2-> ls -l total 16 drwxr-xr-x 2 oracle oinstall 4096 Sep 29 23:09 bin drwxr-xr-x 2 oracle oinstall 4096 Feb 27 2007 doc drwxr-xr-x 2 oracle oinstall 4096 Feb 27 2007 log drwxr-xr-x 2 oracle oinstall 4096 Sep 29 23:11 sql dbaconsole.yourdomain.com.10GR2-> dbaconsole.yourdomain.com.10GR2-> ls -l $HOME/4388.sql.tar -rw-r--r-- 1 oracle oinstall 631808 Sep 29 23:10 /u01/app/oracle/4388.sql.tar dbaconsole.yourdomain.com.10GR2-> dbaconsole.yourdomain.com.10GR2-> tar xvf /u01/app/oracle/4388.sql.tar ./sql/ ./sql/a_adutconf_R107.sql ./sql/a_adutconf_R11.sql ./sql/a_cm_long_reqs.sql ./sql/a_conc_cleanup.sql ./sql/a_conc_interval_R107.sql ./sql/a_conc_interval_R11.sql ... ... ... ./sql/x_db_name.sql ./sql/x_dir.sql ./sql/x_dir_share.sql ./sql/x_dir_start.sql dbaconsole.yourdomain.com.10GR2-> ## ## 4) parse all sql scripts using sqldir ## dbaconsole.yourdomain.com.10GR2-> cd bin dbaconsole.yourdomain.com.10GR2-> ls -l total 128 -rwxr-xr-x 1 oracle oinstall 849 Nov 5 2001 dirlist.bat -rwxr-xr-x 1 oracle oinstall 705 Nov 5 2001 dirlist.sh -rwxr-xr-x 1 oracle oinstall 569 Nov 9 2001 groups.cfg -rwxr-xr-x 1 oracle oinstall 569 Nov 5 2001 groups.cfg.ALL.SEED -rwxr-xr-x 1 oracle oinstall 23361 Feb 11 2004 sqldir -rwxr-xr-x 1 oracle oinstall 15435 Nov 10 2001 sqldir_ddl.log -rwxr-xr-x 1 oracle oinstall 723 Nov 10 2001 sqldir_ddl.sql -rwxr-xr-x 1 oracle oinstall 36864 Feb 11 2004 sqldir.exe -rwxr-xr-x 1 oracle oinstall 8464 Nov 10 2001 sqldir_grp.sql -rwxr-xr-x 1 oracle oinstall 4046 Nov 9 2001 sqldir.list -rwxr-xr-x 1 oracle oinstall 3909 Nov 5 2001 sqldir.list.UNIX.SEED -rwxr-xr-x 1 oracle oinstall 4064 Nov 5 2001 sqldir.list.WIN.SEED -rwxr-xr-x 1 oracle oinstall 3178 Nov 10 2001 sqldir_txt.sql -rwxr-xr-x 1 oracle oinstall 282 Nov 9 2001 TEMPLATE.sql dbaconsole.yourdomain.com.10GR2-> ./dirlist.sh Listing directory: ../sql ./dirlist.sh[40]: sqldir: not found dbaconsole.yourdomain.com.10GR2-> dbaconsole.yourdomain.com.10GR2-> export PATH=$PATH:. dbaconsole.yourdomain.com.10GR2-> ./dirlist.sh Listing directory: ../sql +=============================================+ | SQLDIR v3.1 | +---------------------------------------------+ | Copyright (c) 1998 DBAToolZ.com | | All rights reserved. | +=============================================+ ... SCANNING a_adutconf_R107.sql (108) lines ... SCANNING a_adutconf_R11.sql (138) lines ... SCANNING a_cm_long_reqs.sql (86) lines ... SCANNING a_conc_cleanup.sql (127) lines ... SCANNING a_conc_interval_R107.sql (132) lines ... ... ... ... SCANNING x_banner.sql (41) lines ... SCANNING x_db_name.sql (53) lines ... SCANNING x_dir_share.sql (92) lines ... SCANNING x_dir.sql (159) lines ... SCANNING x_dir_start.sql (53) lines TOTAL Files: 171 To load DBAToolZ script library run sqldir_ddl.sql from SQL*Plus To access DBAToolZ script library run x_dir.sql from SQL*Plus For more information and software updates visit DBAToolZ.com dbaconsole.yourdomain.com.10GR2-> ## ## 5) install sqldir repository into the database ## dbaconsole.yourdomain.com.10GR2-> sqlplus system SQL*Plus: Release 10.2.0.4.0 - Production on Tue Sep 29 23:16:38 2009 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Enter password: Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> @sqldir_ddl.sql SQL> set term off Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options dbaconsole.yourdomain.com.10GR2-> ## ## 6) start using sqldir repository ## dbaconsole.yourdomain.com.10GR2-> cd ../sql dbaconsole.yourdomain.com.10GR2-> sqlplus system @x_dir.sql SQL*Plus: Release 10.2.0.4.0 - Production on Tue Sep 29 23:17:25 2009 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Enter password: Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Session altered. +=====================================================+ | SQLDIR SQL*Plus Menu v1.2 | +=====================================================+ ID Group Name Cnt --- --------------------------------------------- ---- 27 Favorite Scripts ............................ 32 13 Reverse Engineering ......................... 7 11 Rollback .................................... 4 26 Partitioning ................................ 3 3 APPS Concurrent Programs .................... 7 7 Tablespace .................................. 25 0 TOTAL Number Of Scripts: .................... 171 23 Backup Management ........................... 2 10 Redo Log .................................... 8 1 APPS General ................................ 1 5 APPS Administration ......................... 9 17 Statistics .................................. 12 24 Parallel Query .............................. 1 8 Utility ..................................... 22 6 Data Files .................................. 10 15 Table ....................................... 22 18 Storage Management .......................... 10 4 APPS Concurrent Managers .................... 8 12 Maintenance ................................. 20 2 APPS Installation ........................... 3 22 Segment Management .......................... 19 14 SGA Maintenance ............................. 16 19 Database Init Parameters .................... 2 9 Index ....................................... 8 16 User Management ............................. 30 25 SQL Tracing Tuning .......................... 21 20 Latches ..................................... 2 21 Locks ....................................... 5 Enter Group Id or to search Enter [s SEARCH_STRING] : s locks ************** Search results ************** Id Script Name Script Description ---- ----------------------------------- -------------------------------------------------------------------------------- 56 c_unused.sql REM This script used to get the space usage (High-water mark) REM for TABLE, INDEX or CLUSTER REM The high-water mark for a table is the difference between the REM TOTAL_BLOCKS value and UNUSED_BYTES value returned by this procedure call. REM The UNUSED_BLOCKS value represents the number of blocks above REM the high-water mark, the TOTAL_BLOCKS value reflects the total REM number of blocks allocated to the table REM After executing this script you can reclaim space from a TABLE REM For example: REM TOTAL_BLOCKS = 200 REM UNUSED_BLOCKS = 100 REM if the database BLOCK size = 4K, then 100 blocks--400K--could be reclaimed REM if you want to leave 20 blocks within the table as unused space above the REM high-water mark, you can alter the table, specifying that the database REM keep 20 blocks--80K: REM SQL> alter table <TABLE_NAME> deallocate unused keep 80K, REM 105 s_locked_obj.sql REM *** QUICK *** REM Reports the following: REM - object locks from V$LOCKED_OBJECT REM using PL/SQL loops since join of DBA_OBJECTS REM and V$LOCKED_OBJECT is extremly slow REM - blocked objects from V$LOCK and SYS.OBJ$ REM - blocked sessions from V$LOCK REM 114 s_sga_db_buffer_contents.sql REM List blocks per object in buffer, by buffer pool REM 120 s_sga_lib_cache_lock.sql REM Reports library cache locks. Many times in heavy development REM environment PL/SQL code get`s compiled while someone else is REM using it. This creates locks in library cache which can be REM very hard to trace. I would typically check v$session_wait REM to see if there are any waits for "enque", most of the time it`s REM library cache lock especially when other locks are not present. REM -- REM The next step would be to find out which package waiting REM session was trying to compile or execute and run this script REM supplying this package name. When you get the output of this REM script you can kill sessions that are causing library cache lock. REM Enter Script Id To Execute [Enter - Main Menu, Ctl-C - Exit]: 23:18:03 SYSTEM@10GR2:dbaconsole.yourdomain.com> select * from v$version; ************** Search results ************** BANNER ---------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod PL/SQL Release 10.2.0.4.0 - Production CORE 10.2.0.4.0 Production TNS for Linux: Version 10.2.0.4.0 - Production NLSRTL Version 10.2.0.4.0 - Production 23:18:10 SYSTEM@10GR2:dbaconsole.yourdomain.com>
[edited by: Vitaliy at 11:49 (CST) on Sep. 30, 2009]
|
10527
2009-SEP-30 06:27:03
|
||||
|
thanks very mutch but why in your installation it gives you TOTAL Files: 171 To load DBAToolZ script library run sqldir_ddl.sql from SQL*Plus To access DBAToolZ script library run x_dir.sql from SQL*Plus and in my installation it gives TOTAL Files: 6 To load DBAToolZ script library run sqldir_ddl.sql from SQL*Plus To access DBAToolZ script library run x_dir.sql from SQL*Plus and weher i put the sqldir and the sql in oracle_home or in /home/oracle thanks
|
10529
2009-SEP-30 11:48:37
|
||||
|
> thanks very mutch > but why in your installation it gives you > TOTAL Files: 171 > > and in my installation it gives > TOTAL Files: 6 > Take a look at step #3 above (I just numbered them) ## ## 3) download http://kb.dbatoolz.com/ex/uploads/4388.sql.tar ## and extract it into sqldir/sql > and weher i put the sqldir and the sql > in oracle_home or in /home/oracle > thanks > > That's completely up to you -- makes no difference. Personally I keep it in $ORACLE_BASE/admin/scripts/sqldir ... I wouldn't put anything in ORACLE_HOME