OraFAQ Forum: Networking and Gateways » change network configurations after installing db & dev suite

Home » RDBMS Server » Networking and Gateways » change network configurations after installing db & dev suite (oracle db 10.2.0,dev suite 10.1.0.4.2,windows xp professional)

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

change network configurations after installing db & dev suite [message #377175]

Sun, 21 December 2008 05:41

merhanatef
Messages: 28
Registered: September 2008

Junior Member

after installing database & dev suite , once a new network card is installed & the connection is enabled , i'm not able to run reports with the following error:
rep501-Unable to connect to the specified database.
what can i do to change the network configuration after installation?

Report message to a moderator

Re: change network configurations after installing db & dev suite [message #377181 is a reply to message #377175]

Sun, 21 December 2008 07:12

Frank Naude
Messages: 4581
Registered: April 1998

Senior Member

Well, have you done at least some basic troubleshooting? Can you ping the db server? Is the listener running? Can you tnsping the database? Can you connect with any other product (like sqlplus)? Etc.

Report message to a moderator

Re: change network configurations after installing db & dev suite [message #377182 is a reply to message #377175]

Sun, 21 December 2008 07:24

merhanatef
Messages: 28
Registered: September 2008

Junior Member

thank you for replying..
i can ping the database , all the net services in the tnsnames.ora are working fine when tested ,the listener is up ,i can start sqlplus ,i start my application as well, the only problem is with the reports

Report message to a moderator

Re: change network configurations after installing db & dev suite [message #377194 is a reply to message #377182]

Sun, 21 December 2008 10:19

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I'd say that SQL*Plus uses TNSNAMES.ORA which belongs to ORACLE_DATABASE_HOME\NETWORK\ADMIN directory; on the other hand, Reports use its own ORACLE_DEVELOPER_SUITE_HOME\NETWORK\ADMIN\TNSNAMES.ORA which does not contain alias of the database you'd like to connect to.

There've been many discussions about the issue; you might search for them here or on the Internet. However, perhaps you'd be interested in using the TNS_ADMIN environment variable. If so, check this recent OraFAQ Forum topic.

If you still have problems, I guess we'll hear from you soon.

Report message to a moderator

Re: change network configurations after installing db & dev suite [message #380297 is a reply to message #377194]

Sat, 10 January 2009 05:13

merhanatef
Messages: 28
Registered: September 2008

Junior Member

problem solved,thank you very much

Report message to a moderator

Previous Topic:	server clause in tnsnames.ora file
Next Topic:	newbie:trace file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 16:09:06 CST 2024