-
hi,
I was creating a new database (In addition to the default ORCL database) on oracle 8.0.5 for NT.
These were the steps followed by me.
1) svrmgr> connect internal
2) shutdown immediate
3) changed the initorcl.ora for db_name = oct, and saved as
initoct.ora
4) svrmgr> startup pfile=d:\orant\database\initoct.ora
nomount
5) svrmgr>create database oct
6) added the oct entry in the tnsnames.ora
I am not able to open any of the database(orcl / oct).
While try to connect as
svrmgr>startup pfile=...\initorcl.ora open orcl (for orcl)
svrmgr>startup pfile=...\initorcl.ora open orcl (for orcl)
I get ERROR: ORA-03123:Operation would block
could any one help me resolving this, my test database is stopped functioning.
Also explain, how we can work with 2 databases on the same machine.
Badrinath
-
Hi, in addition to init.ora file you must configure config.ora file also. After this only you control file will get created under the name of the new oracle db name
Rgds
Ganesh .R
-
And what have you been doing with the services ?
OracleServiceXXXX and OracleStartXXXX
Laurence
-
have you changed ORACLE_SID when you created the second DB?
