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

Thread: Control file creation

  1. #1
    Join Date
    Nov 2007
    Location
    Douala, Cameroun.
    Posts
    77

    Control file creation

    Hello everybody,

    I'm new in Oracle DB Administration and I'm trying to test different situations. Right now and I have 2 questions:

    1- I would like to manually create a database wihout the CONTROL FILE REUSE option, i.e I'd like to create my own control file. How do I do that? Can anyone give me a sample script?

    2- I deleted the password file and re-created it with the command orapwd. I set the number of DBA users to 5 and I gave them the password admin. Now when I tried to connect to that database as user sys with the password I gave, I got the ORA-01301 insufficient privileges. How do I fix that?

    Thank you.

    P.S. I'm using the 9i release 2 version of Oracle.

  2. #2
    Join Date
    Apr 2007
    Posts
    16
    I'll strongly advise you to let racle create her control file at thetime of DB creation.you certainy cant do without your data,redo and control files.

    Your Second question...
    try adding the Operating system user to the oradba user group( i'm assuming youre using windows).This should enable oracle authenticate you without you having to supply a username/password.you've logged in,you can try altering the password for sys and system accounts.

    N/B to connect using OS authentication,simply type conn /@databasename as sysdba

  3. #3
    Join Date
    Nov 2007
    Location
    Douala, Cameroun.
    Posts
    77
    Hello Crimpe.

    I kinda wanted to quench my curiousity by knowing what's inside tha control file but I think I'm gonna follow your advise on that.

    As for the second matter, I try that qnd it worked.

    Thanks.

  4. #4
    Join Date
    Nov 2007
    Location
    Douala, Cameroun.
    Posts
    77
    Hello Crimpe.

    I kinda wanted to quench my curiousity by knowing what's inside tha control file but I think I'm gonna follow your advise on that.

    As for the second matter, I tried that and it worked.

    Thanks.

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    if you want to see whats in a control file do this as sysdba on a running database

    alter database backup controlfile to trace as 'ctrl.sql';

    and you will get a file with what a control file contains

  6. #6
    Join Date
    Apr 2007
    Posts
    16

    Content of the control file

    Hi abdel,
    Below's a summary of the control file's content.

    • Name of the database
    • Time stamp of database creation
    • Database SID
    • Name & Location of data & redo logs
    • Updated tablespace information
    • Redo logs file history
    • Current log sequence number
    • Location & status of archived redo logs
    • Location of archived redo logs
    • Checkpoint information
    Last edited by crimpe; 11-13-2007 at 09:40 AM.

  7. #7
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    :-) Keep on experiments. Control file is really crucial so it's important to know how it operates

    BTW the reuse option just lets the database to create the control file EVEN IF such file exists. The existing file will be overwritten.
    Otherwise you get an error that the file already exists.
    That does not means that the db reuses some old controlfile anyhow

    Cheers

  8. #8
    Join Date
    Nov 2007
    Location
    Douala, Cameroun.
    Posts
    77
    Thank you guys for the tips. I tried what Dave suggested and It worked. Thanks again for the assistance.

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