OK, it's an open book here. What are your comments about Oracle 9i on Mac OS X?
You must be logged in to the O'Reilly Network to post a talkback.

Showing messages 1 through 92 of 92.

• Problem starting instance, ORA-27103
  2004-03-15 20:29:45  gautamarora [Reply | View]
  
  
  Hi, I could not start instance on my powermac G4. Env settings are correct, also the ulimit settings.
  
  SQL>startup nomount pfile='initdb1.ora'
  ORA-27103: internal error
  Mac OS X Error: 19: Operation not supported by device
  Additional information: 103
  Additional information: 33554432
  Additional information: 32096832
  
  I would appreciate your suggestions.
  
  Thanks,
  
  Gautam
• Problem starting instance, ORA-27103
  2004-03-17 11:18:25  gautamarora [Reply | View]
  
  
  Removed pga_aggregate_target from init.ora file
  and I was able to start the instance. Has anyone got it to work with above parameter ?.
  
  Please anyone advice. Can I put the oracle env varibles from /etc/profile to /users/oracle/.bash_profile
  and remove it from /etc/profile ?.
  
  Thanks,
  
  Gautam
  
  
  
• Problem starting instance, ORA-27103
  2004-04-02 09:00:23  murphyatgenome [Reply | View]
  
  
  I got rid of it also. My memory is fuzzy, but I seem to remember discovering that the automatic PGA feature isn't implemented yet on OS X, meaning you have to manually size the various buffers.
  
  You probably already discovered that you can put the environment variable definitions wherever you want. /etc/profile makes the settings conveniently available to all sh/bash users on a box.
  
  This article was a bit sloppy on various counts, as other comments indicate, and I'm surprised it hasn't been perfected over time. I guess the author is hoping you will buy his product or services ;-)
  

• Problems installing Oracle on a Dual Proc G5
  2003-11-14 16:58:36  anonymous2 [Reply | View]
  
  
  I tried installing Oracle on my new G5 running OS X 10.2 but encountered errors. Basically it looks like the database was unable to be created.
  I checked the logs and found that there were many errors talking about not connected to oracle.
  On checking the alert logs i found the following errors
  
  Errors in file /Users/oracle/9iR2/orahome/rdbms/log/ab_pmon_905.trc:
  PMON: terminating instance due to error 470
  Instance terminated by PMON, pid = 905
  
  Errors in file /Users/oracle/9iR2/orahome/rdbms/log/ab_dbw0_945.trc:
  ORA-07445: exception encountered: core dump [semop+8] [SIGFPE] [Invalid floating point operation] [0xE0AEA000] [] []
  
  Errors in file /Users/oracle/9iR2/orahome/rdbms/log/ab_pmon_943.trc:
  ORA-00471: DBWR process terminated with error
  
  PMON: terminating instance due to error 471
  Instance terminated by PMON, pid = 943
  
  Errors in file /Users/oracle/9iR2/orahome/rdbms/log/ab_dbw0_982.trc:
  ORA-07445: exception encountered: core dump [semop+8] [SIGFPE] [Invalid floating point operation] [0xA000522C] [] []
  Fri Nov 14 18:10:51 2003
  Errors in file /Users/oracle/9iR2/orahome/rdbms/log/ab_pmon_980.trc:
  ORA-00471: DBWR process terminated with error
  Fri Nov 14 18:10:51 2003
  PMON: terminating instance due to error 471
  
  Instance terminated by PMON, pid = 980
  
  Errors in file /Users/oracle/9iR2/orahome/rdbms/log/ab_dbw0_1004.trc:
  ORA-07445: exception encountered: core dump [semop+8] [SIGFPE] [Invalid floating point operation] [0xA000522C] [] []
  Fri Nov 14 18:11:20 2003
  Errors in file /Users/oracle/9iR2/orahome/rdbms/log/ab_lgwr_1006.trc:
  ORA-07445: exception encountered: core dump [semop+8] [SIGFPE] [Invalid floating point operation] [0x201000] [] []
  Fri Nov 14 18:11:29 2003
  Errors in file /Users/oracle/9iR2/orahome/rdbms/log/ab_pmon_1002.trc:
  ORA-00471: DBWR process terminated with error
  Fri Nov 14 18:11:29 2003
  PMON: terminating instance due to error 471
  Instance terminated by PMON, pid = 1002
  
  
  I have seen on some of the posts in this group complain about the same issue. What do you think is happening here. Is it some kind of incompatibility with the G5 and dual proc 64 bit processors?
  Is the only solution moving forward is to wait for Oracle to provide a patch?
  Thanks a lot!
  
  
  
• Problems installing Oracle on a Dual Proc G5
  2004-04-09 19:36:53  marlonkh [Reply | View]
  
  
  Did anyone ever get this to work successfully on a dual g5? I get errors pertaining to the floating point processor thta results in a core dump...
  
  Thanks,
  
  Marlon
• Problems installing Oracle on a Dual Proc G5
  2004-02-10 00:02:37  nettdata [Reply | View]
  
  
  I had the exact same problem, and found that it was caused by the kernel setting the maximum processes per user limit at 100.
  
  You could run the "ulimit -u 500" command and it would seem to work, but the value wouldn't change. If you ran the command again, it would spit back an error that said "operation not allowed".
  
  The trick is to be able to set the max proc allowed limit to something higher than the default 100.
  
  
  
  10.3 allows the use of the /etc/sysctl.conf file to set the initial kernel parameters at boot time.
  
  It didn't exist on my system, so (as root) I created it with the following 2 lines:
  
  kern.maxprocperuid=512
  kern.maxproc=2048
  
  After a reboot, I can then launch a bash shell and the user can increase their max allowed processes to 512 or less.
  
  I set this up automatically in the .bashrc script for the user, so that whenever the bash script was launced it ran the following command:
  
  ulimit -u 500
  
  
  This solved all my problems, and hopefully it'll help others that may run into the same issue.
  
  
• Problems installing Oracle on a Dual Proc G5
  2004-02-14 13:55:48  boomkap [Reply | View]
  
  
  On the OS 10.2 jaguar it looks like the /etc/sysctl.conf file gets ignored. Looks like there is hardlimit set in 10.2. I could not set the number via the sysctl -w command.
  When the Oracle instance is started there should be only 5 processes. I am surprised how by changing the number of user processes fixed that as the default is 100 and only 5 are required to get the instance up.
• Problems installing Oracle on a Dual Proc G5
  2004-02-16 15:35:46  boomkap [Reply | View]
  
  
  I upgraded to Panther and was still not able to get an Oracle instance up successfully. I changed the ulimit to set to 500 successfully. I still get a floating point exception. Any ideas on what else i should try
• Problems installing Oracle on a Dual Proc G5
  2004-01-17 13:49:15  anonymous2 [Reply | View]
  
  
  Maybe the answer is that at the end of the day, just like always, Oracle will not run on a Mac.
  
  mgm@nmsu.edu
• Problems installing Oracle on a Dual Proc G5
  2003-11-26 13:32:00  anonymous2 [Reply | View]
  
  
  Unfortunately I don't have a G5 for testing or I might be able to find out more about this issue. Howerver I can suggest checking the trace file which was written during the crash: /Users/oracle/9iR2/orahome/rdbms/log/ab_pmon_1834.trc
  
  There may be helpful info in this file. Normally, for a released product you would be able to send the file to Oracle for analysis. But since this is a developer release you won't be able to do this.
  
  David Simpson
