Software Testing

Issue: Unable to connect to Oracle DB in OEL (Linux) from windows 1) Go to $cd $ORACLE_HOME/dbs 2) $mv /<ORACLE_HOME>/product/10.2.0/server/dbs/orapwtestdb /<ORACLE_HOME>/product/10.2.0/server/dbs/orapwtestdb_bkp 3) $orapwd file=orapw$ORACLE_SID password=<enter your password> force=y entries=10 4) $ls -ltr orapw* 5) $sqlplus / as sysdba SQL> select * from v$pwfile_users; USERNAME                       SYSDB SYSOP SYSAS ------------------------------ ----- ----- ----- SYS                            TRUE  TRUE  FALSE ... Now trying logging into database from windows...

Procedure followed to bring up the Oracle DB: 1) Login with the su - oracle user 2) sqlplus / as sysdba 3) Check the lsnrctl status if it is not up start by using lsnrctl start 4) Execute "startup" command after login to sqlplus / as sysdba 5) If you encounter with this error: ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener Check if ORACLE_HOME_LISTNER path is set in the .profile Execute the .profile Execute tnsping <ORASID> 6) Login  sqlplus / as sysdba 7) Execute "startup" Encountered with following error: ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file '/home/app/oracle/product/11.2.0/db_1/dbs/initDB11G.ora' 8) Login with sqlplus sys/Password as sysdba 9) Check for the existence of spfile under this path "/home/app/oracle/product/11.2.0/db_1/dbs/spfileorcl.ora" 10) Execute " create pfile from spfile='/home/app/oracle/product/11.2.0/db_1/d...

Summary of Normalization 1st Normal form removes repitition by creating one-to-many relationships 2nd Normal form not creates one-to-many relationships but many-to-one relationships, thus effectively seperating static from dynamic information. 2nd Normal form removes items from tables independent of  primary key. 3rd Normal form is used to resolve many-to-many relationships into unique values 3rd NF allows uniqueness of information by creation of additional many-to-many join resolution tables