Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

****************I am authoring a Book on Oracle Database Cloud Services.......More details to follow.***************

Title : Oracle Database Cloud Revealed
Publisher : Apress
Release Date : Jan-2019

**********************************************************************************


Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]


My Cloud Certifications:

AWS Certified Solutions Architect Associate

Oracle Cloud Infrastructure 2018 Certified Architect Associate.

Oracle Cloud Infrastructure Classic 2018 Certified Architect Associate.

Oracle Database Cloud Administrator Certified Professional.

Oracle Database Cloud Service Operations Certified Associate.

Search This Blog

Tuesday, August 22, 2017

Install and upgrade to Oracle 12c - Part-1


In this series we will install Oracle 11.2.0.2 db software and create a database using DBCA. In the subsequent series.
Part-2 : We will install 12.1.0.2
Part-3 : We will upgrade the database from 11.2.0.2 to 12.1.0,2
Part-4 : We will convert a non - CDB 12.1.0.2 database into a CDB and create a PDB.
Part-5 : We will upgrade the 12.1.0.2 database to 12.2.0.1






























root@shaikdb1 /u0/oracle/product/11.2.0/dbhome_1 =>./root.sh
Running Oracle 11g root script...

The following environment variables are set as:
    ORACLE_OWNER= oradm
    ORACLE_HOME=  /u0/oracle/product/11.2.0/dbhome_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file "dbhome" already exists in /usr/local/bin.  Overwrite it? (y/n) [n]:
The file "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n) [n]:
The file "coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n) [n]:

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.
Finished product-specific root actions.


Create database using dbca:



































[shaikdb1]: /u0/oracle/product/11.2.0/dbhome_1/network/admin> cp samples/listener.ora .
[shaikdb1]: /u0/oracle/product/11.2.0/dbhome_1/network/admin> vi listener.ora

[shaikdb1]: /u0/oracle/product/11.2.0/dbhome_1/network/admin> cat listener.ora | grep -v "#"
SHAIK11G =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = shaikdb1)(PORT = 1663))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1662))
    )
  )



[shaikdb1]: /u0/oracle/product/11.2.0/dbhome_1/network/admin> lsnrctl start SHAIK11G

LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production on 08-AUG-2017 11:30:28

Copyright (c) 1991, 2010, Oracle.  All rights reserved.

Starting /u0/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production
System parameter file is /u0/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Log messages written to /u0/oracle/product/11.2.0/dbhome_1/log/diag/tnslsnr/shaikdb1/shaik11g/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=shaikdb1)(PORT=1663)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1662)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=shaikdb1)(PORT=1663)))
STATUS of the LISTENER
------------------------
Alias                     SHAIK11G
Version                   TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production
Start Date                08-AUG-2017 11:30:30
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      ON
Listener Parameter File   /u0/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u0/oracle/product/11.2.0/dbhome_1/log/diag/tnslsnr/shaikdb1/shaik11g/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=shaikdb1)(PORT=1663)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1662)))
The listener supports no services
The command completed successfully




No comments: