Too Cool for Internet Explorer

Friday, May 27, 2005


Install Oracle 10g on Mac OS X 10.4 ("Tiger")

The last two evenings I spent on installing Oracle 10g on my iBook. Don't ask why I have to have Oracle on an iBook, I just wanted to play around with it. Problem was that I haven't read somewhere before that right now no Oracle database seems to run on Apple's Tiger yet but only on 10.3 ("Panther").
When I realized that, I already had tried to solve the problem a few hours. So I wasn't in the mood to let it go. There had to be a way and I think - a few minutes ago - I found it.

But I will start from the beginning. I'd like to have a manual for myself, too, because I forget stuff like that when I haven't done it for some weeks or months...


1. System Requirements

Mac OS X 10.4 Tiger
to be precise it was

$ sw_vers
ProductName: Mac OS X
ProductVersion: 10.4.1
BuildVersion: 8B15


Developer Tools (Xcode) 2.0 installed


2. Create Required User and Groups

I used the command line instructions from the Database Installation Guide 10g for Mac OS X.

As root create the oinstall group with an unused group ID. I chose 600.

# nicl . -create /groups/oinstall
# nicl . -append /groups/oinstall gid 600
# nicl . -append /groups/oinstall passwd "*"


Next do the same for the dba group. I chose 601 here.

# nicl . -create /groups/dba
# nicl . -append /groups/dba gid 601
# nicl . -append /groups/dba passwd "*"


Then create the user oracle with an unused user ID. I chose 601 here again.

# nicl . -create /users/oracle
# nicl . -append /users/oracle uid 601
# nicl . -append /users/oracle gid 600
# nicl . -append /users/oracle shell /bin/bash
# nicl . -append /users/oracle home /Users/oracle
# nicl . -append /users/oracle realname "Oracle Owner"


Now add the oracle user to the dba group.

# nicl . -append /groups/dba users oracle


Create a home directory and change the owner and group:

# mkdir /Users/oracle
# chown oracle:oinstall /Users/oracle


Finally, set the password for the oracle user:

# passwd oracle


3. Create Directories

I created two directories, one for the Oracle software and one for the data files. This is a suggestion in the Quick Installation Guide and is not needed. Right now it does not even make sense because both directory are on the same volume. So, don't care and handle the following section as you want.

Create the Oracle software directory as follows:

# mkdir -p /Volumes/OSX/Applications/oracle


Create the directory for datafile as follows:

# mkdir -p /Volumes/OSX/oradata


Change the groups and permissions for the directories you just created by executing these commands:

# chown -R oracle:oinstall /Volumes/OSX/Applications/oracle
# chown -R oracle:oinstall /Volumes/OSX/oradata

then

# chmod -R 775 /Volumes/OSX/Applications/oracle
# chmod -R 775 /Volumes/OSX/oradata


4. Configure Kernel Parameters

When installing Oracle on Linux or other flavors or UNIX, certain kernel parameters will have to be adjusted for Oracle to run properly. The Quick Installation Guide specifies the proper minimum values.

To verify the kernel parameter values, execute:

# /usr/sbin/sysctl -a | grep corefile
# /usr/sbin/sysctl -a | grep sem
# /usr/sbin/sysctl -a | grep maxproc


I got the following output:

# /usr/sbin/sysctl -a | grep corefile
kern.corefile = /cores/core.%P

# /usr/sbin/sysctl -a | grep sem
kern.sysv.semmni: 87381
kern.sysv.semmns: 87381
kern.sysv.semmnu: 87381
kern.sysv.semmsl: 87381
kern.sysv.semume: 10
kern.posix.sem.max: 10000

# /usr/sbin/sysctl -a | grep maxproc
kern.maxproc = 532
kern.maxprocperuid = 100


So I only had to adjust the last two values by executing:

/usr/sbin/sysctl -w kern.maxproc=2068
/usr/sbin/sysctl -w kern.maxprocperuid=2068


To make these values stick, that is, presist after a reboot, edit /etc/sysctl.conf and add lines for values that need changing. I used vi to edit the file, but you can use any text editor.

kern.maxproc=2068
kern.maxprocperuid=2068


