Oracle8i for NetWare 管理者リファレンス, リリース8.1.6

Transcription

1 Oracle8i for NetWare J

2 Oracle8i for NetWare, J Oracle8i Administrator's Reference, Release 2 (8.1.6) for NetWare A Copyright 1996, 2000, Oracle Corporation. All rights reserved. Printed in Japan. * Oracle Corporation Oracle Corporation Restricted Rights Notice Restricted Rights Notice Programs delivered subject to the DOD FAR Supplement are "commercial computer software" and use, duplication, and disclosure of the Programs, including documentation, shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, Programs delivered subject to the Federal Acquisition Regulations are "restricted computer software" and use, duplication, and disclosure of the Programs shall be subject to the restrictions in FAR , Commercial Computer Software - Restricted Rights (June, 1987). Oracle Corporation, 500 Oracle Parkway, Redwood City, CA

3 ... ix REDO Oracle8i BUILD_DB.SQL MYDIR INIT.ORA CREATE DATABASE i

4 Net Oracle Enterprise Manager OEM Oracle Enterprise Manager Oracle Intelligent Agent : Oracle Intelligent Agent : : : Oracle Data Gatherer Oracle Data Gatherer Oracle8i Oracle8i Oracle8i SQL*Loader IMP81 EXP Oracle Manager Oracle Manager ii

5 Oracle8i Server Export Export iii

6 7 Import Import SQL*Loader SQL*Loader SQL*Loader SQL*Loader SQL*Loader iv

7 9 ORARUN ORARUN ORARUN ORLOAD ORUNLOAD ORHELP Server Manager Server Manager Server Manager Server Manager Novell Directory Service Oracle Snap-in for NetWare Administrator SYSOPER SYSDBA INTERNAL INTERNAL REDO : ARCHIVELOG : v

8 OCOPY RMAN81.NLM Oracle8i intermedia Text Filters Oracle8i intermedia Text for NetWare Oracle8i intermedia Text Oracle8i intermedia Text Oracle8i intermedia Text Java Oracle Java Option Oracle Java Utilities Oracle JDBC Java Database Connectivity Oracle SQLJ NLM A... A-2 Oracle Installer... A-2 ORA ORA-09499: Oracle8i Server... A-5 OSD OSD-02163: NetWare Oracle... A-8 vi

9 B NLS_LANG... B-2 NLS_LANG... B-2... B-4 MS-DOS NLS_LANG... B-4 C... C-2... C-3 D... D-2... D-2 NetWare... D-4... D-6 E... E-2... E-2 CONFIG.ORA... E-2... E-2 CONFIG.ORA... E-3 API... E-3 DBA_AUTHORIZATION... E-3 LOCAL LOC... E-4 NLS_LANG... E-4 NW_CURDIR... E-5 NW_ENABLE_SID_SUPPORT... E-5 NW_FAULT_HANDLING... E-5 NW_FSTYPE... E-6 NW_NUM_TO_SWITCH... E-6 NW_PGA_MAX_ALLOC... E-7 NW_RUN_MODE... E-7 NW_SERVICE_FAULTS... E-7 NW_SGA_MAX_ALLOC... E-8 vii

10 NW_STKSIZE... E-8 NW_TKPROF_DIR... E-8 NW_TRACE_FILE_TYPE... E-9 ORACLE_GROUP... E-9 ORACLE_HOME... E-9 ORACLE_SID... E-10 PLSQL... E-10 RDBMS... E-10 SQLNET... E-11 SQLPATH... E-11 SQLPLUS... E-12 TCP_KEEPALIVE... E-12 TNS_ADMIN... E-12 UTILITY_MSG... E-13 F OCI Oracle for NetWare... F-2 OCI... F-2... F-2... F-3... F-4 OCI NLM... F-4 : NLM... F-4... F-5 Ctrl-C... F F-6 G DOS... G-2 NetWare... G-3 viii

11 Oracle8i Enterprise Edition for NetWare ix

12 NetWarePC NetWare Oracle8i : NetWare Oracle8i Server Oracle8 Server Oracle8i Server Oracle8i Oracle Oracle Installer Oracle Oracle NetWare ORAHOME1 Optimal Flexible Architecture ORAHOME1 Windows 95 ORAWIN95 Windows NT ORANT ORACLE_HOME [Enter] Oracle8i Server Oracle8i Oracle8i Enterprise Edition Oracle8i Workgroup Server x

13 SQL SET ECHO OFF ALTER DATABASE %ORACLE_HOME% NLM CONFIG.ORA < > 1:... ORACLE_DBA.<context_name> NetWare 2: LOCAL=<MY-SERVER>-IPC SID SID CHKVAL fieldname value1 value2... valuen...define { macro1 macro2 } xi

14 { } [ ] DEFINE { macro1 macro2 } cvtcrt termname [outfile] C: > : Windows NetWare NetWare : Server Manager [Ctrl] [Esc] SYS:SYSTEM :LOAD SVRMGR30 %ORACLE_HOME% NLM xii

15 1 Oracle8i Server 1-1

16 ORACLE SID ORCL Oracle8i intermedia Text Oracle8i Server : Oracle8i for NetWare REDO 1-2 Oracle8i for NetWare

17 INTERNAL Oracle8i Oracle8i ORACLE DBA : INTERNAL SYS SYSDBA : INTERNAL SYS SYSDBA Oracle8i SYS CHANGE_ON_INSTALL DBA CONNECT RESOURCE DBA AQ_ADMINISTRATOR_ROLE AQ_USER_ROLE DELETE_CATALOG_ROLE EXECUTE_CATALOG_ROLE EXP_FULL_DATABASE IMP_FULL_DATABASE RECOVERY_CATALOG_OWNER SELECT_CATALOG_ROLE SNMPAGENT CTXADMIN 1 CTXAPP 1 CTXUSER 1 SYSTEM MANAGER DBA DBA SCOTT TIGER CONNECT RESOURCE 1-3

18 DEMO DEMO CONNECT RESOURCE DBSNMP DBSNMP CONNECT RESOURCE SNMPAGENT Oracle Enterprise Manager CATNSNMP.SQL CTXSYS 1 CTXSYS CONNECT RESOURCE DBA intermedia Text 1 Oracle8i intermedia Text : SQL SYS SYSTEM CTXSYS SVRMGR> ALTER USER USERNAME IDENTIFIED BY PASSWORD; Server Manager Oracle8i for NetWare : Oracle8i Oracle Oracle8i 1 Oracle8i SYSTEM USER_DATA Oracle8i SYSTEM Oracle8i 1-4 Oracle8i for NetWare

19 TEMPORARY_DATA ROLLBACK_DATA SQL GROUP BY ORDER BY DISTINCT ANALYZE COMPUTE STATISTICS SQL : Oracle8 Server Oracle8i ORAHOME1 ORADATA 4 SYS1ORCL.ORA USR1ORCL.ORA RBS1ORCL.ORA TMP1ORCL.ORA SYSTEM USER_DATA ROLLBACK_DATA TEMPORARY_DATA : Oracle8 Server Oracle8i 1-5

20 %ORACLE_HOME% ADMIN ORACLE PFILE 1 INIT.ORA INIT.ORA INIT.ORA REDO : NetWare Oracle8i D Oracle8i %ORACLE_HOME% ORADATA 2 REDO LOG1ORCL.ORA LOG2ORCL.ORA REDO REDO : Oracle8i REDO Oracle8i 1-6 Oracle8i for NetWare

21 %ORACLE_HOME% ORADATA 1 CTL1ORCL.ORA REDO : CONTROL_FILES Oracle8i Oracle8i : Oracle8 Server Oracle8i 1-7

22 1-8 Oracle8i for NetWare

23 2 Oracle8i BUILD_DB.SQL 2-1

24 Oracle8i Oracle8i Oracle8 Enterprise Edition Oracle CREATE DATABASE INIT.ORA DB_NAME DB_NAME DB_NAME ORACLE 2 Oracle8 2 ORA-01102: Oracle Oracle8 SID CREATE CONTROLFILE Oracle8i %ORACLE_HOME% RDBMS ADMIN BUILD_DB.SQL BUILD_DB.SQL 2-2 Oracle8i for NetWare

25 INIT.ORA LISTENER.ORA SID IPC CREATE DATABASE VOL: ORAHOME1 SID ORCL VOL: MYDIR SID PROD PROD ORCL : NetWare Oracle Server INIT<SID>.ORA VOL: ORAHOME1 ADMIN <DB_NAME> PFILE INIT.ORA MYDIR PROD VOL: MYDIR 2-3

26 NetWare Export :LOAD EXP81 FILE=VOL: TEMP MYEXP.DMP FULL=Y LOG=VOL: TEMP MYEXP.LOG ORCL MYEXP.DMP Export MYEXP.LOG 1. NetWare 2. %ORACLE_HOME% ORADATA SYS1ORCL.ORA USR1ORCL.ORA RBS1ORCL.ORA TMP1ORCL.ORA LOG1ORCL.ORA LOG2ORCL.ORA LOG3ORCL.ORA LOG4ORCL.ORA CTL1ORCL.ORA LOG3ORCL.ORA LOG4ORCL.ORA Oracle Server INIT.ORA 2-4 Oracle8i for NetWare

