Oracle wallet - Cronologia

WikiSysop: /* Creazione wallet */

2022-04-29T10:21:31Z

Creazione wallet

← Versione meno recente		Versione delle 10:21, 29 apr 2022
Riga 37:		Riga 37:

	rm -f /app/oracle/wallet/ewallet* /app/oracle/wallet/cwallet*		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		orapki wallet create -wallet "/app/oracle/wallet" -pwd "walletpassword" -auto_login_local
	mkstore -wrl "/app/oracle/wallet" -createCredential host01:1521/service01 sys syspassword		mkstore -wrl "/app/oracle/wallet" -createCredential host01:1521/service01 sys syspassword

WikiSysop: /* wallet java */

2022-02-08T14:15:47Z

wallet java

← Versione meno recente		Versione delle 14:15, 8 feb 2022
Riga 1:		Riga 1:
	=wallet java=		=comandi creazione wallet java=
	* installare sqlc https://www.oracle.com/tools/downloads/sqlcl-downloads.html		* installare sqlc https://www.oracle.com/tools/downloads/sqlcl-downloads.html
	* creare gli script:		* creare gli script:
Riga 21:		Riga 21:
	# simulate orapki command		# simulate orapki command
	java -classpath ${CLASSPATH} oracle.security.pki.textui.OraclePKITextUI "$@"		java -classpath ${CLASSPATH} oracle.security.pki.textui.OraclePKITextUI "$@"


	=Creazione wallet=		=Creazione wallet=

WikiSysop il 14:15, 8 feb 2022

2022-02-08T14:15:22Z

← Versione meno recente		Versione delle 14:15, 8 feb 2022
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

WikiSysop il 08:30, 22 set 2017

2017-09-22T08:30:52Z

← Versione meno recente		Versione delle 08:30, 22 set 2017
Riga 34:		Riga 34:

	[[Categoria:Database]]		[[Categoria:Database]]
			[[Categoria:Oracle]]

WikiSysop il 16:29, 6 mag 2016

2016-05-06T16:29:15Z

← Versione meno recente		Versione delle 16:29, 6 mag 2016
Riga 24:		Riga 24:

	<pre>		<pre>
	TNS_ADMIN=/app/oracle/wallet ~~expdp userid="'/@host01:1521/service01 as sysdba'" full=y compression=all~~ \		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)"' \		flashback_time='"cast(sysdate as timestamp with local time zone)"' \
	directory=backup_oracle dumpfile=expdp_${DBNAME}.${DAY}.dmp \		directory=backup_oracle dumpfile=expdp_${DBNAME}.${DAY}.dmp \

WikiSysop il 14:57, 6 mag 2016

2016-05-06T14:57:52Z

← Versione meno recente		Versione delle 14:57, 6 mag 2016
Riga 16:		Riga 16:

	</pre>		</pre>


	<pre>		<pre>

WikiSysop il 14:56, 6 mag 2016

2016-05-06T14:56:44Z

← Versione meno recente		Versione delle 14:56, 6 mag 2016
Riga 18:		Riga 18:

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

WikiSysop il 14:56, 6 mag 2016

2016-05-06T14:56:23Z

← Versione meno recente		Versione delle 14:56, 6 mag 2016
Riga 2:		Riga 2:
	#!/bin/sh		#!/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*		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


⚫	## TNS_ADMIN=/app/oracle/wallet ~~sqlplus~~ /@host01:1521/service01
	## SELECT SYS_CONTEXT('USERENV', 'CON_NAME') from dual;
	##
	</pre>		</pre>

	<pre>		<pre>
	~~cat~~ /app/oracle/wallet/~~sqlnet.ora~~		TNS_ADMIN=/app/oracle/wallet sqlplus /@host01:1521/service01
⚫	WALLET_LOCATION=(SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=/app/oracle/wallet)))
⚫	SQLNET.WALLET_OVERRIDE = TRUE
⚫	SSL_CLIENT_AUTHENTICATION = FALSE
⚫	SSL_VERSION = 0
	</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>
		⚫	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
	</pre>		</pre>

WikiSysop il 14:53, 6 mag 2016

2016-05-06T14:53:36Z

← Versione meno recente	Versione delle 14:53, 6 mag 2016
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>

WikiSysop: Creata pagina con " Categoria:Database"

2016-05-06T14:50:03Z

Creata pagina con " Categoria:Database"

Nuova pagina

[[Categoria:Database]]