Net8 Configuration Assistant/ Net8 Assistant

[ngutri]

Hello everyone
Hope It is right place to ask.
I got problem with Net8 Configuration Assistant/ Net8 Assistant.
1) Install server and client Oracle8i 8.1.7.0.0 on 2 different Computer
2)Click on "SQL Plus" icon on the server and log in username:scott and password: tiger as default. It works, no problem so far.
3)I want to connect client to server. Click on "SQL Plus" icon on the client and log in username:scott and password: tiger as default AND HOST STRING:????(How can I create such string on server?)

Hope that you can understand what i mean. Thanks

 

[LKBrwnDBA]

You need to create a 'tnsnames.ora' file on your client that contains the network location of the oracle database.

Look under c:\{ORACLE_DIR}\network\admin and you will find an example of tnsnames.ora

Or...Execute the Net8 Assistant on the client

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[KenCunningham]

I've had problems executing net8 on clients (Pentium 4) without following the advice in Faq186-1124

 

[ngutri]

server side

DB01 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = win2000)(PORT = 1521))
#win2000 on server side
#when I ping win2000, it works.
)
(CONNECT_DATA =
(SERVICE_NAME = db.win2000)
#db.win2000 is correct????????
)
)
---------------------------------------------------
client side

DB01 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xp)(PORT = 1521))
#xp on client side
#when I ping xp, it works.
)
(CONNECT_DATA =
(SERVICE_NAME = db.win2000)
#db.win2000 is correct????????
)
)
-----------------------------------------
I open "SQLPlus" icon of client side to connect to server side and task in username:scott and password:tiger
host string:?????(what string should it be here?)

I think it is something wrong with SERVICE_NAME. I could not solve the problem. Please help. Thanks

 

[ngutri]

well, I got it working.

 

[KenCunningham]

Just to put the thread to bed, how?

 

[ngutri]

Just do as LKBrwnDBA (MIS)described

The client and server tnsnames.ora file are the same :

DB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = win2000)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = db.local)
)
)