mac 安装oracle客户端,Mac OS X 10.6.8下安装Oracle客户端

---------------------------------------------------------------------------------------------------------------------

Today I wrote this script that can be used to install and configure SqlPlus on a Mac OS X. It was tested on a Leopard 10.5.4 machine.

Pre-installation:

1. Download from the Oracle website the Oracle Client for Mac OS X (Intel x86) Version 10.2.0.4 and the SqlPlus:

- the Oracle Client ‘Instant Package – Basic’ [instantclient-basic-macosx-10.2.0.4.0.zip]

- the Oracle Client ‘Instant Package – SqlPlus‘ [instantclient-sqlplus-macosx-10.2.0.4.0.zip]

2. Download the bash scripts MacSqlPlus.sh and TNSconnectMac.sh. Last version can be found in the script page.

Installation:

1. Set a root password and log in as root

# sudo passwd

# su -

2. Copy the files instantclient-basic-macosx-10.2.0.4.0.zip, instantclient-sqlplus-macosx-10.2.0.4.0.zip, MacSqlPlus.sh and TNSconnectMac.sh into the directory /var/root.

3. Enter the home directory of the user root, change the permissions of the scripts and execute the installation script.

# cd

# chmod 755 MacSqlPlus.sh TNSconnectMac.sh

# ./MacSqlPlus.sh

Post-Installation: [Steps Required]

1. Make sure you know SID, SERVER and PORT of the server you want to connect.

2. Execute the script TNSconnectMac.sh

# cd

# ./TNSconnectMac.sh

3. Type: Oracle SID, Oracle Server, Oracle Server Port, Oracle Database Username, Oracle Database Password.

Installation Check:

1. To connect the Oracle DB via SqlPlus you can run the following command:

# sqlplus DB_USER/DB_PASS@//DB_SERVER:DB_PORT/DB_SID

---------------------------------------------------------------------------------------------------------------------