• Problems installing Oracle on a Dual Proc G5
  2003-11-26 12:56:36  anonymous2 [Reply | View]
  
  
  when i try the following command
  startup force nomount pfile=/Users/oracle/9iR2/orahome/dbs/initab.ora
  
  I am able to get the instance started for a few moments. This is what i see
  ORACLE instance started.
  
  Total System Global Area 113873180 bytes
  Fixed Size 450844 bytes
  Variable Size 92274688 bytes
  Database Buffers 20480000 bytes
  Redo Buffers 667648 bytes
  
  
  After a few seconds, the instance crashes and this is what i see in the alert logs.
  
  Wed Nov 26 14:45:48 2003
  Starting ORACLE instance (force)
  LICENSE_MAX_SESSION = 0
  LICENSE_SESSIONS_WARNING = 0
  SCN scheme 2
  Using log_archive_dest parameter default value
  LICENSE_MAX_USERS = 0
  SYS auditing is disabled
  Starting up ORACLE RDBMS Version: 9.2.0.1.0.
  System parameters with non-default values:
  processes = 150
  timed_statistics = TRUE
  shared_pool_size = 50331648
  shared_pool_reserved_size= 4500000
  control_files = /Users/oracle/9iR2/orahome/dbs/ctl18.f, /Users/oracle/9iR2/orahome/dbs/ctl28.f, /Users/oracle/9iR2/orahome/dbs/ctl38.f
  db_block_buffers = 10000
  rollback_segments = system, rback1
  db_domain = US.ORACLE.COM
  global_names = FALSE
  instance_name = ab
  service_names = ab.US.ORACLE.COM
  db_name = ab
  open_cursors = 2000
  PMON started with pid=2
  DBW0 started with pid=3
  LGWR started with pid=4
  CKPT started with pid=5
  SMON started with pid=6
  RECO started with pid=7
  Wed Nov 26 14:45:54 2003
  Errors in file /Users/oracle/9iR2/orahome/rdbms/log/ab_ckpt_1840.trc:
  ORA-07445: exception encountered: core dump [semop+8] [SIGFPE] [Invalid floating point operation] [0x53EB8D44] [] []
  Wed Nov 26 14:46:04 2003
  Errors in file /Users/oracle/9iR2/orahome/rdbms/log/ab_pmon_1834.trc:
  ORA-00470: LGWR process terminated with error
  Wed Nov 26 14:46:04 2003
  PMON: terminating instance due to error 470
  Instance terminated by PMON, pid = 1834
  [kapil-khannas-Computer:orahome/rdbms/log] oracle% tail -10000 alert_ab.log
  Wed Nov 26 14:45:48 2003
  Starting ORACLE instance (force)
  LICENSE_MAX_SESSION = 0
  LICENSE_SESSIONS_WARNING = 0
  SCN scheme 2
  Using log_archive_dest parameter default value
  LICENSE_MAX_USERS = 0
  SYS auditing is disabled
  Starting up ORACLE RDBMS Version: 9.2.0.1.0.
  System parameters with non-default values:
  processes = 150
  timed_statistics = TRUE
  shared_pool_size = 50331648
  shared_pool_reserved_size= 4500000
  control_files = /Users/oracle/9iR2/orahome/dbs/ctl18.f, /Users/oracle/9iR2/orahome/dbs/ctl28.f, /Users/oracle/9iR2/orahome/dbs/ctl38.f
  db_block_buffers = 10000
  rollback_segments = system, rback1
  db_domain = US.ORACLE.COM
  global_names = FALSE
  instance_name = ab
  service_names = ab.US.ORACLE.COM
  db_name = ab
  open_cursors = 2000
  PMON started with pid=2
  DBW0 started with pid=3
  LGWR started with pid=4
  CKPT started with pid=5
  SMON started with pid=6
  RECO started with pid=7
  Wed Nov 26 14:45:54 2003
  Errors in file /Users/oracle/9iR2/orahome/rdbms/log/ab_ckpt_1840.trc:
  ORA-07445: exception encountered: core dump [semop+8] [SIGFPE] [Invalid floating point operation] [0x53EB8D44] [] []
  Wed Nov 26 14:46:04 2003
  Errors in file /Users/oracle/9iR2/orahome/rdbms/log/ab_pmon_1834.trc:
  ORA-00470: LGWR process terminated with error
  Wed Nov 26 14:46:04 2003
  PMON: terminating instance due to error 470
  Instance terminated by PMON, pid = 1834
  

• Success on 10.2.8 (G5?)
  2003-10-08 20:42:49  anonymous2 [Reply | View]
  
  
  Has anyone managed to get this to work on 10.2.8, on a G5? The create database statement fails with the following:
  
  ORA-03113: end-of-file on communication channel
  
  and the trace file contains:
  
  ORA-07445: exception encountered: core dump [0xffff832c] [SIGFPE] [Invalid floating point operation] [0xE00D56CC] [] []
• Success on 10.2.8 (G5?)
  2003-11-10 16:44:30  anonymous2 [Reply | View]
  
  
  I am also having the same problem.
  I've got a Dual G5 2 GHz with 2.5 GB Ram.
  I am running Mac OS X 10.3.1 (not the server version).
• Success on 10.2.8 (G5?)
  2003-10-21 19:43:03  anonymous2 [Reply | View]
  
  
  I am running a dual 2ghz G5 with 1.5 gigs memory. Sqlplus starts up normally but I get the same error you do when trying to create the database.
• Success on 10.2.8 (G5?)
  2003-11-10 13:37:09  sstrom [Reply | View]
  
  
  I am also getting this problem. Has anybody seen a fix yet?

• I can't install and got dyld open library error
  2003-09-11 19:07:30  anonymous2 [Reply | View]
  
  
  Hi David,
  
  Your article is great and I get most part setup. I am using Mac X Server 10.2.6. But "sudo nicl . /machines/G4 ip_address 10.1.0.20" doesn't work for me and it gave me unrecognized command error. And "sudo mkdir /Library/StartupItems/Oracle" gave me directory not exist error.
  
  I neglected startup script and when I run
  ./sqlplus /Users/oracle/v920/create_db.sql, it gave me the following error:
  
  dyld: ./sqlplus can't open library: /Users/oracle/Source/9iR2/rdbms/lib/libclntsh.dylib.9.0 (No such file or directory, errno = 2)
  
  Could you tell me what is wrong? My email address is umshuang@ee.umanitoba.ca. Thank you very much.
  
  Best regards,
  Sheng
  

• I feel like I'm really close
  2003-08-15 12:00:35  inajar [Reply | View]
  
  
  So after about a week of fighting with installing Oracle on a beige G3 tower runner Darwin 6.6 (equivalent to OS X 10.2.6) I feel like I'm really close to having a working installation.
  
  David's article and some of the comments here have been a great help. Thanks.
  
  But I'm still having one problem, I can't get the database to actually startup. Everything else seems to be starting just fine though. When I run the startup script I get the following error early on:
  
  "Starting Oracle databases...
  /Volumes/Oracle/orahome/bin/dbstart: cannot create temp file for here document: Permission denied
  
  Database 'prod1' NOT started."
  
  I've tried to dig through the startup scripts to try to find that error message, but I can't find it anywhere. Does anyone have any ideas what is going on here?
  
  Thanks,
  Tim

• did I just unleashed a wild beast on my hard drive?
  2003-08-14 07:29:08  anonymous2 [Reply | View]
  
  
  The article helped me a whole lot installing oracle on my disk. I then imported a dump file we are currently working on, tricked stuff a little bit to import it without loss (character set didn't match, so I tweaked the terminal into thinking it was MS-Win-1252 compatible, using NLS_LANG param).
  
  Maybe this was a very silly thing to do, maybe this is totally unrelated, but some of the files on my hard drive were eaten up by the contents of the DB i just imported. So when I open some files (in fact, all the files that were lately created on the disk), their content is replaced by content from the imported DB (mostly binary content + some readable text parts).
  
  I think this is a very bad thing, whatever the reason is... Either the Mac's file system is buggy, either Oracle is, but this is not cool at all!
  
  Any thought?
  
  Thanks, have luck ;-)
• did I just unleashed a wild beast on my hard drive?
  2003-08-14 08:50:34  dsimpson1 [Reply | View]
  
  
  It seems like you must have some other problem with the OS or file system in order to be getting this type of problem. You might want to backup everything up, then run the Disk Utility to repair any file system corruption problems. I have not seen problems like you are describing with Oracle running on any platform - including this developer release on MacOS X.
  
  David Simpson

• SQL Plus error
  2003-08-06 14:57:55  anonymous2 [Reply | View]
  
  
  I'm just trying to use SQL Plus to connect to a oracle database on a different server (8.1.7) so I didn't create a database on my G4 laptop. I just followed the steps up to configuring the env variables and the limits. When I try to run SQL Plus, I get the following:
  
  Error accessing PRODUCT_USER_PROFILE
  Warning: Product user profile information not loaded!
  You may need to run PUPBLD.SQL as SYSTEM
  Bus error (core dumped)
  
  
  I did some research and the above error can be fixed by doing exactly what it says but I'm not the admin on the db server. Also the above error is not supposed to kill sql plus.. any ideas ? I'm used to using SQL plus on UNIX boxes and don't want to use 3rdparty GUI tools on OSX.

• java_pool_size
  2003-08-02 08:18:25  williamr [Reply | View]
  
  
  I notice the sample init.ora size contains the following:
  
  java_pool_size =150000000
  # small system - java_pool_size=25000000
  # medium system - java_pool_size=50000000
  # large system - java_pool_size=100000000
  
  50% larger than the suggested "large system" size seems an odd choice for a test setup, particularly when Java is not even available in this release of the database. After some research I set mine as:
  
  java_pool_size = 1
  
  This gets rounded up to the system "granule" size, in my case 4M, and I save myself a whole stack of memory.
  
  Also while I'm at it, "prod1" seems an odd choice of database name. Surely it will be a dev/test/scratch database rather than production, and I don't see what "1" buys you. I made mine "dev". But then I'm a nitpicker...
  
• java_pool_size
  2003-08-02 08:21:06  williamr [Reply | View]
  
  
  Oops - apologies for typo in first line of the above post.

