Softwares used and approved : [Windows XP isn't the same way)
Install the following there:
Windows 2003 x86 Enterprise Edition R2 SP2
Oracle9i version
Navicat Premium (Recommended for easiest modifications)
Java JDK (It installs automatically JRE)
Visual C++ redistributable 2008 x86
Visual C++ redistributable 2010 x86
Visual C++ Express 2010 (It will install .NET Framework 4.0)
Download any old server files available with password if told:
Download Celestia Update Server Files
1: Oracle Installation
Available Products
Full installation of the first selection
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: (Copy theses files before on C:\)
@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 with :
Username: alef
Password: password
SID: account
Change thoses attributes for SERVERCONFIG table:
Section 1 and 201, WORLD attribute is Grayheon.
Section 1 and 201 and 401, ADDRESS attribute is not 127.0.0.1 but the ip adress of the server.
Section 1000, ADDRESS attribute is 127.0.0.1:99999
All sections, DBUSER + LOGDBUSER attribute is alef
All sections, DBPWD + LOGDBPWD attribute is password
All sections, DBDSN + LOGDBDSN attribute is account
Change thoses attributes for RPGWT table:
All SERVERID, change it to Grayheon.
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)
)
)
DON'T FORGET TO ERASE DEDICATED SERVER LINE ! (Not on Windows XP)
For INST1_HTTP specify host for 127.0.0.1 ! In TNSNAMES.ORA also.
Removed the entire INI folder and replaced INI folder from Update Celestia files.
Changed INI/DatabaseInit/Database.ini (user: alef, password is password, SID is account)
Changed INI/DatabaseInit/DBSERVERINFO.ini (user: alef, password is password, SID is account)
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. (Can be also Chinese Taiwan)
Account creation: (It can be added manually with Navicat easily)
Connect to SQL Plus with alef user and write the following:
Insert into ALEF.AMT_ACCOUNT (ACCOUNTID,PASSWORD) values ('minera','test');
Insert into ALEF.AMT_MASTER (ACCOUNTID,EMAIL,SOCIALNO,CREATION_DATE,LAST_DATE, MODIFY_DATE,PHONE,MOBILE,ZIPCODE,ADDR1,ADDR2,SMS_Y N,EMAIL_YN,PENALTY_GBN,PAUSE_DATE,IP,LOGINCNT,NOMI NATOR,RPG_LEVEL,LONEY_AGREEYN,LONEY_CHARGEYN,SEX) values ('minera','
','18',to_timestamp('26/01/11','DD/MM/RR HH24:MI:SSXFF'),to_timestamp('26/01/11','DD/MM/RR HH24:MI:SSXFF'),to_timestamp('26/01/11','DD/MM/RR HH24:MI:SSXFF'),null,null,null,null,null,'N','N',' 0',null,null,null,null,null,null,null,null);
Start CAL_LoginServer.exe, wait until it finishes.
Start CAL_RelayServer.exe, wait until it finishes.
Start CAL_WorldServer.exe, wait until it finishes.
Wait 2 minutes after launching in order to allow sockets and communication between them.
Go to archlord folder, in my case it's : C:\Program Files (x86)\F-Archlord
Create text file and add: alefclient.exe /L192.168.1.xxx:11002 (ip adress of the server in LAN)
Rename it in .bat, make shortcut in desktop and launch !
YOU MUST HAVE THE CORRECT CLIENT !
If you need really help, call me
For Windows XP it is almost the same way but i kept on Server 2003 for most stability.
Create your own Private Server Tutorial.