27 INIT.ORA ORCL VOL: ORAHOME1 ADMIN ORACLE PFILE INIT.ORA VOL: ORAHOME1 ADMIN PROD PFILE INIT.ORA INIT.ORA PROD INIT.ORA CONTROL_FILES DB_NAME GLOBAL_NAMES DB_FILES CONTROL_FILES DB_NAME GLOBAL_NAMES DB_FILES CREATE DATABASE CONTROL_FILES = (VOL: MYDIR ORADATA CTL1PROD.ORA, %ORACLE_HOME% ORADATA CTL2PROD.ORA) BUILD_DB.SQL CREATE DATABASE SID DB_NAME=PROD 8 FALSE TRUE Oracle8i CREATE DATABASE MAXDATAFILES 100 DB_FILES=100 : INIT.ORA D 2-5

28 CREATE DATABASE CREATE DATABASE SQL VOL: ORAHOME1 RDBMS ADMIN BUILD_DB.SQL CREATE DATABASE 1. VOL: ORAHOME1 RDBMS ADMIN BUILD_DB.SQL VOL: MYDIR RDBMS ADMIN BLD_PROD.SQL BLD_PROD.SQL a. VOL: ORAHOME1 ADMIN PROD PFILE INIT.ORA PFILE b. CREATE DATABASE ORACLE CREATE DATABASE PROD c. ORCL PROD LOG1ORCL.ORA LOG1PROD.ORA d. Oracle ORAHOME1 MYDIR VOL: ORAHOME1 ORADATA VOL: MYDIR ORADATA -- This file must be run out of the directory containing the -- initialization file. startup nomount pfile=vol: ORAHOME1 ADMIN PROD PFILE INIT.ORA -- Create database create database prod controlfile reuse logfile 'VOL: mydir ORADATA log1prod.ora' size 1M reuse, 'VOL: mydir ORADATA log2prod.ora' size 1M reuse, 'VOL: mydir ORADATA log3prod.ora' size 1M reuse, 'VOL: mydir ORADATA log4prod.ora' size 1M reuse, datafile 'VOL: mydir ORADATA sys1prod.ora' size 10M reuse autoextend on next 10M maxsize 200M character set WE8PC850; create rollback segment rb_temp; -- Create additioanal tablespaces USER_DATA: Create user sets this as the default tablespace -- TEMPORARY_DATA: Create user sets this as the temporary tablespace -- ROLLBACK_DATA: For rollback segments create tablespace user_data datafile 'VOL: mydir ORADATA usr1prod.ora' size 3M reuse autoextend on next 5M maxsize 150M; create tablespace rollback_data 2-6 Oracle8i for NetWare

29 datafile 'VOL: mydir ORADATA rbs1prod.ora' size 5M reuse autoextend on next 5M maxsize 150M; create tablespace temporary_data datafile 'VOL: mydir ORADATA tmp1prod.ora' size 2M reuse autoextend on next 5M maxsize 150M; alter rollback segment rb_temp online; -- Change the SYSTEM users' password, default tablespace and -- temporary tablespace. alter user system temporary tablespace temporary_data; alter user system default tablespace user_data; -- Create 16 rollback segments. Allows 16 concurrent users with open -- transactions updating the database. This should be enough. create public rollback segment rb1 storage(initial 50K next 50K) tablespace rollback_data; create public rollback segment rb2 storage(initial 50K next 50K) tablespace rollback_data; create public rollback segment rb3 storage(initial 50K next 50K) tablespace rollback_data; create public rollback segment rb4 storage(initial 50K next 50K) tablespace rollback_data; create public rollback segment rb5 storage(initial 50K next 50K) tablespace rollback_data; create public rollback segment rb6 storage(initial 50K next 50K) tablespace rollback_data; create public rollback segment rb7 storage(initial 50K next 50K) tablespace rollback_data; create public rollback segment rb8 storage(initial 50K next 50K) tablespace rollback_data; create public rollback segment rb9 storage(initial 50K next 50K) tablespace rollback_data; create public rollback segment rb10 storage(initial 50K next 50K) tablespace rollback_data; create public rollback segment rb11 storage(initial 50K next 50K) tablespace rollback_data; create public rollback segment rb12 storage(initial 50K next 50K) tablespace rollback_data; create public rollback segment rb13 storage(initial 50K next 50K) tablespace rollback_data; create public rollback segment rb14 storage(initial 50K next 50K) tablespace rollback_data; create public rollback segment rb15 storage(initial 50K next 50K) tablespace rollback_data; create public rollback segment rb16 storage(initial 50K next 50K) tablespace rollback_data; 2-7

30 BLD_PROD.SQL 1. ORAPWD81.NLM INTERNAL Oracle Oracle NetWare ORAPWD81 :LOAD ORAPWD81 FILE=VOL: MYDIR DATABASE PWDPROD.ORA PASSWORD=<password> ENTRIES=<users> <password> INTERNAL SYS <users> DBA OPER ORAPWD81.NLM PROD EASYCFG.NCF Configure the Listener PROD Database Instance:PROD 3. IPC EASYCFG Protocol: IPC IPC Key Name: <server_name>_lsnr IPX/SPX TCP/IP AppleTalk Oracle Networking Products for NetWare 4. IPC EASYCFG Database Alias: <server_name>-prod-ipc Network Protocol: IPC IPC Key Name: <server_name>_lsnr Database Instance: PROD 5. NetWare ORALOAD.NCF Oracle8i Server NLM : ORALOAD 2-8 Oracle8i for NetWare

31 6. NetWare Server Manager INTERNAL :LOAD SVRMGR31 SVRMGR> SET INSTANCE <server_name>-prod-ipc SVRMGR> CONNECT INTERNAL/<password> 1 7. CREATE DATABASE BLD_PROD.SQL SVRMGR> SPOOL VOL: MYDIR DATABASE BLD_PROD.LOG MYDIR RDBMS ADMIN BLD_PROD BLD_PROD.SQL BLD_PROD.SQL Server Manager OSD- OSD 8. ADMIN CATALOG.SQL : CATALOG.SQL CATPROC.SQL CATREP.SQL ORA-01432: 12 BUILD_PROD.LOG Oracle8i 2-9

32 9. Oracle8 PL/SQL ADMIN CATPROC.SQL 10. ADMIN CATREP8M.SQL CATREP8M.SQL SVRMGR> SPOOL OFF 12. BLD_PROD.LOG : BLD_PROD.LOG Oracle8 Server : CHANGE_ON_INSTALL MANAGER SYS SYSTEM 2 ALTER USER SVRMGR> ALTER USER SYS IDENTIFIED BY NEW_SYS_ PASSWORD; SVRMGR> ALTER USER SYSTEM IDENTIFIED BY NEW_ SYSTEM_PASSWORD; 13. Server Manager SVRMGR> EXIT Import :LOAD IMP81 SYSTEM/<PASSWORD>@alias FILE=VOL: TEMP MYEXP.DMP FULL=Y LOG=VOL: TEMP MYIMP.LOG 2-10 Oracle8i for NetWare

33 : Import ARCHIVELOG : 1. REDO REDO SELECT * FROM V$CONTROLFILE; SELECT * FROM V$LOGFILE; SELECT * FROM V$DBFILE; : 11 Oracle8i Oracle8i Oracle8i 2. SVRMGR31 :ORASTOP 2-11

34 2-12 Oracle8i for NetWare

35 3 Oracle8 Server Net8 Oracle Enterprise Manager OEM Oracle Data Gatherer 3-1

36 Net8 Oracle Enterprise Manager Net8 Oracle Net8 Easy Config Windows NT Windows 95/98 Oracle8i Net8 Net8 Net8 Oracle Enterprise Manager Oracle Enterprise Manager Net8 Net8 Oracle8i Oracle Net8 Assistant Oracle Net8 Easy Config Oracle Net8 Easy Config Oracle8i Oracle Net8 Easy Config :easycfg : / Oracle Net8 Assistant Oracle Networking Products for NetWare Net8 Oracle Enterprise Manager OEM Oracle Enterprise Manager Oracle Enterprise Manager Oracle Enterprise Manager Oracle Intelligent Agent Oracle8i Oracle Enterprise Manager Windows NT Windows 95/98 Oracle Enterprise Manager 5 Oracle Enterprise Manager 3-2 Oracle8i for NetWare

37 Oracle Enterprise Manager OEM : Oracle Enterprise Manager Oracle8i Oracle8i Enterprise Edition for NetWare Oracle8i Server Oracle8i Oracle Enterprise Manager Oracle Intelligent Agent Oracle Intelligent Agent Oracle8i Oracle Intelligent Agent Oracle Enterprise Manager Oracle Intelligent Agent Oracle Enterprise Manager Oracle Enterprise Manager Windows NT Windows 95/98 Oracle Intelligent Agent Oracle8i for Netware 1. Oracle Intelligent Agent : Oracle Intelligent Agent 1. NetWare :ORALOAD :ORASTART :LOAD LSNCTL81 3-3