5. Set Shell Limits

For performance reasons, shell limits need to be adjusted. Begin by navigating to the directory that contains the IPServices script.

# cd /System/Library/StartupItems/IPServices

Using any text editor, edit the file IPServices and add the following ulimit commands inside the StartService() function:

ulimit -Hu 2068
ulimit -Su 2068
ulimit -Hn 65536
ulimit -Sn 65536


It should then look like this:

StartService ()
{
if [ -a /etc/com.apple.named.conf.proxy ]
then
echo "Starting Internet address sharing"
/usr/libexec/InternetSharing
fi
ulimit -Hu 2068
ulimit -Su 2068
ulimit -Hn 65536
ulimit -Sn 65536
}


6. Configure User Environment

The installer will be run from the oracle user. But before you can run the installer, however, the environment for oracle has to be set properly.

While logged in as oracle, I created the .bash_profile for the user which contains the following:

umask 022
ORACLE_BASE="/Applications/oracle"
ORACLE_SID=AW01
ORACLE_HOME="/Applications/oracle/product/10.1.0/db_1"
export ORACLE_BASE ORACLE_SID ORACLE_HOME
export PATH=$PATH:$ORACLE_HOME/bin

Actually I added the ORACLE_HOME much later, so this is the result from the later installation.

Then I sourced the .bash_profile by exectuing

oracle$ source ~/.bash_profile


7. Add Hostname to /etc/hosts

Because I get the IP address through DHCP from a wireless router, I had to make sure the installer could find this IP address by adding it to my /etc/hosts file. You may not need to do this, depending on how your machine is networked. If, during the install process, you see an error related to the installer not being able to determine the IP address, stop the installer, perform these steps and launch the installer again. As Root, edit the file /etc/hosts and add an entry with your hostname and IP address. I determined my IP address by executing the following commands as root:

root# hostname
root# ifconfig -a


The first command returned iBook.local. The second returned configuration details for each network device. The IP address for en0 is 192.168.0.133. So, I added a line to my /etc/hosts file.

It was interesting that I had to log off from the system to make these changes be recognized by the oracle installer while it was immediately available in the shell.

8. Installing Oracle

First you have to download the necessary files from OTN. To install the database, you'll need the file ship_mac_db.cpio.gz
You have to download them either as user oracle or copy them to /tmp and then get them as oracle and move them to /Volumes/Application/oracle/stage. I created the stage directory there first.

In the stage directory you have to umcompress the file:

oracle$ gunzip ship_mac_db.cpio.gz
oracle$ cpio -idm <>

Now start the installer and hold ya horses:

oracle$ cd Disk1
oracle$ ./runInstaller


If you don't know what to do in the installer take a look at the Quick Installation Guide, because I don't want to write that down now.

And now comes the tricky part, because the installer will not finish successfully, but break while trying to start some assistant at the end of installation.


9. Fixing the Oracle Installation

When the installer breaks just finish the installation as possible. We now will relink the complete libraries. I don't know why I have to do that but maybe it would have helped to set the gcc version before installing oracle. I will try to that next time.
But now we change the default gcc version:

gcc_select 3.3


Change directory to $ORACLE_HOME/lib and

mv libnnz10.dylib libnnz10.dylib.ori


Now make sure that you have added $ORACLE_HOME/bin to your path. If not do so and then

relink all


When everything has been relinked you only have to move that file back

mv libnnz10.dylib.ori libnnz10.dylib


Now you will be able to run dbca and create your database.


Was a tricky one, but Google knew a few links that solved the problem, after reading through a bunch of useless ones.

Update: Just a small note. Please read the comments below for additional information. Matthew has also been able to install Oracle on Leopard already. Thanks again.

Technorati Tags: , , , ,

Bookmark this on Del.icio.us
posted by madhatter @ 11:54 PM


64 Comments:

At 4:58 PM, Anonymous Axel said...

worked well. setting the compiler to gcc 3.3 before you run the installer won't help. you still need to relink. thanks for the well made description.

 
At 1:46 AM, Anonymous Anonymous said...

Thanks for recording this process for Google and for me.

 
At 4:04 AM, Anonymous Anonymous said...

