Mac OS X 10.6.8下安裝Oracle客戶端

bluelight發表於2011-09-30

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
---------------------------------------------------------------------------------------------------------------------


[@more@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/1724534/viewspace-1055427/,如需轉載,請註明出處,否則將追究法律責任。

相關文章