38 Oracle Enterprise Manager OEM : ORASTART ORCL STARTDB.SQL 2. LSNRCTL>DBSNMP_START 2: DBA Oracle8i Oracle Enterprise Manager Oracle8i 1. NetWare Server Manager Oracle8i :LOAD SVRMGR31 SVRMGR> SET INSTANCE <service_name> SVRMGR> CONNECT SYSTEM/MANAGER 2. Oracle Enterprise Manager SVRMGR> CREATE TABLESPACE REPOSIT_TABLESPACE DATAFILE 'path DATAFILE' SIZE XM; X 20MB 3. SVRMGR> CREATE USER USERNAME IDENTIFIED BY PASSWORD 2> DEFAULT TABLESPACE REPOSIT_TABLESPACE; 4. SYSTEM SVRMGR> GRANT DBA TO USERNAME 5. Server Manager SVRMGR> EXIT 3-4 Oracle8i for NetWare

39 Oracle Data Gatherer Server Manager 3: Oracle Enterprise Manager Windows 95/98 Windows NT Oracle8i Oracle Net8 Easy Config : Net8 Net8 for NetWare Intelligent Agent TCP/IP Net8 NAMES.ORA LISTENER.ORA 4: Oracle Enterprise Manager Oracle for NetWare Oracle Enterprise Manager Oracle Enterprise Manager Oracle Enterprise Manager Job Scheduling Event Management Oracle Enterprise Manager Navigator Discovery Oracle Enterprise Manager Oracle Data Gatherer Data Gatherer Oracle Capacity Planner Java Oracle Performance Manager Data Gatherer Intelligent Agent Data Gatherer Data Gatherer OEM Diagnostic Pack Perfomance Manager Capacity Planner : Oracle Intelligent Agent Oracle Enterprise Manager Oracle Data Gatherer for NetWare 3-5

40 Oracle Data Gatherer Oracle Data Gatherer Oracle Data Gatherer NetWare :LOAD VPPCTL81 -START Oracle Data Gatherer NetWare :LOAD VPPCTL81 -STOP 3-6 Oracle8i for NetWare

41 4 Oracle8i Oracle8i Oracle8i Oracle8i 4-1

42 Oracle8i Oracle SQL*Loader Oracle8i Server Import Export Oracle Export Oracle Manager Oracle8i NetWare Oracle8i Oracle8i Oracle8i Windows Oracle8i Import Export SQL*Loader Oracle8i Windows Oracle Data Manager Oracle Data Manager Windows : NetWare Oracle8i Oracle8i Oracle8i 4-2 Oracle8i for NetWare

43 : SID ORCL SID SQL*Loader Export Import 1 Oracle8i NetWare Oracle8i Server Windows NT Oracle8i Windows 95/98 Oracle8i Server Manager SVRMGR31 - DBA - DBA Export EXP81 - DBA - DBA Import IMP81 - DBA - DBA SQL*Loader SQLLDR81 - DBA - DBA Recovery Manager RMAN81 - DBA - DBA Password Utility ORAPWD81 1 OCOPY81 - DBA - DBA SQL*Plus Plus81 Windows NT User Manager Oracle Enterprise Manager Intelligent Agent Instance Manager - DBA - DBA Data Manager - DBA - DBA Schema Manager - DBA - DBA Security Manager - DBA - DBA Backup Manager - DBA - DBA Oracle8i 4-3

44 Oracle8i Windows NT Windows 95/98 NetWare Oracle8i Oracle8i Server Oracle8i SQL Worksheet - DBA - DBA Oracle Assistant Oracle Migration Assistant for Microsoft Access - - Oracle Net8 Assistant Oracle Net8 Easy Config Oracle INTYPE File Assistant - - Oracle Web Publishing Assistant SQL*Plus 1 ORAPWD81 Oracle8i Oracle Manager NWDBM81 Export NWEXP81 Import NWIMP81 SQL*Loader NWLDR81 Export Import SQL*Loader EXP81 IMP81 SQLLDR81 Oracle Manager Export Import SQL*Loader [F1] Import [F1] 4-4 Oracle8i for NetWare

45 Oracle8i : [ ] [ ] Oracle Manager Export Import SQL*Loader Oracle Manager Export Import SQL*Loader [ ] [ ] [PageUp] [PageDown] 1 [Ctrl]+[PageUp] [Ctrl]+[PageDown] [Enter] [Delete] Oracle8i 4-5

46 Oracle8i 4-1 [F5] [Enter] [F5] [Delete] : Oracle Manager Export Import SQL*Loader 4-1 [Insert] EXP_FULL_DATABASE IMP_FULL_DATABASE EXP_FULL_DATABASE IMP_FULL_DATABASE : Oracle8i Oracle8i 4-6 Oracle8i for NetWare

47 Oracle8i Oracle8i Oracle8i SQL*Loader SQLLDR81 IMPORT IMP81 EXPORT EXP81 SQL*Loader SQL*Loader ASCII Oracle SQL*Loader Oracle NetWare SQL*Loader : LOAD SQLLDR81 [options] ORACLE_HOME RDBMS LOADER SQL*Loader : SQL*Loader Oracle RDBMS 6 : SQL*Loader Oracle8i SQL*Loader NetWare SQL*Loader NetWare INFILE 'filename' ["FIX len" "DB3 len" "BTRIEVE"] len SQL*Loader STREAM STREAM Oracle8i 4-7

48 Oracle8i SQL*Loader 4-2 NetWare 4-2 NetWare INTEGER 4 SMALLINT 2 FLOAT 4 DOUBLE 8 IMP81 EXP81 IMP81 EXP81 IMP81 : LOAD IMP81 [options] EXP81 EXP81 : LOAD EXP81 [options] IMPORT EXPORT IMP81 EXP81 EXP-00008: ORACLE xxx ORA-00904: INTERNAL CATEXP.SQL SVRMGR> SET INSTANCE <service name> SVRMGR> CONNECT INTERNAL/<password> RDBMS ADMIN CATEXP 4-8 Oracle8i for NetWare

49 Oracle8i : IMP81 EXP81 Oracle8i Oracle8i NetWare Oracle8i LOGFILE NetWare EXPORT :LOAD EXP81 user/passwd@alias PARFILE=file (CLIB_OPT)/>FIL1.LOG/EFIL2.ERR FIL1.LOG EXPORT FIL2.ERR NetWare Oracle8i 4-9

50 Oracle8i 4-10 Oracle8i for NetWare

51 5 Oracle Manager Oracle Manager NWDBM81 Oracle Manager Oracle Manager 5-1

52 Oracle Manager NORMAL ABORT IMMEDIATE CONFIG.ORA Oracle8i Server : Oracle Manager Oracle Manager Oracle Manager 1. NetWare [Enter] LOAD NWDBM81 2. INTERNAL Oracle Manager 5-2 Oracle8i for NetWare

53 Oracle Manager 5-1 Oracle Manager 5-1 Oracle Manager Oracle Manager 5-1 Oracle Manager / ARCHIVELOG NOARCHIVELOG Oracle Manager 5-3

54 5-1 Oracle Manager / CONFIG.ORA NORMAL ABORT IMMEDIATE Oracle Manager Oracle8i for NetWare

55 NORMAL IMMEDIATE ABORT Oracle Manager INIT.ORA Oracle Manager 5-5

56 SHUTDOWN ABORT RESTRICTED SESSION Oracle8i for NetWare

57 [Enter] 2. [Insert] 5-5 NetWare : 4-5 [F3] 3. [F10] Oracle Manager 2. Oracle Manager 5-7

58 [Space] 5. NORMAL IMMEDIATE ABORT [Enter] 6. [F10] Oracle Manager : [Insert] 5-8 Oracle8i for NetWare

59 : Oracle Manager [Delete] [Insert] [Insert] Oracle Manager 5-9

60 SID Oracle SID OS Oracle Oracle SID Oracle NetWare 5-10 Oracle8i for NetWare

61 Oracle Manager : [Insert] % Oracle Manager 5-11

62 Oracle8i Server [Enter] 5-13 CONFIG.ORA Oracle8i Server 5-13 Oracle8i Server 1. Oracle Manager 2. CONFIG.ORA 5-14 CONFIG.ORA 5-14 CONFIG.ORA 1. CONFIG.ORA / [Enter] CONFIG.ORA 2. [Esc] [Esc] : CONFIG.ORA NLM 5-12 Oracle8i for NetWare

63 [Enter] 2. [ ] 3. DBA OPER [Enter] 4. [F10] 5. [Enter] 6. [Enter] [Enter] 2. [Space] Oracle Manager 5-13

64 [Insert] NetWare : 4. [ ] 5. DBA OPER [Enter] 6. [F10] 7. [Enter] 8. [Enter] 5-17 : 5-14 Oracle8i for NetWare

