DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: help ORA-1503

  1. #1
    Join Date
    Jan 2001
    Posts
    72

    Wink

    What does this error mean? It's not in ORACLE docs: I just renamed my database from CHEMICALDB to NONCHEMICALDB and I found this error message in the alert log:

    ORA-1503 signalled during: CREATE CONTROLFILE SET DATABASE "NONCHEMICALDB " RESETLOG...

  2. #2
    Join Date
    Feb 2001
    Posts
    389
    There has to be another message along with this.

  3. #3
    Join Date
    Mar 2001
    Posts
    45
    This problem can happen when there is no password file present in ?/dbs,
    but the parameter REMOTE_LOGIN_PASSWORDFILE is set.

    Try either supplying password file, else
    reset the parameter in init.ora
    Thanx
    Ramesh.
    ______________________________
    There is nothing Impossible.
    Even Impossible says
    I M POSSIBLE

  4. #4
    Join Date
    Jan 2001
    Posts
    72
    This is an abbreviated message that was in the file including the error message:

    CHARACTER SET US7ASCII
    Thu Mar 14 12:18:10 2001
    ORA-1503 signalled during: CREATE CONTROLFILE SET DATABASE "NONCHEMICALDB " RESETLOG...
    Thu Mar 14 15:27:28 2001
    Shutting down instance (normal)
    License high water mark = 1
    Thu Mar 41 15:27:28 2001
    ALTER DATABASE CLOSE NORMAL
    Thu Mar 14 15:27:28 2001
    SMON: disabling tx recovery
    SMON: disabling cache recovery
    Thu Mar 14 15:27:28 2001
    Thread 1 closed at log sequence 39
    Thu Mar 14 15:27:28 2001
    Completed: ALTER DATABASE CLOSE NORMAL
    Thu Mar 14 15:27:28 2001
    ALTER DATABASE DISMOUNT
    Completed: ALTER DATABASE DISMOUNT
    archiving is disabled

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width