I just tried this but the root.sh script doesn't some wierd stuff.

robert@elastica.com

Did you have to create /opt?

RM=/bin/rm
+ RM=/bin/rm
LN=/bin/ln
+ LN=/bin/ln
ORCLFMAPLOC=/opt/ORCLfmap
+ ORCLFMAPLOC=/opt/ORCLfmap
FILEMAPLOC=$ORCLFMAPLOC/prot1_32 # needs to be prot1_64 for 64 bit platforms
+ FILEMAPLOC=/opt/ORCLfmap/prot1_32

if [ ! -d $ORCLFMAPLOC ];then
$MKDIR $ORCLFMAPLOC
fi
+ '[' '!' -d /opt/ORCLfmap ']'
+ /bin/mkdir /opt/ORCLfmap

 
At 5:17 AM, Anonymous Anonymous said...

robert@elastica.com

What did you do about StartupItems for start/stopping oracle?

 
At 11:20 PM, Anonymous Jonathan said...

I'm have trouble. And, I think it has something to do with my etc/hosts file.

Currently, it reads:
127.0.0.1 localhost
10.2.190.253 localhost
255.255.255.255 broadcasthost
::1 localhost

What should it read?

Everywhere I turn, I get the following error:
"oc4j configuration issue"

 
At 8:19 PM, Blogger madhatter said...

Hi Jonathan.
My /etc/hosts:
192.168.0.139 iBook.local
127.0.0.1 localhost
255.255.255.255 broadcasthost
::1 localhost

But it should work with localhost, too. I only noticed that there may be some trouble when the listener listens on localhost and tnsnames is set up for iBook.local (or something like that)

@Robert: I send you an Email to the address in your posts.

 
At 4:28 PM, Anonymous Anonymous said...

I did everything described here, but the installer will not start. I get the following on my G3 iBook (640MB RAM, 23GB diskspace available), to which I can find no reference on the net:

Any ideas?

avwerk@xs4all.nl

dotto:/Applications/oradata/staging/Disk1 oracle$ ./runInstaller
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/OraInstall2005-07-24_04-07-48PM. Please wait ..../runInstaller: line 59: 363 Bus error $CMDDIR/install/runInstaller $*

 
At 2:45 AM, Anonymous Anonymous said...

can you install on 10.4 desktop? the oracle system reqs supports only 10.4 server.

 
At 9:07 AM, Blogger madhatter said...

Of course. This describes the installation on 10.4 desktop. I have not tried to install on 10.4 server yet. We have Oracle running on non-OSX servers here.

 
At 6:46 AM, Anonymous Anonymous said...

In case you want to know how to start and stop, there's a good howto on this site: http://www.oracle.com/technology/pub/articles/rohrer_macosx_10g.html

 
At 11:48 AM, Blogger madhatter said...

Thank you. I stumbled over that tutorial once, but did not read it to the end. Maybe I will test that script. But I don't need a start-script that much, because I don't use the database every day.
But it would be a good idea to have the stop-script to make sure the database will be shut down when the iBook shuts down.

 
At 12:16 AM, Anonymous Anonymous said...

I cannot get DBCA or the database to start. The install fails half way through with Oracle 10g on Mac OS X Tiger 10.4 with many link and make errors. I installed gcc tools and still fails. How can I fix this? I cannot get the relink all to work as Oracle user.

 
At 5:32 PM, Blogger madhatter said...

Please give me some output from the commands you had trouble with. And please leave a name here, too. It is much easier to reply when you have a name to reference to.

 
At 1:06 AM, Anonymous Anonymous said...

Arvid:

After almost 3 sleepless nights of banging my head against the wall, I fixed the problems and now have Oracle 10g installed and working with my new iBook G4 on mac OS X 10.4 "Tiger".

What I had to do was to completely remove all the Oracle software from my iBook. I went to the Apple Developer Network (ADN) site and downloaded the Xcode 1.1 tools (gcc 3.3) and mlong dec 2003 gcc tools.
Then I installed these developer tools and was able to get Oracle 10g installed and working on my new iBook G4 with Mac OS X 10.4 Tiger. The problem is that the newer versions of Xcode tools such as Xcode 2.2 use a newer version of the gcc tools (gcc 4) which conflicts with the Oracle installer. This is why I kept getting the nasty ld and weird linker errors during the install process. I hope that Oracle fixes this bug in the next release of 10g for Mac OS X. What I found to solve my problems was a blog but this dude named Sergio.
Sergio has a good blog on how to get Oracle 10g installed and working on Mac OS X 10.37 which worked for me with Tiger.