65 Oracle Manager 2. [Enter] Oracle Manager [Insert] 2. [Enter] Oracle Manager : Oracle Manager 5-15

66 5-16 Oracle8i for NetWare

67 6 Export Export NWEXP81 Export Export 6-1

68 Export 2 2 Export 6-1 Export 6-1 Export 1. NetWare [Enter] : LOAD NWEXP Oracle8i for NetWare

69 Export 6-1 Export 2. Export : TablesTable User UserFull Export 6-3

70 Export 6-2 Export 6-2 Export / [ ] [ ] [ ] [ ] User Table Full Tables Table User User table_name 1 user_name 1 1 table_name user_name 6-4 Oracle8i for NetWare

71 Export Export 6-5

72 6-4 Table User Table User Full Table User Full 6-5 Table User Full 1. Export [Enter] 6-6 Oracle8i for NetWare

73 Export Table Tables 5. Tables Tables [Insert] EXP_FULL_DATABASE <schema>.<tablename> <tablename> Export 6-7

74 [Enter] : Tables 3. [Esc] Tables 2. [Delete] 3. Tables 4. [Esc] Export User Users 5. Users User 6-8 Oracle8i for NetWare

75 [Insert] EXP_FULL_DATABASE 2. [Enter] : 4-5 User 3. [Esc] User 2. [Delete] Export 6-9

76 User 4. [Esc] Export [Insert] NetWare : Oracle8i for NetWare

77 6-13 : Export [Enter] Export 2. Export 6-11

78 [Esc] Export Oracle8i for NetWare

79 COMPLETE CUMULATIVE INCREMENTAL ESTIMATE COMPUTE NONE :... [F1] [Enter] 1. X 2. [ ] [Enter] 3. [ ] Export 6-13

80 X 2. [ ] 3. [Enter] 4. [Insert] 5. [Enter] Export Oracle8i for NetWare

81 Export [Insert] Export [Insert] Export 6-15

82 Export : [Space] 6-16 Oracle8i for NetWare

83 7 Import Import NWIMP81 Import Import 7-1

84 Import 2 Import 7-1 Import 7-1 Import 1. NetWare : LOAD NWIMP Oracle8i for NetWare

85 Import 7-1 Import 2. Import : Table User Full 7-2 Import 7-2 Import / User Table Full Import 7-3

86 Import 7-2 Import / Table User [ ] [ ] [ ] table_name 1 user_name 1 1 table_name user_name 7-4 Oracle8i for NetWare

87 Import Import 2. Import 7-5

88 Tables Table Users User Table User Full Import Import 7-6 Oracle8i for NetWare

89 Tables Table Users User Table User Full 2 Import 7-7

90 7-7 Table User Full Import [Enter] : Full Import Import Table Tables 5. Tables 7-8 Oracle8i for NetWare

91 [Insert] 2. [Enter] : 3. [Esc] [Delete] [Esc] Import 7-9

92 Import User Users 5. Users [Insert] 2. : 7-10 Oracle8i for NetWare

93 [Esc] [Delete] [Esc] Import Import 7-11

94 [Insert] NetWare : 7-15 : Import [Enter] 7-12 Oracle8i for NetWare

95 Import [Esc] : [F1] Import 7-13

96 Import Import NONE SYSTEM RESTORE : [F1] [Enter] 1. X 2. [ ] 7-14 Oracle8i for NetWare

97 NONE RESTORE SYSTEM 2. [Enter] 3. [ ] 1. X 2. [ ] 3. [Enter] 4. [Insert] 5. [Enter] 6. [ ] 1. X Import 7-15

98 7-19 Import Import Import [Insert] 7-16 Oracle8i for NetWare

99 Import [Insert] Import Import : [Space] Import 7-17

100 7-18 Oracle8i for NetWare

101 8 SQL*Loader SQL*Loader NWLDR81 SQL*Loader SQL*Loader SQL*Loader SQL*Loader SQL*Loader 8-1

102 SQL*Loader SQL*Loader SQL*Loader SQL*Loader 2 SQL*Loader SQL*Loader SQL*Loader 8-2 Oracle8i for NetWare

103 SQL*Loader SQL*Loader 8-1 SQL*Loader 8-1 SQL* Loader 1. NetWare [Enter] : LOAD NWLDR81 2. SQL*Loader SQL*Loader 8-3

104 SQL*Loader 8-2 SQL*Loader 8-2 SQL* Loader SQL*Loader : : : : : : : SQL*Loader SQL*Loader SQL*Loader SQL*Loader SQL*Loader SQL*Loader : Oracle8i SQL*Loader SQL*Loader Oracle8i for NetWare

105 SQL*Loader SQL*Loader 2. SQL*Loader SQL*Loader 8-5

106 SQL*Loader SQL*Loader 2. SQL*Loader [Insert] NetWare : 8-6 Oracle8i for NetWare

107 SQL*Loader SQL*Loader 2. SQL*Loader SQL*Loader 8-7

108 SQL*Loader [Esc] 1. [Enter] [ ] 3. [Enter] 1. X 2. [ ] [Insert] 3. [Enter] 4. [ ] 1. X 2. [ ] 8-8 Oracle8i for NetWare

109 SQL*Loader : : 1 SQL*Loader : [F1] SQL*Loader 8-9

110 SQL*Loader HEADER SQL*Loader DISCARDS ERRORS Oracle : [F1] SQL*Loader 2. SQL*Loader Oracle8i for NetWare

111 8-9 SQL*Loader SQL*Loader 2. SQL*Loader 3. [Insert] 8-10 SQL*Loader SQL*Loader 2. SQL*Loader 3. [Insert] SQL*Loader 8-11

112 SQL*Loader SQL*Loader 8-11 SQL*Loader 8-11 SQL* Loader 1. SQL*Loader 2. SQL*Loader 3. SQL*Loader SQL*Loader SQL*Loader : SQL*Loader [Space] 8-12 Oracle8i for NetWare

113 9 ORARUN ORARUN ORARUN ORARUN ORARUN 9-1

114 ORARUN ORARUN ORARUN ORACLE NLM ORARUN ORLOAD ORLOAD LOAD NLM ORARUN :LOAD ORARUN ORARUN NLM UNLOAD ORARUN :UNLOAD ORARUN ORARUN ORARUN ORLOAD ORUNLOAD ORHELP ORLOAD NLM ORLOAD [-w] [-snnn] [-pnnn] [-u] NLM [args] -w NLM -snnn NLM NNN -pnnn NLM NNN -u NLM ORARUN NLM [args] NLM NLM : ORLOAD / 9-2 Oracle8i for NetWare

115 ORARUN ORLOAD SVRMGR31 ORACLE NLM ORACLE NLM AUTOEXEC.NCF ORARUN.NLM ORALOAD.NCF SVRMGR31 AUTOEXEC.NCF AUTOEXEC.NCF # # ORALOAD.NCF loads ORARUN and all the ORACLE NLMs ORALOAD # Use ORLOAD to load SVRMGR31 ORLOAD # Assuming that the startup SQL statements are available in startdb.sql file # ORUNLOAD ORHELP ORARUN UNLOAD ORARUN ORUNLOAD ORHELP ORARUN 9-3

116 ORARUN 9-4 Oracle8i for NetWare

117 10 Oracle8i Server Server Manager Novell Directory Service 10-1

118 Server Manager Server Manager Server Manager Server Manager Server Manager Oracle8i 1. MS-DOS Server Manager C: >SVRMGR31 : LOCAL NetWare :LOAD SVRMGR31 2. Oracle8i SVRMGR> SET INSTANCE <service_name> SVRMGR> CONNECT INTERNAL/<password> 3. Server Manager Server Manager 10-2 Oracle8i for NetWare

119 Server Manager Server Manager 1. SVRMGR> STARTUP PFILE=PATH INIT.ORA PATH INIT.ORA 2 SVRMGR> STARTUP PFILE=%ORACLE_ HOME% ADMIN 2 PFILE INIT.ORA SVRMGR> STARTUP PFILE=VOL:ORAHOME1 ADMIN 2 PFILE INIT.ORA VOL Oracle ORAHOME1 Oracle Oracle8i Server Manager Server Manager 1. INTERNAL Oracle8i SVRMGR> SET INSTANCE <service_name> SVRMGR> CONNECT INTERNAL/<password> 2. SVRMGR> SHUTDOWN [MODE] 2 MODE Normal Immediate 10-3

120 Server Manager Abort Transactional : Abort SHUTDOWN IMMEDIATE 10-4 Oracle8i for NetWare

121 Novell Directory Service EASYCFG LISTENER.ORA SID 2. SID 3. EASYCFG IPC TNSNAMES.ORA 4. INIT.ORA %ORACLE_HOME% ADMIN <DB_NAME> PFILE CONTROL_FILE DB_NAME 5. Server Manager :LOAD SVRMGR SVRMGR>SET INSTANCE <service-name> 7. INTERNAL SVRMGR>CONNECT INTERNAL/<PASSWORD> 8. SVRMGR>STARTUP PFILE=%ORACLE_HOME% ADMIN <DB_NAME> PFILE SID Novell Directory Service Novell Directory Service NDS X.500 Novell Directory Service NDS NetWare 4 NDS NDS Oracle 10-5

