Oracle wallet: differenze tra le versioni
Jump to navigation
Jump to search
Nessun oggetto della modifica |
Nessun oggetto della modifica |
||
Riga 1: | Riga 1: | ||
=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= |
|||
<pre> |
<pre> |
||
#!/bin/sh |
#!/bin/sh |
Versione delle 16:15, 8 feb 2022
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* 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