I have recently installed Oracle8i on my Unix machine.
How do you invoke OEM, or Oracle Database config Assistant in Unix so I can create a new db?
when I installed Oracle, I thought I had created a db. However, I am running into all kinds of little problems I have been able to solved with the exception of one. When I started the db, could not mount because it did not find the controlfiles. The controlfiles were not created during the installation. I so I am trying to crete them, but I have the problem bellow:
Enter user-name: internal
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 104669344 bytes
Fixed Size 73888 bytes
Variable Size 55787520 bytes
Database Buffers 48627712 bytes
Redo Buffers 180224 bytes
SQL> CREATE CONTROLFILE REUSE DATABASE "rich" RESETLOGS ARCHIVELOG
2 MAXLOGFILES 32
3 MAXLOGMEMBERS 2
4 MAXDATAFILES 32
5 MAXINSTANCES 16
6 MAXLOGHISTORY 1815
8 GROUP 1 '/export/home/oracle/oradata/rich/REDO03.LOG' SIZE 1M,
9 GROUP 2 '/export/home/oracle/oradata/rich/REDO02.LOG' SIZE 1M,
10 GROUP 3 '/export/home/oracle/oradata/rich/REDO02.LOG' SIZE 1M
19 CHARACTER SET WE8ISO8859P1
CREATE CONTROLFILE REUSE DATABASE "rich" RESETLOGS ARCHIVELOG
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
SQL> shutdown immediate
ORA-01507: database not mounted
The first time I ran into this, I moved the the already existing datafiles into another directory and ran the create database command again to create new *.dbf files but I still get the above error.
Then I am trying to invoke the Oracle Database config Assistant but can 't seen to be able to find it anywhere.