OraFAQ Forum: Other Operating Systems

Home » Infrastructure » Other Operating Systems » Oracle On Mac

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle On Mac [message #606073]

Sat, 18 January 2014 20:22

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.

Report message to a moderator

Re: Oracle On Mac [message #606074 is a reply to message #606073]

Sat, 18 January 2014 20:41

Mahesh Rajendran
Messages: 10708
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

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.

Report message to a moderator

Re: Oracle On Mac [message #606076 is a reply to message #606075]

Sat, 18 January 2014 20:50

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Re: Oracle On Mac [message #606084 is a reply to message #606076]

Sun, 19 January 2014 11:07

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?

Report message to a moderator

Re: Oracle On Mac [message #606099 is a reply to message #606084]

Sun, 19 January 2014 15:12

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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.

Report message to a moderator

Re: Oracle On Mac [message #606100 is a reply to message #606099]

Sun, 19 January 2014 15:44

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)
)

Report message to a moderator

Re: Oracle On Mac [message #606101 is a reply to message #606100]

Sun, 19 January 2014 16:08

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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

Report message to a moderator

Re: Oracle On Mac [message #606105 is a reply to message #606101]

Sun, 19 January 2014 18:12

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

Report message to a moderator

Re: Oracle On Mac [message #606106 is a reply to message #606105]

Sun, 19 January 2014 21:14

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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

Report message to a moderator

Re: Oracle On Mac [message #606169 is a reply to message #606106]

Mon, 20 January 2014 13:51

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

Report message to a moderator

Re: Oracle On Mac [message #606171 is a reply to message #606169]

Mon, 20 January 2014 14:41

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ping 192.168.0.119

Report message to a moderator

Re: Oracle On Mac [message #606173 is a reply to message #606171]

Mon, 20 January 2014 17:06

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

Report message to a moderator

Re: Oracle On Mac [message #606175 is a reply to message #606173]

Mon, 20 January 2014 17:14

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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.

Report message to a moderator

Re: Oracle On Mac [message #606176 is a reply to message #606175]

Mon, 20 January 2014 17:27

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.

Report message to a moderator

Re: Oracle On Mac [message #606177 is a reply to message #606176]

Mon, 20 January 2014 17:53

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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>

Report message to a moderator

Re: Oracle On Mac [message #606268 is a reply to message #606177]

Tue, 21 January 2014 18:26

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.

Report message to a moderator

Re: Oracle On Mac [message #606269 is a reply to message #606268]

Tue, 21 January 2014 18:36

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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

Report message to a moderator