Re: Problems with new databases in PO7

In article <4b19fh$7sa_at_lobo.lule.frontec.se>, mikael_at_lule.frontec.se (Mikael) says:
>
>Hi there!
>
>I have just installed personal oracle7 for windows and now I have some
>problems trying to create a new local database with a new name. I would be
>thankful if someone could tell me what I'm doing wrong.
>
>I'm not sure if this is how I'm supposed to create a new database but
>anyhow, this is what I have done:
>
>- I use the included parameterfile 'init.ora'. The only thing I changed in
> that file was the DB_NAME parameter which I set to my new dbname 'newdb'.
>
>- I didnt change anything in 'oracle.ini' (Should I have?)
>
>- Then I started SQL*DBA and run the commands that follows:
>
> SQLDBA> connect internal;
> SQLDBA> startup nomount pfile=%rdbms71%\init.ora
> SQLDBA> create database newdb
> 2> logfile '%oracle_home%\dbs\wdblog1.ora' size 400K reuse,
> 3> '%oracle_home%\dbs\wdblog2.ora' size 400K reuse
> 4> datafile '%oracle_home%\dbs\wdbsys.ora' size 10M reuse
> 5> character set WE8ISO8859P1;
> SQLDBA>_at_%rdbms71%\admin\catalog
> SQLDBA> connect system/manager
> SQLDBA> _at_%rdbms71%\admin\catdbsyn
> SQLDBA> connect internal
> SQLDBA> _at_%rdbms71%\admin\catblock
> SQLDBA> _at_%ORACLE_HOME%\dbs\v7pup.sql
> SQLDBA> connect internal
> SQLDBA> shutdown
>
> No errors occured and I exited SQL*DBA.
>
>- Then I tried to startup the new database from the database-manager. The
> following error occurs:
>
> ORA-01103 database name 'newdb' in control file is not 'oracle'
>
>WHY??
>
>How is the connect-string for my new database supposed to look like in the
>database manager?
>
>If you have some hints please let me know!
>
>Thanks!
>
>/"Mike"

Hi Mike,

excuse me, I'm brand new on the net and it's quite possible you've already had a sattisfying answer.

The most likely problem is that in the init.ora file you're using there is no mention of any control-files. If not specified, oracle uses the 'default' ones which may still be in use by the default database the installer created for you.

Try to include the parameter :

control_file = ( 'file1', 'file2' )

in the init.ora file (where file1 and file2 are actual file-names including their path). Make sure their names are different than the ones used by the default database, otherwise you end up with the same problem. Re-create your database after this.

Gerrit.

(excuses for any typo's, english isn't quite natural to me) Received on Mon Dec 18 1995 - 00:00:00 CET