This discussion is archived
2 Replies Latest reply: Oct 23, 2010 5:31 AM by 748337 RSS

misery with Oracle 10g installation on my mac book pro..HELP!!!

748337 Newbie
Currently Being Moderated
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

.bash_profile of oracle user
==================

ulimit -Hu 512
ulimit -Su 512
ulimit -Hn 10240
ulimit -Sn 10240

umask 022

export ORACLE_BASE=/Users/oracle/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export DYLD_LIBRARY_PATH=$ORACLE_HOME/lib
export ORACLE_SID=dev
PATH=$ORACLE_HOME/bin:$PATH


/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=4194384
kern.sysv.shmmni=4096
kern.maxfiles=12288
kern.maxfilesperproc=10240
net.inet.ip.portrange.first=49152
net.inet.ip.portrange.last=65000
kern.corefile=/cores/core.%P
kern.maxproc=1024
kern.maxprocperuid=512

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.
as per
http://www.pythian.com/news/1937/quick-install-guide-for-oracle-10g-release-2-on-mac-os-x-leopard-intel/

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

/Users/oracle/oracle/product/10.2.0/db_1/bin/isqlplusctl start

attempted to run manually...but not luck..

Here is what I found in the log file..but have not clue what caused these errors..
in /Users/oracle/oracle/product/10.2.0/db_1/cfgtoollogs/dbca/trace.log
======================
[main] [17:53:33:294] [SQLEngine.initialize:274] Starting Reader Thread...
[Thread-4] [17:53:33:428] [StepContext$ModeRunner.run:2478] ---- Progress Needed:=true
[Thread-4] [17:53:33:536] [BasicStep.execute:202] Executing Step : CLONE_DB_CREATION_RMAN_RESTORE
[Thread-4] [17:53:33:537] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-01092
[Thread-4] [17:53:33:537] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-01034
[Thread-4] [17:53:33:537] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-03114
[Thread-4] [17:53:33:537] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-12560
[Thread-4] [17:53:33:537] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-01109
[Thread-4] [17:53:33:537] [BasicStep.configureSettings:304] messageHandler being set=null
[Thread-4] [17:53:33:539] [BasicStep.execute:202] Executing Step : INSTANCE_CREATION
[Thread-4] [17:53:33:539] [BasicStep.configureSettings:304] messageHandler being set=null
[Thread-4] [17:53:33:543] [InitParamAttributes.sortParams:3532] m_sortOn:-1 sortOn:4
[Thread-4] [17:53:33:567] [Host.noEntryinOratab:5115] Check made for oratab arg passed............
[Thread-4] [17:53:33:567] [Oratab.getTempFile:710] Temp oratab: /tmp/oratab
[Thread-4] [17:53:33:730] [BasicStep.configureSettings:304] messageHandler being set=oracle.sysman.assistants.util.UIMessageHandler@24e801
[Thread-4] [17:53:33:730] [CloneRmanRestoreStep.executeImpl:217] Instance Creation went fine..........
[Thread-4] [17:53:33:730] [CloneRmanRestoreStep.executeImpl:224] db_recovery_file_dest=/Users/oracle/oracle/flash_recovery_area
[Thread-4] [17:53:33:730] [CloneRmanRestoreStep.executeImpl:227] db_recovery_file_dest_size=2147483648
[Thread-4] [17:53:33:773] [SQLEngine.setSpool:1758] old Spool = null
[Thread-4] [17:53:33:774] [SQLEngine.setSpool:1759] Setting Spool = /Users/oracle/oracle/product/10.2.0/db_1/cfgtoollogs/dbca/dev/CloneRmanRestore.log
[Thread-4] [17:53:33:774] [SQLEngine.setSpool:1760] Is spool appendable? --> true
[Thread-4] [17:53:33:774] [CloneRmanRestoreStep.executeImpl:320] starting with pfile=/Users/oracle/oracle/admin/dev/pfile/init.ora
[Thread-2] [17:53:35:41] [BasicStep.handleNonIgnorableError:430] oracle.sysman.assistants.util.UIMessageHandler@24e801:messageHandler
[Thread-2] [17:53:35:41] [BasicStep.handleNonIgnorableError:431] ORA-03113: end-of-file on communication channel
:msg
[Thread-4] [17:53:52:220] [SQLEngine.done:1966] Done called
[Thread-4] [17:53:52:221] [SQLEngine.spoolOff:1826] Setting spool off = /Users/oracle/oracle/product/10.2.0/db_1/cfgtoollogs/dbca/dev/CloneRmanRestore.log
oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-03113: end-of-file on communication channel