Here is the site:

http://www.orablogs.com/sergio/archives/000781.html

It is written for install Oracle 10g on Mac OS X 10.3 "Panther" but it works for Tiger.
Even though you refer to relink all after the Oracle installer fails, I had zero success with this method. I guess Tiger does not play well yet with Oracle unless you install the legacy gcc 3.3 compiler tools. So to address the workaround of moving the lib files and relink all, maybe it worked for your situation but does not work on my environment. Downgrade to Xcode 1.1 tools does.

Cheers,
Ben- Oracle DBA

 
At 6:12 PM, Blogger madhatter said...

Ben: Sergio's Blog is also a good reference. But the solution you found there you must have read over here. I mentioned that you have to use gcc 3.3, too.

Cheers,
Arvid

 
At 9:24 PM, Anonymous Anonymous said...

Hi,

I posted before about an error I received when trying to install 10g (bus error). I managed to fix it (it apparently was an ownership issue) and am now very, very happy with my 10g database on my ibook.

Thank you very much for sharing this!

Regards,
Adelheid

 
At 8:16 PM, Anonymous Anonymous said...

Guys,

I am having problems getting my Oracle listener working with my Oracle database on Mac OS X 10.4 Tiger. It seems that Oracle has problems connecting to my ethernet or airport network cards to resolve addresses for the tnsnames.ora and listener.ora files. I get these errors when I attempt to start, stop or connect to the listener:

Error listening on: (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
TNS-00512: Address already in use
MacOS X Server Error: 48: Address already in use

Listener failed to start. See the error message(s) above...

I also tried changing entries in the configuration files and /etc/hosts and /etc/services files on the iBook but still no luck. I can connect fine locally to my Oracle database. Also get weird connection refused errors as well. Has anyone been able to solve these listener problems with their Mac OS X and Oracle environment?

 
At 11:43 PM, Blogger madhatter said...

I answered by mail already, but here for everybody else who has similar problems like the last anonymous poster... this is my listener.ora:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = warnearv.local)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = aw01)
(ORACLE_HOME = /Applications/oracle/product/10.1.0/db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = aw01.local)
(ORACLE_HOME = /Applications/oracle/product/10.1.0/db_1)
(SID_NAME = aw01)
)
)

 
At 4:26 AM, Blogger decuser said...

hi, thanks for the clear and concise howto, now if I could only get the relink to work...

I receive the following error when I attempt the command:
relink all

relink all
/Volumes/u01/app/oracle/product/10.1.0/db_1/bin/relink: line 59: [: too many arguments
client_sharedlib: No Makefiles found.
utilities: No Makefiles found.
find: illegal option -- n
find: illegal option -- a
find: illegal option -- m
find: illegal option -- e
find: ollow: No such file or directory
find: ins_*.mk: No such file or directory
all: No Makefiles found.

here are the lines from the relink script that appear to be failing, I would appreciate any assistance you could provide.
if [ x${ORACLE_HOME} = x -o ${ORACLE_HOME} = "" ];
then


and



all)
files="`$FIND $ORACLE_HOME -follow -name ins_*.mk`" ;;

 
At 7:19 AM, Blogger decuser said...

hmm, figured it out - I didn't 'export' the ORACLE_HOME - so the find command was being passed a blank and that screwed everything up.

 
At 9:51 PM, Anonymous Anonymous said...

while performing the relink i get ...

ld: /usr/lib/crt1.o illegal reference to symbol: __objcInit defined in indirectly referenced dynamic library /usr/lib/libobjc.A.dylib
make[1]: *** [/Applications/oracle/product/10.1.0/db_1/sysman/lib/nmupm] Error 1
make: *** [nmupm] Error 2

..google says this maybe an OS X bug... any ideas?

 
At 9:55 PM, Blogger madhatter said...