122 Novell Directory Service NDS Oracle DBA Oracle NDS NDS NDS NDS Oracle Oracle Snap-In for NetWare Administrator Oracle8i Server NDS NetWare 4.2 NetWare 5 Windows 95/98/NT NWADMIN NWADMIN95 NWADMINNT SQL*Net 2.3 Net8 SQL*Net Net Oracle8i Oracle Snap-In for NetWare Administrator. : NetWare 5 Oracle8i Oracle Snap-In for NetWare Administrator 10-6 Oracle8i for NetWare

123 Novell Directory Service 10-1 NDS INIT.ORA 10-1 NDS INIT.ORA INIT.ORA NDS OS_AUTHENT_PREFIX="" NDS OS_ROLES=TRUE : OS_AUTHENT_PREFIX Oracle Snap-In for NetWare Administrator NDS Oracle Oracle Instance Object NDS DBA Oracle Snap-In for NetWare Administrator Oracle Snap-in for NetWare Administrator DBA NDS NDS : DESKTOP NetWare NWADMIN NetWare 4.2 NetWare

124 Novell Directory Service NWADMIN Windows 95 SYS: PUBLIC WIN95 NWADMN95.EXE Oracle Snap-in Windows 95 Windows NT SYS: PUBLIC WINNT NWADMNNT.EXE Oracle Snap-in Windows NT NetWare 5 Windows 95/NT SYS: PUBLIC WIN32 NWADMN32.EXE Oracle Snap-in NetWare Oracle8i NWADMIN NetWare Administrator 2. NDS [Root] 10-8 Oracle8i for NetWare

125 Novell Directory Service ORACLE desktop 4. NetWare Administrator desktop 5. Oracle OK 10-9

126 Novell Directory Service Oracle Oracle SID SID NetWare NetWare 7. Oracle Instance Object NDS Oracle8i for NetWare

127 Novell Directory Service CONNECT INTERNAL CONNECT username SYSDBA Oracle DBA NetWare Oracle ORACLE_DBA.<context_name> <context_name> NDS DESKTOP.ORACLE SYSOPER CONNECT username NDS NetWare ORACLE_DBA.<context name> NWADMIN NWAdmn32 NetWare 4.2 NetWare 5 ADMIN CONFIG.ORA ORACLE_GROUP NDS Oracle Oracle Oracle NDS Oracle Oracle NDS Oracle Oracle Server Oracle Server Novell Directory Service DBA : NDS Net8 Oracle8i CD NDS BULLETIN NDSWP.PDF 10-11

128 Novell Directory Service Oracle Snap-In for NetWare Administrator Oracle8i Server NDS for NetWare 4.2 NetWare 5 Oracle8i Server Oracle NDS NDS for NetWare 4.2/NetWare 5 Oracle8i Server Oracle NDS 1. NetWare 4.2 NetWare 5 NDS 2. NDS NLM : LOAD ORASCHEM ORASCHEM NDS Oracle / NetWare Oracle8i Server Oracle NDS / NetWare Oracle8i Server Oracle NDS 1. ORASCHEM NLM / 2. NLM : LOAD ORASCHEM Oracle8i for NetWare

129 Novell Directory Service NetWare 4.x CONNECT INTERNAL Oracle DBA NetWare Oracle8i Server NetWare ORACLE_DBA OSOPER ORACLE_OPER Oracle8i Server NetWare SID ORACLE_SID_DBA ORACLE_SID_OPER SID 2 SID NetWare ORACLE_DBA NWADMIN NWAdmn32 NetWare 4.2 NetWare 5 SUPERVISOR SUPERVISOR Oracle8i Database Administration Tools ORACLE_DBA NetWare NDS NetWare 4.2 CONFIG.ORA ORACLE_DBA NetWare CONFIG.ORA ORACLE_GROUP DBA NetWare CONFIG.ORA ORACLE_GROUP ORACLE_DBA CONFIG.ORA ORACLE_GROUP=<group> <group> 10-13

130 Novell Directory Service : = CONFIG.ORA CONFIG.ORA E Oracle NetWare Oracle Oracle8i Server Server Manager SQL*Plus NetWare INIT.ORA INITORCL.ORA OS_AUTHENT_PREFIX OPS$ OS_AUTHENT_PREFIX SVRMGR> CREATE USER OPS$<sysid> IDENTIFIED EXTERNALLY; sysid NetWare OPS$ NetWare OPUS OS_AUTHENT_PREFIX XXX SVRMGR> CREATE USER XXXOPUS IDENTIFIED EXTERNALLY; NetWare OPUS Oracle Oracle SQL*Plus / Oracle NetWare OPUS XXXOPUS Oracle Oracle XXXOPUS XXXOPUS XXXOPUS FISH SVRMGR> SELECT * FROM XXXOPUS.FISH Oracle Oracle8i Server Oracle8i for NetWare

131 Novell Directory Service OS_AUTHENT_PREFIX NULL NetWare Oracle Snap-In for NetWare Administrator OS_AUTHENT_PREFIX NULL NetWare Oracle8i Server NetWare NetWare 4.2/NetWare 5 NWADMIN NetWare SUPERVISOR NetWare 1 INIT.ORA OS_ROLES TRUE SQL FALSE NetWare NetWare 1. OS_ROLES TRUE NetWare 4.2/NetWare 5 NWADMIN 10-15

132 Novell Directory Service 10-5 NetWare 4. ORA rolename ORA_<SID>_rolename[_[D] [A]] <SID> rolename D A ADMIN OPTION ID TEST USERS ORA_TEST_USERS ORA_TEST_USERS_A ORA_TEST_USERS_D ORA_TEST_USERS_DA NetWare ID NetWare ORA_TEST_USERS_D Oracle8i Server USERS ORA_TEST_USERS_A USERS ADMIN OPTION NetWare ID : Oracle8i : Oracle Oracle8i for NetWare

133 Oracle8i SYSOPER SYSDBA INTERNAL : Oracle8i ORAPWD81 ORACLE_HOME DATABASE PWD<SID>.ORA <SID> ID PASSWORD ENTRIES INTERNAL SYS SYSDBA SYSOPER DBA Server Manager INIT.ORA REMOTE_LOGIN_PASSWORDFILE NONE EXCLUSIVE Oracle8i NDS ORACLE_DBA NONE 1 SYS INTERNAL 10-17

134 SHARED SYS INTERNAL SYSOPER SYSDBA SHARED Oracle8i Oracle8i EXCLUSIVE INTERNAL INITORCL.ORA NONE NDS 1. NDS 2. INIT.ORA REMOTE_LOGIN_PASSWORDFILE NONE NONE NDS REMOTE_LOGIN_PASSWORDFILE NONE EXCLUSIVE SHARED SVRMGR> CONNECT / AS SYSOPER SVRMGR> CONNECT / AS SYSDBA SYSOPER SYSDBA Oracle8i Server DBA SYSOPER SYSDBA INTERNAL BYPASS IPC : INTERNAL Oracle8i for NetWare

135 : Oracle8i INTERNAL Oracle8i INTERNAL : CONNECT INTERNAL : REMOTE_LOGIN_PASSWORDFILE NONE INTERNAL INTERNAL INTERNAL 1. ORAPWD81 2. REMOTE_LOGIN_PASSWORDFILE EXCLUSIVE SHARED 3. SVRMGR> CONNECT INTERNAL/<PASSWORD> <PASSWORD> ORAPWD81 INTERNAL : IPC INTERNAL 2 NetWare : CONFIG.ORA DBA_AUTHORIZATION INTERNAL 10-19

136 REDO Windows 95/98 Windows NT : 1. DBA_AUTHORIZATION INTERNAL 2. INTERNAL/@connect_string INTERNAL INTERNAL ORAPWD81 SQL*Plus ORAPWD81 1. %ORACLE_HOME% DATABASE PWDORCL.ORA 2. ORAPWD SQL*Plus INIT.ORA REMOTE_LOGIN_PASSWORDFILE SHARED EXCLUSIVE 1. SQL*Plus C: > SQLPLUS 2. INTERNAL SQL> CONNECT INTERNAL 3. SYS INTERNAL SQL> ALTER USER SYS IDENTIFIED BY PASSWORD; INTERNAL Oracle8i REDO Oracle8i ARCHIVELOG NOARCHIVELOG NOARCHIVELOG REDO ARCHIVELOG Oracle8i for NetWare

137 REDO REDO ARCHIVELOG ARCHIVELOG NOARCHIVELOG Oracle8i REDO 1: ARCHIVELOG ARCHIVELOG 1. MS-DOS SQL*Plus C: > SQLPLUS 2. INTERNAL Oracle8i SQL> CONNECT INTERNAL 3. SQL> SHUTDOWN 4. SQL> STARTUP MOUNT 5. SQL> ARCHIVE LOG LIST 6. ARCHIVELOG SQL> ALTER DATABASE ARCHIVELOG; 7. SQL> ARCHIVE LOG LIST 10-21

