create pluggable database.
create pluggable database anujv admin user vihaan identified by vihaan;
alter pluggable database anujv open;
or
alter pluggable database all open
col name format a15
SQL> r
1* select name, con_id from v$active_services
NAME CON_ID
--------------- ----------
anujv 5 <<<->Oracle will create this service automatically
anuj2 4
anuj1 3
vihaanXDB 1
vihaan 1
SYS$BACKGROUND 1
SYS$USERS 1
7 rows selected.
col PDB_NAME format a20
select pdb_name, status from cdb_pdbs
PDB_NAME STATUS
-------------------- -------------
ANUJV NORMAL
alter pluggable database anujv open ;
--- create user in pluggable database.
alter session set container=anujv;
create user vihaan1 identified by vihaan1;
SQL> grant connect,resource to vihaan1 ;
Grant succeeded.
edit tnsnames.ora
cd $ORACLE_HOME/network/admin
anujv =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.85.129)(PORT = 1521)))
(CONNECT_DATA =
(SERVICE_NAME = anujv)
)
)
[oracle@localhost admin]$ sqlplus vihaan1/vihaan1@anujv
user / password@tnsname entry
SQL*Plus: Release 12.1.0.1.0 Production on Tue Jul 16 19:58:05 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
or
with out tnsnames.ora entry
sqlplus vihaan1/vihaan1@localhost:1521/anujv
sqlplus vihaan1/vihaan1@192.168.85.129:1521/anujv
[oracle@localhost admin]$ sqlplus vihaan1/vihaan1@192.168.85.129:1521/anujv
SQL*Plus: Release 12.1.0.1.0 Production on Tue Jul 16 20:10:14 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Last Successful login time: Tue Jul 16 2013 20:04:31 +01:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oracle@ora-prim ~]$ export TWO_TASK=//192.168.0.71:1521/vihaan
[oracle@ora-prim ~]$ sqlplus anuj/vihaan
SQL*Plus: Release 12.1.0.2.0 Production on Thu Dec 8 11:10:02 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Last Successful login time: Thu Dec 08 2016 10:02:09 +00:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
or
[oracle@ora-prim ~]$ export TWO_TASK=192.168.0.71:1521/vihaan
[oracle@ora-prim ~]$ sqlplus anuj/vihaan
SQL*Plus: Release 12.1.0.2.0 Production on Thu Dec 8 11:11:00 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Last Successful login time: Thu Dec 08 2016 11:10:03 +00:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oracle@ora-prim ~]$ sqlplus system/sys@192.168.0.71:1521/vihaan
SQL*Plus: Release 12.1.0.2.0 Production on Thu Dec 8 10:01:01 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
or
admin]$ pwd
/u01/app/oracle/product/12.1.0.2/db_1/network/admin
vi tnsnames.ora
add this ..
anuj1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)))
(CONNECT_DATA =
(SERVICE_NAME = ANUJ)
)
)
sqlplus test1/test@anuj1
SQL*Plus: Release 12.1.0.2.0 Production on Sun Apr 23 04:26:35 2017
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Last Successful login time: Sun Apr 23 2017 04:00:42 -04:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
====
create or replace trigger open_pdbs
AFTER STARTUP ON DATABASE
BEGIN
EXECUTE IMMEDIATE 'ALTER PLUGGABLE DATABASE ALL OPEN';
END open_pdbs;
/
show errors
ALTER SESSION SET CONTAINER = ORCL;
REM exec DBMS_SERVICE.create_service('ORCL','ORCL');
REM exec DBMS_SERVICE.start_service('ORCL');
create or replace trigger start_ORCL_service
after startup on database
begin
sys.DBMS_SERVICE.start_service('ORCL');
end After_Startup;
/
show errors
===========================
SQL> alter session set container=ORCLABCD ;
ERROR:
ORA-44787: Service cannot be switched into.
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLABCD READ WRITE NO
SQL> alter session set container=ORCLABCD ;
ERROR:
ORA-44787: Service cannot be switched into.
==========
Try below
SQL> ALTER PLUGGABLE DATABASE ORCLABCD close ;
Pluggable database altered.
SQL> ALTER PLUGGABLE DATABASE ORCLABCD open;
Pluggable database altered.
SQL> alter session set container=ORCLABCD ;
Session altered.
======
Oracle 23c Pluggable !!!!!!!!!!!!!!!!!!!!!!
[oracle@localhost ~]$ sqlplus / as sysdba
SQL*Plus: Release 23.0.0.0.0 - Production on Tue Nov 7 10:43:09 2023
Version 23.3.0.23.09
Copyright (c) 1982, 2023, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid credential or not authorized; logon denied
Help: https://docs.oracle.com/error-help/db/ora-01017/
unset TWO_TASK!!!!!!!!!!!!!!
[oracle@localhost ~]$ unset TWO_TASK
[oracle@localhost ~]$ sqlplus / as sysdba
SQL*Plus: Release 23.0.0.0.0 - Production on Tue Nov 7 10:45:20 2023
Version 23.3.0.23.09
Copyright (c) 1982, 2023, Oracle. All rights reserved.
Connected to:
Oracle Database 23c Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.3.0.23.09
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 FREEPDB1 READ WRITE NO
SQL> alter session set container=FREEPDB1 ;
Session altered.
=====
[oracle@localhost ~]$ export ORACLE_PDB_SID=FREEPDB1
[oracle@localhost ~]$ sqlplus / as sysdba
SQL*Plus: Release 23.0.0.0.0 - Production on Tue Nov 7 11:23:49 2023
Version 23.3.0.23.09
Copyright (c) 1982, 2023, Oracle. All rights reserved.
Connected to:
Oracle Database 23c Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.3.0.23.09
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
3 FREEPDB1 READ WRITE NO
SQL>
======
unset TWO_TASK
conn hr/hr@//localhost:1521/freepdb1
Connected.
====
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
3 FREEPDB1 READ WRITE NO
SQL> grant dba to anuj identified by vihaan123;
w
sqlplus anuj/vihaan123@//localhost:1521/FREEPDB1
sqlplus anuj/vihaan123@//localhost/FREEPDB1
====
or with ip
sqlplus hr/hr@//192.168.0.70:1521/freepdb1
SQL*Plus: Release 23.0.0.0.0 - Production on Tue Nov 7 11:46:00 2023
Version 23.3.0.23.09
Copyright (c) 1982, 2023, Oracle. All rights reserved.
Last Successful login time: Wed Sep 13 2023 19:50:31 +00:00
Connected to:
Oracle Database 23c Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.3.0.23.09
SQL> def
DEFINE _DATE = "07-NOV-23" (CHAR)
DEFINE _CONNECT_IDENTIFIER = "//192.168.0.70:1521/freepdb1" (CHAR) <<<<<<<<<<<<---
DEFINE _USER = "HR" (CHAR)
DEFINE _PRIVILEGE = "" (CHAR)
DEFINE _SQLPLUS_RELEASE = "2303002309" (CHAR)
DEFINE _EDITOR = "vi" (CHAR)
DEFINE _O_VERSION = "Oracle Database 23c Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.3.0.23.09" (CHAR)
DEFINE _O_RELEASE = "2303002309" (CHAR)
SQL>
SQL> show user
USER is "HR"
SQL>
=======
for i in {1..5} ; do sqlplus -L -s sys/oracle@//localhost/pdb1 as sysdba <<< 'select name,open_mode,instance_name from v$instance , v$database;'; done
for i in {1..3} ; do sqlplus -L -s sys/oracle@//localhost/pdb1/CDB1 as sysdba <<< 'select name,open_mode,instance_name from v$instance , v$database;'; done
set linesize 300 pagesize 300
col name for a30
col restricted for a15
col status for a10
col PDBstatus for a15
col PDBrestricted for a15
SELECT
inst_id,
con_id,
name,
open_mode,
CASE
WHEN open_mode LIKE 'READ%' THEN '<-Good'
ELSE '<-bad'
END AS PDBstatus,
restricted ,
CASE
WHEN restricted = 'NO' THEN '<-Good'
ELSE '<-bad'
END AS PDBrestricted
FROM gv$pdbs
ORDER BY con_id;
SELECT
s.inst_id,
s.con_id,
s.name,
s.name_hash,
s.network_name,
s.creation_date,
s.con_id
FROM gv$active_services s
ORDER BY s.con_id;
export ORACLE_PDB_SID=FREEPDB1
[oracle@localhost ~]$ sqlplus / as sysdba
SQL*Plus: Release 23.0.0.0.0 - Production on Sat Nov 11 12:12:17 2023
Version 23.3.0.23.09
Copyright (c) 1982, 2023, Oracle. All rights reserved.
Connected to:
Oracle Database 23c Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.3.0.23.09
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
3 FREEPDB1 READ WRITE NO
===
whoami_pdb.sql
set line 300
col os_pid for a7
col tracefile for a80
col username for a15
col con_name for a10
col schemaname for a10
SELECT distinct s.con_id , c.con_name , s.username , s.user# , s.sid , s.serial# , s.prev_hash_value ,s.sql_id
, schemaname, p.spid os_pid
FROM V$SESSION S, v$process p, v$active_services c, (SELECT sid FROM v$mystat WHERE rownum=1) sid
WHERE audsid = SYS_CONTEXT('userenv','sessionid')
and p.addr = s.paddr
and sid.sid = s.sid
and s.username is not null
and s.con_id=c.con_id
and s.con_id=p.con_id
;
CON_ID CON_NAME USERNAME USER# SID SERIAL# PREV_HASH_VALUE SCHEMANAME OS_PID
---------- ---------- --------------- ---------- ---------- ---------- --------------- ---------- -------
1 CDB$ROOT SYS 0 1625 10412 3590809577 SYS 131783
====
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 VIHAAN MOUNTED
alter session set container=anuj service=vihaan;
set pages 500
set lines 300
col name format a20
col value format a80
col isdefault format a10
select name,value,isdefault from v$parameter
where lower(name) in ('db_name','db_unique_name','db_domain','instance_name','service_names','local_listener')
order by name;
alter session set container = PDB1;
grant dba to anuj identified by anuj123 container = current;
====
ALTER PLUGGABLE DATABASE anuj OPEN;
ALTER PLUGGABLE DATABASE anuj OPEN READ ONLY;
ALTER PLUGGABLE DATABASE anuj OPEN RESTRICTED;
ALTER PLUGGABLE DATABASE anuj CLOSE;
ALTER PLUGGABLE DATABASE anuj CLOSE IMMEDIATE;
ALTER PLUGGABLE DATABASE ALL OPEN;
ALTER PLUGGABLE DATABASE ALL EXCEPT anuj OPEN;
ALTER PLUGGABLE DATABASE ALL CLOSE IMMEDIATE;
ALTER PLUGGABLE DATABASE ALL EXCEPT anuj CLOSE IMMEDIATE;
ALTER PLUGGABLE DATABASE anuj SAVE STATE
ALTER PLUGGABLE DATABASE ALL SAVE STATE;
ALTER PLUGGABLE DATABASE anuj DISCARD STATE;
ALTER PLUGGABLE DATABASE XXX DISCARD STATE;
COLUMN con_name FORMAT A20
COLUMN instance_name FORMAT A20
SELECT con_name, instance_name, state FROM dba_pdb_saved_states;
SQL> alter pluggable database XXX discard state instances=all;
=====
SQL> alter session set "_oracle_script" = true;
SQL> alter pluggable database pdb$seed close;
SQL> alter pluggable database pdb$seed open read write;
SQL> create table registry$sqlpatch_org as select * from registry$sqlpatch ;
SQL> delete from registry$sqlpatch where PATCH_ID=xxx;
SQL> commit;
SQL> alter pluggable database pdb$seed close;
SQL> alter pluggable database pdb$seed OPEN READ ONLY;
SQL> alter session set "_oracle_script"=FALSE;
Execute datapatch individually in each of the containers, starting with CDB$ROOT :
1. Apply datapatch is CDB$ROOT :
===================================
./datapatch -verbose -pdbs CDB\$ROOT
2. Apply datapatch is PDB :
===================================
$ ./datapatch -verbose -pdbs <pdbname>
3. Apply datapatch is PDB$SEED :
==================================
SQL> alter session set container=PDB$SEED;
SQL> alter session set "_oracle_script"=TRUE;
SQL> alter pluggable database pdb$seed close immediate instances=all;
SQL> alter pluggable database pdb$seed OPEN READ WRITE;
SQL> select open_mode from v$database;
SQL> exit
Execute: ./datapatch -verbose -pdbs PDB\$SEED
SQL> alter session set "_oracle_script"=FALSE;
4. show pdbs -> If this shows the PDB$SEED in restricted mode, bounce the database once.
5. Check for the relevant patch existence in the registry$sqlpatch for all the containers (CDB$ROOT, PDB$SEED and PDB) :
set linesize 150
col logfile for a90
select patch_id, action, logfile, status from registry$sqlpatch;
Oracle Grid infrastructure is not configured properly ASMCA needs Oracle Grid Infrastructure to configure ASM
On Oracle 12c / Oracle 11gr2 for ASM on Stand-Alone Server
Run This srcipt again [root@localhost ~]# /u01/app/grid/product/12.1.0/grid/root.shPerforming root user operation for Oracle 12cThe following environment variables are set as: ORACLE_OWNER= grid ORACLE_HOME= /u01/app/grid/product/12.1.0/gridEnter the full pathname of the local bin directory: [/usr/local/bin]:The contents of "dbhome" have not changed. No need to overwrite.The contents of "oraenv" have not changed. No need to overwrite.The contents of "coraenv" have not changed. No need to overwrite.Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root script.Now product-specific root actions will be performed.To configure Grid Infrastructure for a Stand-Alone Server run the following command as the root user:/u01/app/grid/product/12.1.0/grid/perl/bin/perl -I/u01/app/grid/product/12.1.0/grid/perl/lib -I/u01/app/grid/product/12.1.0/grid/crs/install /u01/app/grid/product/12.1.0/grid/crs/install/roothas.plTo configure Grid Infrastructure for a Cluster execute the following command as grid user:/u01/app/grid/product/12.1.0/grid/crs/config/config.shThis command launches the Grid Infrastructure Configuration Wizard. The wizard also supports silent operation, and the parameters can be passed through the response file that is available in the installation media.Then run this script for a Stand-Alone Server[root@localhost ~]# /u01/app/grid/product/12.1.0/grid/perl/bin/perl -I/u01/app/grid/product/12.1.0/grid/perl/lib -I/u01/app/grid/product/12.1.0/grid/crs/install /u01/app/grid/product/12.1.0/grid/crs/install/roothas.plUsing configuration parameter file: /u01/app/grid/product/12.1.0/grid/crs/install/crsconfig_paramsLOCAL ADD MODECreating OCR keys for user 'grid', privgrp 'oinstall'..Operation successful.LOCAL ONLY MODESuccessfully accumulated necessary OCR keys.Creating OCR keys for user 'root', privgrp 'root'..Operation successful.CRS-4664: Node localhost successfully pinned.2013/07/07 19:59:44 CLSRSC-330: Adding Clusterware entries to file '/etc/inittab'localhost 2013/07/07 20:00:17 /u01/app/grid/product/12.1.0/grid/cdata/localhost/backup_20130707_200017.olr2013/07/07 20:00:18 CLSRSC-327: Successfully configured Oracle Grid Infrastructure for a Standalone Server
now run ASMCA again <<<<<<<<<<<<
Oracle Database 12c Release 1 (12.1) Installation On Centos 5.9
Oracle Database 12c Installation ..
Installation Oracle Database 12c Release 1 (12.1) On CentOS-5.9 or On linux
Installation Oracle Database 12c
sed -i s/^SELINUX=.*$/SELINUX=disabled/ /etc/selinux/config
[root@oragrid ~]# cat /etc/selinux/config
# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
# enforcing - SELinux security policy is enforced.
# permissive - SELinux prints warnings instead of enforcing.
# disabled - No SELinux policy is loaded.
SELINUX=disabled
# SELINUXTYPE= can take one of these three values:
# targeted - Targeted processes are protected,
# minimum - Modification of targeted policy. Only selected processes are protected.
# mls - Multi Level Security protection.
SELINUXTYPE=targeted
To set SELinux to permissive, type the following command:
sed -i s/^SELINUX=.*$/SELINUX=permissive/ /etc/selinux/config
setenforce 0
To set SELinux to disabled, type the following command:
sed -i s/^SELINUX=.*$/SELINUX=disabled/ /etc/selinux/config
1.
we need 64 bit OS . Download this torrent and start downloading
http://mirror.centos.org/centos/5.9/isos/x86_64/CentOS-5.9-x86_64-bin-DVD.torrent
sha1sum's for these torrent files:765b578facd7da42704ccd37ef4e498d40376785 CentOS-5.9-i386-bin-1to8.torrent
3f750a2c780aff30c982358c8727ec4a540389ef CentOS-5.9-x86_64-bin-1to9.torrent
d2bd38a60ea03a4370bbbd91b4e909a48c89835b CentOS-5.9-i386-bin-DVD.torrent
11326c888ad0290f5ccc7d4e26c2540438f56c35 CentOS-5.9-x86_64-bin-DVD.torrent
Install Centos
CentOS-5.9-x86_64-bin-DVD
2. Download Oracle Software from E-delivery
edelivery: Oracle Database 12c Release 1 (12.1.0.1) Software (64-bit)
https://edelivery.oracle.com/
Download following file for oracle 12c database
file name
V38500-01_1of2
V38500-02_1of2
-rw-r--r-- 1 root root 1116527103 Jun 28 17:44 V38500-01_2of2.zip
-rw-r--r-- 1 root root 1361028723 Jun 28 17:48 V38500-01_1of2.zip
unzip both the file you will get this dir
In unix create following group and oracle user
groupadd dba
groupadd oinstall
groupadd asmdba
groupadd asmadmin
useradd -g oinstall -G dba,asmdba,asmadmin oracle
chown -R oracle:oinstall /home/oracle
chown -R oracle:oinstalldatabase/
passwd oracle
su - oracle
Add the following lines at the end of the "/home/oracle/.bash_profile" file.
# Oracle Settings
export ORACLE_UNQNAME=vihaan
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/12.1.0/db_1
export ORACLE_SID=vihaan
export PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
groupadd dba
groupadd oinstall
groupadd asmdba
groupadd asmadmin
useradd -g oinstall -G dba,asmdba,asmadmin oracle
create following dir
mkdir -p /u01/app/oracle/product/12.1.0/db_1
chown -R oracle:oinstall /u01
chmod -R 775 /u01
as root
umount tmpfs
vi /etc/fstab ---add this line in
mount -t tmpfs shmfs -o size=1300m /dev/shm
vi /etc/sysctl.conf
Add or amend the following lines in the "/etc/sysctl.conf" file.
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500
/sbin/sysctl -p
Add the following lines to the "/etc/security/limits.conf" file.
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft stack 10240
oracle hard stack 32768
Following 31 rpms/packages (or later version ) are required on Centos 5 / Oracle Linux 5 / Red Hat Enterprise Linux 5 for Oracle 12c 64 bit
binutils-2.17.50.0.6
compat-libstdc++-33-3.2.3
compat-libstdc++-33-3.2.3 (32 bit)
gcc-4.1.2
gcc-c++-4.1.2
glibc-2.5-58
glibc-2.5-58 (32 bit)
glibc-devel-2.5-58
glibc-devel-2.5-58 (32 bit)
ksh
libaio-0.3.106
libaio-0.3.106 (32 bit)
libaio-devel-0.3.106
libaio-devel-0.3.106 (32 bit)
libgcc-4.1.2
libgcc-4.1.2 (32 bit)
libstdc++-4.1.2
libstdc++-4.1.2 (32 bit)
libstdc++-devel 4.1.2
libXext-1.0.1
libXext-1.0.1 (32 bit)
libXtst-1.0.1
libXtst-1.0.1 (32 bit)
libX11-1.0.3
libX11-1.0.3 (32 bit)
libXau-1.0.1
libXau-1.0.1 (32 bit)
libXi-1.0.1
libXi-1.0.1 (32 bit)
make-3.81
sysstat-7.0.2
rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' binutils-2.17.50.0.6 compat-libstdc++-33 gcc gcc-c++ glibc glibc-devel ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel libXext libXtst libXtst libX11 libXau libXi make sysstat
binutils-2.17.50.0.6-20.el5_8.3 (x86_64)
compat-libstdc++-33-3.2.3-61 (x86_64)
compat-libstdc++-33-3.2.3-61 (i386)
gcc-4.1.2-54.el5 (x86_64)
gcc-c++-4.1.2-54.el5 (x86_64)
glibc-2.5-107.el5_9.5 (x86_64)
glibc-2.5-107.el5_9.5 (i686)
glibc-devel-2.5-107.el5_9.5 (x86_64)
glibc-devel-2.5-107.el5_9.5 (i386)
ksh-20100621-12.el5 (x86_64)
libaio-0.3.106-5 (x86_64)
libaio-0.3.106-5 (i386)
libaio-devel-0.3.106-5 (i386)
libaio-devel-0.3.106-5 (x86_64)
libgcc-4.1.2-54.el5 (x86_64)
libgcc-4.1.2-54.el5 (i386)
libstdc++-4.1.2-54.el5 (x86_64)
libstdc++-4.1.2-54.el5 (i386)
libstdc++-devel-4.1.2-54.el5 (x86_64)
libstdc++-devel-4.1.2-54.el5 (i386)
libXext-1.0.1-2.1 (x86_64)
libXext-1.0.1-2.1 (i386)
libXtst-1.0.1-3.1 (x86_64)
libXtst-1.0.1-3.1 (i386)
libXtst-1.0.1-3.1 (x86_64)
libXtst-1.0.1-3.1 (i386)
libX11-1.0.3-11.el5_7.1 (x86_64)
libX11-1.0.3-11.el5_7.1 (i386)
libXau-1.0.1-3.1 (x86_64)
libXau-1.0.1-3.1 (i386)
libXi-1.0.1-4.el5_4 (x86_64)
libXi-1.0.1-4.el5_4 (i386)
make-3.81-3.el5 (x86_64)
sysstat-7.0.2-12.el5 (x86_64)
[root@localhost ~]# yum -y install compat-libstdc++-33
Loaded plugins: fastestmirror, security
Loading mirror speeds from cached hostfile
* base: mirror.bytemark.co.uk
* extras: mirror.sov.uk.goscomb.net
* updates: mirror.sov.uk.goscomb.net
Setting up Install Process
Package compat-libstdc++-33-3.2.3-61.x86_64 already installed and latest version
Package compat-libstdc++-33-3.2.3-61.i386 already installed and latest version
Nothing to do
==========================
for pkg in bc binutils compat-openssl11 elfutils-libelf fontconfig glibc glibc-devel glibc-headers ksh libaio libasan liblsan libX11 libXau libXi libXrender libXtst libxcrypt-compat libgcc libibverbs librdmacm libstdc++ libxcb libvirt-libs make policycoreutils policycoreutils-python-utils smartmontools sysstat; do
echo -n "$pkg: "
inst=$(rpm -q --qf '%{VERSION}-%{RELEASE}\n' "$pkg" 2>/dev/null)
if [ -n "$inst" ]; then
echo "[INSTALLED: $inst]"
else
echo "[NOT INSTALLED]"
fi
done
editing the "/etc/selinux/config" file, making sure the SELINUX flag is set as follows.
SELINUX=permissive
su - oracle
as a oracle
cd database
./runInstaller
[root@localhost tmp]# /u01/app/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.
Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.
[root@localhost tmp]# /u01/app/oracle/product/12.1.0/db_1/root.sh
Performing root user operation for Oracle 12c
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/12.1.0/db_1
Enter the full pathname of the local bin directory: [/usr/local/bin]:
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...
Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
[oracle@localhost ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Sun Jun 30 14:52:23 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> def
DEFINE _DATE = "30-JUN-13" (CHAR)
DEFINE _CONNECT_IDENTIFIER = "vihaan" (CHAR)
DEFINE _USER = "SYS" (CHAR)
DEFINE _PRIVILEGE = "AS SYSDBA" (CHAR)
DEFINE _SQLPLUS_RELEASE = "1201000100" (CHAR)
DEFINE _EDITOR = "ed" (CHAR)
DEFINE _O_VERSION = "Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options" (CHAR)
DEFINE _O_RELEASE = "1201000100" (CHAR)
SQL> select INSTANCE_NAME,VERSION from v$instance ;
INSTANCE_NAME VERSION
---------------- -----------------
vihaan 12.1.0.1.0
====
[root@oraafd ~]# ls -ltr /media/sf_software/
total 9231812
-rwxrwx--- 1 root vboxsf 2889184573 Nov 21 13:37 LINUX.X64_193000_grid_home.zip
-rwxrwx--- 1 root vboxsf 3369893688 Nov 22 14:47 p36916690_190000_Linux-x86-64.zip
-rwxrwx--- 1 root vboxsf 134583311 Nov 22 15:13 p6880880_190000_Linux-x86-64.zip
-rwxrwx--- 1 root vboxsf 3059705302 Dec 5 15:22 LINUX.X64_193000_db_home.zip
[root@oraafd ~]# pwd
/root
[root@oraafd ~]# cd /u01/app/oracle/product/19.3/db_1
[root@oraafd db_1]# unzip -oq /media/sf_software/LINUX.X64_193000_db_home.zip
