| How to connect database from sql*plus with forms & How to solve ORA:12541:TNS: no listener error [message #162027] |
Wed, 08 March 2006 04:47  |
malar_dm
Messages: 31
Registered: December 2005
Location: Chennai,India
|
Member |
|
|
Hi 2 all,
I m not able to solve this problem. Can anyone knows, please help.
While connectivity of database table from sql*plus to forms.
It will not get connected.It shows error message stating
" ORA-12560:TNS:protocol adapter error".
From my knowledge, i copied the tnsnames.ora file from
D:\oracle\ora92\network\admin\tnsnames.ora - (Database)
and paste it into d2k tnsnames.ora file
D:\oracle\orad2k\network\admin\tnsnames.ora - (D2k)
save it and exit
but, the i m not able to connect the database.
username : malar
password : *****
database : (i leave it blank)
I copied the tnsnames.ora file from database and paste it into d2k.
This will be as follows:
# TNSNAMES.ORA Network Configuration File: D:\oracle\orad2k\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORACLE9I =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Local)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oracle9i)
)
)
ORACDATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = home-malar)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = Oracdata)
)
)
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = home-malar)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = [url]http://HRService[/url])
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
# TNSNAMES.ORA Network Configuration File: D:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORACDATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = home-malar)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = Oracdata)
)
)
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = home-malar)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = [url]http://HRService[/url])
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
Please reply...
Thank you
with regards
malarvannan.d
Upd-mod: Desist with all the blank lines!!
[Updated on: Mon, 13 March 2006 22:45] by Moderator Report message to a moderator |
|
|
|
|
|
| How to solve ORA:12541:TNS: no listener error? [message #162574 is a reply to message #162027] |
Sat, 11 March 2006 07:58  |
malar_dm
Messages: 31
Registered: December 2005
Location: Chennai,India
|
Member |
|
|
Hi 2 all,
I am not able to solve this error. Can anyone know please help?
ORA-12541: TNS: no listener
I herewith explain the steps that I followed while at processing.
1. I applied lsnrctl control to start the listener in command prompt.
It shows starting tnslsnr: please wait…
Service OracleOracle_d2kTNSListener already running.
TNS-12536:TNS:operation would block
TNS-12560:TNS:protocol adapter error
TNS-00506:Operation would block
32-bit windows error:997:unknown error.
2. I applied tnsping command
Used parameter files:
D:\oracle\orad2k\network\admin\sqlnet.ora
D:\oracle\orad2k\network\admin\tnsnames.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact <DESCRIPTION= <ADDRESS_LIST=<ADDRESS=<PROTOCOL=TCP> <HOST=home-malar> <PORT=1521>>> <CONNECT_DATA = <SERVER =DEDICATED> <SERVICE_NAME = oracdata>>>
TNS-12541:TNS:no listener
C:\>netstat –a
…
TCP home-malar:1521 home-malar.oracdata:0 LISTENING
…
When I applied this statement in command prompt,
C:\ TCP home-malar:1521 home-malar.oracdata:0 LISTENING
It shows error stating
‘TCP ‘ is not recognized as an internal or external command, operable program or batch file.
Please do some help.
Thanks in advance
With regards
Malarvannan.d
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