138 REDO 8. SQL> ALTER DATABASE OPEN; 9. 2: 2: 1. %ORACLE_HOME% ADMIN <DB_NAME> PFILE INIT.ORA 2. 3 # LOG_ARCHIVE_START = TRUE # LOG_ARCHIVE_DEST = %ORACLE_HOME% ORADATA <DB_NAME> ARCHIVE # LOG_ARCHIVE_FORMAT = "ARC%S.%T" 3. # : LOG_ARCHIVE_FORMAT 4. LOG_ARCHIVE_DEST REDO 5. LOG_ARCHIVE_FORMAT ARC%T 1 3 ARC Oracle8i for NetWare

139 REDO ARC%S ARC%T ARC%S ARC0001 ARC1 ARC SQL> SHUTDOWN 9. SQL> STARTUP 10. SQL> ARCHIVE LOG LIST REDO 10-23

140 Oracle8i 1. DBLINK_ENCRYPT_LOGIN TRUE 2. ORA_ENCRYPT_LOGIN TRUE TRUE Oracle8i Oracle8i FALSE FALSE Oracle8i : 7.1 Oracle Server Oracle DBLINK_ENCRYPT_LOGIN FALSE Oracle8i for NetWare

141 11 OCOPY RMAN81.NLM 11-1

142 Oracle8i DBA 1 Oracle Enterprise Manager Backup Manager Oracle Enterprise Manager Database Application Tools Oracle8i Backup Manager Backup Manager Oracle8i Oracle Enterprise Manager REDO Backup Manager OCOPY RMAN81.NLM Seagate Backup Manager RMAN.EXE Novell Ncopy Oracle OCOPY NLM NetWare Loadable Module Seagate Backup Exec 11-7 OCOPY RMAN81.NLM Oracle8i 11-2 Oracle8i for NetWare

143 Oracle8i Oracle8i Server for NetWare Server Manager HOST NetWare Server Manager [Ctrl] [Esc] : Server Manager ALTER DATABASE BACKUP CONTROLFILE to <filename> filename F: SYS: F: BACKUP CONTROL.ORA SYS:BACKUP CONTROL.ORA REDO REDO ORACLE_HOME NLM Oracle CONFIG.ORA AUTOEXEC.NCF SYS:SYSTEM Oracle 11-3

144 Oracle 2 ARCHIVELOG REDO Oracle ARCHIVELOG REDO NOARCHIVELOG REDO NOARCHIVELOG REDO ARCHIVELOG Oracle8i CREATE DATABASE Oracle8i Server ARCHIVELOG NOARCHIVELOG ALTER DATABASE : NOARCHIVELOG CREATE DATABASE ALTER DATABASE :LOAD SVRMGR31 SVRMGR> SET INSTANCE <service_name> SVRMGR> CONNECT INTERNAL/<password> SVRMGR> STARTUP MOUNT PFILE=%ORACLE_HOME% ADMIN <DB_NAME> PFILE INIT.ORA SVRMGR> ALTER DATABASE ARCHIVELOG; SVRMGR> ALTER DATABASE OPEN; ALTER DATABASE NOARCHIVELOG 11-4 Oracle8i for NetWare

145 Oracle ARCHIVELOG REDO REDO : Oracle8i Server INIT.ORA LOG_ARCHIVE_START FALSE LOG_ARCHIVE_START TRUE 3 INIT.ORA LOG_ARCHIVE_START TRUE LOG_ARCHIVE_DEST REDO LOG_ARCHIVE_FORMAT LOG_ARCHIVE_START TRUE ARCHIVELOG LOG_ARCHIVE_DEST LOG_ARCHIVE_FORMAT 11-6 Server Manager SVRMGR> ALTER SYSTEM ARCHIVELOG START TO <destination>; destination LOG_ARCHIVE_DEST ARCHIVE LOG START ARCHIVE LOG START INIT.ORA 11-5

146 LOG_ARCHIVE_START FALSE Oracle8i Server : ARCHIVELOG REDO REDO ARCH REDO INIT.ORA LOG_ARCHIVE_DEST ARCHIVE LOG LOG_ARCHIVE_DEST %ORACLE_HOME% ORADATA <DB_NAME> ARCHIVE REDO INIT.ORA LOG_ARCHIVE_FORMAT Oracle8i Server %T 1 3 %t 1 %S 1 5 %s 1 LOG_ARCHIVE_FORMAT ARC%S.ORA %S.ORA %T %t LOG_ARCHIVE_FORMAT ARC%S.%T LOG_ARCHIVE_FORMAT Oracle8i 11-6 Oracle8i for NetWare

147 OCOPY : 8.3 NetWare ,999 Oracle8i REDO ARCHIVELOG NetWare <month-day-year> <hour-minute-second>: ORACLE - Cannot allocate log, archival required month-day-year hour-minute-second REDO REDO REDO Oracle8i OCOPY OCOPY I/O. x: x I/O. physicaldriven N

148 RMAN81.NLM OCOPY 2 OCOPY :OCOPY OCOPY OCOPY RMAN81.NLM Recovery Manager RMAN81.NLM Oracle8i NetWare xx V$DATAFILE DOS Oracle8i for NetWare

149 12 Oracle8i intermedia Text Filters Oracle8i intermedia Text imt for NetWare Oracle8i intermedia Text Oracle8i intermedia Text Oracle8i intermedia Text Oracle8i intermedia Text Oracle8i intermedia Text Filters 12-1

150 Oracle8i intermedia Text Oracle Server Oracle SQL PL/SQL Oracle8i intermedia Text Oracle8i intermedia Text NetWare Oracle8i intermedia Text Oracle8i intermedia Text Oracle8i intermedia Text Oracle8i intermedia Text for NetWare Oracle8i intermedia Text for NetWare 4 intermedia Text Library intermedia Text intermedia Text Server DML intermedia Text Loader intermedia Text Oracle intermedia Text Knowledge Base Compiler 1 intermedia Text Library intermedia Text Library CTXLIB81.NLMinterMedia Text intermedia Text NetWare intermedia Text Library NLM intermedia Text intermedia Text Library 12-2 Oracle8i for NetWare

151 Oracle8i intermedia Text intermedia Text Server intermedia Text Server DML intermedia Text CTXSRV81.NLM NLM CTXSRV CTXSRV81.NLM intermedia Text NLM intermedia Text Library NLM CTXSRV81.NLM intermedia Text Loader intermedia Text Loader Oracle intermedia Text Loader CTXLDR81.NLM. NLM SQL*Loader CTXLDR81.NLM intermedia Text Knowledge Base Compiler intermedia Text Knowledge Base Compiler 1 intermedia Text intermedia Text Knowledge Base Compiler CTXKBC81.NLM NLM CTXKBTC Oracle8i intermedia Text intermedia Text for NetWare intermedia Text Library CTXLIB81.NLM CTXSRV81.NLM intermedia Text 1 intermedia Text Library intermedia Text Server NetWare intermedia Text Library CTXLIB81.NLM CTXLIB81.NLM NetWare Oracle8i intermedia Text Filters 12-3

152 Oracle8i intermedia Text Oracle8i intermedia Text Oracle8i intermedia Text Oracle8i intermedia Text NetWare CTXSRV81.NLM intermedia Text NetWare intermedia Text Server intermedia Text Manager CTX_ADM SHUTDOWN CTX_ADM CTXSYS intermedia Text Server SQL*Plus CONNECT CTXSYS/<password> EXECUTE CTX_ADM.SHUTDOWN('ALL'); CTXSRV81.NLM intermedia Text Server Oracle8i intermedia Text NetWare Inso NetWare NLM %ORACLE_HOME% NLM 12-4 Oracle8i for NetWare

153 13 NetWare Java 13-1

154 Java Java Oracle Java Option Oracle Java Utilities Oracle8i Enterprise Edition Java Oracle Java Option JDK Java Development Kit Java CORBA 2.0 Object Request Broker JDBC SQLJ Enterprise JavaBeans Oracle Java Utilities Java Java CORBA Enterprise JavaBeans Oracle8i JVM Oracle JDBC Java Database Connectivity JDBC Java Java JDBC JDBC JDBC X/Open SQL Call Level Interface SQL92 Entry Level JDBC API Oracle Oracle SQLJ SQLJ Java SQL SQLJ SQLJ SQL Java SQLJ SQL SQL SQLJ JDBC Oracle Oracle JDBC Driver 13-2 Oracle8i for NetWare

155 NetWare C 3GL PL/SQL PL/SQL SQL PL/SQL 3GL SQL PL/SQL 3GL PL/SQL SQL*Forms NLM : SQL 2 SQL %ORACLE_HOME% PLSQL DEMO EXTPROC.SQL 13-3

