Oracle: verschil tussen versies

Uit Documents
Ga naar: navigatie, zoeken
Regel 1: Regel 1:
== Oracle ==
+
= Oracle =
  
=== Startup / Shutdown ===
+
== Startup / Shutdown ==
  
 
Login to SQL prompt:
 
Login to SQL prompt:
Regel 24: Regel 24:
 
<syntaxhighlight lang="sql">SQL> shutdown abort;</syntaxhighlight>
 
<syntaxhighlight lang="sql">SQL> shutdown abort;</syntaxhighlight>
  
=== RMAN ===
+
== RMAN ==
  
==== Segmentation Fault while running sbttest ====
+
=== Segmentation Fault while running sbttest ===
  
 
Netbackup server was unable to resolve clients ip address. Added an entry to the /etc/hosts file and the issue was solved.<ref>http://www.symantec.com/business/support/index?page=content&id=TECH57313</ref>
 
Netbackup server was unable to resolve clients ip address. Added an entry to the /etc/hosts file and the issue was solved.<ref>http://www.symantec.com/business/support/index?page=content&id=TECH57313</ref>

Versie van 1 apr 2011 om 20:19

Oracle

Startup / Shutdown

Login to SQL prompt:

sqlplus / as sysdba

Startup normally

SQL> startup;

Startup without actually mounting

SQL> startup nomount;

Use additional initialization file:

SQL> startup nomount pfile='/path/to/init.ora';

Shutdown:

SQL> shutdown;

Shutdown and terminate existing connections

SQL> shutdown immediate;

Shutdown and abort everything (last resort):

SQL> shutdown abort;

RMAN

Segmentation Fault while running sbttest

Netbackup server was unable to resolve clients ip address. Added an entry to the /etc/hosts file and the issue was solved.[1]

References

  1. http://www.symantec.com/business/support/index?page=content&id=TECH57313