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 3rd 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
Comments
Post a Comment