OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » oracle connection (windows xp)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

oracle connection [message #449837]

Thu, 01 April 2010 05:31

zdig10
Messages: 2
Registered: April 2010

Junior Member

Hello everyone;
I apologize if this problem has been discussed already but I am really a beginner and my problem has persisted for a long time:
My database is oracle 10g I created (the database was really created by default during installation) a base whose SID is "orcl". She is on a remote database server data (Windows). I checked the file tnsnames. ora file listener.ora file sql.ora but the connection does not work with oracle sql I develop on my machine oracle client is installed. is there any recommendations to check a file changes ...
Thank you it is very urgent

Report message to a moderator

Re: oracle connection [message #449842 is a reply to message #449837]

Thu, 01 April 2010 06:38

Michel Cadot
Messages: 54167
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Check if your server is on.

Seriously, do you think we can know what is wrong without having any information?
What is your error?
What do you see?

Regards
Michel

Report message to a moderator

Re: oracle connection [message #449855 is a reply to message #449837]

Thu, 01 April 2010 08:46

zdig10
Messages: 2
Registered: April 2010

Junior Member

ok my friend You Have Reason. I described the condition: I work with a pc in which Oracle client(10g) is installed, operating system windows xp sp2 . the oracle server is installed on a server remote database with the operating system is Windows Server 2008. this server belongs to a domain. I try to connect to the Oracle database located on the server. For this I made 2 methods:
1 - I try to connect to oracle using oracle sql developer but even by providing the connection parameters login password username, SID,IP there is an error message: "Exception I / O: the network adapter could not establish the connection "
2-I tried to get connected through a vb.net application that I used to connect to a local oracle database here is the error message: "ORA-12170:
TNS: Connect timeout occurred "

Here is my problem. is that there's other information I have provided?
Note well: I tried to connect from a PC in the same domain and another not belonging but the same problem.
Thank you.

Report message to a moderator

Re: oracle connection [message #450035 is a reply to message #449855]

Sat, 03 April 2010 22:52

BlackSwan
Messages: 20097
Registered: January 2009

Senior Member

From WINDOWS database server system CUT commands below & PASTE into terminal window:

SET
type %ORACLE_HOME%\network\admin\listener.ora
type %ORACLE_HOME%\network\admin\tnsnames.ora
lsnrctl status
lsnrctl service
sqlplus
/ as sysdba
select * from v$version;
exit

CUT results from commands above & PASTE all back here

CUT & PASTE from command line on database server showing that you can successfully connect to instance on DB Server via SQL*Net

Report message to a moderator

Previous Topic:	TNS checksum 0x0000. Is it normal?
Next Topic:	connect remote database without providing SID

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 21 17:09:00 CDT 2013

Total time taken to generate the page: 1.05067 seconds