Hm, hard to say. You have gcc_select 3.3 and set your $ORACLE_HOME?

 
At 7:07 PM, Anonymous Anonymous said...

Okay I've done everything you said and I'm getting the following error message:

ibook:/Applications/oracle/product/10.1.0/db_1/lib oracle$ relink all
/Applications/oracle/product/10.1.0/db_1/bin/relink: line 59: [: too many arguments
relink: cannot execute the following commands:\n
/bin/find /bin/dirname /bin/awk /bin/touch
\nplease change the appropriate MACROS in /Applications/oracle/product/10.1.0/db_1/bin/relink to the correct location on your machine\n

My env is set as follows:
TERM_PROGRAM=Apple_Terminal
TERM=xterm-color
SHELL=/bin/bash
TERM_PROGRAM_VERSION=133
USER=oracle
ORACLE_SID=AW01
ORACLE_BASE=/Applications/oracle
__CF_USER_TEXT_ENCODING=0x259:0:0
PATH=/bin:/sbin:/usr/bin:/usr/sbin:/Applications/oracle/product/10.1.0/db_1/bin
PWD=/Applications/oracle/product/10.1.0/db_1/lib
SHLVL=1
HOME=/Users/oracle
LOGNAME=oracle
ORACLE_HOME=/Applications/oracle/product/10.1.0/db_1
SECURITYSESSIONID=8a1d600
_=/usr/bin/env
OLDPWD=/Applications/oracle/product/10.1.0/db_1/bin
ibook:/Applications/oracle/product/10.1.0/db_1/lib oracle$

Any help you can provide will be greatly appreciated.

 
At 3:58 PM, Blogger madhatter said...

I used the csh, but I can't imagine why there should be any difference. So, no, sorry, I have no idea.

 
At 6:03 PM, Anonymous Anonymous said...

I'm also getting the same error when trying to relink all

ld: /usr/lib/crt1.o illegal reference to symbol: __objcInit defined in indirectly referenced dynamic library /usr/lib/libobjc.A.dylib
make[1]: *** [/Library/Oracle/product/10.1.0/db_1//sysman/lib/nmupm] Error 1
make: *** [nmupm] Error 2

I did set ORACLE_HOME and I have xcode 1.2 (which has gcc 3.3 as recommended by Oracle:

$ gcc -v
Reading specs from /usr/libexec/gcc/darwin/ppc/3.3/specs
Thread model: posix
gcc version 3.3 20030304 (Apple Computer, Inc. build 1640)

I tried using gcc_select but it didn't help... google brought me here, but nowhere else useful :(

 
At 7:42 PM, Blogger madhatter said...

Okay, I really have no clue why you have so much trouble with relinking.
I just did it again to make sure, there have no changes been done through a OSX security update or something like that. It worked without any errors.
So, here is my 'env', maybe you find any hint, where the differences between our configurations are...:

NNTPSERVER=News.eclipse.org
MANPATH=/sw/share/man:/usr/share/man:/usr/local/man:/usr/X11R6/man:/usr/share/o
enssl/man:/usr/share/perl/man:/sw/lib/perl5/5.8.6/man
TERM=xterm-color
HOST=warnearv.local
SHELL=/bin/sh
CPPFLAGS=-I/sw/include
PERL5LIB=/sw/lib/perl5:/sw/lib/perl5/darwin
WINDOWID=8388622
LD_LIBRARY_PATH=
ORACLE_SID=AW01
ORACLE_BASE=/Applications/oracle
HOSTTYPE=powermac
__CF_USER_TEXT_ENCODING=0x1F5:0:3
PATH=/usr/bin:/bin:/sbin:/usr/sbin:/Library/MySQL/bin:/usr/local/pgsql/bin:/usr
local/bin:/usr/X11R6/bin:/usr/local/sbin:/Users/warnearv/bin:/usr/local/subvers
on/bin:/Applications/oracle/product/10.1.0/db_1/bin:/sw/bin:/Users/warnearv/coc
tail/bin
PWD=/var/root
EDITOR=vim
SHLVL=3
HOME=/var/root
OSTYPE=darwin
VENDOR=apple
LOGNAME=warnearv
MACHTYPE=powerpc
LC_CTYPE=de_DE.ISO8859-15
INFOPATH=/sw/share/info:/sw/info:/usr/share/info
DISPLAY=:0.0
ORACLE_HOME=/Applications/oracle/product/10.1.0/db_1
SECURITYSESSIONID=59b1f0
_=/usr/bin/env

 
At 3:55 AM, Anonymous Anonymous said...

After 3 days I finally got Oracle 10g running on a Power Book G4 OS X Server 10.4.

Here are some things I had to do (beside the ones in the tutorial above)
1.- I did the same trick with the file libsqlplus.dylib before relink all.
2.- I checked that I had correctly set ORACLE_HOME.
3.- I commented the first 5 lines (more less) that checks for a valid ORACLE_HOME in the script relink.
4.- I plugged the network cable in my mac so that the finish button in dbca could work (strange, but true).

Hope this helps too.

And thank you madhatter for your help!

 
At 1:32 AM, Anonymous Brad said...

Did the gcc_select 3.3 and libnnz10.dylib move tip while installer was still posting error and the clicked retry. Relink succeeded.
Then when it gave some other error while building something else after relink I moved the file back and did gcc_select 4.0 and click retry.
This seems to work well as you don't have to fix anything.

New to Oracle so I hope this was ok and that it helps someone else.

bgiesbre
at charter
dot net

 
At 2:11 AM, Anonymous Anonymous said...

Hi

I followed your instructions. Everything worked fine until I was asked to login as oracle user in Step 6 (Configure User Environment). I logged in as oracle but I was not allowed to run commands in Terminal (permission denied for even something as simple as creating a directory). Does anyone know what my trouble could be? Thanks for any help you can provide

- Gaby

 
At 9:12 AM, Blogger madhatter said...

Right now I only can imagine that you missed the 'chown' commands in Step 3 and/or 4...
Maybe you can try this again?

 
At 11:41 PM, Blogger Gaby said...

Hello. You were right last time, I had messed up on the permissions I used for oracle before. Thanks for the help. Unfortunately, I am stuck once again. Now, I have a different problem at the following step:

./runInstaller

I was able to get the "Universal Installer: Welcome" window. When I click on "next", I get another window that says:

"Abnormal program termination. An internal error occured. Please provide the following files to Oracle Support:
'Unknown'
'/tmp/OraInstall2007-02-01_04-16-24PM/oraInstall2007-02-01_04-16-24PM.err'
'/tmp/OraInstall2007-02-01_04-16-24PM/oraInstall2007-02-01_04-16-24PM.out'
"
There is an OK button and when I click it, everything dissappears, but I get this java file on my task bar.

Do you know what could be the problem now?
thank you! :)

Gaby

 
At 8:55 AM, Blogger madhatter said...

Gaby, this is strange. I had some trouble with the installer, too, once in a while.
Can you find any more information on that internal error in those files mentioned in the error message?

Cheers,
Arvid

Feel free to email me...

 
At 3:27 AM, Anonymous Anonymous said...

I am getting the fallowing error after installing

ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Mac OS X Error: 2: No such file or directory

 
At 8:56 AM, Blogger madhatter said...

Hello,
I remember seeing such an error message some day, but I can't remember what caused it.
Can you tell me when exactly this message comes up?

 
At 5:51 AM, Anonymous Anonymous said...

When I am trying to start sqlplus. I am not able to connect with any username and password. I am getting the above error

 
At 9:40 AM, Blogger madhatter said...

Do you have a listener running already for the database? Can you connect on port 1521 via telnet instead?

 
At 5:00 PM, Blogger ratna said...

i am able to get into sqlplus using the command sqlplus '/ as sysdba' but no sql command is working in their instead its giving me an error
"ORA-01034: ORACLE not available"

 
At 6:07 PM, Blogger madhatter said...

So there is no startup possible? Do you have called sqlplus as user oracle?

 
At 7:36 AM, Blogger ratna said...

ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/Volumes/u01/app/oracle/product/10.1.0/db_1/dbs/initAW01.ora'

this is the error i am getting when I am trying to start up database

I didnt tried log in as oracle user I am getting to same error as what I got in previoius post

 
At 10:32 AM, Blogger madhatter said...

Are you sure you relinked with gcc set to version 3.3?
Right now I have no real idea what might cause that.

 
At 2:10 PM, Anonymous Anonymous said...

Thx for this great HowTo!!! Everything works now.

One thing, i would like to say additionally: it is necesarry to reboot(!) the machine after configuring the hosts-file. Simple logoff-logon is not working.

greetings from austria
Martin

 
At 4:27 PM, Anonymous Matthew Christy said...

I'm getting the same error as Gabby was, where after the installer runs and I click the first NEXT button, i get an abnormal terminaition error; Tried it on both my MacBook and my Intel iMac.

 
At 5:28 PM, Blogger madhatter said...

I installed only on a iBook, PPC. Maybe that's the difference.

 
At 3:52 AM, Anonymous Matthew Christy said...

Hm.. oracle claims it's universal, but maybe it's not. I'm going to try it on my PPC PowerBook tomorrow while I'm at work..

You're running OS X 10.4.10 with the latest Xcode right (i think 2.1 or something)?? Just to check any differences.

Thanks!

 
At 9:09 AM, Blogger madhatter said...

OSX 10.4.10 and Xcode 2.4.1

 
At 9:09 PM, Anonymous Matthew Christy said...

I got futher with my G5 iMac at work, so it seems to maybe be a problem with the "universal installer" not liking intel-based macs.

I still ran into a snag with the installer, but i think that was my user error not being careful and rushing (because i was at work ;)).

Thanks for the good article. It helped!

 
At 12:28 AM, Anonymous Anonymous said...

i'm installing oracle 10.1.0.3 (Early Adopter) on my Intel Mac OS X Tiger 10.4.10 (Desktop). When I "relink all" using gcc 3.3, I get heaps of errors and fails afterwards:

-----------------------------------------
ld: warning /Volumes/u01/app/oracle/product/10.1.0/db_1/sysman/lib/s0nmem.o cputype (18, architecture ppc) does not match cputype (7) for specified -arch flag: i386 (file not loaded)
ld: warning /Volumes/u01/app/oracle/product/10.1.0/db_1/lib//libclntsh.dylib cputype (18, architecture ppc) does not match cputype (7) for specified -arch flag: i386 (file not loaded)
ld: warning /Volumes/u01/app/oracle/product/10.1.0/db_1/lib//libcore10.a archive's cputype (18, architecture ppc) does not match cputype (7) for specified -arch flag: i386 (can't load from it)
ld: Undefined symbols:
_main
make[1]: *** [/Volumes/u01/app/oracle/product/10.1.0/db_1/sysman/lib/emagent] Error 1
make: *** [emagent] Error 2
----------------------------------------

If you look closely, it seems to it's trying to looking for PPC architecture?

I can't get pass through this step...

 
At 9:28 AM, Blogger madhatter said...

If you take a look at Matthew's comments, it seems that he ran into the same issues.
As I don't have an Intel-based Mac available, I have to admit that I can't work on a solution for those issues.
Donate for a MacBookPro then... ;-)

 
At 8:40 AM, Blogger Matt said...