• Native Compilation
  2003-07-19 09:58:48  williamr [Reply | View]
  
  
  One of 9i's new features I have been wanting to try out is Native Compilation, which allows you to compile your PL/SQL packages as native C programs. However the makefile supplied doesn't work, and seems to have been lifted untested from a Solaris installation. Has anyone been able to get this to work?
  
  e.g. make these settings in your init${ORACLE_SID}.ora file:
  plsql_native_library_dir = '/Users/oracle/9iR2/orahome/plsql_compiled_code'
  plsql_native_library_subdir_count = 0
  
  Then at the SQL> prompt:
  alter session set plsql_compiler_flags = native;
  alter package somepackage compile;
  
  (For some reason you get more error information if you do this from the 'oracle' Unix account rather than over a SQL*Net connection.)
  
  Even when you have corrected the obvious errors to do with missing directories and the wrong path for gcc (which itself needs installing with the Apple Developer CDs) you'll see compiler errors about .so files, which AFAIK don't exist on Macs. Not speaking C, I can't go much further. Any thoughts?
  
  
• Native Compilation
  2003-07-19 10:36:40  dsimpson1 [Reply | View]
  
  
  The native compilation feature does not yet appear to be implemented on MacOS X. Even on Solaris there are some significant issues with this feature in certain situations. Here is my example Solaris makefile with some additional notes: http://www.dotcomsolutionsinc.net/products/installgen/sol_920_64bit_files/installgen_sol920_63_.html
  
  This feature is best limited to PL/SQL code which you have written yourself as opposed to compiling all of the PL/SQL in the database at this time. And it does seem to work well under Solaris - my little test program which just runs a loop runs about 2x faster, and I think that some types of code may run 8x faster.
  
  However the good news that I am seeing posted on the MacOS X specific newsgroup at Oracle's OTN is that MacOS X will be fully supported in the next major release. There have been hints that Oracle 10i will be announced at OracleWorld Sept 7 - 11th in San Francisco. Apple is scheduled to have a booth at OracleWorld too.
• Native Compilation
  2003-07-23 15:58:36  williamr [Reply | View]
  
  
  Well everything seems to be in place for native compilation - 'alter package compile' gets as far as calling gcc, make and ld, it's just that the makefile seems to be designed for creating shared libraries on Solaris. I wonder what the makefile from an HP machine would look like for example. It's frustrating since I don't know C - if I could just spend six months at college learning about relinking object files or whatever they're called, I feel I might be able to get this feature to work...

• Oracle seems to work, but create_db does not
  2003-06-17 23:17:12  anonymous2 [Reply | View]
  
  
  I went through the steps and the DB will come up, although the SystemStarter gives a permission denied error. My question though is on the create_db script which gives a database not open for each script that gets called. What am I missing ? What output would help trouble shoot ?
  As I said the DB seem to come up ok with dbstart and it can be seen by tnsping, but there's nothing there table wise.
  As you can probably tell I'm new to Oracle.
  
  Pete
  
  oracle: ~ % sqlplus /nolog @/Users/oracle/db_create.sql
  
  SQL*Plus: Release 9.2.0.1.0 - Developer's Release on Wed Jun 18 01:10:39 2003
  
  Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
  
  Connected.
  limit: maxproc: Can't set limit
  
  File created.
  limit: maxproc: Can't set limit
  limit: maxproc: Can't set limit
  
  SQL> spool /Users/oracle/v920/assistants/dbca/logs/CreateDB.log
  SQL> shutdown abort
  ORACLE instance shut down.
  SQL> connect / as SYSDBA
  Connected to an idle instance.
  SQL> startup nomount pfile="/Users/oracle/v920/dbs/initprod1.ora";
  ORACLE instance started.
  
  Total System Global Area 352915720 bytes
  Fixed Size 450824 bytes
  Variable Size 335544320 bytes
  Database Buffers 16777216 bytes
  Redo Buffers 143360 bytes
  SQL> CREATE DATABASE PROD1
  2 MAXINSTANCES 1
  3 MAXLOGHISTORY 1
  4 MAXLOGFILES 50
  5 MAXLOGMEMBERS 5
  6 MAXDATAFILES 100
  7 DATAFILE '/Volumes/Oracle/v920/prod1/system01.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT 1024K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
  8 UNDO TABLESPACE "undotbs" DATAFILE '/Volumes/Oracle/v920/prod1/undo01.dbf' SIZE 500M
  9 DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/Volumes/Oracle/v920/prod1/temp01.dbf' SIZE 55M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
  10 CHARACTER SET AL32UTF8
  11 NATIONAL CHARACTER SET AL16UTF16
  12 LOGFILE GROUP 1 ('/Volumes/Oracle/v920/prod1/redo01.log', '/Volumes/Oracle/v920/prod1/redo01g1f2.log') SIZE 10M,
  13 GROUP 2 ('/Volumes/Oracle/v920/prod1/redo02.log', '/Volumes/Oracle/v920/prod1/redo02g2f2.log') SIZE 10M,
  14 GROUP 3 ('/Volumes/Oracle/v920/prod1/redo03.log', '/Volumes/Oracle/v920/prod1/redo03g3f2.log') SIZE 10M
  15 set time_zone = 'America/Chicago';
  CREATE DATABASE PROD1
  *
  ERROR at line 1:
  ORA-01092: ORACLE instance terminated. Disconnection forced
  
  
  SQL>
  SQL> spool off
  SQL>
  SQL> spool /Users/oracle/CreateDBFiles.log
  SQL> CREATE TABLESPACE "TOOLS" LOGGING DATAFILE '/Volumes/Oracle/v920/prod1/tools01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL;
  CREATE TABLESPACE "TOOLS" LOGGING DATAFILE '/Volumes/Oracle/v920/prod1/tools01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
  *
  ERROR at line 1:
  ORA-03114: not connected to ORACLE
  
  

• happy face on ibook
  2003-06-11 18:50:47  xgironx [Reply | View]
  
  
  i now have ora running on my ibook/osxserver/640mbRAM; since I'm ~new to *ix, i ran into env var issues that led to the type of memory issue already posted.
  since ~new to oracle, took some coaching from my oracle teacher, some issues:
  i put ulimit settings in my .profile;
  forgot to put rollback segments online;
  i started with the instructions in this article, but i so mangled various conf/env var files that i trashed it all and started over. looking back over the instructions, more of them make sense. i reckon they were written for a more sophisticated install than i could really grasp.
  this was an excellent learning experience for me as I'd only had one short course on solarisAdmin;
  i took lots o notes on my process; i'll try to share any info i can; next step is to try to run jdeveloper;
  best
  justin
  

• Problem with Listener on 10.2.6?
  2003-05-21 18:32:19  webtoad [Reply | View]
  
  
  Hello:
  
  I'm having trouble getting the Listener to start, I think since I installed 10.2.6 (not the Server version). Can someone else please tell me if the listener works on their 10.2.6 box?
  
  My error message is:
  
  LSNRCTL for MacOS X Server: Version 9.2.0.1.0 - Beta on 21-MAY-2003 21:31:20
  
  Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
  
  Starting /Users/oracle/9iR2/orahome/bin/tnslsnr: please wait...
  
  TNSLSNR for MacOS X Server: Version 9.2.0.1.0 - Beta
  System parameter file is /Users/jfdavis/9iR2/orahome/network/admin/listener.ora
  Log messages written to /Users/jfdavis/9iR2/orahome/network/log/listener.log
  Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=acsoft.biz)(PORT=1521)))
  Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=acsoft.biz)(PORT=2481)))
  
  Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
  TNS-12547: TNS:lost contact
  TNS-12560: TNS:protocol adapter error
  TNS-00517: Lost contact
  MacOS X Server Error: 54: Connection reset by peer
  Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=2481)))
  TNS-12541: TNS:no listener
  TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
  MacOS X Server Error: 61: Connection refused
  
  Thanks for any help!
  
  Jay Davis
  Atlanta
• Problem with Listener on 10.2.6?
  2004-02-18 21:08:11  gpower [Reply | View]
  
  
  Good google tips can be found here: http://groups.google.ca/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=1ac7c7b3.0401011219.7946b3d3%40posting.google.com&rnum=1&prev=/groups%3Fq%3Dlsnrctl%2Bmac%2Bos%2Bx%26ie%3DUTF-8%26oe%3DUTF-8%26hl%3Den%26btnG%3DGoogle%2BSearch
  
  Best advice for me was to "rename the file listener.ora, or move it to a subdirectory" and just run $ORAHOME/bin/lsnrctl. From there you can query its status as well as start and stop it. "If there is no listener.ora file to be read, the listener "listener" will start, listening on the default network address on port 1521."
• Problem with Listener on 10.2.6?
  2003-07-15 07:28:26  anonymous2 [Reply | View]
  
  
  Did you ever get Oracle running correctly under 10.2.6? Can you reply to my address at rwoodruf@umich.edu.
  
  Thanks.

• Is anyone using this with PHP?
  2003-05-16 13:10:27  anonymous2 [Reply | View]
  
  
  Now that Oracle is up and running, I would like to connect from PHP. I recompiled apache and php to add Oracle8 support, but whenever I try to connect, the oci8 extension crashes.
  
  So if anyone here has PHP up and running with Oracle, maybe you could post or drop me a line. I appreciate it.
  
  Thanks,
  -sapporo. <sapporo@land.ru>

