Updates from May, 2015 Toggle Comment Threads | Keyboard Shortcuts

  • Sachin Thapa 19:00 on May 18, 2015 Permalink | Reply
    Tags: , , ,   

    ORA-00020 maximum number of processes exceeded . 

    ORA-00020 maximum number of processes exceeded
    Cause: All process state objects are in use.
    Action: Increase the value of the PROCESSES initialization parameter.

    ORA-00020 comes under “Oracle Database Server Messages”. These messages are generated by the Oracle database server when running any Oracle program.

    (More …)

     
  • Sachin Thapa 18:59 on May 18, 2015 Permalink | Reply
    Tags: , , ,   

    ORA-28002: the password will expire within 7 days . 

    ORA-28002: the password will expire within 7 days
    Cause: The user's account is about to about to expire and the password needs 
    to be changed.
    Action: Change the password or contact the database administrator.
    
    
    Reference: Oracle Documentation 
    
    Solutions:
    
    1) Simply change the password to avoid it temporary
    
      [oracle@lnxsvr ~]$ sqlplus scott/tiger
    
      SQL*Plus: Release 11.2.0.1.0 Production on Wed Jun 20 14:08:01 2012
    
      Copyright (c) 1982, 2009, Oracle.  All rights reserved.
    
      ERROR:
      ORA-28002: the password will expire within 7 days
    
      Connected to:
      Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
    
      SQL> PASSWORD
      Changing password for SCOTT
      Old password:
      New password:
      Retype new password:
      Password changed
    
    
    2) Set PASSWORD_LIFE_TIME of the profile assigned user to UNLIMITED 
       then change the password to avoid it permanently
       
      [oracle@lnxsvr ~]$ sqlplus scott/tiger
    
      SQL*Plus: Release 11.2.0.1.0 Production on Wed Jun 20 14:08:01 2012
    
      Copyright (c) 1982, 2009, Oracle.  All rights reserved.
    
      ERROR:
      ORA-28002: the password will expire within 7 days
    
      Connected to:
      Oracle Database 11g Release 11.2.0.1.0 - 64bit Production   
    
      SQL> connect / as sysdba
      Connected.
      
      SQL> SELECT PROFILE FROM dba_users WHERE username = 'SCOTT';
    
      PROFILE
      ------------------------------
      DEFAULT
    
      SQL> SELECT  LIMIT FROM DBA_PROFILES WHERE PROFILE='DEFAULT' 
      AND RESOURCE_NAME='PASSWORD_LIFE_TIME';
    
      LIMIT
      ----------------------------------------
      60
    
      SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
    
      Profile altered.
    
      SQL> SELECT ACCOUNT_STATUS FROM DBA_USERS WHERE USERNAME='SCOTT';
    
      ACCOUNT_STATUS
      --------------------------------
      EXPIRED(GRACE)
    
      SQL> connect scott/tiger
      Connected.
      
      SQL> PASSWORD
      Changing password for SCOTT
      Old password:
      New password:
      Retype new password:
      Password changed
     
  • Sachin Thapa 18:57 on May 18, 2015 Permalink | Reply
    Tags: , , ,   

    ORA-01031: insufficient privileges . 

    ORA-01031: insufficient privileges
    Cause: An attempt was made to change the current username or password without the appropriate privilege. This error also occurs if attempting to install a database without the necessary operating system privileges. When Trusted Oracle is configure in DBMS MAC, this error may occur if the user was granted the necessary privilege at a higher label than the current login.
    Action: Ask the database administrator to perform the operation or grant the required privileges. For Trusted Oracle users getting this error although granted the the appropriate privilege at a higher label, ask the database administrator to regrant the privilege at the appropriate label.

    (More …)

     
  • Sachin Thapa 18:53 on May 18, 2015 Permalink | Reply
    Tags: , , ,   

    ORA-00027 cannot kill current session . 

    ORA-00027 cannot kill current session
    Cause: An attempt was made to use ALTER SYSTEM KILL SESSION to kill the
    current session.
    Action: If it is necessary to kill the current session, do so from another session.
    
    ORA-00027 comes under "Oracle Database Server Messages". 
    
    

    (More …)

     
  • Sachin Thapa 18:51 on May 18, 2015 Permalink | Reply
    Tags: , , ,   

    ORA-00054: resource busy and acquire with NOWAIT specified . 

    ORA-00054: resource busy and acquire with NOWAIT specified
    Cause: The NOWAIT keyword forced a return to the command prompt
    because a resource was unavailable for a LOCK TABLE or SELECT FOR
    UPDATE command.
    Action: Try the command after a few minutes or enter the command without
    the NOWAIT keyword.

    (More …)

     
  • Sachin Thapa 18:47 on May 18, 2015 Permalink | Reply
    Tags: , , ,   

    ORA-12560: TNS:protocol adapter error . 

    ORA-12560: TNS:protocol adapter error
    Cause: A generic protocol adapter error occurred.
    Action: Check addresses used for proper protocol specification. Before reporting this error, look at the error stack and check for lower level transport errors. For further details, turn on tracing and re-execute the operation. Turn off tracing when the operation is complete.

    (More …)

     
  • Sachin Thapa 18:46 on May 18, 2015 Permalink | Reply
    Tags: , , ,   

    ORA-00942 table or view does not exist . 

    ORA-00942 table or view does not exist
    Cause: The table or view entered does not exist, a synonym that is not allowed here was used, or a view was referenced where a table is required. Existing user tables and views can be listed by querying the data dictionary. Certain privileges may be required to access the table. If an application returned this message, the table the application tried to access does not exist in the database, or the application does not have access to it.

    (More …)

     
  • Sachin Thapa 18:32 on May 18, 2015 Permalink | Reply
    Tags: , , ,   

    ORA-00849: SGA_TARGET cannot be set to more than MEMORY_MAX_TARGET . 

    ORA-00849: SGA_TARGET string cannot be set to more than MEMORY_MAX_TARGET string.
    Cause: SGA_TARGET value was more than MEMORY_MAX_TARGET value.
    Action: Set SGA_TARGET to be less than MEMORY_MAX_TARGET.

    (More …)

     
  • Sachin Thapa 18:30 on May 18, 2015 Permalink | Reply
    Tags: , , ,   

    ORA-02438: Column check constraint cannot reference other columns . 

    ORA-02438: Column check constraint cannot reference other columns
    Cause: attempted to define a column check constraint that references another column.
    Action: define it as a table check constraint.

    (More …)

     
  • Sachin Thapa 18:28 on May 18, 2015 Permalink | Reply
    Tags: , , ,   

    ORA-01157: cannot identify/lock data file string – see DBWR trace file . 

    ORA-01157: cannot identify/lock data file string – see DBWR trace file
    Cause: The background process was either unable to find one of the data files or failed to lock it because the file was already in use. The database will prohibit access to this file but other files will be unaffected. However the first instance to open the database will need to access all online data files. Accompanying error from the operating system describes why the file could not be identified.
    Action: Have operating system make file available to database. Then either open the database or do ALTER SYSTEM CHECK DATAFILES.

    (More …)

     
c
Compose new post
j
Next post/Next comment
k
Previous post/Previous comment
r
Reply
e
Edit
o
Show/Hide comments
t
Go to top
l
Go to login
h
Show/Hide help
shift + esc
Cancel