Hi all, I'm trying to get Oracle installed on Mac OS X Tiger running on a macbook. I've got as far as starting the installer, but I get an error as soon as I press next.

It says "Abnormal program termination", then refers to some error files generated in /tmp.
Opening these files shows the following error:
java.lang.UnsatisfiedLinkError: no oraInstaller in java.library.path

Has anyone come across this? Note that I have no gcc installed - would that help?

 
At 9:43 PM, Anonymous Matthew Christy said...

As I've previously stated, Oracle 10g has issues with the Intel Macs ("Macbook, Macbook Pro, MacPro, current iMac, and current Mac Mini"). It will not install on them, regardless if gcc is installed.

 
At 12:57 AM, Anonymous Matthew Christy said...

FYI, I tried doing this on Leopard.. it was quite the failed attempt:

first nicl has been replaced by dscl.. so i substituted that command in place.

You can't add the ulimit commands to the IPServices file, it no longer exists.

Lastly (and the real kicker), you can't gcc_select 3.3, the command doesn't work, so you can't fix the links and run the dbca. :(

Would love to know if anyone has gotten it to work.

-M

 
At 1:19 AM, Blogger madhatter said...

Matthew, thank you for those details. As I did not have a chance to get Leopard, I haven't tried to install Oracle on it yet, either. But I haven't thought that it will still work.
Another reason why not to upgrade OS X ;-)

 
At 11:16 AM, Blogger Matt said...

