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 Technology: Only 8.01 after version, data dispersion is stored, 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
Second, Oracle Database Core, Database Administrator DBA Database Management and Daily Maintenance Database Overall Design Database Storage Structure Design: Physical Structure, Logic Structure / ****************** *********************************************************** *****************************
You can run Oracle operating system: UNIX: Sun Solaris, HP-UX, AIX, Compaq-Tru64, SCO-UNIX, and Linux (running on PC)
Windows NT / 2000
Oracle cannot be installed on the P4 machine, you want to install the installation of the installation file to install Oracle on the P4 machine (Intel P4 machine only): Copy Oracle's installation CD to your hard disk, then / stage /components/oracle.swp.jre/win32/bin/symcjit.dll file is renamed to symcjit.org, then start installing.
*********************************************************** ********************************************************* /
Database backup and recovery optimization and performance adjustment
Third, application system development
Fourth, the application server OAS
5. Clear the Oracle8i operating environment under Windows NT / 2000 (preparation before reinstall):
1. Delete Oracle8i registry: regedit.exe => hklm => software => Oracle
2. Delete Oracle8i service: regedit.exe => hklm => system => currentControlset => Services => Services starting with Oracle
3. Delete Oracle8i Event Log: Regedit.exe => HKLM => System => CurrentControlSet => Services => EventLog => Application => Event started with Oracle
4. Delete the Windows NT / 2000 installation 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.3 * / [seven, Oracle network configuration]
/ * (1) Query Database Name: SQL> SELECT NAME FROM V $ Database;
(2) Query Database Installement 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 the global database name (SYS users): SQL> SELECT VALUE $ from Props $ Where name = 'global_db_name'; // String Case Size * /
1. Oracle network driver uses SQL * NET V2.0 connection
Oracle for Win98 -> SQL * NET Easy Configuration
2. Oracle Network Drive Using Net8 Connections
3. Oracle network driver uses Net8i connection
Oracle program group -> network administration -> Net8 Assistant
[Create a TNS connection process]: (1) Start NET8 Assistant (2) Local -> Service Name (3) Edit -> Create ... (4) 1: Network Service Name: Give the network database to be used in this The machine specifies a host string that is defined by itself. (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 sessions: SQL> Select Username, SID, Serial #, Machine from v $ session; Delete User Session: SQL> ALTER SYSTEM KILL Session 'SID, SERAIL #';
/ * Exercise SQLUS 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> / / / forward slash: Repeat the previous SQL statement
SQL> Set Linesize 1000 // Displays the line wide in SQL * Plus into 1000 characters.
SQL> Connect System / Manager @ oasjz // Connect directly to the database on 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/network/admin/tnsnames.ora
(2) In Windows 98 / NT / 2000: D: /oracle/ora81/neetwork/admin/tnsnames.ora
B. Manually configure Oracle Listening Process Profile: Listener.ora
(1) In UNIX: /u01/app/oracle/product/8.1.6/neetwork/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 to start the process is the same as Unix.
# Listener.ora NetWork Configuration File: D: /oracle/ora81/neetwork/admin/listener.ora # generated by Oracle Configuration Tools.
Listener = (Description_List = (address_list = (address = (protocol = IPC))) (address_list = (pecol = tcp) (host = ora54)) //// Note: Host's Host must be your hostname, otherwise you will have problems, or you can use your machine's IP address)) (Description = (Protocol_stack = (presentation = RAW)) (Address = (Protocol = tcp) (Host = ORA54)))))))))))
SID_LIST_LISTENER = (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, cannot be changed, otherwise the problem is listening))))
5. Write the host string to the registry (simplify SQL * Plus login) regedit.exe -> hklm -> Software -> Oracle -> Home0 Add Keyword: 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: How to use 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 the Oracle database] D: /> SQLPLUS INTERNAL / ORACLESQL> Startup force // Force to restart the 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 method:
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. The SVRMGR> EXIT server manager ends.
