Hi,
This post might be simpler but I will try to put some useful details which can help a beginner's or DBA's to understand oracle11g release2 installation,Database creation and useful feature of this excellent Database.
Step1:Download the Oracle11g release2 software & Unzip it.
We can download the Oracle11g release2 software from OTN(If you are not having OTN(Oracle technology network) account please create one).Download the software from the below link:
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
Note:You need around 4.5 Gb of space to download these software in your machine,so please make sure you have enough space.The software will be in zip format.Unzip in your machine where around 4.5 GB of space is available.
Step2:Create Directories for your Installation with useful naming conventions
We can create two directories atleast 1)Oracle11g release2 Home:Oracle11g_home =>Where all the binaries,admin files are present and 2)Oracle11g release2 Database files directory:Oracle11g_DB=>Here you can put your Database files and Tablespaces.In this article:
D:\Oracle11g_home=>Oracle11g release2 Home.
D:\Oracle11gDB=>Oracle11g Database files.
Step3: Start your Oracle11g release2 installation
Click the 11gSetup and start your installation.The installation will proceed as mentioned in the diagrams.
Specify the Oracle11g release2 home path,Make sure you have around 4 GB of free space in the Drive where you are keeping the home
Specify the Oracle11g releases2 Database files here all your Datafiles,logfile,parameter files and Tablespace will be present.
Step4::Choose password management page to unlock some users like scott,hr and specify the suitable password
Step5:Verify your installation as follows.
SQL> select name from v$database;
NAME
---------
ORACLE11
SQL> select status from v$instance;
STATUS
------------
OPEN
SQL> select *from v$version;
BANNER
--------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.
2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for 32-bit Windows: Version 11.2.0.1.0 - Produ
ction
NLSRTL Version 11.2.0.1.0 - Production
Component installed:
---------------------
SQL> select comp_id||' '||comp_name||' '||version from dba_registry;
COMP_ID||''||COMP_NAME||''||VERSION
--------------------------------------------------
OWB OWB 11.2.0.1.0
APEX Oracle Application Express 3.2.1.00.10
EM Oracle Enterprise Manager 11.2.0.1.0
AMD OLAP Catalog 11.2.0.1.0
SDO Spatial 11.2.0.1.0
ORDIM Oracle Multimedia 11.2.0.1.0
XDB Oracle XML Database 11.2.0.1.0
CONTEXT Oracle Text 11.2.0.1.0
EXF Oracle Expression Filter 11.2.0.1.0
RUL Oracle Rules Manager 11.2.0.1.0
OWM Oracle Workspace Manager 11.2.0.1.0
COMP_ID||''||COMP_NAME||''||VERSION
--------------------------------------------------
CATALOG Oracle Database Catalog Views 11.2.0.1.0
CATPROC Oracle Database Packages and Types 11.2.0.
1.0
JAVAVM JServer JAVA Virtual Machine 11.2.0.1.0
XML Oracle XDK 11.2.0.1.0
CATJAVA Oracle Database Java Packages 11.2.0.1.0
APS OLAP Analytic Workspace 11.2.0.1.0
XOQ Oracle OLAP API 11.2.0.1.0
18 rows selected.
Datafiles:
------------
SQL> select name from v$datafile;
NAME
--------------------------------------------------
D:\ORACLE11GDB\ORACLE11GDB\SYSTEM01.DBF
D:\ORACLE11GDB\ORACLE11GDB\SYSAUX01.DBF
D:\ORACLE11GDB\ORACLE11GDB\UNDOTBS01.DBF
D:\ORACLE11GDB\ORACLE11GDB\USERS01.DBF
D:\ORACLE11GDB\ORACLE11GDB\EXAMPLE01.DBF
Multiplexed controlfiles:
------------------------
SQL> select name from v$controlfile;
NAME
--------------------------------------------------
D:\ORACLE11GDB\ORACLE11GDB\CONTROL01.CTL
C:\APP\ARL1KOR\FLASH_RECOVERY_AREA\ORACLE11GDB\CON
TROL02.CTL
Redolog files:
--------------
SQL> select group#,member from v$logfile;
GROUP#
----------
MEMBER
--------------------------------------------------
3
D:\ORACLE11GDB\ORACLE11GDB\REDO03.LOG
2
D:\ORACLE11GDB\ORACLE11GDB\REDO02.LOG
1
D:\ORACLE11GDB\ORACLE11GDB\REDO01.LOG
Diagnostic dump dest:
---------------------
SQL> sho parameter %DIAG%
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
diagnostic_dest string C:\APP\ARL1KOR
SQL> sho parameter %USER%
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
license_max_users integer 0
parallel_adaptive_multi_user boolean TRUE
redo_transport_user string
user_dump_dest string c:\app\arl1kor\diag\rdbms\orac
le11gdb\oracle11gdb\trace
SQL> sho parameter %AUDIT%
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string C:\APP\ARL1KOR\ADMIN\ORACLE11G
DB\ADUMP
audit_sys_operations boolean FALSE
audit_trail string DB
SQL> sho parameter %CORE%
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
background_core_dump string partial
core_dump_dest string c:\app\arl1kor\diag\rdbms\orac
le11gdb\oracle11gdb\cdump
shadow_core_dump string none
SQL> sho parameter %BACK%
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
background_core_dump string partial
background_dump_dest string c:\app\arl1kor\diag\rdbms\orac
le11gdb\oracle11gdb\trace
backup_tape_io_slaves boolean FALSE
db_flashback_retention_target integer 1440
fast_start_parallel_rollback string LOW
rollback_segments string
transactions_per_rollback_segment integer 5
In the upcoming posts,I will posts the issues that can occur while using this releases or when you migrate from Oracle9i,10g to Oracle11g release2.Hope it helps.
Best regards,
Rafi.
No comments:
Post a Comment