27
Oct

Silent Installation of Oracle Database 11gr2

Silent install of Oracle Software, Database and Listener.

Go to the software location
Copy sample response file from /database/response/db_install.rsp
[oracle@dbaarena ~]$ cp -rfv /u01/11gR2Setup/database/response/ /u01/home

Modify the db_install.rsp file.
oracle.install.option=INSTALL_DB_SWONLY
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/oracle/OraInventory
ORACLE_HOME=/u01/home/oracle/product/11.2.0/dbhome_1
ORACLE_BASE=/u01/home
oracle.install.db.InstallEdition=EE
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=dba
DECLINE_SECURITY_UPDATES=true
Read more...

12
Jan

Database Link

What is a database link?

A database link is a pointer that defines a one-way communication path from one Oracle Database to another database. A database link allows local users to access data on a remote database.

The following link types are supported:
Private database link- belongs to a specific schema of a database. Only the owner of a private database link can use it.
Public database link- all users in the database can use it.
Global database link- defined in an OID or Oracle Names Server. Anyone on the network can use it.

Read more...

Back to Top