Control file creation

[abdel]

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.

[crimpe]

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

[abdel]

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.

[abdel]

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.

[davey23uk]

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

[crimpe]

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

[Bore]

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

[abdel]

Thank you guys for the tips. I tried what Dave suggested and It worked. Thanks again for the assistance.