OraFAQ Forum: Networking and Gateways => Oracle 10g client not getting connceted to Oracle 10g database

Members

Help

Home

Home » RDBMS Server » Networking and Gateways » Oracle 10g client not getting connceted to Oracle 10g database

Show: Today's Messages :: Show Polls :: Message Navigator

E-mail to friend

Oracle 10g client not getting connceted to Oracle 10g database [message #179659]

Wed, 28 June 2006 05:57

nssubrahmanyam
Messages: 7
Registered: November 2005

Junior Member

I am facing difficulty in connecting Oracle 10g client to Oracle 10g database. Both the machines are in windows xp with service pack-2.
The following observations are made in server machine
1. The loopback test of the server is successful.
2. One net service name created in the server end.
3. Database connection is successful with above service name.
4. tnsping <server ip address> is successful

The tnsnames.ora file of the server is

# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

CONTRACT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 80.0.28.42)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = cam)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

the sqlnet.ora file of the server is

sqlnet.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\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)

SQLNET.INBOUND_CONNECT_TIMEOUT = 30

The listner.ora file of the server is

listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 80.0.28.42)(PORT = 1521))
)

When I am connecting the 10g database with 10g client I am getting ORA-12170 error.

Attempting to connect using userid: nss
The test did not succeed.
ORA-12170: TNS:Connect timeout occurred

There may be an error in the fields entered,
or the server may not be ready for a connection.

Please suggest how to configure this connectivity.

The client side tnsnames.ora file is as given below

# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

CONTRACT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 80.0.28.42)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = cam)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

The sqlnet.ora file of the client side is

sqlnet.ora Network Configuration File: C:\oracle\product\10.2.0\client_1\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)

Please help me in this connectivity

Report message to a moderator

