terprise%';
quit"|${ORACLE_HOME}/bin/sqlplus -s / as sysdba`
echo "check DB Version - Get 1 for EE an... erate Copy of pfile
${ORACLE_HOME}/bin/sqlplus / as sysdba << EOScipt
ALTER DATABASE backup controlfile TO trace AS '${BACKUP_DEST}/${ORACLE_DBNAME} controlfile_trac... up
datalocations=`${ORACLE_HOME}/bin/sqlplus -s / as sysdba << EOScipt
set pagesize 0
sing /srv/ansible/deploy_ansible_user/ansible.cfg as config file
SSH password:
PLAY [Execute Command]... /oracle/ansible_scripts
- name: Call the script as oracle user
become: yes
become_user: oracle
command: "$ORACLE_HOME/bin/sqlplus -s / as sysdba @/home/oracle/ansible_scripts/set_pack_acc... Using /srv/ansible/oracle_maintenance/ansible.cfg as config file
PLAY [Call SQL*Plus Script to disabl
ür eine Cluster Datenbank:
<code sql>
sqlplus / as sysdba
show parameter target
show parameter max
... d GPIDB
srvctl start database -d GPIDB
sqlplus / as sysdba
#check
show parameter target
show paramet... / 2MB = <Anzahl der Pages>
<code sql>
sqlplus / as sysdba
sql>show sga
Total System Global Area 4... sql>select (4.2758E+10 * 1.01 )/ ((1024*1024)*2) as count_pages from dual;
COUNT_PAGES
-----------
he loopback interface. This could
# be tightened as well, but to do so would effect some of
# the adm... 0
# Alles zusammen abfragen:
ntpq -c peer -c as -c rl
remote refid st t when... h the mean cluster time. No action has been taken as the Cluster Time Synchronization Service is runni... d Infrastructure Does not Start after Node Reboot as Master octssd.bin Stuck (Doc ID 1215893.1)
Windo
ssword ofPASSW0RD (with a zero, not the letter O) as dfault ... siehe Doku hier [[http://download.boul... channel, SCSI target ID, and LUN. The dashes act as wildcards meaning "rescan everything"
=== Welc... neriert.
Über die Datenbank:
<code sql>
CONN / AS SYSDBA
SET SERVEROUTPUT ON
DECLARE
l_latency