re: newbie: oracle 8 netware, connect help needed

Hi Steve,

On the server side you can login with username/password and let the host-string blank. This means that oracle logs you to your default database. When you have only one database on your server machine then it is your default database.

On the client side this doesn't work because you have no default database. To get connected with the server you have to work with sqlnet or Net8i. These are the network architecture tools from oracle. The way is simple. 1. login on the server. Create a tnsnames.ora file, sqlnet.ora, listener.ora file and start the listener (for detailed info plaease see docu.).
tnsnames.ora could be like this:(The name of the host= host1, name of the instance=test)
TEST_HOST1 =
  (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = HOST1)(PORT = 1521))     )
(CONNECT_DATA = (SID = test)(SERVER = DEDICATED))
  )
2. Copy the file tnsnames.ora on your client machine.(path $Oracle_Home/network/admin. )

3. Login on client with username/password and test_host1 as service name.

Mehmet Aksar

-- 
Posted from mail.startext.de [62.159.148.202] 
via Mailgate.ORG Server - http://www.Mailgate.ORG