This is all that i have done:
Softwares used:
Windows2003 x86 Enterprise Edition R2 SP2
Oracle9i version
1: Oracle Installation
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 SQL Plus in:
All programs => Oracle -OraHome92 => Application Development => SQL Plus
Username: SYSTEM
Password: password
SID: account
Press OK.
Copy SQL files on C:\ (download it at the first post)
Modify RPGWT.sql: change all names rpgwt by RPGWT
Modify SERVERCONFIG.sql: change all names serverconfig by SERVERCONFIG
Write on SQL Plus:
create user alef IDENTIFIED BY password;
grant connect to alef;
grant resource to alef;
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;
exit;
Re-open SQL Plus but with:
Username: alef
Password: password
SID: account
Write still on SQL Plus:
@C:\ACCOUNT.sql;
@C:\RPGWT.sql;
@C:\SERVERCONFIG.sql;
exit;
Use Navicat:
Specify in Tools => Options => OCI => Oci library: C:\oracle\ora92\bin\oci.dll
Create connection and change ip adress for Serverconfig table: not 127.0.0.1 but the ip of the computer. (execute cmd.exe and type ipconfig.
I changed name WORLD of the 1 and 201 section by Grayheon, changed also in RPGWT table SERVERID by Grayheon (all SERVERID)
I changed all null cases (alef - password - account - alef - password - account) in SERVERCONFIG table for: DBUSER, DBPWD, DBDSN, LOGDBUSER, LOGDBPWD, LOGDBDSN)
Changed that file:
C: \ oracle \ ora92 \ network \ admin \ tnsnames.ora.
# 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 = 127.0.0.1) (PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = account)
)
)
Removed the INI folder and replaced INI folder from Update Celestia files.
Changed INI/DatabaseInit/Database.ini
Changed INI/DatabaseInit/DBSERVERINFO.ini
Changed in Configuration panel of windows: Regional and linguistic Options, i added in Languages languages for complex scripts and languages for oriental country.
In advanced options, i changed non-unicode programs language: Chinese Republic popular language.
You can start the server. New shortcut to the client, start the parameter bit / L192.168.1.200: 11002
Don't forget to disable firewall of windows for the testing purpose !
