Category: DataBase

REMOTE_LOGIN_PASSWORDFILE: is the property that specifies whether oracle uses password file for user authentication and also controls how many databases can use the password file.   Know the REMOTE_LOGIN_PASSWORDFILE property status:   SQL> show parameter remote_login_passwordfile NAME TYPE VALUE ———————————— ——- —————————— remote_login_passwordfile string EXCLUSIVE SQL> OR SQL> show parameter password NAME TYPE VALUE ———————————— ——- —————————— remote_login_passwordfile string EXCLUSIVE SQL> By Default Oracle sets the property to EXCLUSIVE value that means the password file is being used exclusively only by one database.   With this default value, if you attempt to bring up a different database in current instance, then […]

Error#1: ————————— ODBC 32Bit Test Program ————————— SQLSTATE: S1000 Native Error Code:12514 Driver Message:[Oracle][ODBC][Ora]ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor Need Any suggestions to avoid error ? ————————— Yes No —————————   Cause: Unable to locate the Specified Host by name Fix: Create an entry in Hosts file Say you are creating an inst03.dev.test.lab, then in the hosts file ("C:WindowsSystem32driversetchosts") make an entry for inst03.dev.test.lab and specify your target oracle DB IP address.     Error#2: ————————— ODBC 32Bit Test Program ————————— SQLSTATE: 08004 Native Error Code:12154 Driver Message:[Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve service name Need Any suggestions […]

  SQL> SHUTDOWN NORMAL Database closed. Database dismounted. ORACLE instance shut down. SQL>   Fix Error: ORA-01509: specified name ‘INST03’ does not match actual ‘PROD01’ You want to shutdown the actively running instance PROD01 and you execute the “shutdown normal” but the command may end up with below error. SQL> shutdown normal ORA-01509: specified name ‘INST03’ does not match actual ‘PROD01’ SQL> Cause: The Oracle seem to have got its Ini file loaded with some other DBs PFILE/SPFILE FIX: is to have Oracle load again with the relevant  instance config files as shown below SQL> STARTUP PFILE=/opt/oracle/product/8.1.6/dbfiles/initinst03.ora ORA-01081: cannot start […]