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?