Skillnad mellan versioner av "Oracle-Database"

Versionen från 3 februari 2017 kl. 17.44

Install FAQ

# ./runinstaller -ignoreSysPrereqs

# ./runInstaller -record -destinationFile <responsefilename>

Oracle Pre-Reqs doc

Oracle Support Document 169706.1 (Oracle Database (RDBMS) on Unix AIX,HP-UX,Linux,Mac OS X,Solaris,

Tru64 Unix Operating Systems Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2))

can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=169706.1

To record sqlplus entries run the following

SQL> spool

SQL> spool off

SQL> spool < filename >

Dbas login

# ORACLE_SID=<SID>; export $ORACLE_SID

# echo $ORACLE_SID

# sqlplus /nolog

SQL> connect / as sysdba

# sqlplus / as sysdba

ORAENV

The oraenv scriptis installed in /usr/local/bin and takes values from the oratab file located in /etc.

Oratab fields entries are of the form:

$ORACLE_SID:$ORACLE_HOME:<N|Y>:

Oracle startup sequence

Oracle databases statuses sequence: SHUTDOWN -> NOMOUNT -> MOUNT -> OPEN

Check dbas status

SQL> set lines 200 pages 200

SQL> select instance_name,host_name,status from v$instance;

Display alert log for a database

SQL> set linesize 300

SQL> column value format a300

SQL> select value from v$parameter where name='background_dump_dest';