OraFAQ Forum: Networking and Gateways » i cant connect my oracle server. there are host problems.

Home » RDBMS Server » Networking and Gateways » i cant connect my oracle server. there are host problems.

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

i cant connect my oracle server. there are host problems. [message #298589]

Wed, 06 February 2008 11:05

futi
Messages: 22
Registered: November 2007

Junior Member

hi everybody. i can connect my localhost via sqlplus.

C:\sqplus <enter>
username
password
okey
..
..
SQL>...

i can connect, there is no problem.
But, if i want to connect except sqlplus for example with plsql developer, i cant connect the database.( also i cant connect with jdbc ) ( but, i dont change anything about oracle server, i dont understand how happened it. )
Firstly, i was getting the ora-12545 error:
"ORA-12545: Connect failed because target host or object does not ..."

then, i am trying the edit tnsnames.ora and listener.ora, i changed the host as a 127.0.0.1 .

so, again i am trying the connect to the server with plsql developer, this time i am encountering this error :
"ORA-12514 : Tns: listener does not currently know of service requested in connect descriptor."

how can i solve this problem? as i said top of the page, i can connect with sqlplus.
thanx

Report message to a moderator

Re: i cant connect my oracle server. there are host problems. [message #298595 is a reply to message #298589]

Wed, 06 February 2008 11:50

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You have to connect using Net services and so have to congigure a listener and tnsnames.ora.

With sqlplus you connected WITHOUT Net services.

Regards
Michel

[Updated on: Wed, 06 February 2008 11:51]

Report message to a moderator