./wlst.sh
You will get WLST prompt in offline mode, invoke the following command

wls:/offline> domain = "/opt/apps/user_projects/domains/domain_name"
Note: change the domain path if necessary

wls:/offline> service = weblogic.security.internal.SerializedSystemIni.getEncryptionService(domain)
wls:/offline> encryption = weblogic.security.internal.encryption.ClearOrEncryptedService(service)
wls:/offline> print encryption.decrypt("{AES}WDhZb5/IP95P4eM8jwYITiZs01kawSeliV59aFog1jE=")
weblogic123
wls:/offline>

Lancer cmd en tant qu'admin.

takeown /F X:\FULL_PATH_TO_FOLDER
takeown /F X:\FULL_PATH_TO_FOLDER /r /d y
icacls X:\FULL_PATH_TO_FOLDER /grant Administrateurs:F
icacls X:\FULL_PATH_TO_FOLDER /grant Administrateurs:F /t

Open "psappsrv.ubx" file and navigate to the bottom and locate the section with environment settings (it begins with *PS_ENVFILE)

Add the following environment variable:
LLE_DEPRECATION_WARN_LEVEL=NONE

lsof | egrep "deleted|COMMAND"
-> note PID and FD number
file /proc/<PID>/fd/<FD number>
-> "broken symbolic link to ..."
echo > /proc/<PID>/fd/<FD number>

If datafiles of an INDEX tablespace, do not forget to check integrity :
select 'alter index "||index_name||' validate structure;' from dba_indexes where tablespace_name='PSINDEX';

\n# [ $LOGNAME@\h:$PWD [\t] [ohvers SID:${ORACLE_SID:-"no sid"}] ]\n#

alter session set NLS_TERRITORY='FRANCE';
alter session set NLS_LENGTH_SEMANTICS='CHAR';
alter session set NLS_NUMERIC_CHARACTERS='.,';
alter session set NLS_DATE_FORMAT='DD/MM/YYYY';
alter session set NLS_TIMESTAMP_FORMAT='DD/MM/YYYY HH24:MI:SS';

set feedback off
set sqlformat insert
-- set sqlformat csv
spool /path/to/your/file.sql
select * from t;
spool off
set feedback on

HOST=127.0.0.1
for((port=1;port<=65535;++port));do echo -en "$port ";if echo -en "open $HOST $port\nlogout\quit" | telnet 2>/dev/null | grep 'Connected to' > /dev/null;then echo -en "\n\nport $port/tcp is open\n\n";fi;done

Commande rpm intéressante :

rpm -q --changelog sudo

wmic memphysical get MaxCapacity, MemoryDevices

Shrink TEMP Tablespace using alter tablespace command
SQL> ALTER TABLESPACE temp SHRINK SPACE KEEP 50M;.

Shrink TEMPFILE using alter tablespace command
SQL> ALTER TABLESPACE temp SHRINK TEMPFILE '/u01/app/oracle/oradata/TEST11G/temp01.dbf' KEEP 40M;

Shrink TEMP Tablespace to the smallest possible size:
SQL> ALTER TABLESPACE temp SHRINK SPACE;

SELECT pid FROM v$process
WHERE addr =
(
SELECT paddr FROM v$bgprocess
WHERE name = 'SMON'
);

ORADEBUG WAKEUP 6

echo "Connecting to 192.168.1.100"
$Server="192.168.1.100"
$User="Administrator"
$Password="AdminPassword"
cmdkey /generic:TERMSRV/$Server /user:$User /pass:$Password
mstsc /v:$Server

run {
SET ARCHIVELOG DESTINATION TO '/oracle/temp_restore';
RESTORE ARCHIVELOG FROM SEQUENCE 128458 UNTIL SEQUENCE 128510;
}

Excel can be rather particular about what it accepts as "valid CSV". I had to resort to the following on several occasions:

Const vbFormatStandard = 1
Const vbFormatText = 2
Const vbFormatDate = 4

Const xlDelimited = 1
Const xlDoubleQuote = 1

' change according to number/type of the fields in your CSV
dataTypes = Array( Array(1, vbFormatText)
, Array(2, vbFormatStandard)
, Array(3, vbFormatText)
, Array(4, vbFormatDate)
)

Set xl = CreateObject("Excel.Application")
xl.Visible = True

xl.Workbooks.OpenText "input.csv", , , xlDelimited, xlDoubleQuote, False _
, False, True, , , , dataTypes
Set wb = xl.ActiveWorkbook

Voir les commentaires