• I got it to work on a Powerbook 17 inch... couple of quirks...
  2003-05-14 06:31:17  anonymous2 [Reply | View]
  
  
  The trick is making sure to customize ALL of the variables in all of the locations. I was hung up on setting maxproc with ulimit/limit because it is limited by the operating system so that regular users cannot change the soft limit at all... ever. The author, David Simpson, responded to my query and updated that part of his article. Root had no problem, but since this is for on the go development, I think I'll be Ok. I bet that limitation is removed in Mac OS X Server. Also, this thing eats up RAM! I've got a gig and a few apps running in the background and no spare RAM. I'm going to tune my parameters to fix it up. Oracle on mac, it finally happened! Thank you Oracle and David!
  
  -Ferris
  chris22cali@yahoo.com

• Errata
  2003-04-21 08:18:44  anonymous2 [Reply | View]
  
  
  Mr. Simpson,
  Thank you for this cook-book recipe on getting Oracle up and running quicly under Mac OS X. The instructions were easy to follow. I wish to contribute some points that may clarify certain steps to help others:
  
  * under Create Unix user:
  sudo nicl . -append /users/oracle group dba
  
  I believe this entry is completely unnecessary; the user's primary group affiliation is already determined by his "gid" entry.
  
  * for editing /etc/hostconfig
  PORTMAP=-YES-
  
  For those of us running the non-server version of Mac OS X, this entry is meaningless. There is no startup item that makes use of the PORTMAP flag. (The RPCSERVER flag is used to turn on 'portmap').
  
  * getting around ulimit -u 100 (max user processes)
  su - oracle
  
  I believe you meant to use the "m" flag. The only way I was able to get 500 processes following your instructions was to:
  login root
  su -m oracle
  
  * Oracle's startup and shutdown scripts
  /Users/oracle/v920/bin/dbstart
  
  There needs to be one modification made to this script. Under Mac OS X, the /bin/ps command does not support the -f flag (even as root user). Thus this line in the dbstart script:
  pmon=`ps -ef | egrep pmon_$ORACLE_SID | grep -v grep`
  
  needs to be changed to:
  pmon=`ps -e | egrep pmon_$ORACLE_SID | grep -v grep`
  
  * tns and listener configuration
  $ORACLE_HOME/network/admin/tnsnames.ora
  $ORACLE_HOME/network/admin/listener.ora
  
  I had copied and pasted your config for these files. They did not work until I erased the carriage returns for each definition (probably part of the formatting to fit on these web pages). Just for the benefit of others, the following definitions should all be one one line, instead of broken across several lines:
  PROD1 = ...
  LISTENER = ...
  SID-LIST-LISTENER = ...
  
  I wish to also make a request of the author. As a Java developer, I am familiar with SQL commands, but have very vague notions about all of these steps involved in installation or the Oracle server and its default databases. Could you recommend any good references that would provide background on some of the topics that you have touched upon (i.e. listener configuration, configuration of the oracle server, functions of the various components of this server)? The amount of documentation that comes with this download from Oracle is pathetic.
  
  Thanks for providing this substantive how-to; Oracle should distritbute your article as part of its ReleaseNotes.pdf!
  
  -A Shirazi
