Benutzer-Werkzeuge

Webseiten-Werkzeuge


dba:oracle_18c_se_linux

Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

Link zu dieser Vergleichsansicht

Beide Seiten der vorigen RevisionVorhergehende Überarbeitung
Nächste Überarbeitung
Vorhergehende Überarbeitung
Nächste ÜberarbeitungBeide Seiten der Revision
dba:oracle_18c_se_linux [2019/12/08 19:45] – [Oracle Trace File Analyzer (TFA)] gpipperrdba:oracle_18c_se_linux [2019/12/10 18:54] – [Quellen] gpipperr
Zeile 217: Zeile 217:
  
  
-[oracle@dbph01-templ:create_database ]$ ./create_gpi_database.sh+[oracle@gpidbsrv:create_database ]$ ./create_gpi_database.sh
 -- Info :: Oracle HOME found  : use as ORACLE HOME - /opt/oracle/product/18.0.0/dbhome_1 -- Info :: Oracle HOME found  : use as ORACLE HOME - /opt/oracle/product/18.0.0/dbhome_1
 -- Info :: Oracle BASE found  : use as ORACLE BASE - /opt/oracle -- Info :: Oracle BASE found  : use as ORACLE BASE - /opt/oracle
Zeile 232: Zeile 232:
 !! Check the name resolution of the DB host !! Check the name resolution of the DB host
 ----------------------------------- -----------------------------------
-PING dbph01-templ (192.168.123.99) 56(84) bytes of data. +PING gpidbsrv (192.168.123.99) 56(84) bytes of data. 
-64 bytes from dbph01-templ (192.168.123.99): icmp_seq=1 ttl=64 time=0.023 ms+64 bytes from gpidbsrv (192.168.123.99): icmp_seq=1 ttl=64 time=0.023 ms
  
---- dbph01-templ ping statistics ---+--- gpidbsrv ping statistics ---
 1 packets transmitted, 1 received, 0% packet loss, time 0ms 1 packets transmitted, 1 received, 0% packet loss, time 0ms
 rtt min/avg/max/mdev = 0.023/0.023/0.023/0.000 ms rtt min/avg/max/mdev = 0.023/0.023/0.023/0.000 ms
Zeile 256: Zeile 256:
 Security                  ON: Local OS Authentication Security                  ON: Local OS Authentication
 SNMP                      OFF SNMP                      OFF
-Listener Log File         /opt/oracle/diag/tnslsnr/dbph01-templ/listener/alert/log.xml+Listener Log File         /opt/oracle/diag/tnslsnr/gpidbsrv/listener/alert/log.xml
 Listening Endpoints Summary... Listening Endpoints Summary...
-  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbph01-templ)(PORT=1521)))+  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=gpidbsrv)(PORT=1521)))
 The listener supports no services The listener supports no services
 The command completed successfully The command completed successfully
Zeile 268: Zeile 268:
    Environment    Environment
     Database            : GPIDB     Database            : GPIDB
-    Hostname            : dbph01-templ.intec.de+    Hostname            : gpidbsrv.intec.de
     DB Type             : Single Instance     DB Type             : Single Instance
     DB Storage          : Filesystem Storage     DB Storage          : Filesystem Storage
Zeile 362: Zeile 362:
 <code bash> <code bash>
  
-[oracle@dbph01-templ:~ ]$ setdb+[oracle@gpidbsrv:~ ]$ setdb
 ----------------------------------- -----------------------------------
     Current ORACLE SID  :     Current ORACLE SID  :
Zeile 373: Zeile 373:
     New ORACLE HOME set : {/opt/oracle/product/18.0.0/dbhome_1}     New ORACLE HOME set : {/opt/oracle/product/18.0.0/dbhome_1}
 ----------------------------------- -----------------------------------
-[oracle@dbph01-templ:~ ]$ adrci+[oracle@gpidbsrv:~ ]$ adrci
  
 ADRCI: Release 18.0.0.0.0 - Production on Wed Dec 4 21:18:13 2019 ADRCI: Release 18.0.0.0.0 - Production on Wed Dec 4 21:18:13 2019
Zeile 383: Zeile 383:
 ADR Homes: ADR Homes:
 diag/rdbms/intec/INTEC diag/rdbms/intec/INTEC
-diag/tnslsnr/dbph01-templ/listener+diag/tnslsnr/gpidbsrv/listener
 adrci> set home diag/rdbms/intec/INTEC adrci> set home diag/rdbms/intec/INTEC
 adrci> show alert -tail -f adrci> show alert -tail -f
Zeile 415: Zeile 415:
 | Host         | Status of TFA | PID  | Port  | Version    | Build ID             | Inventory Status | | Host         | Status of TFA | PID  | Port  | Version    | Build ID             | Inventory Status |
 +--------------+---------------+------+-------+------------+----------------------+------------------+ +--------------+---------------+------+-------+------------+----------------------+------------------+
-dbph01-templ | RUNNING       | 2051 | 10861 | 18.1.0.0.0 | 18100020171203222424 | COMPLETE         |+gpidbsrv | RUNNING       | 2051 | 10861 | 18.1.0.0.0 | 18100020171203222424 | COMPLETE         |
 '--------------+---------------+------+-------+------------+----------------------+------------------' '--------------+---------------+------+-------+------------+----------------------+------------------'
  
Zeile 505: Zeile 505:
 ==== Quellen ==== ==== Quellen ====
  
- +Oracle: 
-https://www.askmlabs.com/2018/09/oracle-database-18c-simple-installation.html+  https://docs.oracle.com/en/database/oracle/oracle-database/18/install-and-upgrade.html
dba/oracle_18c_se_linux.txt · Zuletzt geändert: 2020/09/14 12:44 von gpipperr