unix list directories only

ls -d */

direct connection

sqlplus user/pass@10.0.0.1:1521/service_name

tnsping direct

the sytax

tnsping '(ADDRESS=(PROTOCOL=tcp)(HOST=10.24.0.11)(PORT=1521))'

authid current_user

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/subprograms.htm#i18574

To give the package the same rights as the caller of the package.