JBUILDER9 WebLogic7 actual articles
Tools (Oracle9i)
Author: Kay Huang
E_mail: hk_sz@163.com
Foreword
This article will introduce some of the tools that will be applied in my article and their installation and configuration.
Oracle9i Chinese version installation and configuration
First, install
After clicking Setup.exe, click "Next" all the way until "Next" is gray, the top title bar is displayed as "Oracle Universal Installer: Database ID", then enter "Global Database Name" (SID) Continue to click "Next" until "Install", click "Install" and start installing.
When "Error: No File D: / Oracle/ora92/OCS4J/Admin/OCS4J.Properties" appears, click "Cancel", and select "Cancel" dialog box to select "Use only to install the component", click "OK", the installation will continue.
When installing "Oracle Universal Installer: Configuration Tool", if the error "ORA-12571: TNS: Package is written), click" OK "directly. This is complete, there is a "error" prompt, "OK" is, then continue "Next", to "Oracle Universal Installer: Configuration Tool", click "Exit".
After the preliminary installation of Oracle9i, the database is not built due to the "ORA-12571: TNS: Packet Enterprise" error, then we will "d: /oracle/ora92/neetwork/admin/sqlnet.ora" , Change the "NTS" to "NONE".
Click "Start / Program / Oracle - OraHome92 / Configuration And Migration Tools / Database Configuration Assistant" to start adding a database:
"Step 1: Operation" selected "Create Database", "Next";
"Step 2: Database Template" selected "New Database", "Next";
"Step 3: Database ID" Fill in "Global Database Name" (my SID is KKDB), "Complete";
The Summary dialog box will pop up, and "OK" will start to create a database. After the database is established, Oracle9i's installation is completed.
Second, set users
1. Click "Start / Program / Oracle - OraHome92 / Application Development / SQL PLUS";
2. In the "User Name [U]:" and "Password [P]:" Enter the system's username and password, the default is SYSTEM and MANAGER;
3. Create a table space "Test", size 100m:
Create TableSpace "test"
Logging
DataFile 'D: /oracle/oradata/test/haig.ora' size 100m;
4. Create user "test", default table space "TEST";
Create User "Test" profile "default" identified by "test"
DEFAULT
TABLESPACE "TEST" Accent UNLOCK;
5. Grant three privileges: unlimited TableSpace, Connect, Resource; Grant Unlimited TableSpace, Connect, Resource to "Test";
6. Use the "Test" user to log in;
Connect Test / Test;
"Connected" is displayed normally, OK.
Third, create an example database
Scheduled table;
CREATE TABLE COUNT
(Num1 Number (5, 2),
Num2 Number (5, 2),
Result Number (6, 2));
2. Insert the data;
INSERT INTO COUNT (NUM1, NUM2, Result) VALUES (1, 1, 2);
INSERT INTO COUNT (Num1, Num2, Result) VALUES (1, 1, 1);
INSERT INTO COUNT (Num1, Num2, Result) Values (2, 8, 10);
Insert Into Count (Num1, Num2, Result) VALUES (68, 90, 158);
3. Submit data;
COMMIT;
The new table is established, and the data is also inserted into success.
My article is the first Auro Forum (www.newer.com.cn/bbs) and programmers forum (www.9cbs.net), welcome to reprint, but please keep the author and the name of the revision, thank you.