• Errata
  2003-04-21 10:36:17  dsimpson1 [Reply | View]
  
  
  A Shirazi,
  Thank you for your kind words and helpful comments. I think that most of these items make nice improvements/fixes.
  I actually didn't intend to use su -m but maybe you have found a better way to implement this functionality. I will need to do some additional testing to see how well it works.
  Looks like I missed that ps -ef (it is from my Solaris scripts), I think that I meant to use ps -aux (which is what I have tried to start using on MacOS X).
  
  Most of the Oracle 9i DBA books relating to Solaris could be helpful to you. I put a listing of reference books on my website (many of which are from O'Reilly): http://www.dotcomsolutionsinc.net/products/installgen/installgen_resources.html#macosx
  
  I have generally added some comments on this listing for the books which I have read.
  
  Also, you can look at the Solaris version of the Oracle 9.2 documentation here at the Oracle website: docs.oracle.com
  
  The basic functionality of Listeners and configuration and networking in general will work the same on any UNIX type of platform. When Oracle releases Oracle 9.2 on MacOS X, you will receive a documentation CD as part of the CD package from the Oracle Store. These CD packages are generally $40 for each platform. The documentation is customized to the extent which is necessary for each platform. Most documentation files will stay the same as for other flavors of UNIX, but platform specific install tasks get re-written.
  
• Errata
  2003-05-03 09:11:00  anonymous2 [Reply | View]
  
  
  Thanks for the link to the books. I certainly have a lot of reading to do in the near future! It's a bit overwhelming after just having learned SQL 92 to realize that there is still so much more to learn.
  
  I found one additional correction necessary for this article: when creating the Oracle startup item (/Library/StartupItems/Oracle/Oracle file) the commands that maniplate the log files will fail because of incorrect capitalization. Under the sections beginning with:
  <font color="blue"># Rotate the Oracle alert error log before database starts</font>
  you have used 'MV' and 'CP'. They should be changed to 'mv' and 'cp' respectively.
  
  The restart section could also be made shorter by simply calling the StopService and StartService methods. Listed below is my modification of your startup item. It also makes use of an entry in the /etc/hostconfig file to turn on and off the startup item, similar to many of the other server startup items. If one decides to use this modified startup item (see below), they will also need to add this line to their /etc/hostconfig file:
  <font color="blue">ORACLEDBSERVER=-YES-</font>
  
  -A. Shirazi
  
  /Library/StartupItems/Oracle/Oracle
  

  #!/bin/sh
  
  . /etc/rc.common
  
  
  
  SetOracleEnv() {
  
    set +o nounset   # otherwise set -u in rc.common gives unbound errors below
  
    # define globally used paths and variables
  
    PATH=/bin:/sbin:/usr/bin:/usr/sbin:.
  
    ORACLE_BASE=/Users/oracle/v920
  
    ORACLE_HOME=/Users/oracle/v920
  
    ORACLE_OWNER=oracle
  
    ORACLE_OWNER_PATH=/Users/oracle
  
    ORACLE_GROUP=dba
  
    PATH=$PATH:$ORACLE_HOME/bin
  
    SRCHOME=$ORACLE_HOME
  
    ORACLE_SID=prod1
  
    CLASSPATH=$ORACLE_HOME/DBCreate/oradev/classes/orapts.jar:$ORACLE_HOME/jdbc/lib/classes12.zip:$CLASSPATH
  
    LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
  
    DYLD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib:$DYLD_LIBRARY_PATH
  
    ORAENV_ASK=NO
  
    TNS_ADMIN=$ORACLE_HOME/network/admin
  
    TERM=vt100
  
    NLS_LANG=AMERICAN_AMERICA.US7ASCII
  
    
  
    export PATH ORACLE_BASE ORACLE_HOME SRCHOME ORACLE_SID CLASSPATH LD_LIBRARY_PATH DYLD_LIBRARY_PATH ORACLE_OWNER TNS_ADMIN TERM NLS_LANG
  
    
  
    ORA_BDUMP_DIR=/Volumes/u01/bdump/
  
    OEM_ADMIN=admin
  
    OEM_ADMIN_PASSWORD=zx-vnm
  
    
  
    export OEM_ADMIN OEM_ADMIN_PASSWORD ORA_BDUMP_DIR
  
    
  
    # set required ulimit parameters for Oracle DB
  
    ulimit -c unlimited
  
    ulimit -d unlimited
  
    ulimit -s 65536
  
    ulimit -u 500
  
    ulimit -n 10000
  
  }
  
  
  
  
  
  StartService() {
  
    if [ "${ORACLEDBSERVER:=-NO-}" = "-YES-" ]; then
  
      ConsoleMessage "Starting Oracle DB Server"
  
  
  
      SetOracleEnv
  
      if [ ! -f $ORACLE_HOME/bin/dbstart -o ! -d $ORACLE_HOME ]; then
  
        echo "Warning: Unable to proceed with Oracle DB startup"
  
        echo ' (cannot find one or both of dbstart or $ORACLE_HOME)'
  
        exit 78 # EX_CONFIG
  
      fi
  
      
  
      # Rotate the Oracle alert error log before database starts
  
      LOG=alert_$ORACLE_SID.log
  
      cd $ORA_BDUMP_DIR
  
      test -f $LOG.5 && mv $LOG.5 $LOG.6
  
      test -f $LOG.4 && mv $LOG.4 $LOG.5
  
      test -f $LOG.3 && mv $LOG.3 $LOG.4
  
      test -f $LOG.2 && mv $LOG.2 $LOG.3
  
      test -f $LOG.1 && mv $LOG.1 $LOG.2
  
      test -f $LOG.0 && mv $LOG.0 $LOG.1
  
      mv $LOG $LOG.0
  
      
  
      su $ORACLE_OWNER -c "$ORACLE_HOME/bin/dbstart"
  
      su $ORACLE_OWNER -c "$ORACLE_HOME/bin/agentctl start"
  
      su $ORACLE_OWNER -c "$ORACLE_HOME/bin/lsnrctl start"
  
      # su $ORACLE_OWNER -c "$ORACLE_HOME/bin/oemctl start oms &"
  
      
  
    fi
  
  }
  
  
  
  StopService() {
  
    # stop in reverse order from startup process
  
    # su $ORACLE_OWNER -c "$ORACLE_HOME/bin/oemctl stop oms $OEM_ADMIN/$OEM_ADMIN_PASSWORD &"
  
    su $ORACLE_OWNER -c "$ORACLE_HOME/bin/agentctl stop"
  
    su $ORACLE_OWNER -c "$ORACLE_HOME/bin/lsnrctl stop"
  
    su $ORACLE_OWNER -c $ORACLE_HOME/bin/dbshut
  
  }
  
  
  
  RestartService() {
  
    StopService
  
    StartService
  
  }
  
  
  
  RunService "$1"

• Errata
  2003-05-03 09:15:14  ashirazi [Reply | View]
  
  
  Whoops! It looks like some of the HTML tags were printed literally in my last post. The entry for the /etc/hostconfig should be without tags, and should read:
  ORACLEDBSERVER=-YES-
  
  One can add this flag to the /etc/hostconfig file with:
  sudo sh -c 'echo "ORACLEDBSERVER=-YES-" >> /etc/hostconfig'
  
  I'm not sure if you had mentioned it already, but one can use the startup item server to stop the Oracle server before a shutdown or restart with the following command:
  sudo SystemStarter stop "Oracle 9.2.0 Database Server"
  
  In my case I have also replaced the long "Oracle 9.2.0 Database Server" string in the StartupParameters.plist file with the more succint "oracleDB". I thus can use these succint commands:
  sudo SystemStarter stop oracleDB
  sudo SystemStarter start oracleDB
  sudo SystemStarter restart oracleDB
  
  I also forgot to set the environment variables in the StopService() and RestartService() methods in my previous post. Here are the relevant files posted again for clarity:
  
  /Library/StartupItems/Oracle/StartupParameters.plist
  --------------------------------------------
  

  <?xml version="1.0" encoding="UTF-8"?>
  
   <!DOCTYPE plist PUBLIC "-//Apple Computer//DTD PLIST 1.0//EN" 
  
  "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
  
   <plist version="1.0">
  
   <dict>
  
   <key>Description</key>
  
   <string>Oracle 9.2.0 Database Server</string>
  
   <key>Provides</key>
  
   <array>
  
   <string>oracleDB</string>
  
   </array>
  
   <key>Requires</key>
  
   <array>
  
   <string>Disks</string>
  
   </array>
  
   <key>Uses</key>
  
   <array>
  
   <string>Network</string>
  
   </array>
  
   <key>OrderPreference</key>
  
   <string>Late</string>
  
   </dict>
  
   </plist>

  
  
  
  /Library/StartupItems/Oracle/Oracle
  -------------------------------
  

  #!/bin/sh
  
  . /etc/rc.common
  
  
  
  SetOracleEnv() {
  
    set +o nounset   # rc.common had previously set -u
  
    # define globally used paths and variables
  
    PATH=/bin:/sbin:/usr/bin:/usr/sbin:.
  
    ORACLE_BASE=/Users/oracle/v920
  
    ORACLE_HOME=/Users/oracle/v920
  
    ORACLE_OWNER=oracle
  
    ORACLE_OWNER_PATH=/Users/oracle
  
    ORACLE_GROUP=dba
  
    PATH=$PATH:$ORACLE_HOME/bin
  
    SRCHOME=$ORACLE_HOME
  
    ORACLE_SID=prod1
  
    CLASSPATH=$ORACLE_HOME/DBCreate/oradev/classes/orapts.jar:\
  
  $ORACLE_HOME/jdbc/lib/classes12.zip:$CLASSPATH
  
    LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
  
    DYLD_LIBRARY_PATH=$ORACLE_HOME/lib:\
  
  $ORACLE_HOME/rdbms/lib:$DYLD_LIBRARY_PATH
  
    ORAENV_ASK=NO
  
    TNS_ADMIN=$ORACLE_HOME/network/admin
  
    TERM=vt100
  
    NLS_LANG=AMERICAN_AMERICA.US7ASCII
  
    
  
    export PATH ORACLE_BASE ORACLE_HOME SRCHOME \
  
  ORACLE_SID CLASSPATH LD_LIBRARY_PATH \
  
  DYLD_LIBRARY_PATH ORACLE_OWNER TNS_ADMIN \
  
  TERM NLS_LANG
  
    
  
    ORA_BDUMP_DIR=/Volumes/u01/bdump/
  
    OEM_ADMIN=admin
  
    OEM_ADMIN_PASSWORD=zx-vnm
  
    
  
    export OEM_ADMIN OEM_ADMIN_PASSWORD ORA_BDUMP_DIR
  
    
  
    # set required ulimit parameters for Oracle DB
  
    ulimit -c unlimited
  
    ulimit -d unlimited
  
    ulimit -s 65536
  
    ulimit -u 500
  
    ulimit -n 10000
  
  }
  
  
  
  
  
  StartService() {
  
    if [ "${ORACLEDBSERVER:=-NO-}" = "-YES-" ]; then
  
      ConsoleMessage "Starting Oracle DB Server"
  
  
  
      SetOracleEnv
  
      if [ ! -f $ORACLE_HOME/bin/dbstart -o ! -d $ORACLE_HOME ]; then
  
        echo "Warning: Unable to proceed with Oracle DB startup"
  
        echo ' (cannot find one or both of dbstart or $ORACLE_HOME)'
  
        exit 78 # EX_CONFIG
  
      fi
  
      
  
      # Rotate the Oracle alert error log before database starts
  
      LOG=alert_$ORACLE_SID.log
  
      cd $ORA_BDUMP_DIR
  
      test -f $LOG.5 && mv $LOG.5 $LOG.6
  
      test -f $LOG.4 && mv $LOG.4 $LOG.5
  
      test -f $LOG.3 && mv $LOG.3 $LOG.4
  
      test -f $LOG.2 && mv $LOG.2 $LOG.3
  
      test -f $LOG.1 && mv $LOG.1 $LOG.2
  
      test -f $LOG.0 && mv $LOG.0 $LOG.1
  
      mv $LOG $LOG.0
  
      
  
      su $ORACLE_OWNER -c "$ORACLE_HOME/bin/dbstart"
  
      su $ORACLE_OWNER -c "$ORACLE_HOME/bin/agentctl start"
  
      su $ORACLE_OWNER -c "$ORACLE_HOME/bin/lsnrctl start"
  
      # su $ORACLE_OWNER -c "$ORACLE_HOME/bin/oemctl start oms &"
  
      
  
    fi
  
  }
  
  
  
  StopService() {
  
    SetOracleEnv
  
    # stop in reverse order from startup process
  
    # su $ORACLE_OWNER -c "$ORACLE_HOME/bin/oemctl \
  
  stop oms $OEM_ADMIN/$OEM_ADMIN_PASSWORD &"
  
    su $ORACLE_OWNER -c "$ORACLE_HOME/bin/agentctl stop"
  
    su $ORACLE_OWNER -c "$ORACLE_HOME/bin/lsnrctl stop"
  
    su $ORACLE_OWNER -c $ORACLE_HOME/bin/dbshut
  
  }
  
  
  
  RestartService() {
  
    SetOracleEnv
  
    StopService
  
    StartService
  
  }
  
  
  
  RunService "$1"

• Does iSQL*Plus work?
  2003-04-18 13:47:28  kiramar [Reply | View]
  
  
  Has anyone been able to run iSQL*Plus via a web browser yet?

• Release Notes Trouble w/./createDB >& dblog
  2003-04-16 19:50:09  kiramar [Reply | View]
  
  
  I'm just looking for the basic install so I'm following the release notes. When I get to step 7 "./createDB >& dblog" I get "Permission Denied". I checked the obvious, permissions and ownership and assigned the oracle user, but still no joy... Does anyone have any suggestions for this problem?
  
  Rich
• It works
  2003-04-18 13:43:17  kiramar [Reply | View]
  
  
  The problem I had was because I wanted to install on a different drive and directory. Although I changed the scripts to reflect this, it still gave me trouble. Anyway, I cleared enough room on the main drive and installed there and it works. Now I can move on to practicing pl/sql for my oracle intro class.
  
  Thank you for this fine article which I plan on tackling soon.
  
  Rich

• cannot start listener
  2003-04-03 23:45:41  anonymous2 [Reply | View]
  
  
  bash-2.05a$ lsnrctl start
  
  LSNRCTL for MacOS X Server: Version 9.2.0.1.0 - Beta on 04-APR-2003 00:44:27
  
  Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
  
  Starting /Users/oracle/v920/bin/tnslsnr: please wait...
  
  TNSLSNR for MacOS X Server: Version 9.2.0.1.0 - Beta
  System parameter file is /Users/oracle/v920/network/admin/listener.ora
  Log messages written to /Users/oracle/v920/network/log/listener.log
  TNS-01150: The address of the specified listener name is incorrect
  
  Listener failed to start. See the error message(s) above...
  
  -- I tried using BBEdit and it still didn't resolve my problem
  
  can someone help?

• Memory error
  2003-04-01 11:31:07  anonymous2 [Reply | View]
  
  
  I get the following error message. Any ideas?
  
  ORA-27102: out of memory
  Mac OS X Error: 41591388: Unknown system error
  Additional information: -1879010124
  Additional information: -1879010036
  Additional information: -1073763840
  
  I am running a 800MHz Powerbook w/10GB free and 768 MB RAM.
• Memory error
  2003-07-06 16:06:23  anonymous2 [Reply | View]
  
  
  Yes ...
  
  Make sure when you run set_ulimit that you do ". ./set_ulimit" not merely "./set_ulimit"
  
  I've verified that failing to do so causes the error by ummm accidently making the same mistake myself!
  
  If you type "./set_ulimit" it will fork a new process and set the limits for that process, rather than your current shell process. So when you run SQL*Plus your current shell process still has the itty-bitty default limits, far too small to run Oracle.
  
  Hope this helps and enjoy!
  
• Memory error
  2003-04-02 07:39:44  dsimpson1 [Reply | View]
  
  
  It seems like you have enough memory and disk space for the install. The first things I would look at are the ulimit and environment variable settings.
  
  David Simpson

• Cannot get TNSListener to start
  2003-04-01 10:44:01  dmknuth [Reply | View]
  
  
  I keep getting the same error when I try to start the listener:
  Started with pid=811
  TNS-01150: The address of the specified listener name is incorrect
  Yet, I am able to ping the hostname properly. What do I need to correct?
• Cannot get TNSListener to start
  2003-04-01 10:57:42  dmknuth [Reply | View]
  
  
  I solved my own problem. Apparently some invisible characters got into the scripts when I copied the text from the web page. BBEdit fixed this for me. Seems to work fine now.

• Summary of Requirements?
  2003-03-19 07:18:23  anonymous2 [Reply | View]
  
  
  In a nutshell, I've got a 400MHz G3 iMac running 10.2.4 (not server) with 384 MB RAM.
  
  I'm currently taking the 9i certification classes and will be needing access to Oracle at home. The iMac is our only computer.
  
  Can I install 9i (following your great instructions) on my system? There seems to be confusion on the Oracle boards regarding plain OS X vs. OS X Server -- they're saying it requires Server.
  
  Since this certification is costing a pretty penny, I don't want to shortchange myself by using a system that's either incomplete or will cause confusion. I've printed our your "what you get" and "what you don't get" bullet points to show my instructor later this week for his thoughts.
  
  I'd much rather stay w/my current system and not spend any additional $$$ if not necessary. However, I'll spend what I need to in order to insure that I learn the material in a proper and efficient manner.
  
  Recommendations/thoughts?
• Summary of Requirements?
  2003-05-06 04:30:36  williamr [Reply | View]
  
  
  Anonymous has probably found this out by now, but for the benefit of anyone else, I just successfully installed Oracle on the exact same configuration, i.e. 400MHz G3 iMac running 10.2, not server edition (except it's OS 10.2.5 now). It coped with 384MB though I've since maxed it out at 512MB which gives it a bit more headroom.
• Summary of Requirements?
  2003-03-19 14:36:58  dsimpson1 [Reply | View]
  
  
  This configuration should work, with the possible exception of requiring more RAM. Oracle says you have to have MacOS X server, but I have installed it just fine on the non-server version of MacOS X. Also Oracle requires a G4 CPU - but I have found that it works on my Beige G3 Mini-Tower (with about 650Mb of RAM, 512Mb is the recommended minimum).
  I encourage you to try doing the install without adding the RAM and see if you end up running out of memory. If you need more RAM - you can buy a 512Mb module rather economically these days.
  
  David Simpson

• To add to the bottom...
  2003-03-18 15:22:02  anonymous2 [Reply | View]
  
  
  Following the releasenotes.pdf which is supplied from Oracle is sufficient if you just want an Oracle SQLPLUS prompt.

• Not worth the trouble depending on who you are....
  2003-03-18 15:21:00  anonymous2 [Reply | View]
  
  
  If youre a single user who wants to just practice your Oracle SQL/PL on a Mac OSX based system dont go through the trouble of going through these steps.
  
  Alot of the info here is pretty generic, I had to tweak the init.sql file and I dont have a network connection for SQL.
  
  I will post some of my modifications when as soon as I get a chance.
  
  Two minor issues I am having is I cant run sqlplus in root. I get a dyld library error and then a core dump. I suspect this is because I didnt install Oracle in root. The other is when I boot up my SystemStater says it is having trouble loading localization strings. For /Library/StartupItems/Oracle/
  
  If you are a user who wants to experiment and get a better understanding of you Max OS X and understand a little bit about how Oracle runs give this thing a whirl. But you have to be *nix savy, or be inclined to become.
• Not worth the trouble depending on who you are....
  2004-02-19 19:22:46  skrishna31 [Reply | View]
  
  
  I am a single user trying to get Oracle on my MAc, just to play in sqlplus and plsql programming. I'm trying to follow the releasenotes.pdf which came when i downloaded macosx_920_dev_rel.tar. The notes says that I should be
  tar xvzf oradev.tar.gz
  Where is this file ?.
  When I try to tar the file i downloaded it compains ?.
  
  Can you provide some guidance ? I'm not trying to explore unix or mac here. I'll be happy if my oracle database works..
• Not worth the trouble depending on who you are....
  2003-03-19 14:42:17  dsimpson1 [Reply | View]
  
  
  Using sqlplus as root is not really supposed to work. This is normal behavior for an Oracle database. You need to run sqlplus as the UNIX account which owns and installs the Oracle software. Usually, this will be a UNIX account named oracle - but you can pick another name if you desire.
  
  On the other issue I don't see an obvious solution to the issue - but you might want to make sure that the StartupParameters.plist file has been installed.
  
  David Simpson

• can't install on emac g4 with 1GB ram
  2003-03-18 03:56:19  anonymous2 [Reply | View]
  
  
  can't install on emac g4 with 1GB ram
  
  ulimit -a
  core file size (blocks, -c) unlimited
  data seg size (kbytes, -d) unlimited
  file size (blocks, -f) unlimited
  max locked memory (kbytes, -l) unlimited
  max memory size (kbytes, -m) unlimited
  open files (-n) 10000
  pipe size (512 bytes, -p) 1
  stack size (kbytes, -s) 65536
  cpu time (seconds, -t) unlimited
  max user processes (-u) 500
  virtual memory (kbytes, -v) 9007199254806527
  
  ulimit -aH
  core file size (blocks, -c) unlimited
  data seg size (kbytes, -d) unlimited
  file size (blocks, -f) unlimited
  max locked memory (kbytes, -l) unlimited
  max memory size (kbytes, -m) unlimited
  open files (-n) 12288
  pipe size (512 bytes, -p) 1
  stack size (kbytes, -s) 65536
  cpu time (seconds, -t) unlimited
  max user processes (-u) 532
  virtual memory (kbytes, -v) 9007199254806527
  
  allways getting
  ORA-03114: not connected to ORACLE
  
  system is 10.2.4
• can't install on emac g4 with 1GB ram
  2003-03-19 14:46:37  dsimpson1 [Reply | View]
  
  
  I don't see any obvious problem with the setup info you have listed here. Maybe a step got missed along the way? Make sure you are logging in as the oracle UNIX account and that the environment variables are correct for your installation.
  
  David Simpson

• what about jvm
  2003-03-17 16:58:42  anonymous2 [Reply | View]
  
  
  after installation succesfully of oracle, I found javavm/install directory with plenty of scripts
  it's possible to install jvm to a database ?
• what about jvm
  2003-03-17 18:44:58  dsimpson1 [Reply | View]
  
  
  From my testing I determined that the Oracle Jserver feature is not working within this developer release. Here is a link to an example script which I would use to install Jserver on MacOS X if this feature was available. http://www.dotcomsolutionsinc.net/products/installgen/macosx_920_32bit_files/installgen_macosx920_18_.html
  
  (This script is very similar to the one I use for Solaris.) We can expect this feature to be added by Oracle for the actual production release.
  
  There is also a top level directory listing links to each of the Oracle install scripts I use on MacOS X:
  
  http://www.dotcomsolutionsinc.net/products/installgen/installgen_files_macosx920.html
  
  David Simpson
• what about jvm
  2003-11-03 16:14:41  anonymous2 [Reply | View]
  
  
  Ok, first off I'd just like to say thanks for a great article !
  
  After a few changes to the specifics described (mostly to customise the scripts to my machine paths etc), I managed to get an installation up and running !
  
  I now tried to install an application that required oracle XA (? transactions perhaps ?) that in turn required the oracle internal jvm to be installed and up and running.
  
  so I re-read your article and found a link to your script no.18 on your site to install the jvm.
  
  Unfortunately i cant seem to get it working properly.
  
  It seems that perhaps I've missed something in the oracle rdbms base install somewhere ?
  
  Any ideas would be greatfully accepted.
  
  I get the following error(s) that seem to come from the initjvmaux (?) internal objects.
  
  I've cut and pasted the last few lines here from my install sequence:
  
  
  ---- stuff cut out from jvm install sequence ------
  
  PL/SQL procedure successfully completed.
  
  SQL>
  SQL>
  SQL> -- Prevent the script from continuing in the case where create java system
  SQL> -- detects existing java classes or there is any other kind of error.
  SQL> whenever sqlerror exit;
  SQL>
  SQL> -- Load all the Java classes
  SQL> begin if initjvmaux.startstep('CREATE_JAVA_SYSTEM') then
  2 initjvmaux.rollbacksetup;
  3 commit;
  4 initjvmaux.rollbackset;
  5 initjvmaux.exec('create or replace java system');
  6 commit;
  7 initjvmaux.rollbackcleanup;
  8 initjvmaux.endstep;
  9 end if; end;
  10 /
  create or replace java system
  begin if initjvmaux.startstep('CREATE_JAVA_SYSTEM') then
  *
  ERROR at line 1:
  ORA-29538: Java not installed
  ORA-06512: at "SYS.INITJVMAUX", line 15
  ORA-06512: at line 5
  
  
  Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - Developer's Release
  With the Partitioning and Oracle Data Mining options
  %
  
  
• what about jvm
  2003-05-06 04:35:37  williamr [Reply | View]
  
  
  I struggled to get the Oracle JVM working for several days until I finally re-read the release notes. I think I had actually seen the line about it not being supported but simply hadn't believed it - in this day and age, Java is pretty central rather than being some optional advanced feature, and it was one of the reasons I installed Oracle in the first place.

• Didn't work for me either
  2003-03-16 20:50:21  anonymous2 [Reply | View]
  
  
  Two questions I have about this article.
  
  1. What is Oracle_startup refered to in part 3
  
  2. Why does the db_create.sql refer to the initprod1.ora file
  in the dbs directory when we are told to put it in network/admin?
  
  3. The article presents steps but never says when to reboot
  to start the server before creating the instance via db_create.sql
  
  
• Didn't work for me either
  2003-03-17 18:59:09  dsimpson1 [Reply | View]
  
  
  1) I see how this could be confusing. The Oracle_startup file was the name of the file I created from listing #1, and it gets renamed as Oracle when it is copied. I was trying to reduce confusion by not having so many things called just "Oracle" to start with.
  
  2) Good point. I wrote the article text wrong, but the caption for the program listing and the db_create.sql would be the correct path to use.
  
  3) You should not find it necessary to reboot. I create a script to start the database when starting the server, but the database is running once the instance is created. Manual shutdown of the instance is still required - with current versions of MacOS X.
  
  David Simpson

