cmd Script:
<code dos>
@ECHO OFF
REM Script to set the environment Variables for the different Oracl... uters IP address
:: -- %~1 - out, IP
SETLOCAL
set ip=
for /f "tokens=2,* delims=:. " %%a in ('"ipconfig|find "IPv4 Address""') do set ip=%%b
( ENDLOCAL & REM RETURN VALUES
IF "%~1" NEQ "" (SET %~1=%ip%) ELSE (set ip=%ip%)
)
set ORIG_PATH=%PA
=================================================
set echo on
create role call_awr_reports;
grant sel... ct on sys.dba_hist_snapshot to call_awr_reports;
set echo off
</code>
Rolle mit "grant call_awr_repo... p_id, instance_number
/
clear break
ttitle off
set feedback off
set heading off
set termout off
column spool_name_col new_val spool_name
column instance
nomount" starten
Dos Schell öffnen:
<code cmd>
set ORACLE_SID=VDSSB
set ORACLE_HOME=d:\oracle\product\11.2.0.4\dbhome_1
d:
cd %ORACLE_HOME%
oradim -NEW ... ROM ACTIVE DATABASE NOFILENAMECHECK
spfile set "DB_UNIQUE_NAME"="VDSSB"
dorecover;
</c... PARAMETER_VALUE_CONVERT '\VDSSB\','\VDS\'
set "DB_UNIQUE_NAME"="VDS"
set LOG_FILE_NAME_CO
benötigt um Tipp Arbeit zu sparen\\
<code plsql>
set lines 140
set pages 500
spool d:\setnewname.txt
select 'set newname for datafile ' || file# || ' to ''+ORADATA/' || ... - control01.ctl bleibt i.d.R. übrig:
- set oracle_home=d:\oracle\1020\asm
- set oracle_s
möglich aber nicht mehr supported!):
<code sql>
#set DB enviroment
cd $ORACLE_HOME/rdbms/admin
sqlplus... New 19c Installs (Doc ID 2591868.1)
<code sql>
#set DB enviroment
cd $ORACLE_HOME/rdbms/admin
sqlplu... t"connect / as sysdba" followed by "alter session set CURRENT_SCHEMA=CTXSYS;"
sqlplus / as sysdba
alter session set CURRENT_SCHEMA=CTXSYS;
SQL> select sys_context(
im Detail geprüft und optimiert werden!)
<code>
set noexec_user_stack=1
set semsys:seminfo_semmsl=256
set semsys:seminfo_semvmx=32767
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmseg=1024
set sh
t werden (ORACLE_SID/ORALCE_HOME/Pfade etc.){{dba:set_db_enviroment_se_edition.png|Umgebung mit eigenen... -------------------------
Define the Character Set of your database
please enter the Charset of th... e locations for the datafiles of your database
Set the Redo Log Destination 1 location
+please ente... ta/redo1]:
/opt/oracle/oradata/redo1 exists
Set the Redo Log Destination 2 location
+please ente
ce im Mount modus starten
- Rman Datenbank mit "set NewName" zurücksichern
- Instance stoppen und m... .801931869
exit
</code>
====Rman Datenbank mit "set NewName" zurücksichern ...
delete noprompt EXPIRED backup;
}
# restore mit set newname
run {
SET newname FOR datafile 1 to '+GPI';
SET newname FOR datafile 2 to '+GPI';
SET newname
4bit
* p6880880 ((MSWIN x86 64 - OPatch Patch Set)
* p19651773 (MSWIN x86 64 - WINDOWS DB BUNDLE ... er OraPowerShell setdb
# oder alternativ manuell
set-item -path env:ORACLE_HOME -value D:\oracle\produ... er OraPowerShell setdb
# oder alternativ manuell
set-item -path env:ORACLE_HOME -value D:\oracle\produ... er NEUEN Umgebung ausführen.
<code powershell>
# set the enviroment
# setdb with oraPowerShell
sqlplu
hen Windows 10 in der Powershell:
<code sql>
# set all to German
set-item -path ENV:JAVA_TOOL_OPTIONS -value "-Duser.language=de -Duser.region=DE -Duser.country=DE"
set-item -path ENV:NLS_LANG -value "german_germany.ut... atabase 12c ...
</code>
Siehe auch SQLcl 4.2 - Set the language of the help text => https://communi
homes
ADR Homes:
..
diag\rdbms\gpi\gpi
..
adrci> set home diag\rdbms\gpi\gpi
adrci> show alert -tail -... ble schema version.</fc>
<code powershell>
adrci> set home diag\tnslsnr\v65690\listener
adrci> purge -a...
<code powershell>
-- für jedes Home!
show homes
set home
adrci> migrate schema
Schema migrated.
ad... 12.1.0.2.0
alter system set compatible='19.0.0' scope=spfile sid='*';
-- Op
rwendet werden.
Beispiel:
<code plsql>
-- setzen
set termout off
col x new_value y
define y=?
select to_char(sysdate,'YYYYMMDDHH24MISS') x from dual;;
set termout on
spool &y._spool.log
-- hier das tun ... d in SQL*Plus Scripten escapen ====
<code sql>
set escape on
-- mit \ escapen
..
and account_statu... m Hostnamen der DB versehen: ====
<code plsql>
SET termout off
DEFINE _EDITOR=vi
col x new_value y
d
Version passen!
adrci
adrci> show homes
adrci> set home diag/rdbms/gipdb/GPIDB1
adrci> show control... etzen:
<code bash>
#Auf 183 Tage setzen
adrci> set control (LONGP_POLICY=4392) ;
</code>
----
=... echo "check home setting for ${a}"
adrci exec="set home ${a};select SHORTP_POLICY,LONGP_POLICY,LAST_... d.log
#
# #####################################
#set the enviroment to the ${USER} home
source /home/$
eed the Tuning Pack for this feature!!!!
prompt
set feedback off
set heading off
set termout off
column spool_name_col new_val spool_name
column instance_number new_val i... RENV','INSTANCE') as instance_number
FROM dual
/
set feedback on
set heading on
set termout on
set tr