Oracle wallet: differenze tra le versioni
Jump to navigation
Jump to search
Nessun oggetto della modifica |
Nessun oggetto della modifica |
||
| Riga 2: | Riga 2: | ||
#!/bin/sh |
#!/bin/sh |
||
mkdir -p /app/oracle/wallet |
|||
echo ' |
|||
| ⚫ | |||
| ⚫ | |||
| ⚫ | |||
| ⚫ | |||
' > /app/oracle/wallet/sqlnet.ora |
|||
rm -f /app/oracle/wallet/ewallet* /app/oracle/wallet/cwallet* |
rm -f /app/oracle/wallet/ewallet* /app/oracle/wallet/cwallet* |
||
| Riga 7: | Riga 15: | ||
mkstore -wrl "/app/oracle/wallet" -createCredential host01:1521/service01 sys syspassword |
mkstore -wrl "/app/oracle/wallet" -createCredential host01:1521/service01 sys syspassword |
||
| ⚫ | |||
## SELECT SYS_CONTEXT('USERENV', 'CON_NAME') from dual; |
|||
## |
|||
</pre> |
</pre> |
||
<pre> |
<pre> |
||
TNS_ADMIN=/app/oracle/wallet sqlplus /@host01:1521/service01 |
|||
| ⚫ | |||
| ⚫ | |||
| ⚫ | |||
| ⚫ | |||
</pre> |
</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> |
||
| ⚫ | |||
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> |
||
Versione delle 14:56, 6 mag 2016
#!/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
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