Pedro Emanuel de Castro Faria Salgado’s Blog

install Xcode 3.1.1
install Macports

sudo port -v selfupdate

sudo mkdir -p /opt/local/var/macports/distfiles/oracle-instantclient
cd /opt/local/var/macports/distfiles/oracle-instantclient
download Oracle Instant client zip files into this directory
sudo mv ~/Downloads/instantclient*.zip .

cat ~/.profile
#
# MACPORTS
#
export PATH=/opt/local/bin:/opt/local/sbin:$PATH
export MANPATH=/opt/local/share/man:$MANPATH
export DISPLAY=:0.0

source ~/.profile
sudo port -v selfupdate

ls

-rw-r--r--@ 1 psalgado  staff  34020719 Apr 22  2008 instantclient-basic-macosx-10.2.0.4.0.zip
-rw-r--r--@ 1 psalgado  staff    603493 Apr 22  2008 instantclient-sdk-macosx-10.2.0.4.0.zip

sudo port install oracle-instantclient

emacs ~/.profile
# Oracle
export ORACLE_HOME=/opt/local/lib/oracle
export PATH=$PATH:$ORACLE_HOME
export DYLD_LIBRARY_PATH=$DYLD_LIBRARY_PATH:$ORACLE_HOME
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME
export TNS_ADMIN=/opt/local/lib/oracle/network/admin

download cx_Oracle.4.4.1
tar xvfz cx_Oracle-4.4.1
cd cx_Oracle-4.4.1
sudo su
bash
export ORACLE_HOME=/opt/local/lib/oracle
python setup.py build
python setup.py install

Ctrl+D

source ~/.profile
sudo mkdir -p $TNS_ADMIN

(for Intel check here)

after a few days of hard time… and trying to figure out what I did right before… here goes a complete set of instructions…

+ setup user/group

- added the user ‘oracle’

- added the user ‘oinstall’
+ setup shell environment

- unset ORACLE_HOME

- unset TNS_ADMIN

+ installing the client software

- download ship_mac_db.cpio.gz

- cd Downloads

- gunzip ship_mac_db.cpio.gz; cpio -idmv < ship_mac_db.cpio

or

- Archive Utility will take care of it

- the docs are here

- cd Disk1

- mkdir -p /Library/Oracle/oraInventory

- mkdir -p /Library/Oracle/product/10.1.0/client

- sudo chown -R psalgado /Library/Oracle

+ ./runInstaller

- Oracle inventory step

- full path of Oracle inventory: /Library/Oracle/oraInventory

- group name: oinstall

- sudo /Library/Oracle/oraInventory/orainstRoot.sh

- Specify File Locations

- source (unchanged): /Users/psalgado/Downloads/Disk1/stage/products.xml

- destination name: OraDb10g_home

- destination path: /Library/Oracle/product/10.1.0/client

- Select installation type

- Custom

- SQLPlus

- Oracle Call Interfaces

- Oracle One-Off Patch Installer

- on the first error do

chmod u+w /Library/Oracle/product/10.1.0/client/css/admin/init.cssd

- on the second error do

cp /Library/Oracle/product/10.1.0/client/lib/libclntsh.dylib /Library/Oracle/product/10.1.0/client/lib/libclntsh.dylib.10.1

- retry

- sudo /Library/Oracle/product/10.1.0/client/root.sh

Password:

Running Oracle10 root.sh script…

\nThe following environment variables are set as:

ORACLE_OWNER= psalgado

ORACLE_HOME= /Library/Oracle/product/10.1.0/client

Enter the full pathname of the local bin directory:

[/usr/local/bin]:

Creating /usr/local/bin directory…

Copying dbhome to /usr/local/bin …

Copying oraenv to /usr/local/bin …

Copying coraenv to /usr/local/bin …

Creating /etc/oratab file…

Adding entry to /etc/oratab file…

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root.sh script.

Now product-specific root actions will be performed.
+ setup shell environment

- emacs ~/.bashrc

# Oracle

export ORACLE_OWNER=oracle

export ORACLE_HOME=/Library/Oracle/product/10.1.0/client

export DYLD_LIBRARY_PATH=$DYLD_LIBRARY_PATH:$ORACLE_HOME/lib

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib

export PATH=$PATH:$ORACLE_HOME/bin/
+ cx_Oracle

- download it

- cd ~/Downloads/cx_Oracle-4.3.1/

- source ~/.bashrc

- python setup.py build

(don’t worry about the warnings… not even the not required architecture)

- python setup.py install

sent by Luca Pelucchi

There was a little boy visiting his grandparents on their farm.
One day Johnny was given a slingshot to play with.

He practiced in the woods but he could never hit the target.
Getting a little discouraged he headed back to dinner.
As he was walking back he saw Grandma’s pet duck.
Just out of impulse he let the slingshot fly,
hit the duck square in the head, and killed it.
He was shocked. In a panic, he hid the dead duck in the
woodpile, only to see his sister watching
Diane had seen it all, but she said nothing.

After lunch the next day Grandma said,
“Diane, let’s wash the dishes.” But Diane said,
“Grandma, Johnny told me he wanted to help
in the kitchen.” Then she whispered to him,
“Remember the duck?” So Johnny did the dishes.

The following day Grandpa asked if the children wanted to go fishing. But Grandma said,
“I’m sorry but! I need Diane to help make supper.”
Diane just smiled and said,
“Johnny told me he wanted to help you.”
She whispered again, “Remember the duck?”
So Diane went fishing and Johnny stayed home.

After several days of Johnny doing both his chores and Diane’s he finally couldn’t stand it any longer.
He came to Grandma and
confessed that he had killed the duck.
Grandma knelt down, gave him a hug, and
said, “Sweetheart, I know. You see, I was standing at the window and I saw the
whole thing.

But because I love you, I forgave you. I was just wondering how long you would let
Diane make a slave of you.”

Thought for the day and everyday thereafter:
Whatever is in your past, whatever you have done that the devil keeps throwing up in your face
(lying, debt, fear, hatred,
anger, unforgiveness, bitterness, etc.),
you need to know that God was
standing at the window and He saw the whole thing.
He has seen your whole lif! e. He w ants you to know that He loves you and that you are forgiven. He’s just wondering how long you will let the devil make a slave of you. The great thing about God is that when you ask for forgiveness,
He not only forgives you, but He forgets. It is by God’s grace and mercy that we are saved.

Go ahead and make the difference in someone’s life today. Share this
with a friend and always remember, God is at the window.

steps

Oracle InstantClient installation

cx_Oracle installation

$ cd cx_Oracle-4.2/
$ sudo python setup.py build
$ sudo python setup.py install

links

• Rails & Oracle Client on Mac OS X
• CXTools download page

steps

DocBook installation on macosx