Hello Raimonds, I have the same problem as Shyam. Working with LDLIBRARYPATH is fine only when you invoke the tools as user “oracle”.
If you want to use them as a different user (i.e. From your own account) then it fails. It seems that DYLDLIBRARYPATH is suddenly “lost” when sqlplus reaches the stage when it load $ORACLEHOME/bin/oracle.
Installing Oracle database in Mac OS X Hello, I was trying to install Oracle database 10g R2 on my Mac, I got stuck at editing the kernal parameters in the pre-installtion tasks section. Discuss: Oracle Database 10g Release 1 for Apple MAC OS X (v. 10.1.0.3) - media - with Oracle Enterprise Manager 10g Grid Control (10.1.0.3) for Linux x86 Sign in to comment Be respectful, keep it.
You can clearly observe this by setting DYLDPRINTLIBRARIES=1 in your environment. This file has the setuid bit, and I guess this behavior is for obvious security reasons (just write your own shared lib and wupti, privilege gained!!!) The only way I managed to get this to work was to create the expected “/b/227” subtree and make some links as shown below. If you know a better way, please let me know. I followed this tutorial line by line, but couldn’t install, it is failing on linking.
Hello to you, I tried to install Intel Oracle10GR2 for Mac yesterday, and after installation everything was good, I could connect and disconnect me without problem this morning when I try to connect I get the following message: ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Mac OS X Error: 2: No such file or directory – I think I have ever seen on windows this type of message, and the resolve needed to stop and restart services Oracle but I do not know how to do it under Mac OS X. Thank you Comment by Youssef — April 24, 2009 @. Youssef, I noticed you had the same problem that I am currently havingthat is: thunderhawk:admin oracle$ sqlplus system@orcl SQL.Plus: Release 10.2.0.4.0 – Production on Fri May 15 18: Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Enter password: ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Mac OS X Error: 2: No such file or directory How did you get sqlplus to finally work. I am out of gas trying to figure this out!help? Comment by Michael Morin — May 16, 2009 @.
Hello, I followed the installation to a teehowever I get the following errors with the listener! Thunderhawk: oracle$ more.bashprofile export DISPLAY=:0.0 export ORACLEBASE=$HOME export ORACLEHOME=/Users/oracle/oracle/product/10.2.0/db1 export DYLDLIBRARYPATH=$ORACLEHOME/lib export ORACLESID=ORCL PATH=$PATH:/$ORACLEHOME/bin umask 022 ulimit -Hn 65536 ulimit -Sn 65536 —– thunderhawk: mmorin$ su – oracle Password: thunderhawk: oracle$./lsnrctl status -bash:./lsnrctl: No such file or directory thunderhawk: oracle$ lsnrctl status LSNRCTL for MacOS X Server: Version 10.2.0.4.0 – Production on 14-MAY-2009 22:27:24 Copyright (c) 1991, 2007, Oracle. All rights reserved. I updated my listener.ora thanks to Philippe Causse and tnsnames.oralogout as oracle and log back in as oracle and issue the lsnrtcl status command and get the following: hunderhawk:oracle oracle$ lsnrctl status LSNRCTL for MacOS X Server: Version 10.2.0.4.0 – Production on 14-MAY-2009 23:47:37 Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener MacOS X Server Error: 2: No such file or directory Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener MacOS X Server Error: 61: Connection refused. My listener.ora looks like this: thunderhawk:admin oracle$ more listener.ora # listener.ora Network Configuration File: /Users/oracle/oracle/product/10.2.0/d b1/network/admin/listener.ora # Generated by Oracle configuration tools. Hi., I am trying to install oracle database 10.2 on mac os 10.5.4.
I followed you installation doc and completed below steps: In installation wizard I selected the following options: 0. Advanced Installation – so that I can change some default options 0. Standard Edition – as I don’t need additional features of Enterprise Edition 0.
Create Database / General Purpose 0. Global database name: orcl, SID: orcl 0. Character set: UTF-8 AL32UTF8 0. Create database with sample schemas after specify database storage option window I get Error ORA-12547 TNS lost contact Error. With two option retry and ignore. I selected retry but again shows the same error.
If ignored it it moved forward but showed same error many times. At last, password management window it didn’t showed any database installed. Can any one suggest?? -Shyam Comment by — May 15, 2009 @. Thanks to Phillipe Causse, I was finally able to get the Listener to start.
This blog is a great resource to have. My kudos to all. Thunderhawk: oracle$ lsnrctl start LSNRCTL for MacOS X Server: Version 10.2.0.4.0 – Production on 15-MAY-2009 10:14:11 Copyright (c) 1991, 2007, Oracle. All rights reserved.
New Question: Now that the Listener startedI try to start the database and get: hunderhawk:bin oracle$ dbstart ORACLEHOMELISTNER is not SET, unable to auto-start Oracle Net Listener Usage: //Users/oracle/oracle/product/10.2.0/db1/bin/dbstart ORACLEHOME and when I issue the sqlplus at the command prompt I get: hunderhawk:bin oracle$ sqlplus SQL.Plus: Release 10.2.0.4.0 – Production on Fri May 15 10: Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Enter user-name: oracle Enter password: ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Mac OS X Error: 2: No such file or directory Enter user-name: —— Any leads as to why the dbstart command did not work?and how I get sqlplus to work for me?I thank you all in advance. Comment by Michael Morin — May 15, 2009 @. Dbstart can be used directly from the command line to start oracle, if the Y flag in oratab is set: sudo vim /etc/oratab # Change N to Y at end of line: orcl:/Users/oracle/oracle/product/10.2.0/db1:Y oracle$ dbstart $ORACLEHOME Processing Database instance “orcl”: log file /Users/oracle/oracle/product/10.2.0/db1/startup.log oracle$ sqlplus scott/tiger@orcl SQL.Plus: Release 10.2.0.4.0 – Production on Wed Jul 1 21: Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Release 10.2.0.4.0 – Production SQL Comment by Steven Trevor — July 2, 2009 @.
Hello Raimonds, I have posted my issues many times on this blog but still I am facing the same problem. I configured all related files as: I login through oracle and find that /etc.sysctl.conf is configured as: kern.sysv.semmsl=87381 kern.sysv.semmns=87381 kern.sysv.semmni=87381 kern.sysv.semmnu=87381 kern.sysv.semume=10 kernel.sysv.shmall=2097152 kernel.sysv.shmmax= kernel.sysv.shmmni=4096 kern.maxfiles=65536 kern.maxfilesperproc=65536 net.inet.ip.portrange.first=1024 net.inet.ip.portrange.last=65000 kern.corefile=core kern.maxproc=2068 kern.maxprocperuid=2068 anything wrong here?? @@@.bashprofile is configured as: umask 022 export ORACLEHOME=/Users/oracle/oracle/product/10.2.0/db1 export DYLDLIBRARYPATH=$ORACLEHOME/lib export ORACLESID=rsg PATH=$PATH:/$ORACLEHOME/bin AND THE OUTPUT OF configToolFailedCommands.bak as: # Copyright (c) 1999, 2008, Oracle. All rights reserved.
Hi, Can anyony tell me where I am wrong to install oracle database 10.2 on mac on 10.5.server. I am getting Error ORA-12547 TNS Lost contact. I have configured files as below: @Alex: I fixed ulimit issue and now by.bashprofile looks like that 1.bashprofile: ulimit -Hu 512 ulimit -Su 512 ulimit -Hn 10240 ulimit -Sn 10240 umask 022 export ORACLEHOME=/Users/oracle/oracle/product/10.2.0/db1 export DYLDLIBRARYPATH=$ORACLEHOME/lib export ORACLESID=rsg PATH=$PATH:/$ORACLEHOME/bin 2. /etc/sysctl.conf: kern.sysv.semmsl: 87381 kern.sysv.semmns: 87381 kern.sysv.semmni: 87381 kern.sysv.semmnu: 87381 kern.sysv.semume: 10 kern.sysv.shmall: 2097152 kern.sysv.shmmax: 4194304 kern.sysv.shmmni: 4096 kern.maxfiles: 12288 kern.maxfilesperproc: 10240 net.inet.ip.portrange.first: 49152 net.inet.ip.portrange.last: 65535 kern.corefile: /cores/core.%P kern.maxproc: 1024 kern.maxprocperuid: 512 3. /etc/hosts: ## # Host Database # # localhost is used to configure the loopback interface # when the system is booting. Do not change this entry. ## 192.168.1.133 localhost #127.0.0.1 localhost 255.255.255.255 broadcasthost::1 localhost fe80::1%lo0 localhost 4.
Oracle: root# hostname oracle.rsg.com 5. Environment Looks: oracle: oracle$ env MANPATH=/usr/share/man:/usr/local/share/man:/usr/X11/man TERM=xterm-color SHELL=/bin/bash USER=oracle ORACLESID=rsg PATH=/bin:/usr/bin:/usr/sbin:/sbin:/usr/local/bin:/usr/X11/bin://Users/oracle/oracle/product/10.2.0/db1/bin PWD=/Users/oracle SHLVL=1 HOME=/Users/oracle DYLDLIBRARYPATH=/Users/oracle/oracle/product/10.2.0/db1/lib ORACLEHOME=/Users/oracle/oracle/product/10.2.0/db1 =/usr/bin/env Now, how to move?? Comment by — May 25, 2009 @. Hi., I have installed oracle software 10.2 on mac 10.5 server. I created database through dbca but tnsnames.ora and listener.ora files not get created as its location e.g /Users/oracle/oracle/product/10.2.0/dba/network/admin. I created both files and configured it. Now, when I start listener by using: oracle: oracle$ lsnrctl start LSNRCTL for MacOS X Server: Version 10.2.0.4.0 – Production on 27-MAY-2009 15:16:07 Copyright (c) 1991, 2007, Oracle.
All rights reserved. The install went fine, I can start and stop the instance without any problems, (only when I su – oracle), I can use sqlplus to perform all database operations (creating tables, procedures etc) However when I try to use any other tools i:e SQLDeveloper, or NavCat Developer, I get a: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist 01034. 00000 “ORACLE not available” The funny thing though, SQL Developer actually conntected fine a few times (even navicat), but after I tried to use the tools on a different day, it seems to give me the error above (the problem seems to be an intermitting problem), I can’t seem to get sqldeveloper or navicat to to work anymore. (SQLplus is the only tool that will work) any suggestions? Comment by lionel joens — June 2, 2009 @.
I already startup the Database, the listener. But when I try to connect from other computer client, an ORA-12541: TNS:no listener The host is reached thru ping, tnsping throws the same ORA.
Here is the output of my server (iMac) iMac:etc oracle$ sqlplus / as sysdba SQL.Plus: Release 10.2.0.4.0 – Production on Mon Jun 22 22: Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Connected to an idle instance. SQL startup ORACLE instance started. Total System Global Area 612368384 bytes Fixed Size 2085872 bytes Variable Size 167775248 bytes Database Buffers 436207616 bytes Redo Buffers 6299648 bytes Database mounted. Database opened.
SQL quit Disconnected from Oracle Database 10g Release 10.2.0.4.0 – Production iMac:etc oracle$ lsnrctl start LSNRCTL for MacOS X Server: Version 10.2.0.4.0 – Production on 22-JUN-2009 22:18:41 Copyright (c) 1991, 2007, Oracle. All rights reserved. Hi Raimonds, Great guide, thanks for taking the time to post it.
I’m trying to install 10g R2 client on my Macbook (10.5 Leopard on Core 2 Duo, so 64-bit) using the client downloaded from. I get an error saying Unable to find make utility in location: /usr/bin/make (and I can see that it’s not at that location). This brings me to a halt with Retry and Ignore options not helping and Cancel being the only option left. I can’t seem to find much info on make for mac os.
Thanks, Jim Comment by jimothyg — August 4, 2009 @. The first issue with Snow Leopard is that the runInstaller script is pointing to the 1.4.2 JDK, which at least on my Mac Mini, appears to have been removed (if it was ever there) after upgrading to 10.6. After tweaking the JAVAHOME variable in the script to reference the 1.5.0 path, I get the following: Starting Oracle Universal Installer No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2009-08-2811-53-28PM. Please wait macsmacmini:Disk1 oracle$ Fri Aug 28 23:53:30 macsmacmini.local java4460: kCGErrorFailure: Set a breakpoint @ CGErrorBreakpoint to catch errors as they are logged. Exception in thread “main” java.lang.InternalError: Can’t connect to window server – not enough permissions. I have Oracle up and running on my IMac with Mac OS X 10.5.8 which I obtain from my Apple Protection Plan. I would like to assume that Apple will upgrade me to Snow Leopard but I have not received any messages lately. I think it is important to upgrade Mac OS X at suggested intervals as to not experience bumps in the road for your apps especially Oracle. I think I am going to hold off for now since Snow Leopard just came outperhaps some of these Oracle issues will be addressed down the road.
Comment by Michael Morin — August 28, 2009 @. Progress Running a remote “ssh -X” session from my macbook didn’t help (which normally works as I’ve done Oracle installs on Solaris this way), so I logged into the desktop and was almost able to launch the installer. This time it barfed on an UnsatisfiedLink, as the JVM’s in 10.6 default to 64bit, and the installer relies on 32bit JNI calls. Using “./runInstaller -J-d32” will get things going – the status screen is showing “Install Successful” and is currently linking away. Comment by Macca — August 28, 2009 @. I am trying to install oracle database on mac snow leopard. I have completed all pre installation task.
Now trying to install. I am getting following error:- No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2009-08-3110-22-39AM. Please wait The Java RunTime Environment was not found at /System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Home/bin/java. Hence, the Oracle Universal Installer cannot be run. Please visit and install JRE version 1.3.1 or higher and try again.: No such file or directory Can you help me in this regard. –SD Comment by SD — August 31, 2009 @. Oracle Installation on snow leopard: I edit the runInstaller file as suggested by you and started installation. I selected to install “oracle Software only” at the point to reach 79% of installation I got following errors: Error in invoking target ‘allnoorcl ipcg ihsodbc32’ of makefile ‘Users/oracle/oracle/product/10.2.0./db1/rdbms/lib/insrdbms.ml’.
See ‘Users/oracle.oraInventory/logs/installActions2009-09-0105-55-43PM.log’ for details. I retried to install but got the same error. Now, what to do next? Please provide any document, if you have. Comment by SD — September 1, 2009 @. @Macca: May I ask, after Oracle showed Installed Successfully, were you be able to start oracle server on Snow Leopard? I had the same problem as @SD (comment #77).
Aftre checking the trace file and dump file, I have an assumption that the problem is the format of the compiled objects or 64-bit gcc version compatibility, which caused by XCode gcc or new kernel doesn’t work with oracle. Therefore they cannot be linked into the dynamic library. According to @Chris Murphy, upgrading from Leopard works. Unfortunately, according to Apple’s release notes, XCode 3.1.3 in Leopard won’t install in Mac OS X 10.6, so now I’m creating a testing environment with Leopard 10.5.8 on another hard drive, and then will install Oracle which is mounted in Snow Leopard drive. I’ll post the result of the test. But I don’t think this would be a good solution for most users Nat. Comment by Nat — September 1, 2009 @.
Here is the updates on installing Oracle on newly installed Snow Leopard. A bit cheat and tricky but at least my oracle works, dbca, netca, emca, all work. I did install Mac 10.5.8/XCode 3.1.3 on another (thumb) drive, and created a soft link of oracle target installation to the drive in Snow Leopard. Then, installed oracle as usual, using customized installation in my case but any of them should work fine. (of course, runInstaller, GUI thru ‘su – oracle’ via remote X11, etc. Worked right out-of-the-box).
I didn’t create a database yet. Then, I booted with Snow Leopard, and run $ORACLEBASE/oraInventory/orainstRoot.sh and $ORACLEHOME/root.sh to create necessary files and fix the permission.
Next, I modified $ORACLEHOME/inventory/Templates/jdk/copyJDK.sh to use all Java framework 1.5.0 instead of 1.4.2. Also at line #43, change ‘java -Xbootclasspath’ to ‘java -d32 -Xbootclasspath’. Then, remove the entire $ORACLEHOME/jdk and run the ‘copyJDK.sh `echo $ORACLEHOME` to re-create/copy the correct java library. This will solve not only DBCA, but also NETCA, EMCA and everything else GUI using java.
(Optional) for command line version, you will also have to modify several files in $ORACLEHOME/oui because they don’t use the above jdk link in $ORACLEHOME. After that, I have to log on to workstation using ‘oracle’ user. (Running Oracle GUI using remote X11 still doesn’t work even after I was using new jnilib/jdk from Snow Leopard). Then, I could run ‘dbca’ to create database, and ‘netca’ to create listener. If I have time, I might try installing from Snow Leopard and XCode 3.2 and modify the make file to have GCCVERSION set to 4.
The culprit is indeed the incompatibility of object files to bind/link to the libraries that oracle use. XCode 3.2 comes with gcc 4.2.1 while XCode 3.1.3 comes with gcc 4.0.1. Also XCode version is fixed with Mac OS X version, so we can’t just install XCode 3.1.3 on Snow Leopard. Anyone interested to pursue on this? I would love to hear the result. Phewww and it’s supposed to be a short updates. Comment by Nat — September 2, 2009 @.
If you want to try out, I tried another approach by using gcc 4.0.1, same version as Xcode 3.1.3/OSX 10.5.8, and modified several scripts and makefiles to use the correct java and compiler/linker version. It didn’t work. I noticed that the compiler and linker 4.0.1 were used but the problem still remained. I haven’t got time to look into it much.
One thing is, the bothering /oracle/product/10.2.0/db1/hs/lib32/hsodbc.o wasn’t even there in the working oracle config from XCode 3.1.3/OSX 10.5.8. And I don’t think it is even needed in the first place. In fact, they weren’t even in the installation log.
Comment by Nat Mongkolprasit — September 3, 2009 @. Hi there, I have an X11 issue with Snow Leopard. Followed all the suggestion for X11 settingDISPLAY:localhost:0.0; export DISPLAY xhost + and thru X11 preference, I checked “Allow connections from network clients” and unchecked “Authenticate connections” I did check the runInstaller to point to “1.5.0” instead. And using Using “./runInstaller -J-d32″ to run, but no luck still got following exception.
OUI-10025:Unable to start an interactive install session because of the following error:Can’t connect to window server – not enough permissions. Comment by Ruly — September 9, 2009 @. Hi All, first of all, ray, thank you very much for this wirteup and the collection of additional tips, tricks and workarounds. I really wanted to understand why running Java Apps trough ssh X11 forwarding does not work, and the answer seems to be really simple: Because it’s not implemented. The Mac OS X bundled java (for me) does not even try to contact the X Server, it simply tries to contact the local window manager (which fails), and that’s it. The picture gets a little clearer when trying to start a demo app: apex: root# /System/Library/Frameworks/JavaVM.framework/Versions/1.6.0/Commands/java -jar /tmp/SwingSet2.jar Wed Dec 16 13:07:12 apex.XXX.de java8387: 3891612: (connectAndCheck) Untrusted apps are not allowed to connect to or launch Window Server before login.
Exception in thread “main” java.lang.InternalError: Can’t connect to window server – not enough permissions. The first error message is explained well in the docs. The solution to the issue is simple: Use a java runtime with X11 support. One resource I’ve found is this: Please note the license requirements on the site. I will try to raise awareness within Apple for the popular demand for a Mac OS X bundled java release with X11 support. Nils Comment by — December 16, 2009 @. Hello, I tried to install Oracle on my local box, which I use everywhere and I did not get static IP, but without a static IP I cannot connect to Oracle from other boxes.
Of course in most of all cases you don’t get this problem, because any real DB server should have a static IP, but I have spent a day to fix this problem and probably it will be useful for somebody else. And thanx for this article, without that I did not have any chance to run DB (I’m a Java developer, not Oracle DBA).
Regards, Ian Comment by — April 11, 2010 @.