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
ce im Mount modus starten
- Rman Datenbank mit "set NewName" zurücksichern
- Instance stoppen und m... s vom Thread 2 wieder anlegen
- Datenbank mit Reset Logs öffnen
- Temp File anlegen
- Thread 2 di... .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 '+GP
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 the database you like to install [AL32UTF8]:
----------... e locations for the datafiles of your database
Set the Redo Log Destination 1 location
+please ente
eter reseten, Bespiel:
<code sql>
ALTER SYSTEM RESET "_some_hidden_parameter" scope = spfile;
</code>
... homes
ADR Homes:
..
diag\rdbms\gpi\gpi
..
adrci> set home diag\rdbms\gpi\gpi
adrci> show alert -tail -...
<code >
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\OracleOraDB12Home1ClrAgent
# ImagePath a... ble schema version.</fc>
<code powershell>
adrci> set home diag\tnslsnr\v65690\listener
adrci> purge -a
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
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
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
!)<code dos>cmd
reg add hklm\system\currentcontrolset\services\tcpip6\parameters /v DisabledComponents ... nd mit "opatch apply"einspielen <code dos>
cmd
d:
set ORACLE_HOME=D:\oracle\product\12.1.0.2\dbhome_1
c... vds
diag\tnslsnr\12CWIN2012ORA01\listener
adrci> set home diag\rdbms\vds\vds
adrci> show alert -tail ... ese als SYS validieren und reparieren
<code sql>
set serveroutput on
exec validate_apex;
</code>
In m
**!
\\
auf folgende Meldung achten **possible charset conversion** :\\
<code>
Export done in WE8MSWIN1252 character set and UTF8 NCHAR character set
server uses UTF8 character set (possible charset conversion)
</code>
<code>
D:\scripts>exp my_ours/m