| how to connect database through toad [message #179587] |
Wed, 28 June 2006 02:35  |
tushar_spatil
Messages: 12
Registered: June 2006
Location: mumbai
|
Junior Member |
|
|
hi to all,
i have one proble when i m connecting to my database through
toad
it give me following error
"ora:12542 connection failed target host or object is not present"
my tnsname.ora file is as follows
# TNSNAMES.ORA Network Configuration File: F:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
STRATE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = admin)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = sample)
)
)
SAMPLE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = admin)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = sample)
)
)
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = admin)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = Ro)
)
)
currently i m working on 'sample' database
can one explain me how to use toad
regards
tushar(jr DBA)
|
|
|
|
| Re: how to connect database through toad [message #179600 is a reply to message #179587] |
Wed, 28 June 2006 03:06  |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
Are you sure that's the error you're getting?
ORA-12542 has the text TNS:address already in use ad is returned when trying to start a listener.
Debug 101:
Is the database up?
Is the listener running?
Can you connect to the database from SQL*Plus using the same connection details?
|
|
|
|
|
|
| Re: how to connect database through toad [message #179612 is a reply to message #179609] |
Wed, 28 June 2006 03:51 |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
If you can connect to the Db through sqlplus then the answer is 'YES'
To check the listener status, from the command prompt:
H:\>lsnrctl status
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 28-JUN-2006 09:51:53
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
Start Date 20-JUN-2006 11:57:41
Uptime 7 days 21 hr. 54 min. 14 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\oracle\product\10.2.0\db_1\network\admin\listener.ora
Listener Log File D:\oracle\product\10.2.0\db_1\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=noneofyourbusiness.net)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
So, what was the error message you were getting?
|
|
|
|
|
|
| Re: how to connect database through toad [message #179615 is a reply to message #179614] |
Wed, 28 June 2006 04:10 |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
Ok, DBA 101:
If you created your DB properly, there should be a file LISTENER.ORA in the same directory as your TNSNAMES.ORA
If this is the case, you should be able to use the command
to fire up the listener.
If that doesnt' work, or the file isn't there, you'll need to use the Net COnfiguration Assistant (supplied with the install) to set one up.
|
|
|
|
|
|
|
|
|
|
| Re: how to connect database through toad [message #179640 is a reply to message #179635] |
Wed, 28 June 2006 05:04 |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
Check the HOST is correct.
You should be able to go to the command prompt and type
and get a non-error response back.
If you don't, then the value of HOST that you're using is probably incorrect.
Check the listener.log file for errors too.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: how to connect database through toad [message #179674 is a reply to message #179660] |
Wed, 28 June 2006 06:49 |
tushar_spatil
Messages: 12
Registered: June 2006
Location: mumbai
|
Junior Member |
|
|
hi
I am really sorry for that language.
I just change host=IP address as shown below
here is my tnsnamefile# TNSNAMES.ORA Network Configuration File: F:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
STRATE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =
192.168.15.250)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = sample)
)
)
SAMPLE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =
192.168.15.250)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = sample)
)
)
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =
192.168.15.250)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
ans still I get that problem
regards
tushar
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
