Tagged: 10g Toggle Comment Threads | Keyboard Shortcuts

  • Sachin Thapa 15:00 on April 12, 2016 Permalink | Reply
    Tags: 10g, , , index, indexes, , rebuild   

    Know when to rebuild indexes 

    Summary

    An Oracle server index is a schema object that can speed up the retrieval of rows by using a pointer.

    You can create indexes on one or more columns of a table to speed SQL statement execution on that table. If you do not have an index on the column, then a full table scan occurs.

    (More …)

     
  • Sachin Thapa 19:44 on August 12, 2015 Permalink | Reply
    Tags: 10g, , , datafile is missing, ,   

    Full restore via RMAN of a database when a datafile is missing and never backed up !! 

    Problem Description
    ——————-

    Full restore via RMAN of a database when a datafile is missing and never
    backed up results in the following errors:

    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure during compilation of command

    (More …)

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

    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: 10g, , ,   

    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: 10g, , ,   

    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: 10g, , ,   

    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: 10g, , ,   

    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: 10g, , ,   

    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: 10g, , ,   

    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: 10g, , ,   

    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 …)

     
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