Oracle wallet

comandi creazione wallet java

• installare sqlc https://www.oracle.com/tools/downloads/sqlcl-downloads.html
• creare gli script:

mkstore:

#!/bin/bash
# set classpath for mkstore - align this to your local SQLcl installation
SQLCL=$(dirname $(which sql))/../lib
CLASSPATH=${SQLCL}/oraclepki.jar:${SQLCL}/osdt_core.jar:${SQLCL}/osdt_cert.jar
# simulate mkstore command
java -classpath ${CLASSPATH} oracle.security.pki.OracleSecretStoreTextUI  "$@"

orapki:

#!/bin/bash
# set classpath for orapki - align this to your local SQLcl installation
SQLCL=$(dirname $(which sql))/../lib
CLASSPATH=${SQLCL}/oraclepki.jar:${SQLCL}/osdt_core.jar:${SQLCL}/osdt_cert.jar
# simulate orapki command
java -classpath ${CLASSPATH} oracle.security.pki.textui.OraclePKITextUI "$@"

Creazione wallet

#!/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*
# il wallet creato con mkstore non si lega al filesystem, ed è quindi copiabile su altro server
#mkstore -wrl "/app/oracle/wallet" -create
#per sicurezza meglio creare il wallet con orapki -auto_login_local rende il wallet non copiabile su un altro server
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

ezconnect

Dalla versione 19:

sqlplus user/password@tcps://hostname:2484/servicename?wallet_location=path_to_wallet_directory