Orange for ORACLE V4.0 Installation Guide
ORANGE FOR ORACLE V4.0 INSTALLATION GUIDE...1 1....2 1.1...2 1.2...2 1.2.1...2 1.2.2 (Online Upgrade)...11 1.3 ORANGE CONFIGURATION ADMIN...12 1.3.1 Orange Configuration Admin...12 1.3.2...13 1.3.3 DBMS...13 1.3.4 DBMS...15 1.3.5...15 1.3.6 DB...16 1.3.7...17 1.4 REGISTRATION KEY...18 1.5...20 1.5.1...20 1.5.2 DBMS...21 2....22 2.1...22 2.1.1 TNS...22 2.1.2 tnsnames.ora...22 2.2...24 2.2.1 Global Options...25 2.3 LOGON...31 2.4...32 2.5...33 1
4.0 ANSI UNICODE.. ANSI SQL*Net (NET8 : 8.0.5, : 8.1.7 ) UNICODE SQL*Net 9.0.1 SQL*Net., SQL*Net SQL*Net. 4.0,. Windows 98 Windows NT Windows 2000 Windows XP Windows 2003 Windows Vista 1.2.1 4.0 CD CD-ROM Setup. ANSI, UNICODE,,. ANSI UNICODE.. UNICODE 9.0.1. Acrobat Reader. [ 1.1 Orange4Setup.exe] CD CD-ROM. 2
[ 1.1 Orange4Setup.exe] [ 1.2 - Preparing]. [ 1.2 - Preparing] 3
, [ 1.3 Welcome]. [Cancel] [Next]. [ 1.3 Welcome] [ 1.4 ]. [Yes]. 4
[ 1.4 ] [ 1.5 ]. [Browse]. [Next]. [ 1.5 ] 5
[ 1.6 ]., [Existing Folders],. [Next]. [ 1.6 ] [ 1.7 ]. [Typical], Component [Custom]. [Next]. 6
[ 1.7 ] [ 1.8 ] [Custom] Component. [Next]. [ 1.8 ] 7
[ 1.9 ]. [ 1.9 ] [ 1.10 (Online Upgrade)].. [Tools] [Global Options ]. ( 2.2.1 Global Options ) (Ask before upgrade). (Always upgrade without asking). (Never upgrade without asking). [ ](Upgrade check interval[days]). 7. 3 10 Online upgrade check. (!.!. ) 8
[ 1.10 (Online Upgrade)] 9
(Catalog).. [Next]. Orange Configuration Admin [ 1.11 Orange Configuration Admin] [Orange Configuration Admin]. (Orange Configuration Admin 1.3 Orange Configuration Admin ) [ 1.11 Orange Configuration Admin] 10
[ 1.12 ]. [Finish]. [ 1.12 ] 1.2.2 (Online Upgrade) V2.1. [ 1.13 ],... [ 1.13 ] 11
Orange Configuration Admin Orange Configuration Admin. Orange Configuration Admin,, PL/SQL. DBA Edition SYS, Standard Edition DBA. V2.2 Orange Configuration Admin (SQL, PL/SQL, Plan, Table Editor, Trace, Schema Browser, Description, Database Information). Orange Configuration Admin DBA. 1.3.1 Orange Configuration Admin Orange Configuration Admin [ 1.14 - Orange Configuration Admin ] [ ] [ ] [Orange for ORACLE] [Orange Configuration Admin]. [ 1.14 - Orange Configuration Admin ] 12
1.3.2 Orange Configuration Admin [ 1.15 - Orange Configuration Admin ]. [Next]. [ 1.15 - Orange Configuration Admin ] 1.3.3 DBMS [ 1.16 - Connect to DBMS]. Orange Configuration Admin DBA SYS, SYSTEM. SYS, SYSTEM DBA DBA Orange Configuration Admin. AS <DEFAULT>. 9i SYS SYSDBA SYSOPER, 9i SYS SYSDBA. init Parameter O7_DICTIONARY_ACCESSIBILITY=TRUE SYSDBA <DEFAULT>. [Next]. 13
[ 1.16 - Connect to DBMS] [Next]., Orange Configuration Admin [ 1.17 - Upgrade ]. [ 1.17 - Upgrade ] [ ]. 14
1.3.4 DBMS [ 1.18 - DBMS Information]. [Next]. [ 1.18 - DBMS Information] 1.3.5 [ 1.19 ].. TOOLS. [Next]. 15
[ 1.19 ] 1.3.6 DB [ 1.20 ]. SYSTEM RBS, TEMP.. [Next]. [ 1.20 ] 16
1.3.7 [ 1.21 start] [Start]. [ 2.22 ]. [ 1.21 start] [ 1.22 ] [Next] [Finish]. [Finish] Orange Configuration Admin. [ 1.23 - Orange Configuration Admin History ] 17
Configuration Admin History Configuration Admin Configuration Admin. Configuration Admin [New] [ 1.16 - Connect to DBMS] DBMS. [ 1.23 - Orange Configuration Admin History ] [Reconfigure], [Batch Configuration]. [ 1.23 - Orange Configuration Admin History ] [ ] [ ] [Orange for ORACLE]. 18
[ 1.24 Orange for ORACLE ] [ 1.25 - Registration Key ]. Product License Card. [Paste Key]. [ 1.25 - Registration Key ] 19
1.5.1 [ 1.26 ] /. [ 1.26 ] [ 1.27 ] [ 1.27 ] Orange for ORACLE 4.0. 20
1.5.2 DBMS (ORANGE). [ 1.28 DBMS DB user orange ] DBA SQL*Plus drop user. SQL> DROP USER orange CASCADE ; [ 1.28 DBMS DB user orange ] 21
2.1.1 TNS SQL*Net. SQL*Net tnsnames.ora. Oracle Net8 Easy Configuration. DBA. Network Configuration Tool TNS.(!.!. ) 2.1.2 tnsnames.ora. File tnsnames.ora. 2 tnsnames.ora. Network Configuration Tool tnsnames.ora. Network Configuration Tool( ). Service Names - tnsnames.ora TNS. TNS Register New Name( TNS. ) TNS Name Service Configuration Compatible with Oracle8i release 8.0 SID SID Global Service Name Service Name. Connection Type DB server MTS Dedicated. Address Configuration. TCP. HOST IP. Network Ping Ping Test(. ) 22
[ 2.1 Network Ping ] 23
[ 2.1 Network Ping ] Network Ping TNS Ping ( ). TNS ping ( )., scott scott ( ). [ 2.2 ]. [ 2.2 ] TNS Ping. ( ) (tnsnames.ora ). [ 2.3 ]. Orange for ORACLE V4.0 DBA Edition. 24
[ 2.3 ] 2.2.1 Global Options [Tools] [Global Options ] [ 2.4 - Global Options General ]. General Associate *.SQL/SQD/PLD/PTD file.sql,.sqd,.pld,.ptd..sql SQL script.sqd SQL Tool Workspace ( ),.PLD PL/SQL Tool.PTD Plan Tool Explain Plan Trace Schema. 25
[ 2.4 - Global Options General ] Startup Logon Dialog on Startup Logon. Show Schema Browser after logon Logon Dialog on Startup,. Show Tool Window After Logon Logon Dialog on Startup,. [ 2.5 - Global Options Startup ] Database 26
Reconnect Automatically when a session was disconnected, statement. Commit Automatically after every statement SQL Tool statement Commit. Ask Before Disconnect Ask. Commit Before Disconnect Ask Commit. Commit Commit Rollback Rollback. Date Type Format Date. YYYY/MM/DD HH24:MI:SS YYYY-MM-DD HH24:MI:SS. [ 2.6 - Global Options Database ] Editor.... 27
[ 2.7 - Global Options Editor ] SQL*Net SQL*Net Parameter. SQL*Net. Orange for ORACLE. Orange for ORACLE(Fail-Safe),. NLS_LANG NLS_LANG.. Orange Home Home. Home Selector Home. 2 Home Default Home Home. 28
[ 2.8 - SQL*Net] Upgrade Policy. Always ask before upgrade Patch,. Always upgrade without asking dialog Patch,. Never Upgrade without asking dialog. [Online Upgrade Check]. Upgrade Check Interval Always ask before upgrade Always upgrade without asking dialog Patch. 3~10. 29
[ 2.9 - Update Policy] Encoding Unicode. Encoding. Encoding. UNICODE DB ANSI. UNICODE. [ 2.10 - Encoding] 30
[File] [Connect ] [ 2.111 - Logon Dialog]. [OK] DBMS. [ 2.111 - Logon Dialog] Service Name tnsnames.ora TNS. TNS. User Name ( 30 ) Password ( 30 ) Save Password -. Auto Connect. Save Password. Authentication Default, Sysdba, Sysoper. Oracle 9i, SYS SYSDBA SYSOPER, Oracle 8i default., Oracle 9i O7_DICTIONARY_ACCESSIBILITY=TRUE SYSDBA / SYSOPER. Drop entry Entry.,. 31
[ 2.122 DBMS ].,.,........ [ 2.122 DBMS ] 32
...,. [File] [Connect ] ( ). ID,.. ( ).,. ( ). SQL Tool, PL/SQL Tool, PLAN Tool, Trace Tool, Table Editor, Schema Tool, Description Tool, Database Information, Data Dictionary Tool..,,. ( ).. SQL Monitor, Session Monitor, Transaction Monitor, Lock/Latch Monitor, Instance Monitor, Oracle ERP Monitor, Export Tool, Import Tool, Loader, Space Manager, Security Manager, Analyze Manager, Graph & Report, Health Check, Log Miner Tool, Reorg Manager Network Configuration Tool File Editor,. Session Independent. Network Configuration Tool, File Editor 33