|
|
|
|
| Re: TNS operation timed out [message #129691 is a reply to message #129347] |
Tue, 26 July 2005 05:04   |
Achchan
Messages: 86
Registered: June 2005
|
Member |
|
|
You have only one database with probabely one database_service on your machine,So why do you want to use service_name as connection identifier?
If this is just didactic so go to tnsnames.ora and set service_name parameter.It is by default your global_database name.
-Let me know what heppens
|
|
|
|
| Re: TNS operation timed out [message #130005 is a reply to message #129691] |
Wed, 27 July 2005 11:40 |
oracle_techie
Messages: 24
Registered: July 2005
Location: Munbai
|
Junior Member |
|
|
I already have specified service name, pl suggest any solution.
I am sending you TNSNAME.ora FILE
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
OEMREP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = zen)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = OEMREP)
)
)
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = zen)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
ZEN1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = zen)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = zen1)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
ZEN_ZEN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ZEN)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ZEN)
(SERVER = DEDICATED)
)
)
ZEN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = zen)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = zen)
)
)
SAMEER =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = zen)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(Key = zen))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SAMEER)
)
)
MYDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = zen)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mydb)
)
)
-----------------------------------
Following is listener.ora file
# LISTENER.ORA Network Configuration File: C:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.
STARTUP_WAIT_TIME_LISTENER = 60
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = zen)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = zen)
(ORACLE_HOME = C:\oracle\ora92)
(SID_NAME = zen)
)
(SID_DESC =
(GLOBAL_DBNAME = mydb)
(ORACLE_HOME = C:\oracle\ora92)
(SID_NAME = mydb)
)
(SID_DESC =
(GLOBAL_DBNAME = zen1)
(ORACLE_HOME = C:\oracle\ora92)
(SID_NAME = zen1)
)
)
TRACE_LEVEL_LISTENER = USER
-----
|
|
|
|
|
|
 Can connect as Scott/tiger, but not as Scott/tiger@zen1 [message #130188 is a reply to message #129343] |
Thu, 28 July 2005 11:47 |
oracle_techie
Messages: 24
Registered: July 2005
Location: Munbai
|
Junior Member |
|
|
system : Oracle 9.2i on XP
Please suggest some solution.
SQL> Connect scott
Enter password: *****
Connected.
SQL> Connect scott@zen1
Enter password: *****
ERROR:
ORA-12535: TNSperation timed out
following are TNSNAMES.ORA & Listener.ora files
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
OEMREP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = zen)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = OEMREP)
)
)
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = zen)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
ZEN1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = zen)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = zen1)
)
)
# LISTENER.ORA Network Configuration File: C:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.
STARTUP_WAIT_TIME_LISTENER = 60
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = zen)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = zen)
(ORACLE_HOME = C:\oracle\ora92)
(SID_NAME = zen)
)
(SID_DESC =
(GLOBAL_DBNAME = mydb)
(ORACLE_HOME = C:\oracle\ora92)
(SID_NAME = mydb)
)
(SID_DESC =
(GLOBAL_DBNAME = zen1)
(ORACLE_HOME = C:\oracle\ora92)
(SID_NAME = zen1)
)
)
TRACE_LEVEL_LISTENER = USER
[Updated on: Thu, 28 July 2005 22:06] Report message to a moderator |
|
|
|
|
|
| Re: Can connect as Scott/tiger, but not as Scott/tiger@zen [message #130237 is a reply to message #130192] |
Thu, 28 July 2005 22:10 |
oracle_techie
Messages: 24
Registered: July 2005
Location: Munbai
|
Junior Member |
|
|
sending portion of tnsnames.ora file with Ip address specified
Still it is not working. Pl give solution.
ZEN1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 169.254.126.11)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = zen1)
)
)
Also sending SQLNEt.ora
# SQLNET.ORA Network Configuration File: C:\oracle\ora92\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NONE)
NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME, ONAMES)
|
|
|
|
|
|
|
|
|
|
| Re: Can connect as Scott/tiger, but not as Scott/tiger@zen [message #130408 is a reply to message #130386] |
Fri, 29 July 2005 16:46 |
 |
Barbara Boehmer
Messages: 9102
Registered: November 2002
Location: California, USA
|
Senior Member |
|
|
The full text of your error message is:
"TNS:operation timed out
Cause: The requested connection could not be completed within the timeout period specified by the CONNECT_TIMEOUT parameter in LISTENER.ORA. This error arises from the TNSLSNR.
Action: Either reconfigure CONNECT_TIMEOUT to be 0, which means wait indefinitely, or reconfigure CONNECT_TIMEOUT to be some higher value. Or, if the timeout is unacceptably long, turn on tracing for further information."
What this means is that it did not have enough time to do what it needed to do to complete the connection. It could just need more time or it could be that there is something else wrong and no matter how much time you give it, it will not be able to complete it. It is best to see if more time helps first, then if not, diagnose the additional problem. In order to check for a time problem, you can make the process faster, by shutting down everything else first and doing things like using the i.p. address, as already suggested by others, and you can also increase the time alotted. I do not recommend setting the time to 0, because you could end up with something hung, then have to figure out how to terminate it, and just have another problem to deal with. I am also running Oracle 9i on Windows XP and used to get that error frequently, if I had other things running and tried to use a full connect string, which takes longer to validate. I solved the problem, by changing the connect_timeout parameter to 30 seconds. Since you have not already set the parameter, the default is 10 seconds, which is not long enough for windows (or windoze as some like to call it).
So, I suggest that you add a line at the bottom of your listener.ora file that says, "CONNECT_TIMEOUT_LISTENER=30" to increase the time from 10 seconds to 30 seconds or use a larger number, depending on how long you want to wait to ensure that the time limit is not the problem, then restart your computer, for the parameter to take effect. Then try connecting again. If you still have problems, then you will need to do some further diagnosis. You might check task manager, look in processes, and scroll down to system idle process. If the system idle process CPU is not in the 90's when your computer is not doing anything else, then you need to find out what is hogging the CPU time. You might, for example download something like spybot or adaware to find and remove spyware. If that is not the problem, then you will need to do further diagnostics and see what is wrong with your Oracle setup.
|
|
|
|
| Re: Can connect as Scott/tiger, but not as Scott/tiger@zen [message #130427 is a reply to message #130386] |
Sat, 30 July 2005 03:52 |
Achchan
Messages: 86
Registered: June 2005
|
Member |
|
|
Why do you repeat same thing oracle_techie? All people here trying to help you so instead of posting more and more "TNS: operation timed out" and "No solution yet" try to be calm and helpful.
Here is not some kind of your school that when you ask something,teacher should answer it immediately.You are going to be professional so learn professional tacts too.
|
|
|
|
|
|
| Re: Can connect as Scott/tiger, but not as Scott/tiger@zen [message #130462 is a reply to message #130450] |
Sun, 31 July 2005 00:39 |
Achchan
Messages: 86
Registered: June 2005
|
Member |
|
|
Hi,
Do you use firewall on your system? If so you may need to exclude port 1521 from port list.
One other thing: set CONNECT_TIMEOUT_LISTENER to 0 so it will wait infinitely and also go to c:\windows\system32\drivers\etc and find a file called HOSTS or LMHOSTS. add this line there and save:
<your_machine_IP> zen
If you are local then maybe 127.0.0.1 zen also should be added.
And finally: Are you on a DHCP network?
If any did not help so set trace_level of listener in ADMIN level and send us your trace files.
-Good luck!
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Can connect as Scott/tiger, but not as Scott/tiger@zen [message #131880 is a reply to message #131159] |
Tue, 09 August 2005 22:30 |
oracle_techie
Messages: 24
Registered: July 2005
Location: Munbai
|
Junior Member |
|
|
As suggested by someone I tried nslookup.
nslookup zen and nslookup <ip address> did not work giving output,
How to fix it?
C:\DOCUME~1\ZHA>nslookup zen
DNS request timed out.
timeout was 2 seconds.
*** Can't find server name for address 169.254.125.34: Timed out
*** Default servers are not available
Server: UnKnown
Address: 169.254.125.34
DNS request timed out.
timeout was 2 seconds.
*** Request to UnKnown timed-ou
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
