How to connect database from sql*plus to forms? [message #164054] |
Tue, 21 March 2006 08:57 |
malar_dm
Messages: 31 Registered: December 2005 Location: Chennai,India
|
Member |
|
|
Hi 2 all,
This is very urgent… please help?
I m not able to connect database from sql*plus to forms.
While input the data as
username : malar
password : ****
database : oracdata
It shows error message stating "ORA - 12541 : TNS:no listener"
From my knowledge, I copied the tnsnames.ora file from database and paste it below the tnsnames.ora file of forms. I followed two steps. This will be as follows:
Step 1:
# 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 = http://HRService)
)
)
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 = http://HRService)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
Step :2
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. It shows
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
3. I applied this command in command prompt.
C:\>netstat –a
…
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 help…
Thanks in advance
With regards
Malar
|
|
|
|
Re: How to connect database from sql*plus to forms? [message #164785 is a reply to message #164145] |
Sun, 26 March 2006 03:44 |
malar_dm
Messages: 31 Registered: December 2005 Location: Chennai,India
|
Member |
|
|
hi littlefoot,
Thanks for ur reply. I followed ur method i.e Coping sqlnet.ora and listener.ora file and paste it into tnsnames.ora file.
But, still it will not get connected.It shows error msg stating "ORA - 12541 : TNS:no listener".
Please help, i m not able 2 solve this problem.
It's very urgent.
Thanks in advance
malar.
|
|
|
|
|
|
Re: How to connect database from sql*plus to forms? [message #166094 is a reply to message #164790] |
Tue, 04 April 2006 08:50 |
malar_dm
Messages: 31 Registered: December 2005 Location: Chennai,India
|
Member |
|
|
Hi
I m not solve this problem. I just explain the steps that I followed. pls do some needful.
The data’s contained in sqlnet.ora and listener.ora file in database is same as the data contained in sqlnet.ora and listener.ora in d2k.
So, I just copied the data’s contained in tnsnames.ora file in database and paste it below tnsnames.ora in d2k.
But it will not work.
I start the listener control in command prompt. It shows;
Oracle oracled2k: TNS listener already running.
TNS: 12536: TNS: Operation would block
TNS: 12560: TNS: protocol adopter error
TNS: 00506: Operation would block.
32 bit windows error: 997: unknown error.
I am not solve this problem.
Please help…
very urgent...
Thanks in advance
malar.
|
|
|
|
|
Re: How to connect database from sql*plus to forms? [message #166740 is a reply to message #164790] |
Sat, 08 April 2006 00:30 |
malar_dm
Messages: 31 Registered: December 2005 Location: Chennai,India
|
Member |
|
|
Hi
I m not solve this listener protocal error. Can u please help me.
I start the listener control in command prompt. It shows;
Oracle oracled2k: TNS listener already running.
TNS: 12536: TNS: Operation would block
TNS: 12560: TNS: protocol adopter error
TNS: 00506: Operation would block.
32 bit windows error: 997: unknown error.
I am not solve this problem.
Please help…
very urgent...
Thanks in advance
malar.
|
|
|
|