| shipon |
Posted: May 15, 2008 06:29:58 AM |
Total Post: 27
Joined: Feb, 2008
|
Dear Friends ,
I have to install Oracle10g in my windows 2003 server .
The problem is , I cannot connect to my production server (AIX server with Oracle 10g) . When I get connected then it shows thw follwoing error :
SQL> conn branchdb/branchdb@ababil2
ERROR:
ORA-12541: TNS:no listener
But from all other pcs' I can connect it smoothly . I dont understand is it O/S problem or Database problem . Have anybody give me any idea about this ?
Here is my three files :
1)sqlnet.ora :
# sqlnet.ora Network Configuration File: C:\oracle\product\10.2.0\db_2\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
2)tnsnames.ora
# tnsnames.ora Network Configuration File: D:\oracle\product\10.1.0\Db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ABABIL2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.12)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ababil2)
)
)
Here 192.168.1.12 is my production server IP ..
Waiting for ur quick reply .. .. |
|
|
 GOPU |
| Posted: May 15, 2008 06:37:04 AM |  |
|
Total Post: 239
Joined: Apr, 2008
|
ORA-12541: TNS:no listener
It means that the listner is not up.Can you able to ping to the sever from the system you are trying.?
Check the network cables also... :)
|
|
|
|
|
| shipon |
| Posted: May 15, 2008 06:58:09 AM | |
|
Total Post: 27
Joined: Feb, 2008
|
Thx GOPU ,
Yea I can ping the production server from my wondows serevr (from the system I am trying.?) But When I do 'tnsping' then it shows the above error .
|
|
|
|
|
| Murtuja |
| Posted: May 15, 2008 07:21:13 AM | |
|
Total Post: 814
Joined: Jan, 2006
|
Hi,
run this command
sql> alter system register;
|
|
|
|
|
| GOPU |
| Posted: May 15, 2008 07:27:50 AM | |
|
Total Post: 239
Joined: Apr, 2008
|
Then you have problems with your files.Check the tnsnames.ora file and the listner....Once more
|
|
|
|
|
| Gitesh |
| Posted: May 15, 2008 11:18:29 PM | |
|
Total Post: 322
Joined: May, 2005
|
check service_name and port no of listener.ora.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
