I've logged in as 'oracle' user and can connect to the db using sqlplus system@orcl ( where orcl is sid ).
However, when I log in as a my regular user and try the same thing
sqlpus system@orcl, then I'm getting the following error..
dyld: Library not loaded: /b/227/sqlplus/lib/libsqlplus.dylib
Referenced from: /Users/oracle/oracle/product/10.2.0/db_1/bin/sqlplus
Reason: no suitable image found. Did find:
/Users/oracle/oracle/product/10.2.0/db_1/lib/libsqlplus.dylib: open() failed with errno=13
this is my .bash_profie
did I miss anything else? I'm guessing its a permission thing..but not sure what permissions and what folders..
Better late than never?
I tried everything before I fixed the install permissions.
See comment 54 in the link below:
There is a script $ORACLE_HOME/install/changePerm.sh that you can run to change permissions.
After enduring a rather painful experience of installing Oracle on Snow Leopard, here's my recommendation:
Most of the information you need can be found in the three guides cited on the Oracle OS X page:
Read them carefully before starting your installation.
If you just skim over them, you will find yourself spending all the time you think you are saving when you have to go back and re-read them to solve your installation problems.
I learned this the hard way.