Oracle wallet: differenze tra le versioni

Da Emigar.
Jump to navigation Jump to search
(Creata pagina con " Categoria:Database")
 
Nessun oggetto della modifica
Riga 1: Riga 1:
<pre>
#!/bin/sh


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
## SELECT SYS_CONTEXT('USERENV', 'CON_NAME') from dual;
##
</pre>

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

<pre>
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
</pre>

<pre>
</pre>




Versione delle 14:53, 6 mag 2016

#!/bin/sh


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
## SELECT SYS_CONTEXT('USERENV', 'CON_NAME') from dual;
## 

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

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



Estratto da "http://www.emigar.com/wiki/index.php?title=Oracle_wallet&oldid=5340"