In answer to Gaby's question, re the "Abnormal program termination" - I had the same thing. I finally found the solution was to change the CurrentJDK link to point to 1.3 as follows:
cd /System/Library/Frameworks/JavaVM.framework/Versions.
rm CurrentJDK
ln -s 1.3 CurrentJDK

hope that works for you

Matt

 
At 9:39 AM, Blogger ajmanee said...

i did this last step

cd /System/Library/Frameworks/JavaVM.framework/Versions.
rm CurrentJDK
ln -s 1.3 CurrentJDK

but am still getting the same error
for Abnormal Program Term......

ALEX

 
At 9:05 PM, Anonymous Matthew Christy said...

Okay I got it working under leopard (Fresh Install, NOT upgrade).

When installing the Leopard Dev Tools, make sure you select the Customize Button and check the 10.3.9 (gcc 3.3) checkbox, which is not checked by default. This will install gcc 3.3.

Before you select_gcc 3.3 in step 9, you must copy over the gcc_select script from one of the old installations of devtools. I've kindly put it on my domain for download (for those of you who don't have an old install of devtools, or who have done fresh installs of leopard):

http://www.cryosys.com/sql/gcc_select

sudo copy gcc_select /usr/sbin

set r/w/x permissions:

sudo chmod 775 /usr/sbin/gcc_select