Re: Oracle 10g client not getting connceted to Oracle 10g database [message #179680 is a reply to message #179659 ]

Wed, 28 June 2006 07:20

Mahesh Rajendran
Messages: 9610
Registered: March 2002
Location: oracleDocoVille

Senior Member

To start with, comment off all entries in sqlnet.ora and try again.
Regards~

EDIT:

Quote:

The test did not succeed.
ORA-12170: TNS:Connect timeout occurred

Read this later.

[Updated on: Wed, 28 June 2006 07:24]

Report message to a moderator

Re: Oracle 10g client not getting connceted to Oracle 10g database [message #179770 is a reply to message #179680 ]

Wed, 28 June 2006 11:50

nssubrahmanyam
Messages: 7
Registered: November 2005

Junior Member

Dear Mr Mahesh,

Thanks for the reply.

1. I am not able to access the database from the client. Now I am forced to allow the users to do the data entry only in the server machine where database resides.

2. The exact error is given below. This error is in client machine.

---------------------------------------------
Attempting to connect using userid: nss
The test did not succeed.
ORA-12170: TNS:Connect timeout occurred

There may be an error in the fields entered,
or the server may not be ready for a connection.
---------------------------------------------------

I will do the changes suggested in sqlnet.ora file. I hope you have suggested to comment off the entries in client side sqlnet.ora. Am I correct ?

With Best regards

N.S.Subrahmanyam

Report message to a moderator

Re: Oracle 10g client not getting connceted to Oracle 10g database [message #179772 is a reply to message #179770 ]

Wed, 28 June 2006 11:52

Mahesh Rajendran
Messages: 9610
Registered: March 2002
Location: oracleDocoVille

Senior Member

comment the entries in server and client side.

Report message to a moderator

Re: Oracle 10g client not getting connceted to Oracle 10g database [message #179843 is a reply to message #179772 ]

Thu, 29 June 2006 00:56

nssubrahmanyam
Messages: 7
Registered: November 2005

Junior Member

Dear Mahesh,

I have commennted off both sqlnet.ora files and tried.

I have pur "/*" at starting of sqlnet.ora file script and "*/" at the end of the script. This is what I understood by commenting off. Is this OK?

I am getting the same error while connecting through net manager from client side

----------------------------------------------
Attempting to connect using userid: nss
The test did not succeed.
ORA-12170: TNS:Connect timeout occurred

There may be an error in the fields entered,
or the server may not be ready for a connection.

----------------------------------------------------

I also tried from command prompt of client machine to connect. The errors are provided in the attachment file. Even telnet (host ip address) from command prompt is also not working.

Both server and client are win xp service pack-2 with fire wall on. Do I need to change anything there ?

N.S.Subrahmanyam

Attachment: command prompt errors.JPG
(Size: 43.09KB, Downloaded 223 time(s))

Report message to a moderator

Re: Oracle 10g client not getting connceted to Oracle 10g database [message #179904 is a reply to message #179843 ]

Thu, 29 June 2006 04:50

Mahesh Rajendran
Messages: 9610
Registered: March 2002
Location: oracleDocoVille

Senior Member

>> I have pur "/*" at starting of sqlnet.ora file script and "*/" at the end of the script. This is what I understood by commenting off. Is this OK?
Not OK.
It is already explained in the file.

#sqlnet.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\sqlnet.ora
# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to

Use #

Report message to a moderator

Re: Oracle 10g client not getting connceted to Oracle 10g database [message #180021 is a reply to message #179904 ]

Thu, 29 June 2006 18:26

nssubrahmanyam
Messages: 7
Registered: November 2005

Junior Member

Dear Mahesh,

I have edited the sqlnet.ora file at both client and server side as suggested by you. I got the following error when connected from client through net manager.
-------------------------------------------------
Attempting to connect using userid: nss
The test did not succeed.
ORA-12170: TNS:Connect timeout occurred

There may be an error in the fields entered,
or the server may not be ready for a connection.
-------------------------------------------------------

The tnsping from command prompt gives TNS-12535 timeout error. Pls see the attachment.

I also checked up the sqlnet.log file of client which registered the following.

--------------------------------------------------------------
Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
Time: 30-JUN-2006 04:31:42
Tracing not turned on.
Tns error struct:
ns main err code: 12535
TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505
TNS-00505: Operation timed out
nt secondary err code: 60
nt OS err code: 0
Client address: <unknown>
----------------------------------------------------------------

Please suggest me the next course of action.

N.S.Subrahmanyam

Attachment: command prompt errors.JPG
(Size: 46.63KB, Downloaded 241 time(s))

[Updated on: Thu, 29 June 2006 18:30]

Report message to a moderator

Re: Oracle 10g client not getting connceted to Oracle 10g database [message #180023 is a reply to message #179659 ]

Thu, 29 June 2006 19:40

anacedent
Messages: 7061
Registered: July 2005
Location: +32° 58' 41.00"N -1...

Senior Member

As a shot in the dark, comment out the following line
#SQLNET.AUTHENTICATION_SERVICES= (NTS)
and stop & start the listener

Report message to a moderator

Re: Oracle 10g client not getting connceted to Oracle 10g database [message #180041 is a reply to message #180023 ]

Thu, 29 June 2006 22:48

nssubrahmanyam
Messages: 7
Registered: November 2005

Junior Member

Dear Anacedent ,

i have done as suggested by you. But the problem remained. Fianlly I could locate that the windows firewall of server could be the problem. I turned off the firewall and connected successfully without making any changes to sqlnet.ora or tnsnames.ora.

I know that turning off the firewall is not advisable. Can you suggest me how to configure firewall (win xp) for receiving oracle 10g client.

I have added one port in exceptions tab of windows firewall with some name (Oracle 10g port or so) and declared the port number as 1521 (defualt in our case). In the scope button i have given the ip addresses of the client with subnet mask ( ip address / subnet mask) and saved the configuration. Now it is working fine.

If you have any other good alternative to what I have done, please let me know.

Thanks for the support given to me throughout in this forum. This is my first interaction in Oracle forum and I appreciate the professional support you extent to new users like me.

N.S.Subrahmanyam

[Updated on: Fri, 30 June 2006 00:26]

Report message to a moderator

Re: Oracle 10g client not getting connceted to Oracle 10g database [message #180042 is a reply to message #179904 ]

Thu, 29 June 2006 22:52

nssubrahmanyam
Messages: 7
Registered: November 2005

Junior Member

Dear Mahesh ,

I have done as suggested by you. But the problem remained. I sent one reply in the morning. This is my second reply to your suggestion. I went on with finding other probabilities.

Fianlly I could locate that the windows firewall of server could be the problem. I turned off the firewall and connected successfully without making any changes to sqlnet.ora or tnsnames.ora.

I know that turning off the firewall is not advisable. Can you suggest me how to configure firewall (win xp) for receiving oracle 10g client.

I have added one port in exceptions tab of windows firewall with some name (Oracle 10g port or so) and declared the port number as 1521 (defualt in our case). In the scope button i have given the ip addresses of the client with subnet mask ( ip address / subnet mask) and saved the configuration. Now it is working fine.

If you have any other good alternative to what I have done, please let me know.

Thanks for the support given to me throughout in this forum. This is my first interaction in Oracle forum and I appreciate the professional support you extent to new users like me.

I will always remember a gentleman called Mahesh Rajendran.

Thanks a lot

N.S.Subrahmanyam

[Updated on: Fri, 30 June 2006 00:24]

Report message to a moderator

Re: Oracle 10g client not getting connceted to Oracle 10g database [message #180125 is a reply to message #180042 ]

Fri, 30 June 2006 04:07

Mahesh Rajendran
Messages: 9610
Registered: March 2002
Location: oracleDocoVille

Senior Member

Ah!. Firewall.
The standard workaround for that is make the registry settting use_shared_socket=TRUE.

Report message to a moderator

Re: Oracle 10g client not getting connceted to Oracle 10g database [message #180137 is a reply to message #180125 ]

Fri, 30 June 2006 05:25

nssubrahmanyam
Messages: 7
Registered: November 2005

Junior Member

Thanks. Noted the details

N.S.Subrahmanyam

Report message to a moderator

Previous Topic:	Connecting Two Server using a Client Machine
Next Topic:	ORA-12505: TNS:listener does not currently know of SID given in connect des

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jul 4 11:18:08 CDT 2009

Total time taken to generate the page: 0.02020 seconds

.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.