156 Oracle8i Enterprise Edition Net8 Oracle8i Server Oracle8i Server Oracle8i for NetWare NetWare Oracle8i Server PL/SQL PL/SQL EXTP81.NLM Net8 Client Net8 Server Net8 Protocol Adapters Net8 Oracle8i Enterprise Edition CD-ROM Net8 Net8 %ORACLE_HOME% NETWORK ADMIN LISTENER.ORA %ORACLE_HOME% NETWORK ADMIN TNSNAMES.ORA PL/SQL Net8 EXTPROC PL/SQL EXTPROC NLM EXTPROC NLM Oracle8i Server TNSNAMES.ORA SQLNET.ORA TNSNAMES.ORA LISTENER.ORA Net Oracle8i for NetWare

157 1. EXTPROC SID LISTENER.ORA LISTENER = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= IPC) (KEY= <server-name>_lsnr) ) (ADDRESS= (PROTOCOL= SPX) (KEY= <server-name>_lsnr) ) (ADDRESS= (PROTOCOL= TCP) (Host= server.company.com) (Port= 1521) ) ) STARTUP_WAIT_TIME_LISTENER = 0 CONNECT_TIMEOUT_LISTENER = 10 TRACE_LEVEL_LISTENER = OFF SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = ORCL) ) (SID_DESC = (SID_NAME = extproc) (PROGRAM=EXTP81) ) ) 2. EXTPROC 1 TNSNAMES.ORA extproc_connection_data.world = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = spx.world) (PROTOCOL = SPX) (SERVICE = server-name_lsnr) ) ) 13-5

158 ) (CONNECT_DATA = (SID = extproc) ) extproc_connection_data.world = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP) (Host = server.company.com (Port = 1521) ) (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP) (Host = server.company.com (Port = 1526) ) ) (CONNECT_DATA = (SID = extproc) ) ) : SQLNET.ORA NAMES.DEFAULT_DOMAIN NAME.DEFAULT_ZONE WORLD TNSNAMES.ORA EXTPROC_CONNECTION_DATA.WORLD C 3GL EXTPROC C : NLM 13-6 Oracle8i for NetWare

159 #include <process.h> void main () { ExitThread(TSR_THREAD, 0); } #define NullValue -1 /* This function simply returns the returns the larger of x and y. */ long find_max(long x, short x_indicator, long y, short y_indicator, short *ret_indicator) { /* first check to see if you have any nulls */ /* Just return a null if either x or y is null */ } if ( x_indicator==nullvalue y_indicator==nullvalue) { *ret_indicator = NullValue; return(0); } else { *ret_indicator = 0; /* Signify that return value is not null */ if (x >= y) return x; else return y; } NLM 3GL NLM NLM NLM find_max EXTERN.NLM NLM 13-7

160 NLM Oracle8i 2 1. PL/SQL NLM Server Manager :LOAD SVRMGR31 CREATE LIBRARY PL/SQL SVRMGR> CREATE LIBRARY externprocedures AS EXTERN.NLM ; ORACLE:ORAHOME1 NLM externprocedures EXTERN.NLM ORACLE:ORAHOME1 NLM NetWare NLM EXTERN.NLM Oracle ORACLE:ORAHOME1 : DBA PL/SQL SQL PL/SQL EXECUTE 2. PL/SQL BEGIN...END EXTERNAL PL/SQL EXTERNAL PL/SQL EXTERNAL NLM C 13-8 Oracle8i for NetWare

161 CREATE OR REPLACE FUNCTION PLS_MAX( x BINARY_INTEGER, y BINARY_INTEGER) NLM RETURN BINARY_INTEGER AS EXECUTE EXTERNAL LIBRARY externprocedures NAME "find_max" / LANGUAGE C PARAMETERS ( x long, -- stores value of x x INDICATOR short, -- this is used to determine if x is a NULL value y long, -- stores value of y y INDICATOR short, -- this is used to determine if y is a NULL value RETURN INDICATOR short ); -- need to pass pointer to return value's -- indicator variable to -- determine if NULL. --This means that my function will be defined as: --long max(long x, short x_indicator, -- long y, short y_indicator, short * ret_indicator) PL/SQL SQL ) PL/SQL PLS_MAX FIND_MAX 13-9

162 FIND_MAX 1. Useit PL/SQL PL/SQL PLS_MAX CREATE OR REPLACE PROCEDURE UseIt AS a integer; b integer; c integer; BEGIN a := 1; b := 2; c := PLS_MAX(a,b); dbms_output.put_line('the maximum of ' a ' and ' b ' is ' c); END; 2. SVRMGR> EXECUTE UseIt; Oracle8i PL/SQL %ORACLE_HOME% PLSQL DEMO EXTPROC.C EXTPROC.SQL Oracle8i for NetWare

163 A Oracle8 for Windows NT Oracle Installer ORA ORA-09499: Oracle8i Server OSD OSD-02163: NetWare Oracle A-1

164 Oracle8i Oracle8i LOGFILE NetWare Export LOAD EXP81 USERNAME/PASSWORD PARFILE=FILENAME FILE1.LOG FILE2.ERR FILE1.LOG Export FILE2.ERR Oracle Installer Oracle Installer Oracle Installer DISK_FULL DRIVE_LOCKED FILE_CORRUPTED FILE_NOT_FOUND INVALID_FILE_NAME LEXICAL_ERROR CD-ROM A-2 Oracle8i for NetWare

165 Oracle Installer LOCKING_ VIOLATION OS_ERROR PERMISSION_ DENIED READ_ERROR RECALIBRATION_FAILURE SHARING_VIOLATION I/O LOCKING_VIOLATION CD-ROM SUPERVISER CD-ROM TOO_MANY_OPEN_FILES A-3

166 Oracle Installer WRITE_ERROR WRITE_PROTECTED I/O Oracle CD-ROM A-4 Oracle8i for NetWare

167 ORA ORA-09499: Oracle8i Server ORA ORA-09499: Oracle8i Server Oracle8 NetWare OSD OSD OSD OSD OSD-02163: NetWare Oracle ORA ORA ORA ORA ORA ORA ORA ORA ORA ORA ORA ORA ORA ORA ORA ORA ORA ORA ORA ORA ORA ORA ORA sfccf: sfcopy: sfifi: sfofi: sfotf: sfqio: sfrfb: sfsrd: sftcls: sftget: sftopn: sfwfb: sfwfbmt: slgfn: sfdone: I/O sfqio: I/O Completion Routine sdnfy: %s %s sfsfs: sfrfs: smpalo: PGA smsalo: SGA smscre: SGA smsget: SGA A-5

168 ORA ORA-09499: Oracle8i Server ORA ORA ORA ORA ORA ORA ORA ORA ORA ORA ORA ORA ORA ORA ORA ORA ORA ORA ORA ORA ORA ORA ORA ORA ORA ORA ORA ORA ORA ORA smprset: smcstk: sfsmap: SGA smsdes: SGA sigpidu: ID spdcr: spdde: spini: sptpa: spwat: spawn: Oracle szalloc: szlon: OS szrfc: szrfc: sllfcf: sllfop: sllfrb: sllfsk: sksaalo: sksachk:: sksabln: sksasmo: osncon: DPMI osncon: sclgt: slsleep: slspool: slsprom: A-6 Oracle8i for NetWare

169 ORA ORA-09499: Oracle8i Server ORA ORA ORA ORA ORA ORA ORA ORA ORA ORA ORA ORA ORA ORA ORA ORA ORA ORA sltln: sql2tt: ORACLE_EXECUTABLE 2 szrpc: szprv: slkhst: slgtd: szrfc: OS slzdtb: 10 slpdtb: 10 Oracle Oracle DBA scgcan: LK_SYNC_CANCEL scgcc: LK_CLOSE scggc: LK_OPEN_CONVERT scggc: LK_CONVERT scgcm: ORACLE_SID scumnt: Oracle A-7

170 OSD OSD-02163: NetWare Oracle OSD OSD-02163: NetWare Oracle NetWare OSD : : NetWare NLM ORACLE SGA OSD ID : : OSD : : OSD PDA : : OSD : : OSD : : OSD : : OSD : : A-8 Oracle8i for NetWare

171 OSD OSD-02163: NetWare Oracle OSD : : OSD NetWare : : INIT.ORA DB_BLOCK_BUFFERS SGA NLM OSD : : INIT.ORA DB_BLOCK_BUFFERS SGA NLM OSD SGA : SGA : OSD : : OSD : : INIT.ORA DB_BLOCK_SIZE 64KB OSD : CREATE REUSE INIT.ORA DB_BLOCK_SIZE : REUSE CREATE REUSE DB_ A-9

172 OSD OSD-02163: NetWare Oracle BLOCK_SIZE OSD CREATE : CREATE : CREATE CREATE REUSE REUSE Oracle8i SQL CREATE OSD REUSE : CREATE REUSE : REUSE CREATE CREATE OSD : : Oracle8i OSD : : Oracle8i OSD : CREATE REUSE : CREATE REUSE CREATE OSD : : OSD : SQL NetWare 256 : A-10 Oracle8i for NetWare

