Category Archives: linux

11g, 12c, Administration, linux, Oracle, Oracle 10g, oracle 9i, script, unix

Executing SQL script from command line or executable shell script

June 4, 2017 Larry Catt Leave a comment

You can call into SQLPLUS to execute SQL script from any shell script. This procedure shows how to structure your statements to LINUX environment for call into SQLPLUS from shell script.

1. Logon to your LINUX server as a user with access to SQLPLUS.
2. Use VI to create a executable file. Replace the connection string with appropriate username/password@SID values. Additionally, change the script you which to execute in this example we are executing “utlrp.sql”.

sqlplus sys/password@orcl as sysdba < < EOF @?/rdbms/admin/utlrp.sql exit; EOF

Larry Catt
OCP

11g, 12c, Administration, hp-ux, linux, unix

Executing Oracle Script as a LINUX or UNIX background process

May 30, 2017 Larry Catt Leave a comment

There are multiple situations where you have to execute processes in your Oracle environment as a daemon or background process of your OS. This procedure describes the use of “NOHUP” to begin the execution of a background process. In this example we are executing the Oracle 12c upgrade script ‘preupgrd.sql’ on an OEL (Oracle Enterprise Linux) platform.

1. Logon to your OEL server as the oracle software owner.

root@mylinux#su – oracle
oracle@mylinux#

2. Change directory to the location of your script file.

oracle@mylinux#cd /opt/app/oracle/product/12.1.0.2/rdbms/admin/
oracle@mylinux#

3. At the OS prompt execute the NOHUP command passing in a sqlplus connection string and the script name to be executed following by a terminating ampersand sign ‘&’.

nohup sqlplus sys/password as sysdba @./preupgrd.sql &

oracle@mylinux#nohup sqlplus sys/password as sysdba @./preupgrd.sql &
[1] 7260
oracle@mylinux#nohup: ignoring input and appending output to `nohup.out’

oracle@mylinux#

4. The (nohup) command will produce a log file in the local directory named nohup.out which records all terminal output from the daemon.

oracle@mylinux#cat nohup.out
SQL*Plus: Release 11.2.0.4.0 Production on Sat Mar 26 17:28:19 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Loading Pre-Upgrade Package…

SQL>

5. You can also see the processing with the system process command (ps) as shown below.

oracle@mylinux#ps -ef|grep nohup
oracle 9707 9268 0 18:11 pts/0 00:00:00 grep nohup
[1]+ Exit 1 nohup sqlplus sys/password as sysdba @./preupgrd.sql
oracle@mylinux#

6. This completes executing an Oracle script as a LINUX or UNIX background process.

Larry J. Catt, OCP

11g, 12c, Administration, hp-ux, linux, Users

Change time zone of Oracle RDBMS on Linux OS

May 11, 2017 Larry Catt Leave a comment

This procedure demonstrates the method to change the time zone setting of an Oracle RDBMS installed on a Linux server. NOTE: Oracle RDBMS by default take the time of the OS which they are installed on. Due to the number and variations LINUX distributions, this procedure may not work on all LINUX installs. This procedure was performed on Oracle Enterprise Linux 7.2 (OEL 7.2).

Logon to your Linux server as root.

[larry@linux2 ~]$ sudo su

[sudo] password for larry:

[root@linux2 larry]#

Change user to Oracle software owner and logon to SQLPLUS.

[root@linux2 etc]# su – oracle

Last login: Wed Nov 30 16:36:03 UTC 2016 on pts/1

[oracle@linux2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Wed Nov 30 16:38:13 2016

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

SQL>

Show the current date and time zone for the Oracle database with command: select systimestamp from dual;

SQL> select systimestamp from dual;

SYSTIMESTAMP

—————————————————————————

30-NOV-16 04.40.33.575810 PM +00:00

SQL>

Exit out of SQLPLUS and change user to root.

SQL> exit

Disconnected from 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@linux2 ~]$ su –

Password:

Last login: Wed Nov 30 16:38:00 UTC 2016 on pts/1

[root@linux2 ~]#

Change to directory /etc

[root@linux2 ~]# cd /etc

[root@linux2 etc]#

Display the currently set system time with command date.

[root@linux2 etc]# date

Wed Nov 30 12:39:08 UTC 2016

[root@linux2 etc]#

