-
Hi guys,
I just reloaded my machine with Windows NT, and created the tnsnames.ora file. When I try to login using the username/password@service_name, the sql-plus does not respond and i need to use the task manager to 'end task'.
However, when i use username/password@host_name, it connects just fine to one of the databases which is on that server(may be termed as a default service).
What is wrong and what is needed to be done to correct this?
Thanks
manjunath
-
Sorry,
there was some problem with Net* Configuration.
The problem was solved after I reconfigured the same.
manjunath
-
Did u add all the database names in TNSNAMES.ora file.if not add that
databasename.world.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ipaddress)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = databasename)
)
)
databasename2.world.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ipaddress)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = databasename2)
)
)
Also chek ur path.Go to dos prompt & type path & see what is the path set to
-
Can u tnsping the database ?
-
Hi manjunathk,
What is the version of Oracle u r using? If it is 8i what is the global database name? Place the globaldatabase name as service name. (ex: orcl.domain). It should work now.
nag
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|