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.