continue with step 9.

Currently I got around the ulimit problem by just inserting the commands into a cron until we can get more clarification on Leopards boot sequence and how to execute commands once upon bootup.

Good luck!

 
At 10:29 PM, Blogger madhatter said...

Matthew, thanks a lot for getting us updated information on how to install 10g on Leopard. I really appreciate that you post it here.

 
At 8:25 AM, Anonymous Prashant said...

Mathew,

Can you please help a bit !

I am trying to install on Leopard and I have selected gcc-3.3 using your gcc_select (thanks there!) But I can't seem to go beyond following error. The installer always throw this exception and quits.


ava.lang.UnsatisfiedLinkError: /private/tmp/OraInstall2008-01-26_02-05-57AM/oui/lib/macosx/liboraInstaller.jnilib:


Funny part is liborainstaller.jnilib is available. Don't know whats wrong there.

I tried to use different Java version like 1.3, 1.4 but no use.

Thanks in advance,

Prashant

 
At 12:54 AM, Blogger Nitin said...

I am getting error after running installer
An internal error occured.please provide following files to Oracle support
"Unkown"
"/tmp/OraInstall2008-01-30_7_50_
28AM/OraInstall2008-01-30_7_50-28AM.err"

 
At 5:04 AM, Blogger Nitin said...

i am waiting for answer as i am not able to install

 
At 8:19 AM, Blogger madhatter said...

Nitin, I am sorry to hear that, but that error message does not tell anything about the error that occured. Can you take a look in the specified file and give us a few more information what made the installer crash from it. TIA

 
At 7:31 PM, Blogger Nitin said...

hi
My problem is same which gaby(who posted sane problem before) had
and I think he rectified it ,
can u plz check and let me know any solution

 
At 8:38 PM, Blogger madhatter said...

Nitin, I am also not aware of what caused the trouble at Gaby's installation. We tried to solve that in a private chat back then, but we did not find a solution. My guess was that she had the wrong environment settings and told her mine. She than had not the time to try that and I did not hear about the status from her again.

 
At 1:45 AM, Blogger Nitin said...

hi
can u guide me to install all over again in private chat room .
I am in San diego, USA ,plz let me know time
Thanks

 
At 3:21 AM, Blogger Pedro said...

MATT, thanks for ln -s 1.3 CurrentJDK! That worked!!

 

Post a Comment

Links to this post:

Create a Link

<< Home