Oracle: verschil tussen versies
Uit Documents
| Regel 1: | Regel 1: | ||
| − | + | = Oracle = | |
| − | + | == 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 == | |
| − | + | === 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
Inhoud
Oracle
Startup / Shutdown
Login to SQL prompt:
sqlplus / as sysdbaStartup 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]