173 OSD OSD-02163: NetWare Oracle OSD : 4GB : 4GB OSD : : OSD : : OSD : : OSD-2073 : : OSD : : OSD : : A-11

174 OSD OSD-02163: NetWare Oracle OSD : : OSD : : OSD : : OSD : Betrieve : OSD NetWare / : NetWare CONNECT INTERNAL : CONNECT INTERNAL OSD NetWare DBA : DBA NetWare : CONFIG.ORA ORACLE_GROUP NetWare ORACLE_GROUP ORACLE_DBA OSD NetWare OS : NetWare 30 : NetWare 30 OSD OS A-12 Oracle8i for NetWare

175 OSD OSD-02163: NetWare Oracle OSD OSD-02095NetWare OSD NetWare filecopy : INIT.ORA LOG_ARCHIVE_DEST : OSD : : OSD : : Novell NetWare OSD : : OSD : CONFIG.ORA 256 : CONFIG.ORA CONFIG.ORA E OSD : : OSD CONFIG.ORA : %ORACLE_HOME% NLM CONFIG.ORA : %ORACLE_HOME% NLM CONFIG.ORA CONFIG.ORA E A-13

176 OSD OSD-02163: NetWare Oracle OSD-02124CONFIG.ORA : : OSD : : OSD O/S : fix n var : fix n var OSD : : OSD : : OSD : : A-14 Oracle8i for NetWare

177 B NLS NLS_LANG NLS_LANG B-1

178 NLS_LANG NLS_LANG Oracle8 for Windows NT NLS Oracle8 for Windows NT Oracle Installer NLS_LANG NLS_LANG NLS_LANG = LANGUAGE_TERRITORY.CHARACTER_SET LANGUAGE TERRITORY CHARACTER_SET NLS_LANG AMERICAN_AMERICA.WE8PC850 NLS_LANG CONFIG.ORA : NLS_LANG NLS Oracle8i NLS_LANG Oracle8 for Windows NT NLS_LANG NLS_LANG ARABIC_UNITED ARAB EMIRATES.AR8MSWIN1256 BRAZILIAN PORTUGUESE_BRAZIL.WE8ISO8859P1 BULGARIAN_BULGARIA.CL8MSWIN1251 CANADIAN FRENCH_CANADA.WE8ISO8859P1 CATALAN_CATALONIA.WE8ISO8859P1 CROATIAN_CROATIA.EE8MSWIN1250 CZECH_CZECH REPUBLIC.EE8MSWIN1250 DANISH_DENMARK.WE8ISO8859P1 B-2 Oracle8i for NetWare

179 NLS_LANG NLS_LANG DUTCH_THE NETHERLANDS.WE8ISO8859P1 ARABIC_UNITED ARAB EMIRATES.AR8MSWIN1256 AMERICAN_AMERICA.WE8ISO8859P1 ENGLISH_UNITED KINGDOM.WE8ISO8859P1 ESTONIAN_ESTONIA.BLT8MSWIN1257 FINNISH_FINLAND.WE8ISO8859P1 FRENCH_FRANCE.WE8ISO8859P1 GERMAN_GERMANY.WE8ISO8859P1 GREEK_GREECE.EL8MSWIN1253 HEBREW_ISRAEL.IW8MSWIN1255 HUNGARIAN_HUNGARY.EE8MSWIN1250 ICELANDIC_ICELAND.WE8ISO8859P1 INDONESIAN_INDONESIA.WE8ISO8859P1 ITALIAN_ITALY.WE8ISO8859P1 JAPANESE_JAPAN.JA16SJIS KOREAN_KOREA.KO16KSC5601 LATIN AMERICAN SPANISH_AMERICA.WE8ISO8859P1 LATVIAN_LATVIA.BLT8MSWIN1257 LITHUANIAN_LITHUANIA.BLT8MSWIN1257 MEXICAN SPANISH_MEXICO.WE8ISO8859P1 NORWEGIAN_NORWAY.WE8ISO8859P1 POLISH_POLAND.EE8MSWIN1250 PORTUGUESE_PORTUGAL.WE8ISO8859P1 ROMANIAN_ROMANIA.EE8MSWIN1250 RUSSIAN_CIS.CL8MSWIN1251 SIMPLIFIED CHINESE_CHINA.ZHS16GBK SLOVAK_SLOVAKIA.EE8MSWIN1250 B-3

180 NLS_LANG SPANISH_SPAIN.WE8ISO8859P1 SWEDISH_SWEDEN.WE8ISO8859P1 THAI_THAILAND.TH8TISASCII TRADITIONAL CHINESE_TAIWAN.ZHT16BIG5 TURKISH_TURKEY.WE8ISO8859P9 UKRAINIAN_UKRAINE.CL8MSWIN1251 VIETNAMESE_VIETNAM.VN8VN3 AMERICAN_AMERICA.US7ASCII 1. Oracle Installer Oracle MS-DOS NLS_LANG Oracle SQL*Plus SQL Loader Import Export Server Manager MS-DOS NLS_LANG MS-DOS Windows ANSI OEM Oracle NLS_LANG Windows MS-DOS NLS_LANG OEM ANSI MS-DOS NLS_LANG SET NLS_LANG NLS_LANG B-4 Oracle8i for NetWare

181 MS-DOS NLS_LANG MS-DOS OEM Oracle AR8ASMO8X WE8PC850 WE8PC850 EE8PC852 WE8PC850 WE8PC850 US8PC437 WE8PC850 WE8PC850 WE8PC850 EL8PC737 EE8PC852 WE8PC850 JA16SJIS KO16KSC5601 WE8PC850 WE8PC850 EE8PC852 WE8PC850 EE8PC852 RU8PC866 ZHS16GBK EE8PC852 EE8PC852 WE8PC850 WE8PC850 B-5

182 MS-DOS NLS_LANG ZHT16BIG5 TR8PC857 B-6 Oracle8i for NetWare

183 C Oracle8i Server C-1

184 Oracle8i for NetWare BACKGROUND_DUMP_DEST BACKGROUND_DUMP_DEST %ORACLE_HOME% ADMIN <DB_NAME> UDUMP Oracle8i.TRC SIDDBWR.TRC SIDSMON.TRC SID USER_DUMP_DEST xxxxxxxx.trc xxxxxxxx Windows NT ID 8 Oracle8i Server 1 REDO SIDALRT.LOG BACKGROUND_DUMP_DEST BACKGROUND_DUMP_DEST %ORACLE_HOME% ADMIN <DB_NAME> BDUMP SIDALRT.LOG C-2 Oracle8i for NetWare

185 Oracle8i TNS TNS: ORA TNS: ORA TNS: SID ORA TNS: TNSLSN81.NLM NetWare TNSNAMES.ORA NetWare LISTENER.ORA SID LISTENER.ORA TNSLSN81.NLM NetWare IPC SPX TCP/IP C-3

186 C-4 Oracle8i for NetWare

187 D Oracle8i NetWare : NetWare Oracle Server INIT<SID>.ORA VOL: ORAHOME1 ADMIN <DB_NAME> PFILE INIT.ORA D-1

188 ASCII REDO Oracle8i Oracle8i Oracle8i NLM NetWare 1 : Oracle8i INIT.ORA SID ORCL INIT.ORA INIT.ORA %ORACLE_HOME% ADMIN <DB_NAME> PFILE Server Manager STARTUP Oracle8i DBA Oracle8i INIT.ORA INIT.ORA D-2 Oracle8i for NetWare

189 CONTROL_FILES INIT.ORA CONTROL_FILES=%ORACLE_HOME% ORADATA <DB_NAME> CTL1ORCL.ORA ORACLE_HOME %ORACLE_HOME% DATABASE Oracle8i Server Oracle8i Server # # SGA 3 SGA db_block_buffers = 60 # SMALL # db_block_buffers = 550 # MEDIUM # db_block_buffers = 3200 # LARGE SGA # db_block_buffers = 60 # SMALL db_block_buffers = 550 # MEDIUM # db_block_buffers = 3200 # LARGE D-3

190 NetWare NetWare NetWare Oracle8i Oracle8i for NetWare : Oracle8i BACKGROUND_DUMP_DEST %RDBMS% TRACE COMMIT_POINT_STRENGTH COMPATIBLE CONTROL_FILES %ORACLE_HOME% ORADATA CTL1%SID%.ORA %ORACLE_HOME% ORADATA CTL1%SID%.ORA %SID% ORCL DB_BLOCK_BUFFERS DB_BLOCK_CHECKPOINT_BATCH DB_BLOCK_ WRITE_BATCH DB_BLOCK_SIZE DB_FILES MAXDATAFILES 254 DB_FILE_MULTIBLOCK_READ_ COUNT DB_NAME ORACLE DISTRIBUTED_TRANSACTIONS.25 x TRANSACTIONS 16 0 TRANSACTIONS DML_LOCKS ENQUEUE_RESOURCES GLOBAL_NAMES FALSE TRUE TRUE/FALSE D-4 Oracle8i for NetWare