Category: DataBase

You encounter ORA-01031: insufficient privileges error:   [root@ProdDB01 ~]# dbstart SQL*Plus: Release 8.1.6.0.0 – Production on Thu Mar 20 11:54:55 2014 (c) Copyright 1999 Oracle Corporation.  All rights reserved. SQL> ERROR: ORA-01031: insufficient privileges SQL> [3]+  Stopped                 dbstart [root@ProdDB01 ~]#   Fix: Login as Oracle user or SysDBA.  Usually, many of the administrators mayn’t have sysdba password. The workaround is to do sudo as Oracle user and start the database.   [root@ProdDB01 ~]# su – oracle -bash-3.1$ lsnrctl start LSNRCTL for Linux: Version 8.1.6.0.0 – Production on 20-MAR-2014 12:12:07 (c) Copyright 1998, 1999, Oracle Corporation.  All rights reserved. TNS-01106: Listener […]

Error: When you attempt to connect to your Oracle DB instance, you’ll receive below error ————————— ODBC 32Bit Test Program ————————— SQLSTATE: S1000 Native Error Code:12541 Driver Message:[Oracle][ODBC][Ora]ORA-12541: TNS:no listener Need Any suggestions to avoid error ? ————————— Yes No —————————   Cause and Troubleshooting: Cause: The Oracle Instance is NOT running on the Oracle DB server. login as: root [email protected]’s password: Last login: Wed Feb 19 15:35:19 2014 from 192.168.1.91 [root@OraProd01 ~]# lsnrctl LSNRCTL for Linux: Version 8.1.6.0.0 – Production on 19-FEB-2014 16:36:28 (c) Copyright 1998, 1999, Oracle Corporation.  All rights reserved. Welcome to LSNRCTL, type "help" for information. […]

  select users.email, count(*) from users, user_pwd_history where email like ‘%govardhan%’ and users.USR_ID = user_pwd_history.USR_ID group by users.email