Chapter 1 Put the database in ARCHIVELOG modeshutdown the databasestart the database in mount modeset the […]
$ cat tnsnames.ora tnsnames.ora Network Configuration File: /u01/app/oracle/product/12.1.0.2/db_1/network/admin/tnsnames.oraGenerated by Oracle configuration tools. CDB2 =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS […]
Create a PDB by using a non-CDB 6.1 Create a PDB by using a non-CDB in […]
Create a PDB by using a non-CDB in different version and different characterset 1. Create noncdb […]
STARUP FORCE MOUNT EXCLUSIVE RESTRICT;DROP DATABASE;
[1] Set up Network Tracing / Logging with LISTENER.ora1.1 TRACE_LEVEL_LISTENER & TRACE_DIRECTORY_LISTENER1.2 TRACE_FILELEN_LISTENER & TRACE_FILENO_LISTENER1.3 LOGGING_LISTENER,LOG_FILE_LISTENER […]
[1] PFILE[2] SPFILE[3] orapwfile[5] sqlnet.ora Oracle configuration files are: [1] PFILE [2] SPFILE [3] orapwfile, [5] […]
-- Add the below in your .bash_profile #Oracle Profile export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/12.1.0./dbhome_1 export ORACLE_SID=orcl export […]
In 12c we have now common and local users, this is the main point you need […]
In this article we are going to discuss How to Create Database using OMF parameter, we […]