Pro Oracle Database 12c Administration

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.