ORACLE DB(12C) INSTALLATION

ORACLE DB(12C) INSTALLATION

 

 

Installation of DB

1. Run as admininstrator -> setup.exe

2. Untick the box - next - yes(don’t enter email ..keep empty)

3. Next

4. Click 3^rd option (use window built-in account) - next -yes

5. Enter database name  -> change character set as unicode - > enter pswd as system -> oracle base (D:\app\) -> untick create as container database ->database file location ( d:\app\oradata)- > next -> yes

6. install

 

Changes after install complete:

1.      type ipconfig - copy ip

2.      Type hostname - copy hostname

3.      D:\app\product\12.1.0\dbhome_2\NETWORK\ADMIN - open tnsnames.ora in notepad++ --> change localhost to ur hostname

4.      D:\app\product\12.1.0\dbhome_2\NETWORK\ADMIN - open listener.ora in notepad++ --> replace localhost with ur hostname

5.      C:\Windows\System32\drivers\etc - open hosts in notepad++ --> add ip and nostname

 

To check if connected:(after changing localhost as hostname and adding ip )

1. Cmd run as administrator

2. Type lsnrctl- stop - start - status- exit

3. - sqlplus / as sysdba

4. -select name, open_mode from v$database;

5.  -conn system/system

6. - exit

7.  - tsnping xstore