atus database -d GPIDB
Instance GPIDB1 is running on node racdb01
Instance GPIDB2 is running on node racdb02
srvctl status service -d GPIDB
</code>
Bei... fc #800000>**Problem**:</fc>
Opatch version check on racdb01 home /opt/oracle/product/12.1.0.2/dbhome_... 7/10 22:33:00 CLSRSC-152: Could not set ownership on '/opt/12.1.0.2/grid/suptools/tfa/release/tfa_home
ate,'YYYYMMDDHH24MISS') x from dual;;
set termout on
spool &y._spool.log
-- hier das tun was soll
sp... lus Scripten escapen ====
<code sql>
set escape on
-- mit \ escapen
..
and account_status not in (... mpt "_USER'@'_CONNECT_IDENTIFIER-&y>"
SET termout ON
</code>
Alternativ zu "SYS_CONTEXT('USERENV','SE... egeben werden.
<code sql>
spool log.out
set echo on
-- Befehl
alter index .....;
set echo off
spool
fen:
* Oracle Database 12.1.0.2.0 is certified on Linux x86-64 Oracle Linux 7 !
* Oracle Clusterware 12.1.0.2.0 is certified on Linux x86-64 Oracle Linux 7
Damit steht einer Or... root, grid, oracle User
<code bash>
#generate key on every node
ssh-keygen -t rsa
#self
cat ~/.ssh/id_... sa.pub >> ~/.ssh/authorized_keys
ssh racdb01
#key on 2
ssh racdb02 ssh-keygen -t rsa
# Copy public key
ct DATABASE_ROLE,LOG_MODE,FORCE_LOGGING,FLASHBACK_ON from v$database;
DATABASE_ROLE LOG_MODE FORCE_LOGGING FLASHBACK_ON
---------------- ------------ ----------- -----... ter database archivelog;
alter database flashback on;
alter database force logging;
alter database ope... ys@vdssb as sysdba
sql> alter database flashback on;
sql> exit
</code>
==Primare DB - Einrichten d
========================================
set echo on
create role call_awr_reports;
grant select on sys.gv_$database to call_awr_reports;
grant select on sys.gv_$instance to call_awr_reports;
grant select on sys.v_$database to call_awr_reports;
grant select
VIP is enabled.
SCAN VIP is individually enabled on nodes:
SCAN VIP is individually disabled on nodes:
SCAN 1 IPv4 VIP: 10.10.10.210
SCAN VIP is enabled.
SCAN VIP is individually enabled on nodes:
SCAN VIP is individually disabled on nodes:
$GRID_HOME/bin/srvctl config scan_listener
SCAN
M_ATTRIBUTE a
inner join v$asm_diskgroup g on (g.group_number=a.group_number)
where g.name like... v$asm_disk d
inner join v$asm_diskgroup g on (g.group_number=d.group_number)
where g.name like... v$asm_disk d
inner join v$asm_diskgroup g on (g.group_number=d.group_number)
where d.path like... ce votedisk +REDO01
Failed to create voting files on disk group REDO01.
Change to configuration failed
ode sql>
GRANT CTXAPP TO MYUSER;
GRANT EXECUTE ON CTXSYS.CTX_CLS TO myuser;
GRANT EXECUTE ON CTXSYS.CTX_DDL TO myuser;
GRANT EXECUTE ON CTXSYS.CTX_DOC TO myuser;
GRANT EXECUTE ON CTXSYS.CTX_OUTPUT TO myuser;
GRANT EXECUTE ON CTXSYS.CTX_Q
tch lsinventory
..
Patch 19651773 : applied on Wed Dec 31 11:04:16 UTC 2014
Unique Patch ID: 18... LTER PACKAGE CTXSYS.DRIOPT COMPILE;
grant select on SYS.DBA_INDEXES to ctxsys;
grant select on SYS.DBA_TRIGGERS to ctxsys;
grant select on SYS.DBA_PART_KEY_COLUMNS to ctxsys;
grant select on SYS.D
verteilen]]
<code bash>
# für root/grid/oracle
# on db01
cd
#generate key on every node
ssh-keygen -t rsa
ssh db02 ssh-keygen -t rsa
# Copy public ke... installiert:
yum list | grep cvuqdisk
#Install on second node
scp cvuqdisk-1.0.10-1.rpm root@racdb0... PRVF-7573 : Sufficient swap size is not available on node "racdb01" [Required = 15.2881GB (1.6030712E7
039.1)"
----
====PRVG-11134 : Interface "%" on node "%" is not able to communicate with interface "%" on node "%"====
Fehler:
<code bash>
Checking mult... 230.0.1.0"...
RVG-11134 : Interface "10.2.2.208" on node "srvora04" is not able to communicate with interface "10.2.2.244" on node "srvora03"
</code>
Siehe auch : Grid Infr
r@pipperr.de
AHF will also be installed/upgraded on these Cluster Nodes :
1. racdb02
The AHF Location and AHF Data Directory must exist on the above nodes
AHF Location : /opt/oracle.ahf
AH... acle.ahf/data
Do you want to install/upgrade AHF on Cluster Nodes ? [Y]|N : Y
Extracting AHF to /opt... chk scheduler from AHF ...
AHF install completed on racdb01
Installing AHF on Remote Nodes :
AHF wi
TEMP01 TEMPFILE '+DATASSD' SIZE 2000M AUTOEXTEND ON NEXT 20M MAXSIZE 20000M EXTENT MANAGEMENT LOCAL ... DOTBS01 DATAFILE '+DATASSD' SIZE 3000M AUTOEXTEND ON NEXT 20M MAXSIZE 20000M;
CREATE UNDO TABLESPACE ... DOTBS02 DATAFILE '+DATASSD' SIZE 3000M AUTOEXTEND ON NEXT 20M MAXSIZE 20000M;
alter system set undo_... ACKUP_RESTORE.SETCONFIG('CONTROLFILE AUTOBACKUP','ON');
-- Configure RMAN configuration record 2
VARIA