DBA Arena

Symptoms:

When attempting to run autoconfig on patch fs the following error occurs.


ERROR
-----------------------
Enter value for 1: Enter value for 2: Enter value for 3: ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

.end err out.


 
Read more...

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...

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...