h>
timedatectl
#falls es nicht passt
timedatectl set-timezone Europe/Berlin
</code>
Für die eigentli... space für APEX anlegen:
<code sql>
ALTER SESSION SET CONTAINER = ans;
CREATE TABLESPACE APEX DATAFIL... RESTRICTED, OPEN_TIME FROM V$PDBS;
ALTER SESSION SET CONTAINER = FREE;
SHOW CON_NAME
</code>
=== ... iner wechseln
sqlplus / as sysdba
ALTER SESSION SET CONTAINER = FREEDB1;
#prüfen ob nicht ein alter
e [1]: 2
The setting named: db.connectionType was set to: basic in configuration: default
The setting named: db.hostname was set to: 10.10.10.90 in configuration: default
The setting named: db.port was set to: 1521 in configuration: default
The setting named: db.servicename was set to: SRV_GPIDB_MAIN in configuration: default
The
5s
flush_jitter = "0s"
## By default or when set to "0s", precision will be set to the same
## timestamp order as the collection interval, with the m... It is up to each individual
## service input to set the timestamp at the appropriate precision.
## ... ,
## "stderr" or, on Windows, "eventlog". When set to "file", the output file
## is determined by
L_STORE', 'multi_column_datastore' )
exec ctx_ddl.set_attribute ( 'GPI_MULTI_COL_STORE', 'columns', 'kd_name, anschrift, bemerkung' )
exec ctx_ddl.set_attribute ( 'GPI_MULTI_COL_STORE', 'filter', ... n t1
for each row
begin
update search_master set CHANGE_DATE=to_char(sysdate) where PK_TABLENAME='... n t2
for each row
begin
update search_master set CHANGE_DATE=to_char(sysdate) where PK_TABLENAME='
ath system variable is missing or invalid. Please set java.library.path with a correct value and retry ... _gpi> startup
..
TNS-04077: WARNING: No password set for the Oracle Connection Manager instance.
..
CMCTL:cman_gpi> set password
Enter Old password:
Enter New password:... 1c/cman_gpi
diag/tnslsnr/cman21c/listener
adrci> set home diag/netcman/cman21c/cman_gpi
adrci> show a
<code bash>
#über Kommando Werkzeug
hostnamectl set-hostname racdb01.pipperr.local
# Neue Session sta... n
#
vi /etc/sysconfig/ntpd
OPTIONS=" -x -g"
# Set the ntp Settings
#
vi /etc/ntp.conf
#server
# My... omodify notrap
#check your local nameserver and set the time
ntpdate 192.168.178.1
#activate the ser... 1 ntpd[2330]: 0.0.0.0 c617 07 panic_stop -3601 s; set clock manually within 1000 s.
</code>
Lösung: "--
ivate/haproxy.pem
mode http
http-request set-header X-Forwarded-For %[src]
reqadd X-Forwar... y default, if your workload permits it you should set it to at least 2048. Please set a value >= 1024 to make this warning disappear.
Configuration file is... t name, for mod_proxy ensure ProxyPreserveHost is set to On
</code>
siehe dazu auch den Oracle Suppor
e Objektanzahl und Rechte vergleichen:
<code sql>
SET linesize 130 pagesize 30 recsep OFF
select owne... en Instancen wenn RAC!) :
<code sql>
alter system set undo_retention=4800 scope=memory sid='*';
# Für ... SPACE UNDOTBS01 RETENTION GUARANTEE;
ALTER system SET undo_retention=36000 scope=memory sid='GPIDB1';
... SPACE UNDOTBS02 RETENTION GUARANTEE;
ALTER system SET undo_retention=36000 scope=memory sid='GPIDB2';
cht jede Firma einen TOAD leisten und den Feature Set kann der Oracle SQL Developer im Prinzip durchaus... -developer/
=== Problem mit 20.4 ===
Problem: "set hidden param parseThreshold" Fehlermeldung bei lä... arsethreshod_error.png | Oracle SQLDeveloper 20.4 set hidden param parseThreshold}}
Einstellung der Session ändern mit:
<code bash>
set hidden param parseThreshold = 45000;
</code>
Nu
Bedarf am Listener entsprechend anmelden
LSNRCTL> set current_listener LISTENER_GPI
#einschalten
LSNRCTL> set trc_level 16
# Wo liegt der Trace
LSNRCTL> show trc_file
#Ausschalten
LSNRCTL> set trc_level 0
</code>
siehe => "SQL*Net listener d... t für Patches: 11.2.0.3 Grid Infrastructure Patch Set Updates - List of Fixes in each GI PSU (Doc ID 15
32UTF8
#
# ODBC specific environment variables
#
set ODBCINI=/etc/odbc.ini
</code>
===Oracle Net f... Result :: ' || v_result);
UPDATE dual@MSSQL01 set FROM_X ='Y';
end loop;
end;
/
exit
</code>
Da... _CHARACTERSET')
order by 2
/
NLS DB Character Set Setting
------------------------ -----------
... MSSQL
* https://stackoverflow.com/questions/7321159/determining-the-character-set-of-a-table-database
xpand_sql_text die Funktion auflösen kann:
<code>
SET SERVEROUTPUT ON
DECLARE
v_full_sql CLOB;
BEGIN... keinen Sinn ...
-- nächster Versuch:
with data_set as (
select k.Kundenname,
getInteralKDNrSQM... teralKDNr
from Kunden k
)
select *
from data_set
group by Kundenname
, InteralKDNr
SQL... über **DBMS_UTILITY.expand_sql_text**
<code sql>
SET SERVEROUTPUT ON
DECLARE
v_full_sql CLOB;
BEGIN
g und kann es verwendet werden ===
<code plsql>
set serveroutput on
declare
v_out1 varchar2(3000);
... cht ausreichend:
<code bash>
SP2-0158: Unbekannte SET-Option "show"
Zeile 676: "set SQLC MIX" ist veraltet.
SP2-0158: Unbekannte SET-Option "recsep"
Autotrace deaktiviert
</code>
----