Jun 28, 2013
Oracle Database 12c New Features
1.2K

Oracle Database 12c New Features

Hi Guys, Oracle 12C Database has Released.  You can download it from edelivery.oracle.com. It comes with plug and play concept. Pluggable database: – Oracle provided metadata and data is kept in the container database (CDB). – User metadata and data is kept in the plugable database (PDB) . – One container...
Apr 12, 2013
Create Oracle database in silent mode
1.2K

Create Oracle database in silent mode

How to create Oracle database in silent mode? COMMAND ========= dbca -silent -gdname dbname -sid dbname -responsefile NO_VALUE -createDatabase -templateName General_purpose.dbc -characterset AL32UTF8 -memorypercentage 30 -emconfiguration LOCAL OUTPUT ======= Enter SYSTEM user password: password Enter SYS user password: password Copying database files 1% complete 3% complete
Jan 08, 2013
Oracle Database 12c Architecture
1.5K

Oracle Database 12c Architecture

Oracle Database 12c Multi-Tenant Data Architecture: Shared Database, Separate Schema In this architecture, each tenant has their own set of tables stored in a separate schema. Each database server will only serve up one database. The login credentials used to connect to the database by each user will determine which tenant’s...
Jan 08, 2013
Oracle database 12c be released
1.1K

Oracle database 12c be released

oracle database 12c be released: The next version of Oracle’s database will feature support for multitenancy as a critical feature, providing superior security, control, and efficiency for software services delivered from the cloud, CEO Larry Ellison said Sunday during the OpenWorld conference in San Francisco.  Ellison’s comments Sunday provided the...
Jul 13, 2012
How to change the password of a DB Link in Oracle
3.7K

How to change the password of a DB Link in Oracle

How to change the password of a DB Link in Oracle? Alter Database Link to Change Password Sometimes, when we use alter database link command, it will show below error: SQL> ALTER DATABASE LINK APPS_SME.SAMPLE.COM CONNECT TO hr IDENTIFIED BY hr; ALTER DATABASE LINK APPS_SME.SAMPLE.COM CONNECT TO hr IDENTIFIED BY...
May 23, 2012
Kill LOCAL=NO Processes at one go
4.3K

Kill LOCAL=NO Processes at one go

Kill LOCAL=NO Processes at one go Whenever you are trying to shutdown the database, sometimes it will hang up in the process of shutdown. At that time, open another terminal and grep for LOCAL=NO processes “ps -ef|grep LOCAL” Output oracle 3747948 1 0 Apr 27 – 0:00 INSTANCENAME (LOCAL=NO) oracle...