Oracle wallet

Da Emigar.
Jump to navigation Jump to search
#!/bin/sh

mkdir -p /app/oracle/wallet

echo '
WALLET_LOCATION=(SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=/app/oracle/wallet)))
SQLNET.WALLET_OVERRIDE = TRUE
SSL_CLIENT_AUTHENTICATION = FALSE
SSL_VERSION = 0
' > /app/oracle/wallet/sqlnet.ora

rm -f /app/oracle/wallet/ewallet* /app/oracle/wallet/cwallet*
orapki wallet create -wallet "/app/oracle/wallet" -pwd "walletpassword" -auto_login_local
mkstore -wrl "/app/oracle/wallet" -createCredential host01:1521/service01 sys syspassword


TNS_ADMIN=/app/oracle/wallet sqlplus /@host01:1521/service01 as sysdba


TNS_ADMIN=/app/oracle/wallet expdp userid="'/@host01:1521/service01 as sysdba'" full=y compression=all \
   flashback_time='"cast(sysdate as timestamp with local time zone)"' \
   directory=backup_oracle dumpfile=expdp_${DBNAME}.${DAY}.dmp \
   logfile=expdp_${DBNAME}.${DAY}.log