#1303
oracle
#1297
DEPARTMENT_NAME LAST_NAME SALARY DRANK ———————– —————— ———- ———- Purchasing Colmenares 2500 1 Purchasing Himuro 2600 2 Purchasing Tobias 2800 3 Purchasing Baida 2900 4 Purchasing Khoo 3100 5 Purchasing Raphaely 11000 6 Human Resources Marvis 6500
#1295
#1276
Retrieve the name of the Oracle instance currently connected to : Starting database with PFILE/SPFILE : Create an ini file (init$ORACLE_SID.ora) with :
#1273
is often due to one of the following reasons: – there is still an “sgadef.dbf” file in the “ORACLE_HOME/dbs” directory – the processes for Oracle (pmon, smon, lgwr and dbwr) still exist – shared memory segments and semaphores still exist even though the database has been shutdown – there is a “ORACLE_HOME/dbs/lk” file
#1270
Edit the file Source: Oracle Diaries: The Oracle system identifier ” already exists, specify another SID
#1268
1.Set the database parameter REMOTE_LOGIN_PASSWORDFILE = { shared | exclusive | none } 2. Check/Create a password file at location $ORACLE_HOME/dbs/ with command : 3. Restart DB
#1266
Oracle 12c Post Installation Mandatory Steps
#1097
To check how the job is defined :
#1048
Cause : / wrong definition of etc/hosts Short & Full hostname must match the real IP Error when creating oracle 11gR2 database with dbca: ORA-21561: OID generation failed