how can i use exp(export) utility from OS authentication?

[beksalur]

i am using unix shell script for exporting and importing oracle table data. currently i ma using explicit username/password pair to connect oracle engine from export and import utilities. After deciding hardening to our servers i want to connect oracle engine from exp and imp with OS authentication as below, so i dont want to be seen our userid and password in my shell script.
exp as sysdba file='....' log='....' full=y

how can i do it in Solaris?

Thanks in advance.

 

[LKBrwnDBA]

Create a user with 'identified externally' and invoke imp/exp/sqlplus, etc.. like this:

exp / file=... log=...etc...

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[LKBrwnDBA]

PS: Oracle user must be same name as os user with the os_authent_prefix (vg. OPS$ORACLE)


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[beksalur]

thanks LKBrwnDBA and take care!