hey guys look here..a chinese tutorial:
Software requirements:
Windows2003 x64 Enterprise Edition
Oracle9i version
1: Oracle Installation
File Location
Location bar to choose the path, due to the huge database, please install a partition in the large space inside
Available Products
Full installation of the first election
Installation Type
Select Enterprise
Database Configuration
General election
Mts recovery service configuration
Select the default port 2030
Database ID
Global database name account
Sid account
Location of database files
Choose
Database character set
Use the default character set
--- Start the installation
Set sys password and system password
Restart the machine end of the installation
Open
-------------------------------------------------- ---------------
Start SQLPLUS, enter the following command
- Create User
create user alef IDENTIFIED BY password;
Set role permissions
- Grant / Revoke role privileges
grant connect to alef;
grant resource to alef;
- Grant / Revoke system privileges
grant alter session to alef;
grant create cluster to alef;
grant create database link to alef;
grant create sequence to alef;
grant create session to alef;
grant create synonym to alef;
grant create table to alef;
grant create view to alef;
grant dba to alef;
Import Database
SQLPLUS to run
@ D: \ sql \ account.sql; \ \ path to your right can be a SQL
A total of three libraries, finished a guide, the other two with SQLPLUS imported.
After the change SERVERCONFIG guide database server table name, password. IP address for your server IP!
Oracle 9i client installation client, the election administrator that. Bahrain the following content into the database and the client installation directory under the installation directory file path is D: \ oracle \ ora92 \ network \ admin \ tnsnames.ora, change the following!
# TNSNAMES.ORA Network Configuration File: D: \ oracle \ ora92 \ NETWORK \ ADMIN \ tnsnames.ora
# Generated by Oracle configuration tools.
ACCOUNT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.88) (PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = account)
)
)
You can start the server. New shortcut to the client, start the parameter bit / L192.168.1.200: 11002