at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1482)
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.startup(SQLEngine.java:1875)
at oracle.sysman.assistants.dbca.backend.CloneRmanRestoreStep.executeImpl(CloneRmanRestoreStep.java:321)
at oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210)
at oracle.sysman.assistants.util.step.Step.execute(Step.java:140)
at oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2488)
at java.lang.Thread.run(Thread.java:637)
[Thread-4] [17:53:52:225] [BasicStep.configureSettings:304] messageHandler being set=oracle.sysman.assistants.util.UIMessageHandler@24e801
[Thread-4] [17:53:52:225] [StepContext$ModeRunner.run:2504] oracle.sysman.assistants.dbca.backend.CloneRmanRestoreStep.executeImpl(CloneRmanRestoreStep.java:435)
oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210)
oracle.sysman.assistants.util.step.Step.execute(Step.java:140)
oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2488)
java.lang.Thread.run(Thread.java:637)
[Thread-4] [17:53:53:419] [SQLEngine.done:1966] Done called
[Thread-4] [17:53:53:420] [Host.createStepSQLInterface:5948] sid =dev
[Thread-4] [17:53:53:423] [SQLEngine.initialize:242] Execing SQLPLUS/SVRMGR process...
[Thread-4] [17:53:53:455] [SQLEngine.initialize:270] m_bReaderStarted: false
[Thread-4] [17:53:53:455] [SQLEngine.initialize:274] Starting Reader Thread...
[Thread-4] [17:53:53:469] [CloneRmanRestoreStep.cancel:601] Cleaning up partially extracted files failed
[Thread-4] [17:53:54:628] [SQLEngine.done:1966] Done called
[Thread-4] [17:53:54:630] [CloneRmanRestoreStep.cancel:616] RMAN cleanup failed
[Thread-4] [17:53:54:630] [CloneRmanRestoreStep.cancel:617] oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1482)
oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeQuery(SQLEngine.java:703)
oracle.sysman.assistants.dbca.backend.CloneRmanRestoreStep.generateCancelScript(CloneRmanRestoreStep.java:826)
oracle.sysman.assistants.dbca.backend.CloneRmanRestoreStep.cancel(CloneRmanRestoreStep.java:611)
oracle.sysman.assistants.util.step.StepContext$ModeRunner.cancel(StepContext.java:2581)
oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2543)
java.lang.Thread.run(Thread.java:637)
[Thread-4] [17:53:54:630] [CloneDBCreationStep.cancel:889] CloneDBCreationStep.cancel(): nodeList= null
[Thread-4] [17:53:54:631] [SQLEngine.reInitialize:611] Reinitializing SQLEngine...
[Thread-4] [17:53:54:632] [SQLEngine.initialize:242] Execing SQLPLUS/SVRMGR process...
[Thread-4] [17:53:54:664] [SQLEngine.initialize:270] m_bReaderStarted: false
[Thread-4] [17:53:54:664] [SQLEngine.initialize:274] Starting Reader Thread...
[Thread-4] [17:53:54:675] [SQLEngine.initialize:323] Waiting for m_bReaderStarted to be true
[Thread-4] [17:53:55:834] [Oratab.getTempFile:710] Temp oratab: /tmp/oratab
[Thread-4] [17:53:55:835] [OsUtilsBase.deleteFile:744] OsUtilsBase.deleteFile: /Users/oracle/oracle/product/10.2.0/db_1/dbs/orapwdev
[Thread-4] [17:53:55:835] [OsUtilsBase.deleteFile:744] OsUtilsBase.deleteFile: /Users/oracle/oracle/product/10.2.0/db_1/dbs/initdev.ora
[Thread-4] [17:53:55:836] [OsUtilsBase.deleteFile:744] OsUtilsBase.deleteFile: /Users/oracle/oracle/admin/dev/pfile/init.ora
[Thread-4] [17:53:55:836] [CloneDBCreationStep.cancel:930] CloneDBCreationStep.cancel(): bRaw=false
[Thread-4] [17:53:55:837] [OsUtilsBase.deleteFile:744] OsUtilsBase.deleteFile: /Users/oracle/oracle/oradata/dev/system01.dbf
[Thread-4] [17:53:55:837] [OsUtilsBase.deleteFile:744] OsUtilsBase.deleteFile: /Users/oracle/oracle/oradata/dev/undotbs01.dbf
[Thread-4] [17:53:55:837] [OsUtilsBase.deleteFile:744] OsUtilsBase.deleteFile: /Users/oracle/oracle/oradata/dev/sysaux01.dbf
[Thread-4] [17:53:55:837] [OsUtilsBase.deleteFile:744] OsUtilsBase.deleteFile: /Users/oracle/oracle/oradata/dev/users01.dbf
[Thread-4] [17:53:55:838] [OsUtilsBase.deleteFile:744] OsUtilsBase.deleteFile: /Users/oracle/oracle/oradata/dev/redo01.log
[Thread-4] [17:53:55:838] [OsUtilsBase.deleteFile:744] OsUtilsBase.deleteFile: /Users/oracle/oracle/oradata/dev/redo02.log
[Thread-4] [17:53:55:838] [OsUtilsBase.deleteFile:744] OsUtilsBase.deleteFile: /Users/oracle/oracle/oradata/dev/redo03.log
[Thread-4] [17:53:55:839] [OsUtilsBase.deleteFile:744] OsUtilsBase.deleteFile: /Users/oracle/oracle/oradata/dev/control01.ctl
[Thread-4] [17:53:55:839] [OsUtilsBase.deleteFile:744] OsUtilsBase.deleteFile: /Users/oracle/oracle/oradata/dev/control02.ctl
[Thread-4] [17:53:55:839] [OsUtilsBase.deleteFile:744] OsUtilsBase.deleteFile: /Users/oracle/oracle/oradata/dev/control03.ctl
[Thread-4] [17:53:55:879] [SQLEngine.done:1966] Done called


Could any one help me with this issue?.. am I missing anything?..how can I get this to work..and do actual database'y stuff..

Cheers
  • 1. Re: misery with Oracle 10g installation on my mac book pro..HELP!!!
    792476 Newbie
    Currently Being Moderated
    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 :)))))))))))

    Here is the URL to Ray's guide:

    http://blog.rayapps.com/2009/09/14/how-to-install-oracle-database-10g-on-mac-os-x-snow-leopard/

    Edited by: user13387528 on Aug 19, 2010 2:22 AM
  • 2. Re: misery with Oracle 10g installation on my mac book pro..HELP!!!
    748337 Newbie
    Currently Being Moderated
    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
    Trace/BPT trap

    this is my .bash_profie

    export ORACLE_BASE=/Users/oracle/oracle
    export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
    export ORACLE_SID=ora10gdb
    export DYLD_LIBRARY_PATH=$ORACLE_HOME/lib
    PATH=$PATH:$ORACLE_HOME/bin

    did I miss anything else? I'm guessing its a permission thing..but not sure what permissions and what folders..

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points