Hey Guys, I've been trying to install Oracle 10g on my Macbook pro since last week ( on part-time basis )..still no joy..I've looked up endless forums..tried all I can but kinda given up on solving it by self..hence I'm here!! really appreciate your suggestions..
Oracle installer version : 10.2.0.4.0
OS : Mac OS X 10.6.4
Here are my oracle user and dba group settings..( ran chown oracle:dba /Users/oracle )
dscl . -list /groups gid | grep 600 = dba 600
dscl . -list /users gid | grep 600 = oracle 600
dscl . -list /users uid | grep 600 = oracle 600
Logged on to my macbook pro as 'oracle' user as I could not run oracle installer from my regular user, say 'myuser'
I ran ./runInstaller -J-d32 to bring up the installer wizard. There was no option to select Advanced installation options. I've got welcome page and then it went straight to Oracle edition ( enterprise or standard etc ).
I pretty much went with default settings and clicked install.
I did get Error in invoking target ‘all_no_orcl ipc_g ihsodbc32 error during linking then edited file $ORACLE_HOME/rdbms/lib/ins_rdbms.mk (without exiting installer – just switch to the terminal) and comment out line with $(HSODBC_LINKLINE) Then switched back to the error in the installer and click “Retry”. And installation was successful.
I've also edited java to ad -d32 as the link above.
Oracle net CA went well also...and then dbca fails..( I'm getting ora-03113 end-of-file on communication channel )
here are the contents of configToolFailedCommands (in /Users/oracle/oracle/product/10.2.0/db_1/cfgtoollogs)
/Users/oracle/oracle/product/10.2.0/db_1/bin/dbca -progress_only -createDatabase -templateName General_Purpose.dbc -gdbName dev -sid dev -sysPassword 0524ce87a4c697aa9bec15cb8e5510e77f4631b9d077c613fa -systemPassword 05a875507616bb3541a4df90f138bc7d6a460ce667390a6631 -sysmanPassword 0522aa23f8372c3b80a6703570274141923f452a3dbdbd35b4 -dbsnmpPassword 05cc2ee9d3e0a1a95e15676fd7b7d588b9f08baae39194ef7b -emConfiguration NONE -datafileJarLocation /Users/oracle/oracle/product/10.2.0/db_1/assistants/dbca/templates -datafileDestination /Users/oracle/oracle/oradata/ -responseFile NO_VALUE -characterset AL32UTF8 -obfuscatedPasswords true -sampleSchema true -oratabLocation /Users/oracle/oracle/product/10.2.0/db_1/install/oratab -recoveryAreaDestination NO_VALUE
I had the same problem and run into Ray's guide on how to install Oracle on Snow Leopard. Suprisingly Ray's website was even linked directly from the download site of Oracle :) The key step for me was that the $ORACLE_HOME/bin/oracle binary is not OK and needs to be replaced. It can be downloaded from Ray. (I was a little bit nervous about downloading a binary executable but as Ray is directly linked from Oracle itself he earned my trust.)
TADAAAA: dbca run flawlessly and now I can sqlplus system@orcl :)))))))))))
Thanks mate!! it did the trick!!..
I've logged in as 'oracle' user and can connect to the db using sqlplus system@orcl ( where orcl is sid ).
However, when I log in as a my regular user and try the same thing
sqlpus system@orcl, then I'm getting the following error..
dyld: Library not loaded: /b/227/sqlplus/lib/libsqlplus.dylib
Referenced from: /Users/oracle/oracle/product/10.2.0/db_1/bin/sqlplus
Reason: no suitable image found. Did find:
/Users/oracle/oracle/product/10.2.0/db_1/lib/libsqlplus.dylib: open() failed with errno=13