Reading notes from Pro Oracle Database 12c Administration [Kindle Edition] .
Installing with a Copy of an Existing Installation
Tip See MOS note 300062.1 for instructions on how to clone an existing Oracle installation.
Step 1. Copy the Binaries, Using an OS Utility
tar -cvf - $ORACLE_HOME | ssh $new_host "cd $ORACLE_HOME; tar -xvf -"
Step 2. Attach the Oracle Home
./runInstaller -silent -attachHome -invPtrLoc /etc/oraInst.loc \ ORACLE_HOME="/u01/app/oracle/product/12.1.0.1/db_1" \ ORACLE_HOME_NAME="ONEW"
Customizing Your SQL Prompt
SET SQLPROMPT '&_USER.@&_CONNECT_IDENTIFIER.> '
Identifying DBA-Created Accounts
See MOS note 227010.1 for more details about guidelines on checking for default passwords.
Basic Password Security
Tip See MOS note 454635.1 for details on Oracle Database DEFAULT profile changes.
Renaming a Table
Note The process of renaming a table wasn't entirely bug free in Oracle Database 11g Release 1 but has been corrected in Oracle Database 11g Release 2. See MOS note 886762.1 for more details.
Restoring and Recovering to Different Server
Note …Starting with Oracle Database 11g Release 2, you can use RMAN to duplicate a database based on backups you copy from the target to the auxiliary server. See MOS note 874352.1 for more details.
Step 16. Rename the Database
Tip You can also use the NID utility to change the database name and database identifier (DBID). See MOS note 863800.1 for more details.
Starting and Stopping the Database and Listener
Tip If you want to stop and start automatically (on system reboots), you can use other processes, such as the Intelligent Agent, Management Server, or HTTP Server. See MOS note 222813.1 for more details.