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?
P.S. I'm using the 9i release 2 version of Oracle.
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
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
:-) 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