| Instalation problem [message #51495] |
Sun, 26 May 2002 19:29  |
Ananth K.T
Messages: 5
Registered: May 2002
|
Junior Member |
|
|
Hai ,
I try to install oracle 8i client on windows98 machine.After instalation i can't enter into oracle and receive the error 'TNS:could not resolve service name' .I'm trobled with net8 configuration when it asks for service name which should same as global database name.But i don't know what is global database name.
Help me how to configure and which files(tnsnames.ora,listener.ora) should be modifieed and how.
Please look forward about it.
Thanking u all.
Ananth K.T
|
|
|
|
| Re: Instalation problem [message #51510 is a reply to message #51495] |
Mon, 27 May 2002 22:26  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
hello!
its good to have service name same as database name.
I do that personally!. But it is NOT a MUST.
have a look on the following sample entry from tnsnames.ora
*******************************************************
MYSERVICE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.133.20.14)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = high9i)
)
)
*******************************************************
where,
myservice = the hostring/serivice name which we use for during the login..ie..username/passcode@hostring;
HOST = IP number of the machine where database is installed. you can also give the machine name.
PORT = 1521 is the default port for oracle.
SERVICE_NAME= High9i is database name.
thus, this service name is an aggregation of databasename+machinename+portnumber.
so you can configure it as shown above. you can directly edit tnsnames.ora or use net8 configuration assistent(gui).
now consider these two entries in tnsnames.ora.
here two net serviceNames are configured, MYSERVICE (service_name not equal to database_name) and HIGH9i
(service_name equal to database_name). But both point to the same database.
MYSERVICE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.133.20.14)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = high9i)
)
)
HIGH9I =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.27)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = high9i)
)
)
SQL> connect mag/mag@high9i
Connected.
SQL> select name from v$database;
NAME
---------
HIGH9I
SQL> connect mag/mag@myservice
Connected.
SQL> select name from v$database;
NAME
---------
HIGH9I
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
