12c Install

useradd -g dba -G oinstall ora12
123

useradd -g dba -G oinstall vento
123

 DB_11.2.0.2.0]# yum install --nogpgcheck unzip

/u01/app/vento
/u01/app/vento/product/11.2.0/dbhome_1
/u01/app/vento/oradata


mkdir -p /u01/app/vento
chown -R vento:dba /u01/app/vento
chmod -R 775 /u01/app/vento


mkdir -p /u01/app/vento/product/11.2.0/dbhome_1
chown -R vento:dba /u01/app/vento/product/11.2.0/dbhome_1
chmod -R 775 /u01/app/vento/product/11.2.0/dbhome_1

mkdir -p /u01/app/vento/oradata
chown -R vento:dba /u01/app/vento/oradata
chmod -R 775 /u01/app/vento/oradata

This is a prerequisite condition to test whether the package "pdksh-5.2.14" is available on the system. (more details)
Expected Value
 : pdksh-5.2.14( x86_64)
Actual Value
 : missing

http://rpm.pbone.net/index.php3/stat/4/idpl/1883952/com/pdksh-5.2.14-30.x86_64.rpm.html


 I want to copy an Oracle database from one server to another. I'm going to save the entire database into a CD and copy the exact database to another server. Please give me instructions. Thanks!
For the same server and operating system do the following. The DB will have the same name as the original.

1. Shut source database down with the NORMAL or IMMEDIATE option.

 Copy all datafiles. Select the name from v$datafile; to get their names.

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/u01/app/vento/oradata/vento/system01.dbf
/u01/app/vento/oradata/vento/sysaux01.dbf
/u01/app/vento/oradata/vento/undotbs01.dbf
/u01/app/vento/oradata/vento/users01.dbf



Copy all online redo logs. Select the member from v$logfile; to get their names.

Copy all control files. Select the name from v$controlfile; to get their names.
SQL> select member from v$logfile;

MEMBER
--------------------------------------------------------------------------------
/u01/app/vento/oradata/vento/redo03.log
/u01/app/vento/oradata/vento/redo02.log
/u01/app/vento/oradata/vento/redo01.log


Copy the parameter file. Find it in $ORACLE_HOME/dbs in Unix and $ORACLE_HOME/database in Windows. The name is initDBNAME.ora where DBNAME is database name.

/u01/app/vento/product/11.2.0/dbhome_1/dbs
[vento@tos01 dbs]$ scp -r orapwvento initvento.ora root@192.168.1.6:/u01/database/ventobkp


All of the files must be placed in directories that have same name as the source server directories. The names returned from the queries above are fully qualified with directory names.

Create all of the directories specified in the parameter file you just copied. It will be BDUMP, CDUMP, UDUMP. Just recreate all of the directories you find specified in your parameter file.

Edit the parameter file you copied. Set REMOTE_LOGIN_PASSWORDFILE to NONE if it is set SHARED or EXCLUSIVE.

Start the database up.

If you use a true temporary tablespace for sorting, you will have to recreate it. The database will still start, but the first sort that writes to it will . Simple syntax is in the manuals.

To use remote authentication again, run ORAPWD. Here's the syntax:


orapwd
Usage: orapwd file=<fname> password=<password> entries=<users>
orapwd file=prapwdvento password=123 entries=9


where:
file = name of password file (mand)
password = password for SYS (mand)
entries = maximum number of distinct DBAs and OPERs (opt).
There are no spaces around the equal-to (=) character

Edit the parameter file to set REMOTE_LOGIN_PASSWORDFILE to SHARED or EXCLUSIVE (depending on what it was set to before).

Restart the DB for it to take affect.

http://searchoracle.techtarget.com/answer/How-do-I-copy-an-Oracle-DB-from-one-server-to-another