Home » Infrastructure » Other Operating Systems » Oracle On Mac
Oracle On Mac [message #606073] Sat, 18 January 2014 20:22 Go to next message
iSam
Messages: 11
Registered: January 2014
Location: Austria
Junior Member
Dear Friends,
I have Mac OS X and I want working with Oracle PL/SQL on Mac. In Oracle website have not any Mac version!? Would you please help me for installation Oracle and Oracle Client on Mac?
Thanks a lot.
Re: Oracle On Mac [message #606074 is a reply to message #606073] Sat, 18 January 2014 20:41 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10625
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Instant client, Yes.
http://www.oracle.com/technetwork/topics/intel-macsoft-096467.html
While I am mostly happy with vim, For some serious pl/sql, you might want to use a tool like Sql developer

Start looking into a VM of your choice (and something that supports the most recent version of Oracle database server).

[Updated on: Sat, 18 January 2014 20:43]

Report message to a moderator

Re: Oracle On Mac [message #606075 is a reply to message #606074] Sat, 18 January 2014 20:45 Go to previous messageGo to next message
iSam
Messages: 11
Registered: January 2014
Location: Austria
Junior Member
Thanks. Would you please advice me about installing Instant client on Mac? With Oracle guide i can't install.
Re: Oracle On Mac [message #606076 is a reply to message #606075] Sat, 18 January 2014 20:50 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10625
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Google is full of it.
http://ronr.blogspot.com/2013/02/oracle-client-11gr2-11203-for-apple-mac.html

In a nutshell,
Unzip the files and set your .profile or .bash_profile or whatever you are using with ENV variables.
Re: Oracle On Mac [message #606084 is a reply to message #606076] Sun, 19 January 2014 11:07 Go to previous messageGo to next message
iSam
Messages: 11
Registered: January 2014
Location: Austria
Junior Member
Thanks a lot, but I have many issue for installation. I installed until TEST section step by step and I make /Applications/oracle/network/admin. but I don't know how can I make tnsname and other process for connect to my virtual windows that I have oracle on that?
Re: Oracle On Mac [message #606099 is a reply to message #606084] Sun, 19 January 2014 15:12 Go to previous messageGo to next message
BlackSwan
Messages: 22789
Registered: January 2009
Senior Member
SQL*Net & listener is not required to connect to local database.

tnsnames.ora is just a simple text file that can be created using text editor like vim.
Re: Oracle On Mac [message #606100 is a reply to message #606099] Sun, 19 January 2014 15:44 Go to previous messageGo to next message
iSam
Messages: 11
Registered: January 2014
Location: Austria
Junior Member
I make tnsnames.ora with bellow content in /Applications/oracle/network/admin. but I can't connect to my oracle db in VMWare with this command sqlplus hr/hr@//192.168.0.119:8443/XE!?
XE = (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.119)(PORT = 8443))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
Re: Oracle On Mac [message #606101 is a reply to message #606100] Sun, 19 January 2014 16:08 Go to previous messageGo to next message
BlackSwan
Messages: 22789
Registered: January 2009
Senior Member
It would help if you actually used COPY & PASTE so we can see what you do & how Oracle responds.
saying that you can't connect is 100% & totaly devoid of any actionable details.

>sqlplus hr/hr@//192.168.0.119:8443/XE!?
above is correct format to use EZCONNECT; which does not utilize tnsnames.ora file

I doubt that 8443 is correct port#.

issue OS commands below

lsnrctl status
lsnrctl service

COPY the results from above then PASTE all back here
Re: Oracle On Mac [message #606105 is a reply to message #606101] Sun, 19 January 2014 18:12 Go to previous messageGo to next message
iSam
Messages: 11
Registered: January 2014
Location: Austria
Junior Member
Thanks. I ran these command on CMD of my Windows 7 that installed on VMWare and take bellow results.

Result for lsnrctl status:


LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 20-JAN-2014 03:36:22

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
Start Date 19-FEB-2013 20:25:54
Uptime 248 days 13 hr. 13 min. 56 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File C:\oraclexe\app\oracle\product\10.2.0\server\network\admin\listener.ora
Listener Log File C:\oraclexe\app\oracle\product\10.2.0\server\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=WIN-MH3464DRG3G)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=8080))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "XEXDB" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Service "XE_XPT" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Service "xe" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
The command completed successfully


Result for lsnrctl service:


LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 20-JAN-2014 03:38:03

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "XEXDB" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1002 state:ready
DISPATCHER <machine: WIN-MH3464DRG3G, pid: 2548>
(ADDRESS=(PROTOCOL=tcp)(HOST=WIN-MH3464DRG3G)(PORT=49175))
Service "XE_XPT" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:174 refused:0 state:ready
LOCAL SERVER
Service "xe" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:174 refused:0 state:ready
LOCAL SERVER
The command completed successfully
Re: Oracle On Mac [message #606106 is a reply to message #606105] Sun, 19 January 2014 21:14 Go to previous messageGo to next message
BlackSwan
Messages: 22789
Registered: January 2009
Senior Member
sqlplus hr/hr@//192.168.0.119:1521/xe

above might work; assuming that EZCONNECT is configured within sqlnet.ora & 192.168.0.119 is associated with WIN-MH3464DRG3G hostname
Re: Oracle On Mac [message #606169 is a reply to message #606106] Mon, 20 January 2014 13:51 Go to previous messageGo to next message
iSam
Messages: 11
Registered: January 2014
Location: Austria
Junior Member
I ran sqlplus hr/hr@//192.168.0.119:1521/XE, but I have bellow error:

SQL*Plus: Release 11.2.0.3.0 Production on Mon Jan 20 20:47:50 2014

Copyright (c) 1982, 2012, Oracle. All rights reserved.

ERROR:
ORA-12170: TNS:Connect timeout occurred


Enter user-name: hr
Enter password:
ERROR:
ORA-12162: TNS:net service name is incorrectly specified


Enter user-name: hr
Enter password:
ERROR:
ORA-12162: TNS:net service name is incorrectly specified


SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
Re: Oracle On Mac [message #606171 is a reply to message #606169] Mon, 20 January 2014 14:41 Go to previous messageGo to next message
Michel Cadot
Messages: 59136
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

ping 192.168.0.119

Re: Oracle On Mac [message #606173 is a reply to message #606171] Mon, 20 January 2014 17:06 Go to previous messageGo to next message
iSam
Messages: 11
Registered: January 2014
Location: Austria
Junior Member
I have not this ping but when I ran ipconfig on CMD of widows that installed on VMWare, I have bellow result:

Windows IP Configuration

Ethernet adapter Bluetooth Network Connection:

Media State . . . . . . . . . . . : Media disconnected
Connection-specific DNS Suffix . :

Ethernet adapter Local Area Connection:

Connection-specific DNS Suffix . : upc.at
Link-local IPv6 Address . . . . . : fe80::32:e74e:1d4:9993%11
IPv4 Address. . . . . . . . . . . : 192.168.0.119
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . . . . : 192.168.0.1

Tunnel adapter isatap.{6F089CDC-6C0A-461C-875C-E806F67F90B8}:

Media State . . . . . . . . . . . : Media disconnected
Connection-specific DNS Suffix . :

Tunnel adapter Local Area Connection* 11:

Connection-specific DNS Suffix . :
IPv6 Address. . . . . . . . . . . : 2001:0:5ef5:79fd:18b3:1cba:3f57:ff88
Link-local IPv6 Address . . . . . : fe80::18b3:1cba:3f57:ff88%13
Default Gateway . . . . . . . . . : ::

Tunnel adapter isatap.upc.at:

Media State . . . . . . . . . . . : Media disconnected
Connection-specific DNS Suffix . : upc.at
Re: Oracle On Mac [message #606175 is a reply to message #606173] Mon, 20 January 2014 17:14 Go to previous messageGo to next message
BlackSwan
Messages: 22789
Registered: January 2009
Senior Member
>Media State . . . . . . . . . . . : Media disconnected
>Media State . . . . . . . . . . . : Media disconnected
>Media State . . . . . . . . . . . : Media disconnected

I am not surprised that you get error since obvious problem exists at OS level.
Oracle is the victim; not the culprit.
Request assistance from your local OS System Administrator.
Re: Oracle On Mac [message #606176 is a reply to message #606175] Mon, 20 January 2014 17:27 Go to previous messageGo to next message
iSam
Messages: 11
Registered: January 2014
Location: Austria
Junior Member
Would you please guide me how can I connect by SQLDeveloper (Mac Version) or terminal to my oracle server on another datacenter (Not here or VMWare)? Need SQL*Net & listener? If yes, how can I make and config these?
Thanks a lot.
Re: Oracle On Mac [message #606177 is a reply to message #606176] Mon, 20 January 2014 17:53 Go to previous messageGo to next message
BlackSwan
Messages: 22789
Registered: January 2009
Senior Member

For System1 post hostname, IP#, Operating System name & version & Oracle s/w version to 4 decimal places.
For System2 post hostname, IP#, Operating System name & version & Oracle s/w version to 4 decimal places.
Clarify which hostname is associated with DataBase (DB) Server system & which hostname with SQL Client.

From DB Server post content of listener.ora & sqlnet.ora (if either exist)
From DB Server post results from following commands
lsnrtcl status
lsnrctl service
sqlplus scott/tiger

From SQL Client post content of tnsnames.ora & sqlnet.ora (if either exist)
From SQL Client post results from following commands
tnsping <DB_alias>
ping <DBhostname>
sqlplus scott/tiger@<DB_alias>
Re: Oracle On Mac [message #606268 is a reply to message #606177] Tue, 21 January 2014 18:26 Go to previous messageGo to next message
iSam
Messages: 11
Registered: January 2014
Location: Austria
Junior Member
Thanks a lot from you and all of friends that helped me. I turned of firewall on windows that installed on VMWare on Mac, and issue was resolve and I can connect to this oracle from SQL Developer and terminal. Would you please guide me how can I connect by SQLDeveloper (Mac Version) or terminal to my oracle server on another datacenter (Not here or VMWare)? If I change content of tnsnames.ora or change my command (sqlplus hr/hr@//192.168.0.119:1521/XE), can I connect to another server in another datacenter with different IP and ...? If not, moreover what I need?
Thanks a lot.
Re: Oracle On Mac [message #606269 is a reply to message #606268] Tue, 21 January 2014 18:36 Go to previous messageGo to next message
BlackSwan
Messages: 22789
Registered: January 2009
Senior Member
since you choose to ignore my request for specific details & I suggest that you Read The Fine Manual (URL below) to learn all about SQL*Net on your own.

http://docs.oracle.com/cd/E11882_01/network.112/e41945/toc.htm
Re: Oracle On Mac [message #606270 is a reply to message #606269] Tue, 21 January 2014 18:51 Go to previous messageGo to next message
iSam
Messages: 11
Registered: January 2014
Location: Austria
Junior Member
Many thanks. I need SQL*Net on my Mac for connect to another Oracle server, right? Is it enough only?
Re: Oracle On Mac [message #606271 is a reply to message #606270] Tue, 21 January 2014 19:00 Go to previous messageGo to next message
BlackSwan
Messages: 22789
Registered: January 2009
Senior Member
SQL Developer can utilize JDBC Thin protocol; so SQL*Net client is not required.
Re: Oracle On Mac [message #606272 is a reply to message #606271] Tue, 21 January 2014 20:06 Go to previous message
iSam
Messages: 11
Registered: January 2014
Location: Austria
Junior Member
Really thanks Wink
Previous Topic: VMware software - free?
Next Topic: Pro * Cobol
Goto Forum:
  


Current Time: Thu Sep 18 17:20:38 CDT 2014

Total time taken to generate the page: 0.10245 seconds