• Checksum for download
  2003-03-05 14:21:52  myshkin5 [Reply | View]
  
  
  The md5 for macosx_920_dev_rel.tar.gz (Oracle's web site says it is "Updated: December 20, 2002") is:
  
  e03d11a52b03bac57a1a06e019b14246

• Good grief
  2003-02-28 11:20:34  anonymous2 [Reply | View]
  
  
  After trying to install twice using just the Release Notes I found this article. After another two consecutive attempts to get this damn thing running, I have the distinct feeling that it's laughing at me.
  
  Thanks, but I'll stick with PostgreSQL.
  
  
  All I have to do with PostgreSQL is:
  compile
  install
  initdb -D /location
  pg_ctl -D /location start
  createdb mydb
  psql mydb
  
  

• Break it down, Please!
  2003-02-11 23:30:35  myshkin5 [Reply | View]
  
  
  I have some problems with this article. There are several unnecessary steps and some security issues. In particular things like turning on portmap should not be necessary and could cause security problems if mis-configured (Apple has portmap turned off by default for a reason).
  
  After reading the release notes from Oracle, I will say you have definitely made an improvement. If I remember correctly, the release notes even say you should turn on telnet!
  
  If you have any interest in re-organizing the article, I would be very interested if you broke things down starting with the bare minimum steps to get a very small Oracle install running (as I am just tinkering here from a single machine I don't want Oracle taking over all of my resources). The article could go on to describe several exercises to expand the resources used thereby covering small test systems to large production systems.
  
  Thank you for a very helpful article. I am having some problems getting Oracle to run (probably because I am not following all the steps :). I will post my problems seperately.
  
  Dwayne

• How do 4D and Omnis databases fit in as alternatives?
  2003-02-10 12:39:22  jeffnailen [Reply | View]
  
  
  David, excellent series of articles, thank you for the info. I'm new to databases. Considering the wealth of database choices now available with OS X, how do the old 4D and Omnis databases fit in as alternatives? Are they still viable alternatives to OpenBase, FrontBase, etc. or are they in a different category?
  
  I'm especially interested in them as RAD environments for desktop apps, not so much for web database publishing, and am also looking at OpenBase's RADStudio. I get the general impression that FileMaker, 4D, and Omnis are more oriented toward desktop application development (that's what I'm interested in) whereas OpenBase, FrontBase, MySQL, SyBase, & Oracle are more oriented toward web databases. Is that correct?
  
  I'm a little confused regarding the whole front-end/back-end distinction and where all the options fit in. Any enlightenment on where they fit in would be appreciated.
  
  It's hard to navigate the database options for the Mac. We need a good up-to-date book on Mac databases covering the basics and all the Mac heritage & UNIX heritage options for those shopping around before we can jump into books on particular databases!
  
  Thanks!
• How do 4D and Omnis databases fit in as alternatives?
  2003-04-27 06:43:42  anonymous2 [Reply | View]
  
  
  I'm really interested in this particular subject as well. I'm putting together a two tiered approach to problem solving on this level and would like help from those out there really working in this environment?
  
  Do people have real jobs dedicated to this purpose or has the business world compeltely left out the Mac database community entirely? Let's put a strong foot forward and hack some things out.
• How do 4D and Omnis databases fit in as alternatives?
  2003-02-10 13:54:37  dsimpson1 [Reply | View]
  
  
  I suggest that Omnis and 4D would fit into the category of workgroup sized databases. I would also put FileMaker, OpenBase, FrontBase and mysql in the same category as well.
  I would categorize Oracle, Sybase and DB2 as enterprise class databases due to their ability to handle thousands of simultaneously connected users.
  This is not meant to be a negative statement towards any of the workgroup category databases. You can get quite a bit of work done with workgrouup databases. Also, 4D and Omnis (now under the Raining Data company name) have made impressive feature updates to enable web publishing of their databases. Intranet Web publishing of in-house databases deserves consideration even for previously client-server apps. This way you can have the freedom to pick any client OS to access the backend data, and also provide straightforward VPN access for remotely located employees - without any client configuration.
  I guess you are right, it would take a book to cover all of the options!
  
  David Simpson
• How do 4D and Omnis databases fit in as alternatives?
  2003-02-10 14:27:13  jeffnailen [Reply | View]
  
  
  Thanks for your quick reply David.
  
  Perhaps you could write or co-author the book! :-)

• Can't install following article...please help
  2003-02-09 20:11:45  dsimpson1 [Reply | View]
  
  
  This type of error could occur if you don't have the ulimit or environment variables set correctly.
  
  David Simpson

• Can't install following article...please help
  2003-02-09 20:11:40  dsimpson1 [Reply | View]
  
  
  This type of error could occur if you don't have the ulimit or environment variables set correctly.
  
  David Simpson

• install
  2003-02-08 22:32:38  anonymous2 [Reply | View]
  
  
  I followed the instructions exactly and it did not create a db. Half way thru it stopped and asked for a value for "owa_file_var". Not finding anything suitable on the web for this value I supplied a path in $ORACLE_HOME.
  
  Has anyone successfully installed Oracle following these instructions? Or are we being led down a dark path? I've installed Oracle on Sun's, HP's, and Windows, but never on OS X.
• install
  2003-04-20 00:02:01  anonymous2 [Reply | View]
  
  
  I had the same error and supplied the following file name: /users/oracle/v920/rdbms/admin/owadummy.sql . It seems to be progressing okay now ... cross my fingers ...
  
  Steve Anderson
  andersons001@hawaii.rr.com
• install
  2003-02-09 20:13:59  dsimpson1 [Reply | View]
  
  
  There seem like a number of issues which could cause this problem including: lack of memory, corruption of the downloaded binary tar file or problems with the ulimit or environment variable settings.
  
  David Simpson
• install
  2003-02-11 23:35:37  myshkin5 [Reply | View]
  
  
  Can you post the md5 of the download? Since it is such a large download, I am guessing many people may have corruption problems.
  
  Thanks
  Dwayne

• Can't install following article...please help
  2003-02-08 09:49:27  anonymous2 [Reply | View]
  
  
  I've got a lot of "Database not opened" ERRORS since the begining.

• Can't install following article...please help
  2003-02-08 09:49:16  anonymous2 [Reply | View]
  
  
  I've got a lot of "Database not opened" ERRORS since the begining.

• one ready, one unknown
  2003-02-05 13:29:48  jsfranko [Reply | View]
  
  
  anybody help with listener.ora, tnsnames.ora?
  
  I get one instance of my database with service name <sid>.US.ORACLE.COM, which has status of ready, and one Service with <sid>.mydomain.com with instance status unknown.
  
  Also I have a sqlnet.ora that points to three name servers that I got from the company pc installation of oracle. But it doesn't seem to use it.
  
  How can I both refer to may companies name servers for service names, and be able to use my own database server's service name? How do I supply my service name to people on other computer running sqlplus clients?
  
  j.scott.franko@noreply.fedex.com
• one ready, one unknown
  2003-02-05 16:31:34  dsimpson1 [Reply | View]
  
  
  If all you wanted to do was simply access two different databases, this would be easy because you could simply put two different entries in your local tnsnames.ora file. I have not configured the Oracle names server feature so I am not sure of the specifics of that configuration. It would seem that if it is like DNS, you would have to make sure that every Oracle database is listed within the server in order to access it.
  
  David Simpson

• Unable to create the db
  2003-01-18 14:47:22  scriba [Reply | View]
  
  
  I can't create the db using the creation script
  described in the article. I get a lot of oracle
  errors.

• No success with sql*plus on client only
  2003-01-09 11:34:39  anonymous2 [Reply | View]
  
  
  I want to run sql*plus on my Mac and connect to an Oracle database running externally on a Dell Server. I followed the directions to do a full binary install of the Oracle 9.2 database but I stopped short of actually configuring and starting the database on my local Mac. I did, however, run the DBENV script to set up the environment variables and configured the tnsnames.ora file to reference the external database. I tested this setup using tnsping and all seemed OK, however, when I try and run sql*plus and connect to the external database, I get an error saying the database does not exist. Has anybody encountered this or know what the solution would be?
  
  Many thanks!!!
  
  Alin Pilkington
• No success with sql*plus on client only
  2003-01-24 08:28:47  dsimpson1 [Reply | View]
  
  
  Alin,
  It looks like you probably need to specify the tnsnames.ora service name within your connection string, like this:
  sqlplus username/password@dbSID
  
  Where "dbSID" represents the service name for your Dell server database.
  
  David Simpson

• Great Article and a Question
  2003-01-08 15:28:27  anonymous2 [Reply | View]
  
  
  My company developes software on Oracle, I sometimes perform the installation of our product on really expensive hardware. As a Mac fanatic I received the release of the Oracle database under OSX as a great notice. By the time I read this article I had my database already created with my product completely deployed, but I have to say that the article has a great level of detail and as others say it covers a lot of ground. Great job!
  Now my question, I wanted to know if you heard of nay plans from Oracle to release the Forms and Report developer for OSX.
  Thanks a million.
• Great Article and a Question
  2003-01-24 08:25:51  dsimpson1 [Reply | View]
  
  
  I have not heard if there are any plans to release any of the other Oracle tools for Mac OS X beyond JDeveloper (which is already available). JDeveloper is written in Java, thus it would have been a straightforward process to make it available for Mac OS X.

• re: sqlplus history
  2003-01-08 07:20:38  anonymous2 [Reply | View]
  
  
  sqlplus doesn't maintain a history on Unix machines. It's a windows only feature.

• Have you tried less than 512 MB RAM?
  2003-01-08 06:20:18  Jonathan Gennick | [Reply | View]
  
  
  I know Oracle "requires" 512 MB of RAM. I'm curious about whether you've tried running Oracle under OS X with less than that and gotten away w/it.
  
  By the way, it's useful to know that it runs on a G3, even though the official requirement is a G4. I wonder whether Oracle actually uses any G4-specific features.
• Have you tried less than 512 MB RAM?
  2003-01-08 09:13:15  dsimpson1 [Reply | View]
  
  
  It has been awhile since I did the initial setup on my beige G3 (with a G4 Sonnet upgrade) - but I think that I got this to work with 256Mb of RAM. I have problems using more than 256Mb of RAM whenever I use the G4 CPU in that machine so I think that I originally tested with 256Mb. Then I opted to swap back to the G3 CPU so that I could use the 512Mb of RAM - and this worked so I also learned that there wasn't any problem with using the G3. Oracle is generally pretty good about trying to be as hardware independent as possible. They probably want to reduce the number of machines which they officially support by making a G4 as a minimum requirement. It is a remote possibility that they could use G4 specific feaures in the future - but this seems unlikely based upon what they have done on other platforms. On RS/6000 AIX servers there are both 32bit and 64bit CPUs supported by Oracle with some releases, and on Sun servers they also support 32bit and 64bit configurations. On HP-UX there are also a variety of different PA-RISC CPUs used by HP, which don't seem to affect Oracle compatibility either. However you should be aware that the 9.2.0.2 patchfile (not yet available for Mac OS X) does require an additional 300Mb of RAM just to install the patch. This memory requirement can be reduced after the patch has been installed. This patchfile fixes critical issues with authentication on Windows servers, and is a mandatory patchlevel for using Streams replication.
  
  David Simpson

• sql*plus command history
  2003-01-06 08:41:06  anonymous2 [Reply | View]
  
  
  My installation is up and running (Thanks for the great series!), but I'm having a bit of a problem with sqlplus.
  
  When I ran sqlplus from the Windows command line, I was able to use the cursor keys to move back and forth through my command history, but when I try to do this in the OS X terminal I just get a series of characters like ^[[A (the up arrow) or ^[[B (the down arrow). I was finally able to get the Delete key working by adding 'stty erase ^H' to my .bashrc file, but no luck so far with arrows. Any suggestions?
  
  Cheers.
• sql*plus command history
  2003-05-08 04:24:59  anonymous2 [Reply | View]
  
  
  There is a small program called gqlplus for linux/unix which offers backspace delete and command history
  
  regards
• sql*plus command history
  2003-01-08 09:31:07  dsimpson1 [Reply | View]
  
  
  Thanks for the feedback, it looks like I should be adding the 'stty erase^H' to the .bashrc file. I do this on Solaris within the /etc/profile file but I didn't think it was needed here on Mac OS X because the Terminal app seems to work just fine.
  
  One person has replied that the command history is only available on Windows. However I must admit that I don't know the answer. There is what appears to be a good book from O'Reilly on SQL/Plus - which I unfortunately have not yet read. I am wondering if there is an environment variable like ORA_TERM which I should be setting?
  
  David Simpson

• JDeveloper also now available
  2003-01-05 12:40:58  anonymous2 [Reply | View]
  
  
  Thanks Devid for another excellent article! (With no prompting, I will say that I am a happy user of Installgen also, which has great support for Mac OS X.)
  
  Note that Oracle has posted the jdbc's (which are included in the preview release of the database under the jdbc folder) separately, and also the full JDeveloper 9i for Mac OS X quietly on its web page -- the same link as previously given
  
  http://www.oracle.com/start/apple/intro.html?src=1439096&Act=5
  
  or directly at
  
  http://otn.oracle.com/software/products/jdev/htdocs/macsoft.html
  
  Let's keep pushing and supporting the Oracle releases for Mac OS X!!

• Complements Release Notes Nicely
  2003-01-05 08:58:09  anonymous2 [Reply | View]
  
  
  This article rocks but it may not be the simplets solution.
  
  The Release Notes are missing the details regarding user group configuration (with command line version of netinfo). A few other things are also spelled out that are just mentioned in the Release Notes.
  
  My goal was to create a sandbox environment and the Release Notes get you there pretty fast. You need a good stomach to handle the article since it's not always clear what's brewing.
  
  Be as it may, this is a very good article and covers a lot of ground that hasn't been covered by anywhere to the best of my knowledge.

• Excellent Article
  2003-01-04 16:48:08  anonymous2 [Reply | View]
  
  
  I've been waiting for something like this for quite some time.
  
  My only (hopefully constructive) comment concerns the installation over three external volumes. With so many things going on, I'm not sure if I will succeed in installing it on my single internal HD.
  I'm a novice and the article makes unsecure in regards to what will break. I'm still chugging along.
  
  Other than that, I'm hoping that series continues.
  It's much needed literature.

• We need more articles like this
  2003-01-04 11:40:50  pt_thai [Reply | View]
  
  
  This is a great article. People need to know how they can install and use industry-standard software like Oracle on OS X to ensure that businesses take the platform seriously. I use Oracle at the office, and I am thrilled about the idea of doing some work with Oracle on my TiBook. Thanks, O'Reilly, for writing such articles that Apple should have written.