Home » RDBMS Server » Networking and Gateways » i cant connect my oracle server. there are host problems.
i cant connect my oracle server. there are host problems. [message #298589] Wed, 06 February 2008 11:05 Go to next message
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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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

Re: i cant connect my oracle server. there are host problems. [message #298711 is a reply to message #298589] Thu, 07 February 2008 04:47 Go to previous messageGo to next message
futi
Messages: 22
Registered: November 2007
Junior Member
how can i do configure this, what must be the content of the .ora files? thanx
Re: i cant connect my oracle server. there are host problems. [message #298778 is a reply to message #298711] Thu, 07 February 2008 11:34 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Net Services Reference or use netca.

Regards
Michel
Previous Topic: oracle in vmware JDBC problem
Next Topic: listener listening on 2 different ports
Goto Forum:
  


Current Time: Thu Mar 28 20:44:12 CDT 2024