3
Jul

With AD-TXK Delta.9 and higher, Autoconfig Fails On PatchFS with error "ORA-12514: TNS:listener does not currently know of service requested

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

ERRORCODE = 1 ERRORCODE_END
.end std out.

.end err out.

 
Read more...

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