Originally Posted by BoynoobNA View Post
Exit Code 0
and says Crash
Help!!
I did everything right !
I did download all files from ricks27
I did edit SERVERCONFIG and I did put 192.168.0.106(my Local Host IP).
And the Tnsnames.ora I typed 192.168.0.1 still didn't work ( I tried 192.168.0.106 too didn't work I tried even 127.0.0.1 still didn't work!! and if one of these were right which one is it?).
UPDATE!!!
THIS IS HOW MY TNSNAME.ORA looks like!
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ACCOUNT =
(DESCRIPTION =
(ADDRESS_LIST =
==>> wrong(put 127.0.0.1 too)
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.106)(PORT = 1521))
)
(CONNECT_DATA =)
(SERVICE_NAME = account)
)
)
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION =

)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
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 your name server.
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 your name server
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.
(THX TO Feldunost OriginalPost)