Posts

Showing posts from January, 2021

ORACLE DB(12C) INSTALLATION

Image
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 l