Howa to setup a connection on MAC SQL Developer to Oracle on a Server
652774Dec 2 2008 — edited Dec 3 2008My 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?