Home » Other » Client Tools » SQL Dev- connect to Win Server 2012
SQL Dev- connect to Win Server 2012 [message #620262] Wed, 30 July 2014 14:23 Go to next message
oragami
Messages: 16
Registered: July 2014
Junior Member
Hi.
Can anyone help me please. I am trying to connect as a client to my win 2012 server. I establish a connection np as localhost on my production box as sysdba
by when I try to connect as sysdba via the client it doesn't recognize my user name/password. I connect in the same manner in SQL Dev as SYSDBA (which is the role I chose).
I have port forwarded (in/out going ports) 1521 on my router.

What exactly should I choose when I login as a client in Developer as far a a Connection? Basic/tns/advanced. If tns or advanced (which asks for jdbc driver??) how can I set that up?
Do I need to tweak any tns or listener ora files on my server box?

Many, many thanks for any help!

-oragami
Re: SQL Dev- connect to Win Server 2012 [message #620265 is a reply to message #620262] Wed, 30 July 2014 14:27 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
what is database server hostname & IP#
what is client hostname & IP#

post 4 successful pings, two from dbserver to both client hostname & IP# and two from client using both hostname & IP# of DB Server
Re: SQL Dev- connect to Win Server 2012 [message #620275 is a reply to message #620265] Wed, 30 July 2014 15:38 Go to previous messageGo to next message
oragami
Messages: 16
Registered: July 2014
Junior Member
server

hostn: www.planetmas.net
ip# 24.12.118.21

client
jamess-mach
10.0.1.30

I try to log in from SLQ Dev with my host name

Pinging server from client

using dns name
64 bytes from 24.12.118.21: icmp_seq=0 ttl=64 time=0.951 ms
64 bytes from 24.12.118.21: icmp_seq=1 ttl=64 time=0.917 ms
64 bytes from 24.12.118.21: icmp_seq=2 ttl=64 time=1.668 ms
64 bytes from 24.12.118.21: icmp_seq=3 ttl=64 time=1.720 ms
using ip
64 bytes from 24.12.118.21: icmp_seq=0 ttl=64 time=1.549 ms
64 bytes from 24.12.118.21: icmp_seq=1 ttl=64 time=1.784 ms
64 bytes from 24.12.118.21: icmp_seq=2 ttl=64 time=1.629 ms
64 bytes from 24.12.118.21: icmp_seq=3 ttl=64 time=1.623 ms

Pinging client from server

using client ip

took a dive-
Pinging 10.0.1.30 with 32 bytes of data:
Reply from 10.0.1.43: Destination host unreachable.
Reply from 10.0.1.43: Destination host unreachable.
Reply from 10.0.1.43: Destination host unreachable.
Reply from 10.0.1.43: Destination host unreachable.

Ping statistics for 10.0.1.30:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),

using client hostname

ping request could not find host

Thanks!
Re: SQL Dev- connect to Win Server 2012 [message #620280 is a reply to message #620275] Wed, 30 July 2014 20:55 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Oracle has no inherent capability to do any networking or packet exchange.
Oracle depends upon the Operating System for any & all packet exchange.

The 4 pings were to simply test that bi-directional network functionality exists between client & DB server.
Results demonstrate that a problem exists without any involvement of Oracle.

Unless & until the network mis-configuration has been corrected, the probability for success remains at ZERO.

root cause & fix are external to Oracle database & are really OFF TOPIC for this forum.
Re: SQL Dev- connect to Win Server 2012 [message #620955 is a reply to message #620280] Thu, 07 August 2014 08:07 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
BlackSwan
In general yes, however ..

ping uses icmp and not tcp, and a different port. So it is possible that ping will fail while a sqlnet connect could still work. I have had networks where the NA blocked ping in an effort to foil network probing.

Probably a better test would be to telnet on port 1521.

The fact that the OP reported "when I try to connect as sysdba via the client it doesn't recognize my user name/password." seems to suggest the tns traffic on tcp IS going through, else it would not have gotten far enough to reject a password.

[Updated on: Thu, 07 August 2014 08:08]

Report message to a moderator

Re: SQL Dev- connect to Win Server 2012 [message #620958 is a reply to message #620262] Thu, 07 August 2014 08:15 Go to previous message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
oragami wrote on Wed, 30 July 2014 14:23
Hi.
Can anyone help me please. I am trying to connect as a client to my win 2012 server. I establish a connection np as localhost on my production box as sysdba
by when I try to connect as sysdba via the client it doesn't recognize my user name/password.


The fact that it got far enough to reject a password suggests the network config is ok, in spite of your ping results. See my reply to Black Swan on that.

Quote:
I connect in the same manner in SQL Dev as SYSDBA (which is the role I chose).
I have port forwarded (in/out going ports) 1521 on my router.


Many, most DBAs consider a remote client connection as SYSDBA to be a security hole and do not allow it. I'm in that camp myself.

Quote:
What exactly should I choose when I login as a client in Developer as far a a Connection? Basic/tns/advanced. If tns or advanced (which asks for jdbc driver??) how can I set that up?
Do I need to tweak any tns or listener ora files on my server box?

Which method you choose is your choice. You have to supply the requested fields with values that are appropriate to your situation. If you choose tns, you have to supply a value that is listed in your tnsnames.ora. There will be a drop-down list to choose from. If the database you need is not in the list, you need to add it to your tnsnames.ora file first. If you choose 'basic', you have to supply host name, port, and sid or service name, as is appropriate. I can't tell you what those values are, because they are specific to your installation. I can tell you that 'localhost' is NOT correct.

Many, many thanks for any help!

-oragami[/quote]
Previous Topic: Ora 12c & iSQLplus
Next Topic: toad problem
Goto Forum:
  


Current Time: Thu Mar 28 14:25:20 CDT 2024