Install Oracle10g on snow leopard 10.6.2 (Mac OS X)

1 . Install preparation

Basic Environment:Snow leopard10.6.2,Oracle10.2.0.4

OpenRun the following command on the Mac terminal:

Sudo
-I

CreateThe oinstall group and oracle users must ensure that the combined user ID does not conflict with the existing system information. Here 700 is used.

Create group: 

Dscl.-create
/Groups/oinstall

Dscl.-append
/Group/oinstall GID 700

Dscl.-append
/Groups/oinstall passwd "*"

Create a user: 

Dscl.-create
/Users/Oracle

Dscl.-append
/Users/Oracle uid 700

Dscl.-append
/Users/Oracle GID 700

Dscl.-append
/Users/Oracle shell/bin/bash

Dscl.-append
/Users/Oracle Home/users/Oracle

Dscl.-append
/Users/Oracle realname "Oracle software owner"

Create a user's home directory:

Mkdir
/Users/Oracle

Chown
ORACLE: oinstall/users/Oracle

 

ModifyOracle user password:

Passwd Oracle

Modify kernel parameters:

VI
/Etc/sysctl. conf

My modifications are as follows:

Kern. sysv. shmmin = 1

Kern. sysv. shmseg = 8

 

Kern. sysv. semmsl = 87381

Kernel. sysv. semmns = 87381

Kern. sysv. semmni= 87381

Kern. sysv. semmnu = 87381

Kern. sysv. semume = 10

Kernel. Shmall = 2097152

Kernel. SYS. shmmax = 2147483648

Kernel. SYS. shmmni = 4096

Kern. maxfiles = 65536

Kern. maxfilesperproc = 65536

Net. inet. IP. portrange. First = 1024

Net. inet. IP. portrange. Last = 65000

Kern. corefile = Core

Kern. maxproc = 2068

Kern. maxprocperuid = 2068

 

The installation script of Oracle depends on Java 1.4.2. Check whether 1.4.2 exists in the/system/library/frameworks/JavaVM. Framework/versions directory. If no link is required:

Udo
Ln-S/system/library/frameworks/JavaVM. Framework/versions/1.5.0
/System/library/frameworks/JavaVM. Framework/versions/1.4.2

My environment is snow leopard, defaultThe JDK version is 1.6 and all Java version links have been implemented. Therefore, this step is not required.

 

CreateMy environment variables for oracle users are as follows, including some of my own settings for reference:

UseVI creates a. bash_profile with the following content:

Export
PS1 = "\ $ PWD>"

# Export
Ant_opts =-djava. AWT. Headless = true

Umask
022

 

Export
Clicolor = 1

Export
Lscolors = gxfxcxdxbxegedabagacad

Alias
CLS = 'clear'

Alias
LL = 'LS-l'

Alias
La = 'LS-'

Alias
Vi = 'vim'

 

Export
Oracle_base = $ home

Export
Oracle_sid = macora

Export
ORACLE_HOME =/users/Oracle/product/10.2.0

Export
Path =/usr/local/bin:/users/Oracle/product/10.2.0/bin: $ path

Export
Dyld_library_path = $ ORACLE_HOME/lib

Export
Display =: 0.0

Export
Nls_lang = "simplified chinese_china.utf8"

Ulimit
-HN 65536

Ulimit
-Sn 65536

 

The display settings are mainly used to solve the problem of using Oracle users to start the X environment on the command line. In fact, after various attempts, I finally did not implement the settings and logged out my users, directly log on to Oracle for installation. Later I found an explanation:

Above works only for OS x 10.5 leopard. OS X 10.6
Snow Leopard has stricter security settings so you cannot simply Su to Oracle
User and export display-you actually have to login as Oracle user (logout in
Gui and login as Oracle "Oracle software owner") instead of "Su-Oracle ".
Thanks to Raimond for this.

 

The final installation isThe Oracle user has logged on to the system.

2. Begin Installation

ToLog on to the MAC system as an oracle user, find the runinstaller under disk1, and execute:

./Runinstaller
J-d32

32 indicates that the system is running on a 32-bit operating system. Follow the prompts for subsequent installation. I installed the Enterprise Edition. To support multiple languages, I chose UTF-8 as the database encoding.

There are two problems during installation:

1. "error
In invoking target 'all _ no_orcl ipc_g ", run the following command to cancel the installation if this error occurs:

CD
~ /Oracle/product/10.2.0/db_1/rdbms/lib

VI ins_rdbms.mk

Use# Comment out the rows starting with $ (hsodbc_linkline:

# $ (Hsodbc_linkline)

Then return to the installationProgramClick "retry ".

2. A ORA-3113 error may also be prompted during installation, this problem Raimonds
Simanovskis is solved by providing patch files, as follows:

CD
$ ORACLE_HOME/bin

Curl
-O http://rayapps.com/downloads/oracle_ee.zip

Unzip
Oracle_ee.zip

Chmod
Ug + S Oracle

Rm
Oracle_se.zip

Note: install and use the Enterprise EditionOracle_ee.zip

Use oracle_se.zip for standard installation

Then return to the installer and click "retry ".

 

Last prompt to useThe root permission is used to execute two scripts, which is the same as the installation in Linux.

Sudo/users/Oracle/orainventory/orainstroot. Sh

Sudo/users/Oracle/product/10.2.0/root. Sh

 

Finally, you will see the prompt: the installation is successful!

3. Configuration

After the installation is complete, you can modifyTnsnames. ora and listener. ora are used to specify the port and accessible IP addresses, such as localhost, 127.0.0.1, and actual website address. Port is good. The default value is 1521.

Then run the following command:

Sqlplus
/As sysdba

Startup

The Oracle routine has been started.

Total system global area612368384 bytes

Fixed size 2085872 bytes

Variable Size 167775248 bytes

Database Buffers  
436207616 bytes

Redo Buffers 6299648 bytes

The database has been loaded.

Start the listener:

LSNRCTL
Start

Tnslsnr for MacOS X Server: Version
10.2.0.4.0-Production

The system parameter file is/Users/Oracle/product/10.2.0/Network/admin/listener. ora

Write/Users/Oracle/product/10.2.0/Network/log/listener. Log

Listeners: (Description = (address = (Protocol = IPC) (Key = extproc1 )))

Listeners:
(Description = (address = (Protocol = TCP) (host = localhost) (Port = 1521 )))

Listeners: (Description = (address = (Protocol = TCP) (host = 192.168.70.1) (Port = 1521 )))

......

(Description = (address = (Protocol = TCP) (host = 192.168.70.1) (Port = 1521 )))

Service Summary..

Service"Plsextproc" contains one routine.

  Routine "plsextproc ",
Status unknown, including one handler for this service...

Command executed successfully

 

In this way, you can use the database. If you want to add the service name of another server, you can useNetca tool.

In addition, do not try to startEmctl service. Currently, this version does not support using EM on Mac.
Console.

ActuallyEm
The functions in the console can be basically implemented through the command line method.

 

Recommended inUse oracle on Mac
SQL developer, free and easy to use.

 

The entire installation process is not complex.Oracle is installed on Linux almost once.

Now, enjoy your data service.