以下のツールは、$ORACLE_HOME/bin の下にあります。
ほとんどのものは、シェル・スクリプトですから読解可能です。
下記の表の sh に丸がついているものがそれに該当します。
ツール名をクリックすると、表示例を見れます。
| ツール名 | 機 能 | 使 用 法 | Ver | sh |
|---|---|---|---|---|
| adapters | protocol adapters のリスト取得 | adapters EXECUTABLE | |
○ |
| cursize | カーソル情報表示 | cursize [-mMAXCUR] [-sCURSIZE] [username/passwd] | |
× |
| dbassist | データベース作成 | dbassist | 8i >= | ○ |
| dbfsize | データベース情報表示 | dbfsize database file | |
× |
| demobld | デモ用データ作成 | demobld userid passwd | |
○ |
| demodrop | デモ用データ消去 | demodrop userid passwd | |
○ |
| dbhome | SID の ORACLE_HOME 表示 | dbhome [SID] | |
○ |
| deploync | java から作った共用ライブラリ表示 | deploync -user |
8i > | ○ |
| dropjava | java プログラムをデータベース から削除 |
dropjava -user | 8i > | ○ |
| echodo | コマンドを echo し実行 | |
○ | |
| gennaflg | naccflgs,naldflgs の生成 | gennaflg [nau-adapter]+ [export | domestic] | |
○ |
| gensyslib | sysliblist の生成 | gensyslib | |
○ |
| loadjava | java プログラムをデータベース に登録 |
loadjava -resolve -user | 8i > | ○ |
| ncomp | java class ファイルから 共用ライブラリ作成 |
ncomp -verbose -user | 8i > | ○ |
| oerr | oracle のエラー情報取得 | oerr FACILITY ERR_NO | |
○ |
| ott (object type translator) |
database の表から c の構造体を作成する | ott userid=XXX intype=YY.typ outtype=ZZ.typ code=c hfile=demo.h |
|
× |
| owhat | 実行モジュール/ライブラリの パッチ情報取得 |
owhat EXEC/LIB what EXEC/LIB ...(SCCS) |
|
○ |
| pupbld | PRODUCT_USER_PROFILE 表 の作成 |
環境設定： setenv SYSTEM_PASS "system/manager" pupbld |
|
○ |
| relink | relink | relink [all,oracle,network,client, client_sharedlib,interMedia,precomp, utilities,oemagent] |
8i >= | ○ |
| sbttest | rman のメディア管理ソフトが正しいかのチェック | sbttest test | 8i > | ○ |
| statusnc | ncomp のステータス表示 | statusnc -user | 8i > | ○ |
| symfind | ライブラリのシンボル検索 | symfind [-i] [-v] [-o outfile] [-l libstring] symbol [dirs]s] | |
○ |
| tnsping | tnsnames.ora に登録されている名前で接続できるかをテストする | tnsping TSN_NAME | |
|
| trcfmt | .cdf や .dat から ASCII 情報作成 | trcfmt cdf_filename | |
○ |
| unixenv | unix の環境情報表示 | unixenv | >= 8.0 | ○ |
|
|
|
プロトコル・アダプタ表示
> adapters
Installed Net8 Protocol Adapters are:
BEQ Protocol Adapter
IPC Protocol Adapter
TCP/IP Protocol Adapter
RAW Protocol Adapter
Installed Net8 Naming Adapters are:
Oracle TNS Naming Adapter
Oracle Naming Adapter
Installed Advanced Networking Option/Network Security products are:
Oracle Security Server Authentication Adapter
|
|
|
> cursize Opened 50 cursors of 64K bytes Total size of cursors 3276800 bytes
|
|
|
/HOME9/ora817/oradata/ora817/control01.ctl の情報
> dbfsize /HOME9/ora817/oradata/ora817/control01.ctl Database file: /HOME9/ora817/oradata/ora817/control01.ctl Database file type: file system Database file size: 698 8192 byte blocks
|
|
|
scott/tiger のデモ用のデータを削除し、作成する。
> demodrop SQL*Plus: Release 8.1.7.0.0 - Production on 金 Mar 1 09:38:50 2002 (c) Copyright 2000 Oracle Corporation. All rights reserved. ERROR: ORA-01017: invalid username/password; logon denied ユーザー名を入力してください: scott パスワードを入力してください: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production に接続されました。 Dropping demonstration tables. Please wait. Demonstration table drop is complete. Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Productionとの接続が切断されました。 > demobld SQL*Plus: Release 8.1.7.0.0 - Production on 金 Mar 1 09:39:04 2002 (c) Copyright 2000 Oracle Corporation. All rights reserved. ERROR: ORA-01017: invalid username/password; logon denied ユーザー名を入力してください: scott パスワードを入力してください: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production に接続されました。 Building demonstration tables. Please wait. Demonstration table build is complete. Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Productionとの接続が切断されました。
|
|
|
> dbhome /home4/ora806/app/oracle/product/8.0.6
|
|
|
ORA-2331 のエラーの詳細情報を得る。
> oerr ORA 2331 02331, 00000, "データ型: %sの列に制約は作成できません。" // *Cause: An attempt was made to create a constraint on a column // posessing a non-constrainable datatype -- VARRAY, nested table, // object, LOB, FILE, or REF. // *Action: Change the column datatype, or remove the constraint.
|
|
|
> sqlplus scott/tiger SQL*Plus: Release 8.1.7.0.0 - Production on 木 Mar 7 11:18:35 2002 (c) Copyright 2000 Oracle Corporation. All rights reserved. PRODUCT_USER_PROFILEヘのアクセス中にエラーが発生しました。 警告: 製品のユーザー・プロファイル情報がロードされていません。 PUPBLD.SQLをSYSTEMとして実行する必要があるかもしれません。 SQL> quit > setenv SYSTEM_PASS "system/manager" > pupbld Installing product user profile tables... Product user profile tables installed. > sqlplus scott/tiger SQL*Plus: Release 8.1.7.0.0 - Production on 木 Mar 7 11:45:00 2002 (c) Copyright 2000 Oracle Corporation. All rights reserved. Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production With the Partitioning option JServer Release 8.1.7.0.1 - Production に接続されました。 SQL> quit
|
|
|
oracle をリリンクする。
> relink oracle
|
|
|
> cd $ORACLE_HOME/lib > symfind afidesgtdty SymFind - Find Symbolin <**>.a, .o, .so ------------------------------------------------------ Command: /HOME9/ora817/app/oracle/product/8.1.7/bin/symfind afidesgtdty Local Directory: /HOME9/ora817/app/oracle/product/8.1.7 Output File: (none) Note: I do not traverse symbolic links Use '-v' option to show any symbolic links Locating Archive and Object files ... [112] | 16| 2868|FUNC |LOCL |0 |13 |afidesgtdty ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ./lib/libsqlplus.a > symfind nfpucdi $ORACLE_HOME/network/lib SymFind - Find Symbol in <**>.a, .o, .so ------------------------------------------------------ Command: /HOME9/ora817/app/oracle/product/8.1.7/bin/symfind nfpucdi /HOM E9/ora817/app/oracle/product/8.1.7/network/lib Local Directory: /HOME9/ora817/app/oracle/product/8.1.7 Output File: (none) Note: I do not traverse symbolic links Use '-v' option to show any symbolic links Locating Archive and Object files ... [13] | 0| 112|FUNC |LOCL |0 |5 |nfpucdi ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ /HOME9/ora817/app/oracle/product/8.1.7/network/lib/libncm8.a
シンボルの表示情報の詳細は、 ここを参照ください。
|
|
|
tnsnames.ora に登録されている名前で正しく接続できるか？
> tnsping ozzy816 TNS Ping Utility for IBM/AIX RISC System/6000: Version 8.1.7.2.0 - Production on 28-MAR-2002 16:16:06 (c) Copyright 1997 Oracle Corporation. All rights reserved. Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=ozzy)(PORT=1551)) OK (150ミリ秒)
|
|
|
UNIX の環境表示
> unixenv
Machine Environment:
--------------------
User: uid=110(ora806) gid=100(dba)
Current Directory: /home3/ora806
Machine: {
HP-UX moon B.10.20 A 9000/826 1911318281 2-[UE CZX
[From uname -a]
moon
[From hostname]
}
Ulimit: {
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 65536
stack(kbytes) 8192
memory(kbytes) unlimited
coredump(blocks) 4290772993
nofiles(descriptors) 2048
}
Swap: {
procs memory page
faults cpu
r b w avm free re at pi po fr de sr
in sy cs us sy id
0 66 0 5163 6938 0 0 0 0 0 0 0
112 64 34 1 0 99
[From vmstat]
}
Disk Mounts: {
/ on /dev/vg00/lvol3 defaults on Sun Nov 4 19:51:50 2001
/stand on /dev/vg00/lvol1 defaults on Sun Nov 4 19:51:53 2001
/var on /dev/vg00/lvol7 defaults on Sun Nov 4 19:52:06 2001
/usr on /dev/vg00/lvol6 defaults on Sun Nov 4 19:52:06 2001
/tmp on /dev/vg00/lvol5 defaults on Sun Nov 4 19:52:06 2001
/opt on /dev/vg00/lvol4 defaults on Sun Nov 4 19:52:07 2001
/home3 on /dev/vg01/lvol3 defaults on Sun Nov 4 19:52:07 2001
/home2 on /dev/vg01/lvol2 defaults on Sun Nov 4 19:52:07 2001
/home1 on /dev/vg01/lvol1 defaults on Sun Nov 4 19:52:07 2001
[From /etc/mount]
}
Disk Free: {
/home1 (/dev/vg01/lvol1 ) : 3693010 total allocated Kb
2416489 free allocated Kb
1276521 used allocated Kb
34 % allocation used
/home2 (/dev/vg01/lvol2 ) : 1846397 total allocated Kb
236228 free allocated Kb
1610169 used allocated Kb
87 % allocation used
/home3 (/dev/vg01/lvol3 ) : 2282926 total allocated Kb
956706 free allocated Kb
1326220 used allocated Kb
58 % allocation used
/opt (/dev/vg00/lvol4 ) : 358982 total allocated Kb
7689 free allocated Kb
351293 used allocated Kb
97 % allocation used
/tmp (/dev/vg00/lvol5 ) : 31086 total allocated Kb
22247 free allocated Kb
8839 used allocated Kb
28 % allocation used
/usr (/dev/vg00/lvol6 ) : 504513 total allocated Kb
143202 free allocated Kb
361311 used allocated Kb
71 % allocation used
/var (/dev/vg00/lvol7 ) : 172790 total allocated Kb
135782 free allocated Kb
37008 used allocated Kb
21 % allocation used
/stand (/dev/vg00/lvol1 ) : 43046 total allocated Kb
30601 free allocated Kb
12445 used allocated Kb
28 % allocation used
/ (/dev/vg00/lvol3 ) : 89702 total allocated Kb
73524 free allocated Kb
16178 used allocated Kb
18 % allocation used
[From df -k]
}
Environment: {
COLUMNS=80
EDITOR=vi
EPC_DISABLED=TRUE
EXINIT=source /home3/ora806/.exrc
HOME=/home3/ora806
IST_HOME=/home3/ora806/app/oracle/product/8.0.6/insight
JAVA_HOME=/home3/ora806/app/oracle/product/8.0.6/network/jre11
LANG=japanese
LD_LIBRARY_PATH=/usr/lib:/home3/ora806/app/oracle/product/8.0.6/lib
LINES=24
LOGNAME=ora806
MAIL=/var/mail/ora806
MANPATH=/usr/share/man/%L:/usr/share/man:/usr/contrib/man/%L:/usr/contri
b/man:/usr/local/man/%L:/usr/local/man:/opt/pd/share/man/%L:/opt/pd/share/man:/o
pt/pd/share/man/%L:/opt/pd/share/man:/opt/pd/share/man/%L:/opt/pd/share/man:/opt
/asx/share/man/%L:/opt/asx/share/man:/opt/graphics/starbase/share/man:/opt/audio
/share/man:/opt/blinklink/share/man:/opt/ansic/share/man/%L:/opt/ansic/share/man
:/opt/langtools/share/man/%L:/opt/langtools/share/man:/opt/video/share/man:/opt/
videoout/share/man:/opt/imake/man
NLS_LANG=japanese_japan.ja16sjis
ORACLE_BASE=/home3/ora806/app/oracle
ORACLE_HOME=/home3/ora806/app/oracle/product/8.0.6
ORACLE_SID=ora806
ORACLE_TERM=vt100
ORA_NLS33=/home3/ora806/app/oracle/product/8.0.6/ocommon/nls/admin/data
PATH=.:/home3/ora806/app/oracle/product/8.0.6/bin:/usr/bin:/opt/ansic/bi
n:/usr/ccs/bin:/usr/contrib/bin:/opt/nettladm/bin:/opt/atok/bin:/usr/bin/X11:/us
r/contrib/bin/X11:/opt/pd/bin:/opt/asx/bin/X11:/opt/egb/bin:/opt/upgrade/bin:/op
t/vje/bin:/opt/langtools/bin:/opt/graphics/OpenGL/debugger/bin:/opt/imake/bin:/h
ome3/ora806/app/oracle/product/8.0.6/insight/bin:/usr/local/bin
PWD=/home3/ora806
SHELL=/usr/bin/csh
SHLIB_PATH=/home3/ora806/app/oracle/product/8.0.6/lib:/opt/ansic/bin:/us
r/lib:usr/ccs/lib:/usr/ucb/lib
TERM=vt100
TMPDIR=/tmp
TNS_ADMIN=/home3/ora806/app/oracle/product/8.0.6/network/admin
TZ=JST-9
_=/usr/bin/env
}
System Tables: {
HP-UX moon B.10.20 A 9000/826 02/28/102
16:55:14 text-sz ov proc-sz ov inod-sz ov file-sz ov
16:55:15 N/A N/A 120/1620 0 12700/15008 0 472/26358 0
[From sar -v 1 1]
}
Semaphores: {
IPC status from /dev/kmem as of Thu Feb 28 16:55:15 2002
T ID KEY MODE OWNER GROUP CREATOR CGROUP
NSEMS OTIME CTIME
Semaphores:
s 0 0x2f140002 --ra-ra-ra- root sys root sys
6 9:53:24 9:52:30
s 1 0x4118069b --ra-ra-ra- root root root root
1 9:52:48 9:52:42
s 2 0x4e0c0002 --ra-ra-ra- root root root root
2 9:52:46 9:52:42
s 3 0x411c1125 --ra-ra-ra- root root root root
2 no-entry 9:52:42
s 4 0x00446f6e --ra-r--r-- root root root root
1 no-entry 9:52:54
s 5 0x00446f6d --ra-r--r-- root root root root
1 no-entry 9:52:55
s 6 0x01090522 --ra-r--r-- root root root root
1 no-entry 9:52:56
s 7 0x5018fa8c --ra-ra-ra- root other root root
1 9:53:27 9:53:26
s 145808 0x00000000 --ra-ra---- ora804 dba ora804 dba
50 19:30:41 14:50:13
s 324009 0x00000000 --ra-ra---- ora806 dba ora806 dba
50 16:54:37 15:21:08
s 291610 0x00000000 --ra-ra---- ora806 dba ora806 dba
50 19:00:13 16:00:09
[From ipcs -sa]
}
Shared Mem: {
IPC status from /dev/kmem as of Thu Feb 28 16:55:16 2002
T ID KEY MODE OWNER GROUP CREATOR CGROUP
NATTCH SEGSZ CPID LPID ATIME DTIME CTIME
Shared Memory:
m 0 0x2f140002 --rw------- root sys root sys
2 1286144 348 826 9:53:19 no-entry 9:53:19
m 1 0x4118069b --rw-rw-rw- root root root root
0 348 456 456 9:52:48 9:52:48 9:52:42
m 2 0x4e0c0002 --rw-rw-rw- root root root root
1 31008 456 456 9:52:46 9:52:48 9:52:42
m 3 0x411c1102 --rw-rw-rw- root root root root
1 8192 456 471 9:52:46 9:52:42 9:52:42
m 4 0x5018fa8c --r--r--r-- root other root root
1 1075142 871 871 9:53:27 9:53:27 9:53:27
m 9221 0xf0d1f9e4 --rw-rw---- ora804 dba ora804 dba
6 5787648 27835 6341 19:30:49 19:35:14 14:50:13
m 15366 0x03533d48 --rw-rw---- ora806 dba ora806 dba
12 5795840 18505 18505 15:21:10 15:23:37 15:21:08
m 10759 0x8def6e0c --rw-rw---- ora806 dba ora806 dba
9 5795840 14654 17933 19:10:07 19:15:54 16:00:09
[From ipcs -ma]
}
/etc/oratab: {
ora734:/home2/ora734/app/oracle/product/7.3.4:N
*:/home3/isono804/app/oracle/product/8.0.4:N
recover:/home3/ora804/app/oracle/product/8.0.4:N
ora805:/home2/ora805/app/oracle/product/8.0.5:N
ora723:/home3/net804/app/oracle/product/8.0.4:N
*:/home3/ora804/app/oracle/product/8.0.4:N
*:/home3/ora804/app/oracle/product/8.0.4:N
ora804:/home2/ora804/app/oracle/product/8.0.4:N
ora806:/home3/ora806/app/oracle/product/8.0.6:Y
}
Tracing: { dbx xdb sdb adb trace truss prss crash kcrash debug gdb }
|
|
|
> dropjava -user scott/tiger ch14app.jar
> loadjava -resolve -user scott/tiger ch14app.jar
> ncomp -u scott/tiger ch14app.jar
#
# this list is produced by query
# select status, class_name from jaccelerator$status;
#
NEED_NCOMPING jvm/ch14/NComp
NEED_NCOMPING jvm/ch14/
Error while invoking class oracle/aurora/deploy/jvm_ch14_Installer
ORA-29532: 不明なJava例外でJavaコールが終了しました: java.security.AccessCon
trolException: the Permission (java.io.FilePermission /HOME9/ora817/app/oracle/p
roduct/8.1.7/javavm/deploy/libjox8_ec4f3c860c_scott_jvm_ch14.so read) has not be
en granted by dbms_java.grant_permission to SchemaProtectionDomain(SCOTT|PolicyT
ableProxy(SCOTT))
ORA-06512: "SYS.DBMS_JAVA", 行 0
ORA-06512: 行 1
loadjava: 1 errors
# Deployment History, produced by query:
# select timestamp, status, dll_name from jaccelerator$dlls order by dll_name
Wed Mar 14 16:59:37 JST 2001 installed /libjox8_e53c27a112_scott_jvm_ch14.so
Wed Mar 14 17:38:35 JST 2001 installed /libjox8_e53c4b4a85_scott_jvm_ch14.so
Thu Mar 15 14:32:57 JST 2001 installed /libjox8_e540c7b074_scott_jvm_ch14.so
Mon Mar 26 15:28:22 JST 2001 installed /libjox8_e579a07cac_scott_UnnamedPackage.so
Mon Mar 26 15:33:33 JST 2001 installed /libjox8_e579a5349b_scott_UnnamedPackage.so
Mon Mar 26 16:03:57 JST 2001 installed /libjox8_e579c0ffc1_scott_UnnamedPackage.so
Mon Mar 26 16:23:11 JST 2001 installed /libjox8_e579d2a45e_scott_UnnamedPackage.so
Tue Mar 27 09:25:28 JST 2001 installed /libjox8_e57d7a79f8_scott_UnnamedPackage.so
Mon Apr 02 17:10:24 JST 2001 installed /libjox8_e59e0a5307_scott_UnnamedPackage.so
Mon Apr 02 17:26:50 JST 2001 installed /libjox8_e59e19695e_scott_UnnamedPackage.so
Tue Apr 03 09:02:28 JST 2001 installed /libjox8_e5a171f0f0_scott_UnnamedPackage.so
> deploync -user scott/tiger ch14app.jar
# Deployment History, produced by query:
# select timestamp, status, dll_name from jaccelerator$dlls order by dll_name
Wed Mar 14 16:59:37 JST 2001 installed /libjox8_e53c27a112_scott_jvm_ch14.so
Wed Mar 14 17:38:35 JST 2001 installed /libjox8_e53c4b4a85_scott_jvm_ch14.so
Thu Mar 15 14:32:57 JST 2001 installed /libjox8_e540c7b074_scott_jvm_ch14.so
Mon Mar 26 15:28:22 JST 2001 installed /libjox8_e579a07cac_scott_UnnamedPackage.so
Mon Mar 26 15:33:33 JST 2001 installed /libjox8_e579a5349b_scott_UnnamedPackage.so
Mon Mar 26 16:03:57 JST 2001 installed /libjox8_e579c0ffc1_scott_UnnamedPackage.so
Mon Mar 26 16:23:11 JST 2001 installed /libjox8_e579d2a45e_scott_UnnamedPackage.so
Tue Mar 27 09:25:28 JST 2001 installed /libjox8_e57d7a79f8_scott_UnnamedPackage.so
Mon Apr 02 17:10:24 JST 2001 installed /libjox8_e59e0a5307_scott_UnnamedPackage.so
Mon Apr 02 17:26:50 JST 2001 installed /libjox8_e59e19695e_scott_UnnamedPackage.so
Tue Apr 03 09:02:28 JST 2001 installed /libjox8_e5a171f0f0_scott_UnnamedPackage.so
> statusnc -user scott/tiger ch14app.jar
#
# this list is produced by query
# select status, class_name from jaccelerator$status;
#
NOT_FOUND_IN_SCHEMA jvm/ch14/NComp
ALREADY_NCOMPED jvm/ch14/
|
|
|