| arun |
Posted: Dec 19, 2007 01:50:54 AM |
Total Post: 28
Joined: Sep, 2007
|
Oracle 9i on Redhat Linux 9
This is my problem
I am unable to connect to the instance
by username/password@connection_string
But It works with username/password
|
|
|
 Ratnaker |
| Posted: Dec 19, 2007 07:58:07 AM |  |
|
Total Post: 136
Joined: Apr, 2007
|
Hi
You need to configure Oracle Net service then it will work.
|
|
|
|
|
| arun |
| Posted: Dec 19, 2007 12:09:55 PM | |
|
Total Post: 28
Joined: Sep, 2007
|
|
|
|
|
| arun |
| Posted: Dec 19, 2007 12:11:59 PM | |
|
Total Post: 28
Joined: Sep, 2007
|
TNSNAMES.ORA :
ARUN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = arun)
)
)
SQLNET.ORA :
NAMES.DIRECTORY_PATH = (TNSNAMES, HOSTNAME)
|
|
|
|
|
| Soumya |
| Posted: Dec 20, 2007 03:18:43 AM | |
|
Total Post: 56
Joined: Mar, 2006
|
Hi,
You can do following :
1) put HOST value as the ip addres or the hostname .
2) check in the database the value of " show parameter service "
and put that value.
3) or use the SID parameter with its value.
Hope this helps...
|
|
|
|
|
| arun |
| Posted: Dec 21, 2007 03:49:28 AM | |
|
Total Post: 28
Joined: Sep, 2007
|
Thank for ur reply.
Actually problem is with TNSNAMES.ORA
The file was moved from WINDOWS SYSTEM TO LINUX Server.
I created a new TNSNAMES.ORA file at linux server.
Now the problem was solved.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
