I. Database language section 1. SQL language: Relational database standard language 2. PL / SQL: Process language Procedural language3. SQL * Plus: Simple report, operating system interface 4. Oracle 8.01 appears: (1) Data partition Technical: Only the 8.01 version is applied, the data is dispersed, don't put it on a hard disk, I / O performance, good security. (2) Object technology: stored procedures, functions, packages, database triggers, dynamic SQL programming (3) Database permission management (4) Data Integrity Constraints 2, Oracle Database Core, Database Administrator DBA Database Manage and daily maintenance database overall design data fixtures storage structure design: physical structure, logical structure / ****************************************** *********************************************************** *************** ORECLE operating system: UNIX: Sun Solaris, HP-UX, AIX, Compaq-Tru64, SCO-UNIX, and Linux (running on PC) Windows Oracle cannot be installed on the NT / 2000 P4 machine, you want to install the installation of the installation file to install or download the patch to install Oracle on the P4 machine (Intel P4 machine): Copy Oracle installation CD to the hard disk, then Rename the /stage/components/racle.swp.jre/win32/bin/symcjit.dll file to symcjit.org, then start installing. *********************************************************** ********************************************************* / Backup and Recovery Optimization and Performance Adjustment 3, Application Server OAS 5, Clear Oracle8i Run Environment under Windows NT / 2000 (Preparation before reinstall): 1. Remove Oracle8i Registry: Regedit.exe => HKLM => Software => Oracle 2. Delete Oracle8i service: regedit.exe => hklm => system => CurrentControlSet => Services => The service started with Oracle 3. Delete Oracle8i event log: regedit.exe => HKLM => System => coprentControlSet => Services => EventLog => Application => Events starting with Oracle 4. Delete Windows NT / 2000 Install Disk / Program Files / ORACLE directory. 5. Delete Oracle8i Environment Variable Control Panel => System => Advanced => Environment Variables (1) Delete ClassPath (2) Edit Path, delete the path that is related to Oracle. 6. Delete Oracle8i menu 7. Restart Windows NT / 2000, stop service. 8. Delete the Oracle8i home directory.
/ * IP: 75.64.16.Xmask: 255.255.248.0gateway: 75.64.16.3dns: 75.64.16.3dns: 75.64.16.3 * / [seven, Oracle network configuration] / * (1) query database name: SQL> SELECT NAME FROM V $ DATABASE; (2) Query Database Installence Name: SQL> SELECT Instance_name from V $ Instance; (3) Query Database Service Name: SQL> Select Value from V $ Parameter Where Name = 'Service_names'; // (lowercase) (4) Query global Database Name (SYS User): SQL> SELECT VALUE $ from Props $ Where name = 'global_db_name'; // String Case Size * / 1. Oracle Network Drive Using SQL * NET V2.0 Connect Oracle for Win98 -> SQL * Net Easy Configuration 2. Oracle Network Drive Using NET8 Connection 3. Oracle Network Drive Using Net8i Connection Oracle Program Group -> Network Administration -> Net8 Assistant [Create TNS Connection Procedure]: (1) Start Net8 Assistant (2) Local -> Services Name (3) Edit -> Create ... (4) 1 page: Network service name: Give the network database to be used to specify a host string, define it yourself. (5) Page II: Agreement: TCP / IP (Internet Protocol) (6) Page 3: Host Name: Enter the IP address or domain name of the other machine. Port number: The default is 1521, which is generally not required. (7) Page 4: (ORACLE8I) Service Name: Enter the service name of the network database (8) Page 5: Completion. (9) Menu: File -> Save Network Configuration. Monitor user session: SQL> Select Username, SID, Serial #, Machine from V $ session; Delete User Session: SQL> ALTER System Kill Session 'SID, Serail #'; / * Exercise SQLPlus Stud 01 / Stud 01Sql> Show User SQL> SELECT * from Emp; SQL> Select * from dept; * / [// Use the following method to repeat the previous SQL statement (in SQL * Plus) SQL> L // lowercase letters L, display the previous SQL statement 1 * Select UserName, SID, Serial #, Machine From V $ sessionsql> / / / front slope: Repeat the previous SQL statement SQL> Set LineSize 1000 // Set the line wide in SQL * Plus to 1000 characters. SQL> Connect System / Manager @ oasjz // Directly connected to another machine in SQL * Plus, @ character is another machine TNSName] 4. Manually configure Oracle network connection: Mainly configured "TNSNames .ora "file.
A. Manually configure Oracle Network Connection Profile: TNSNames.ora (1) In UNIX: /u01/app/oracle/product/8.1.6/neetwork/admin/tnsnames.ora (2) in Windows 98 / NT / 2000 Medium: D: /oracle/thsnames.ora B. Manually Configure Oracle Listening Process Profile: Listener.ora (1) In UNIX: /u01/app/oracle/Product/8.1.6/network /admin/listener.ora Unix Start Process Command: $ LSNRCTL START // Start Monitor Process $ LSNRCTL Status // Display Listening Process Status $ LSNRCTL Stop // Stop Listening Process (2) In Windows 98 / NT / 2000: D : /oracle/ora81/neetwork/admin/listener.ora The command of the launch process is the same as Unix.
# LISTENER.ORA Network Configuration File: d:. /Oracle/Ora81/network/admin/listener.ora# Generated by Oracle configuration tools LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC) (KEY = ExtProc0)))) (address = (protocol = tcp) (host = ora54) (port = 1521)) // Note: Host's Host must be your host name, otherwise listens to problems, you can Use your machine's IP address)) (deSCription = (presecol_stack = (presentation = RAW)) (Host = ORA54))) SID_LIST_LISTENER = (Port = 2281))) SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = d: / Oracle / Ora81) (PROGRAM = extproc)) (SID_DESC = (GLOBAL_DBNAME = ora54) (ORACLE_HOME = d: / Oracle / Ora81) (SID_NAME = ora54) / / Note: ORA54 is the SID name of the database, can not be changed, otherwise a problem)) 5. Write the host string to the registry (simplified SQL * Plus login) regedit.exe -> hklm -> Software -> Oracle -> Home0 Add Keywords: Local (String ), Key value: host string name. / * Copy the content below to a .reg file, double-click execution in Windows 2000, you can achieve increase or modify the role of Local key value Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINE / SOFTWARE / ORACLE / HOME0] "local" = "Ora54" * / [SVRMGRL: Server Manager] D: /> SVRMGRL Oracle Server Manager Release 3.1.6.0.0 - Production Copyright (C) 1997, 1999, Oracle Corporation. all rights reserved.
Oracle8i Enterprise Edition Release 8.1.6.0.0 - ProductionWith The Partitioning OptionjServer Release 8.1.6.0.0 - Production SVRMGR> Connect Internal // Use SVRMGRL, the first command used after entering must be this command. Password: // If you require a password, enter the Oracle connection success. SVRMGR> SELECT NAME FROM V $ database; / / Check the currently used database name Name ------- ORA44 has selected 1 line. SVRMGR> Shutdown Immediate // Close the currently used database is turned off. The database has been removed. Oracle instance is closed. SVRMGR> Startup // Start the currently used database, if it is invalid, use Startup Force that has started an Oracle instance. The system global region has a total of 24433932 bytes Fixed Size 70924 bytes Variable size 7507968 bytes Database buffers 16777216 bytes Redo buffers 77824 bytes ORA-00205: ??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? ???????? SVRMGR> [Another example of launching Oracle database] D: /> SQLPLUS INTERNAL / ORACLESQL> Startup force // Force restart database. [Modify password] SQL> grant connect to system identified by NewPassword; // if the number as a password, use double quotes SQL> grant connect to sys identified by NewPassword; SQL> alter user system identified by NewPassword; SQL> Alter user sys identified by newpassword; sql> password // Need to enter the original password // Note: Method for modifying the password or equivalent; SYS and System users can modify each other; if SYS is forgotten with the system user, use the following Methods: D: /> SVRMGRL Oracle Server Manager Release 3.1.6.0.0 - Production Copyright (C) 1997, 1999, Oracle Corporation. all rights reserved. Oracle8i Enterprise Edition Release 8.1.6.0.0 - Productionwith The Partitioning OptionjServer Release 8.1.6.0.0 - Production Svrmgr> Connect InterNal / Oracle connection is successful. SVRMGR> Grant Connect to System Identified by Manager; statement has been processed.
