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.