Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Howa to setup a connection on MAC SQL Developer to Oracle on a Server

652774Dec 2 2008 — edited Dec 3 2008
My question is how to setup a connection on a Mac to Oracle on our Windows Server.

I have downloaded SQL Server, and can open it. I try a new connection. On Windows, I know that I have a tnsnames file and that identifies the
server. On my PC, the entry for Oracle looks like this:

ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server1.iowa.uiowa.edu)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)

On the MAC, I tried to do connection type "Basic", then put in the following:
Hostname: server1.iowa.uiowa.edu
Port: 1521
SID: ORCL

When I test this, I get "unknown host specified". I tried to log into the Network. Then I get:
"The network adaptor could not establish the connection."

I also tried to go to TNS, but don't get anything on the dropdown. On my PC, I know that I have
a tnsnames.ora file that it refers to, but don't know how to put this on a Mac.

Could someone please explain how to setup the connection?
This post has been answered by -K- on Dec 3 2008
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 31 2008
Added on Dec 2 2008
2 comments
1,220 views