List the current setting to link /etc/localtime and remove link /etc/localtime, using the “rm –f” command.

[root@linux2 etc]# ls -l localtime

lrwxrwxrwx. 1 root root 23 Nov 30 14:22 localtime -> /usr/share/zoneinfo/UTC

[root@linux2 etc]# rm -rf localtime

[root@linux2 etc]#

Create new link to directory /usr/share/zoneinfo/<your time zone> with you correct timezone. In this example we are changing to EST.

ln -s /usr/share/zoneinfo/EST localtime

[root@linux2 etc]# ls -l localtime

lrwxrwxrwx. 1 root root 23 Nov 30 09:23 localtime -> /usr/share/zoneinfo/EST

[root@linux2 etc]#

Execute linux date command to see new timezone.

[root@linux2 etc]# date

Wed Nov 30 11:43:59 EST 2016

[root@linux2 etc]#

Logon as the oracle software owner and logon to SQLPLUS.

[root@linux2 etc]# su – oracle

Last login: Wed Nov 30 11:41:44 EST 2016 on pts/1

[oracle@linux2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Wed Nov 30 11:45:13 2016

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

SQL>

To verify the new timezone update has been completed, execute the SQL statement: select systimestamp from dual;

SQL> select systimestamp from dual;

SYSTIMESTAMP

—————————————————————————

30-NOV-16 11.46.25.722487 AM -05:00

SQL>

This completes update of timezone for Oracle RDBMS on a Linux platform.

Larry Catt

OCP

Administration, error, hp-ux, linux, unix

Allowing SCP on Linux 7

May 7, 2017 Larry Catt Leave a comment

Attempting to transfer files from one server Linux1 to Linux2 results in error: Linux2 sshd not started.

[oracle@linux1 STAGE]$ scp * oracle@10.2.0.155:/u01/STAGE/*
ssh: connect to host 10.2.0.155 port 22: Connection refused
lost connection
[oracle@linux1 STAGE]$
1. Logon as the root user to linux2 server.

[larry@linux2 ~]$ su –
Password:
Last login: Wed Sep 14 10:26:34 EDT 2016 on pts/1
[root@linux2 ~]#

2. Attempt to start the SSH service with command: service sshd start

[root@linux2 ~]# service sshd start
Redirecting to /bin/systemctl start sshd.service
[root@linux2 ~]#

3. Check the status of sshd service with command: service sshd status

[root@linux2 ~]# service sshd status
Redirecting to /bin/systemctl status sshd.service
? sshd.service – OpenSSH server daemon
Loaded: loaded (/usr/lib/systemd/system/sshd.service; enabled; vendor preset: enabled)
Active: active (running) since Wed 2016-09-14 10:23:36 EDT; 16min ago
Docs: man:sshd(8)
man:sshd_config(5)
Main PID: 1283 (sshd)
CGroup: /system.slice/sshd.service
??1283 /usr/sbin/sshd -D

Sep 14 10:23:36 linux2.localdomain systemd[1]: Started OpenSSH server daemon.
Sep 14 10:23:36 linux2.localdomain systemd[1]: Starting OpenSSH server daemon…
Sep 14 10:23:36 linux2.localdomain sshd[1283]: Server listening on 0.0.0.0 p….
Sep 14 10:23:36 linux2.localdomain sshd[1283]: Server listening on :: port 22.
Sep 14 10:25:45 linux2.localdomain sshd[3639]: pam_unix(sshd:auth): authenti…y
Sep 14 10:25:47 linux2.localdomain sshd[3639]: Failed password for larry fro…2
Sep 14 10:25:50 linux2.localdomain sshd[3639]: Accepted password for larry f…2
Sep 14 10:39:50 linux2.localdomain systemd[1]: Started OpenSSH server daemon.
Hint: Some lines were ellipsized, use -l to show in full.
[root@linux2 ~]#

4. Re-attempt the transfer from linux1 server.

[oracle@linux1 STAGE]$ scp * oracle@10.2.0.155:/u01/STAGE/.
oracle@10.2.0.155’s password:
fmw_12.2.1.1.0_infrastructure_Disk1_1of1.zip 100% 1490MB 99.3MB/s 00:15
fmw_12.2.1.1.0_infrastructure.jar 100% 1490MB 99.4MB/s 00:15
fmw_12211_readme.htm 100% 19KB 19.1KB/s 00:00
fmw.rsp 100% 1996 2.0KB/s 00:00
jdk1.7.0_79: not a regular file
jdk-7u79-linux-x64.tar.gz 100% 146MB 146.4MB/s 00:01
[oracle@linux1 STAGE]$
This completes failure of SCP transfer from stopped SSHD processes.
Larry Catt
OCP

Administration, hp-ux, linux, unix

Change time zone of Linux Server

May 4, 2017 Larry Catt Leave a comment

This procedure demonstrates the method to change the Time Zone of a typical Linux server. NOTE: Due to the number and variations LINUX distributions, this procedure may not work on all LINUX installs. This procedure was performed on Oracle Enterprise Linux 7.2 (OEL 7.2).

Logon to your Linux server as root.

[larry@linux2 ~]$ sudo su –

[sudo] password for larry:

Last login: Thu Nov 3 11:02:19 EDT 2016 on pts/1

[root@linux2 ~]#

Change to directory /etc

[root@linux2 ~]# cd /etc

[root@linux2 etc]#

Display the currently set system time with command date.

[root@linux2 etc]# date

Wed Nov 30 12:39:08 UTC 2016

[root@linux2 etc]#

List the current setting to link /etc/localtime and remove link /etc/localtime, using the “rm –f” command.

[root@linux2 etc]# ls -l localtime

lrwxrwxrwx. 1 root root 23 Nov 30 14:22 localtime -> /usr/share/zoneinfo/UTC

[root@linux2 etc]# rm -rf localtime

[root@linux2 etc]#

Create new link to directory /usr/share/zoneinfo/<your time zone> with you correct timezone. In this example we are changing to EST.

ln -s /usr/share/zoneinfo/EST localtime

[root@linux2 etc]# ls -l localtime

lrwxrwxrwx. 1 root root 23 Nov 30 09:23 localtime -> /usr/share/zoneinfo/EST

[root@linux2 etc]#

Execute linux date command to see new timezone.

[root@linux2 etc]# date

Wed Nov 30 09:25:40 EST 2016

[root@linux2 etc]#

This completes changing the time zone on Linux server.

Larry Catt

OCP

12c, dbca, linux, Multitenant, Oracle, PDB

Create PDB in silent mode

December 12, 2016 Larry Catt Leave a comment

In Oracle 12c RDBMS you can use the Database Configuration Assistant to create a PDB from shell scripts or command line in an existing CDB. You can provide all of the necessary parameters for the PDB creation through a response file or at the command prompt. In this example we will provide all required command line option to create new PDB called pdb1 in the CDB1 container.

Logon to your Oracle server as the Oracle software owner.

[root@linux2 ~]# su – oracle

Last login: Wed Oct 5 15:10:16 EDT 2016 on pts/2

[oracle@linux2 ~]$

Define the following parameter with values:
1. -sourceDB = the name of the CDB database you wish to create your PDB in.
2. -pdbName = the name of the new PDB database.
3. -pdbAdminPassword = password for the PDB admin user.

You will have to also supply the tags: –silent and -createPluggableDatabase

Update the below DBCA command with the values defined in step 2.

dbca -silent -createPluggableDatabase -sourceDB cdb1 -pdbName pdb1 -pdbAdminPassword password

Example execution.

[oracle@linux2 admin]$ dbca -silent -createPluggableDatabase -sourceDB cdb1 -pdbName pdb1 -pdbAdminPassword password

Creating Pluggable Database

4% complete

12% complete

21% complete

38% complete

85% complete

Completing Pluggable Database Creation

100% complete

Look at the log file “/opt/app/oracle/cfgtoollogs/dbca/cdb1/pdb1/cdb1.log” for further details.

[oracle@linux2 admin]$

View the status of the listener process to validate that the new PDB has been picked up by the listener with the command: lsnrctl status

[oracle@linux2 admin]$ lsnrctl status

LSNRCTL for Linux: Version 12.1.0.2.0 – Production on 20-OCT-2016 10:21:44

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.30.15.75)(PORT=1521)))

STATUS of the LISTENER

————————

Alias LISTENER

Version TNSLSNR for Linux: Version 12.1.0.2.0 – Production

Start Date 19-OCT-2016 14:06:54

Uptime 0 days 20 hr. 14 min. 50 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /opt/app/oracle/product/12.1.0.2/db_1/network/admin/listener.ora

Listener Log File /opt/app/oracle/diag/tnslsnr/linux2/listener/alert/log.xml

Listening Endpoints Summary…

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.30.15.75)(PORT=1521)))

Services Summary…

Service “cdb1” has 2 instance(s).

Instance “cdb1”, status UNKNOWN, has 1 handler(s) for this service…

Instance “cdb1”, status READY, has 1 handler(s) for this service…

Service “cdb1XDB” has 1 instance(s).

Instance “cdb1”, status READY, has 1 handler(s) for this service…

Service “pdb1” has 1 instance(s).

Instance “cdb1”, status READY, has 1 handler(s) for this service…

The command completed successfully

[oracle@linux2 admin]$

Update the tnsnames.ora file with the reference to newly created PDB1 with the command:

echo -e “PDB1 =\n” \

” (DESCRIPTION =\n” \

” (ADDRESS_LIST =\n” \

” (ADDRESS = (PROTOCOL = TCP)(HOST = “`hostname -i`”)(PORT = 1521))\n” \

” )\n” \

” (CONNECT_DATA =\n” \

” (SERVER = DEDICATED)\n” \

” (SERVICE_NAME = pdb1)\n” \

” )\n” \

” )\n” >> $ORACLE_HOME/network/admin/tnsnames.ora

Example execution:

[oracle@linux2 admin]$ echo -e “PDB1 =\n” \

> ” (DESCRIPTION =\n” \

> ” (ADDRESS_LIST =\n” \

> ” (ADDRESS = (PROTOCOL = TCP)(HOST = “`hostname -i`”)(PORT = 1521))\n” \

> ” )\n” \

> ” (CONNECT_DATA =\n” \

” (SERVER = DEDICATED)\n” \

” (SERVICE_NAME = pdb1)\n” \

” )\n” \

” )\n” >> $ORACLE_HOME/network/admin/tnsnames.ora> ” (SERVER = DEDICATED)\n” \

> ” (SERVICE_NAME = pdb1)\n” \

> ” )\n” \

> ” )\n” >> $ORACLE_HOME/network/admin/tnsnames.ora

[oracle@linux2 admin]$

Test connection to new PDB with the command: tnsping pdb1

[oracle@linux2 admin]$ tnsping pdb1

TNS Ping Utility for Linux: Version 12.1.0.2.0 – Production on 20-OCT-2016 10:32:32

Used parameter files:

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.30.15.75)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = pdb1)))

OK (0 msec)

[oracle@linux2 admin]$

This completes the creation of new PDB in silent mode.

Larry Catt

OCP

12c, CDB, linux, Multitenant, PDB

Configure Linux for multiple Oracle Database connections

February 6, 2016 Larry Catt Leave a comment

You can have multiple database on a single server of any platform. The key to this configuration is have the appropriate environmental parameter for the database you which to attach to. This procedure demonstrates the setup of .bash_profile file to set the appropriate OS environmental parameters upon attachment as the Oracle software owner. NOTE: This procedure was done on a Oracle Enterprise Linux server.

Logon to your database server as the root user.

[larry@linux2 ~]$ su –

Password:

Last login: Wed Jan 7 08:49:18 EST 2016 on pts/1

[root@linux2 ~]#

List the current databases running on your database server with command: ps –ef|grep smon

[root@linux2 ~]# ps -ef|grep smon

oracle 3793 1 0 08:47 ? 00:00:00 ora_smon_cdb1

oracle 6454 1 0 09:38 ? 00:00:00 ora_smon_orcl

root 15059 15008 0 13:44 pts/1 00:00:00 grep –color=auto smon

[root@linux2 ~]#

From the ‘ps’ command, we can see there are two active database instance on this server: CDB1 and ORCL. We need to adjust the .bash_profile file in the oracle software owner home directory to choose between these two instances at logon.
Go to the home directory of your oracle software owner.

[root@linux2 ~]# cd /home/oracle

[root@linux2 oracle]#

Now normal install of multiple databases on a single server will all use the same Oracle binaries, thus the only thing which will be different between the environmental variables will be the ORACLE_SID value. If something else is different, you can adjust the shell script below to allow for more variable definition. In this example attach the following to end of the .bash_profile file with vi.

## Beginning of request for information

database=””

while [ -z “$db” ]

echo “Enter database to use:”

echo “1 – ORCL “

echo “2 – CDB1 “

echo “Option > “

read db

if [[ “$db” != “1” &&

“$db” != “2” ]]

then

echo “$db” is not valid >&2

db=””

done

## Ending of request for information </strong>

##Beginning of local variable definitions

if [[ $db = “1” ]]

then

export ORACLE_SID=orcl

elif [[ $db = “2” ]]

then

export ORACLE_SID=cdb1

else

echo “Invalid options “

## Ending of local variable definitions

Now logon as the oracle software owner and you will be prompted to give 1 for orcl instance or 2 for cdb1. Any other options will produce nothing.

Choosing option 1 example:

[root@linux2 oracle]# su – oracle

Last login: Wed Jan 7 14:02:23 EST 2016 on pts/1

Enter database to use:

1 – ORCL

2 – CDB1

[oracle@linux2 ~]$ echo $ORACLE_SID

orcl

[oracle@linux2 ~]$

Choosing option 2 example:

[root@linux2 oracle]# su – oracle

Last login: Wed Jan 7 14:04:51 EST 2016 on pts/1

Enter database to use:

1 – ORCL

2 – CDB1

[oracle@linux2 ~]$ echo $ORACLE_SID

cdb1

[oracle@linux2 ~]$

Choosing option other than 1 or 2 example:

[root@linux2 oracle]# su – oracle

Last login: Wed Jan 7 14:12:24 EST 2016 on pts/1

Enter database to use:

1 – ORCL

2 – CDB1

Option >

3 is not valid

Enter database to use:

1 – ORCL

2 – CDB1

Option >

4 is not valid

Enter database to use:

1 – ORCL

2 – CDB1

Option >

This completes setup of Linux for multiple Oracle Databases.

Larry Catt

OCP

12c, linux

Part 11 – Building Oracle 12c development suite – Installation of Oracle 12c

June 28, 2015 Larry Catt Leave a comment

Installation of Oracle 12c
Oracle Corporation provides the ability for developers to create a complete development suite on their personal windows desktop or laptop without requiring the expensive equipment required for a true production system. This article outlines the process for actual installation of Oracle 12c RDBMS Oracle Enterprise Linux 6.5 platform. This procedure assumes that Part 1 through Part 10 of this series has been complete successfully.
NOTE: This process can be used for most Linux installations, regardless of original company or organization providing the base Linux OS.

1. Logon to your Windows desktop/laptop as an administrator and open Oracle VirtualBox.
2. SSH to your OEL virtual server as the oracle software owner.
3. CD to the directory /opt/app/oracle_software/database that was created during part 10 of this series and execute the command ‘cp ./response/db_install.rsp .’

[root@oel65 oracle_software]# cp ./response/db_install.rsp .
[root@oel65 oracle_software]#

4. Open the file db_install.rsp and edit the variable “ORACLE_HOSTNAME” and make ORACLE_HOSTNAME equal to the correct server name for your VM.

5. As the oracle user, change directory to /opt/app/oracle_software/database and execute the command ‘./runInstaller -silent -responseFile /opt/app/oracle_software/database/db_install.rsp’

[root@oel65 database]# ./runInstaller –silent –responseFile /opt/app/oracle_software/database/db_install.rsp
Starting Oracle Universal Installer….
[root@oel65 database]#

6. Change to the user root with the command ‘su -‘ and execute the scripts “/opt/app/oracle_inventory/inventory/orainstRoot.sh” and “/opt/app/oracle/ucop_db/root.sh”

7. This completes the installation of Oracle 12c on your Linux VM.

Larry Catt, OCP

12c, linux, Oracle

Part 10 – Building Oracle 12c development suite – Preparing Linux OS for 12c installation

June 8, 2015 Larry Catt Leave a comment

Preparing Linux OS for 12c installation
Oracle Corporation provides the ability for developers to create a complete development suite on their personal windows desktop or laptop without requiring the expensive equipment required for a true production system. This article outlines the process for configuration of Oracle Enterprise Linux 6.5 installation in preparation for installation of Oracle 12c RDBMS.
NOTE: This process can be used for most Linux installations, regardless of original company or organization providing the base Linux OS.

1. Logon to your Windows desktop/laptop as an administrator and open Oracle VirtualBox.
2. Logon to your Linux Server as the root user and create the group “dba” and user account “oracle” to be your oracle software owner with the following commands:
groupadd dba
useradd oracle -g dba -G root
passwd oracle

3. Create the following directory structures to support your oracle software installation with the commands:
mkdir /opt/app
mkdir /opt/app/oracle
mkdir /opt/app/oracle_software
mkdir /opt/app/oracle_inventory
mkdir /opt/app/oracle_inventory/inventory

4. Change ownership of directory structures to the oracle software owner with the following commands:
chown oracle:dba /opt/app
chown oracle:dba /opt/app/oracle
chown oracle:dba /opt/app/oracle_software
chown oracle:dba /opt/app/oracle_inventory
chown oracle:dba /opt/app/oracle_inventory/inventory

5. Change the ownership of the Oracle RDBMS media files downloaded in Part 9 of this serious to the oracle software owner with the following commands:
chown oracle:dba /opt/app/oracle_software
chown oracle:dba /opt/app/oracle_software/*
chmod 777 /opt/app/oracle_software/*

6. Switch to the oracle software owners account and change directory back to /opt/app/oracle_software location.
[root@oel65 oracle_software]# su – oracle
[oracle@oel65 ~]$ cd /opt/app/oracle_software
[oracle@oel65 oracle_software]$

7. Unpack all the mediate files with the following command: “find . -name “*.zip” -exec unzip {} \;”
[oracle@oel65 oracle_software]$ find . -name “*.zip” -exec unzip {} \;
…
..
inflating: database/response/netca.rsp
inflating: database/response/dbca.rsp
inflating: database/response/db_install.rsp
[oracle@oel65 oracle_software]$

8. This completes the setup of the VM Enterprise Linux for Oracle 12c RDBMS installation.

Larry Catt, OCP

12c, linux, Oracle

Part 9 – Building Oracle 12c development suite – Media packages required for installation of Oracle RDBMS 12c

May 30, 2015 Larry Catt Leave a comment

Part 9 – Building Oracle 12c development suite.
Media packages required for installation of Oracle RDBMS 12c

Oracle Corporation provides the ability for developers to create a complete development suite on their personal windows desktop or laptop without requiring the expensive equipment required for a true production system. This article outlines the process of downloading the media required for installation of Oracle 12c RDBMS in a RHEL 6.5 environment.
NOTE: This process can be used for most Linux installations, regardless of original company or organization providing the base Linux OS.

1. Logon to your Windows desktop/laptop as an administrator and open Oracle VirtualBox.
2. Open an internet browser and download the following files from www.oracle.com and place them in the directory /opt/app/oracle_software.

p17694377_121020_Linux-x86-64_1of8.zip
p17694377_121020_Linux-x86-64_2of8.zip
p17694377_121020_Linux-x86-64_3of8.zip
p17694377_121020_Linux-x86-64_4of8.zip
p17694377_121020_Linux-x86-64_5of8.zip
p17694377_121020_Linux-x86-64_6of8.zip
p17694377_121020_Linux-x86-64_7of8.zip
p17694377_121020_Linux-x86-64_8of8.zip

3. Change directory to /opt/app/oracle_software with the command “cd /opt/app/oracle_software”

[root@OEL65 ~]# cd /opt/app/oracle_software/
[root@OEL65 oracle_software]#

4. Extract the zip files with the following command: “find . -name “*.zip” -exec unzip {} \;”

[root@OEL65 oracle_software]# find . -name “*.zip” -exec unzip {} \;
[root@OEL65 oracle_software]#

5. NOTE: This is a base version of the software and requires additional patches to bring it to current date.
6. This completes the setup of the VM network.

Larry Catt, OCP

Catt Solutions

Category Archives: linux

Executing SQL script from command line or executable shell script

Executing Oracle Script as a LINUX or UNIX background process

Change time zone of Oracle RDBMS on Linux OS

Allowing SCP on Linux 7

Change time zone of Linux Server

Create PDB in silent mode

Configure Linux for multiple Oracle Database connections

Part 11 – Building Oracle 12c development suite – Installation of Oracle 12c

Part 10 – Building Oracle 12c development suite – Preparing Linux OS for 12c installation

Part 9 – Building Oracle 12c development suite – Media packages required for installation of Oracle RDBMS 12c

Oracle tips and tricks.