The scenario is much like this there exists a database server with Oracle 10g installed, by having an instance already being used, allows refer to this as Instance1 (with similar SID). Now, you want to possess a second instance on a single server, with SID i.e. Instance2. I use the DCA (Database Configuration Assistant), but just get errors in the finish from the creation (normally around 85%).
Error message goes such as this:
Enterprise manager configruration unsuccessful because of the followin error - Error beginning Database Control Make reference to the log file at C:oracleproduct10.2.0db-1cftoollogsdbcaInstance2emConfig.log for additional particulars. You are able to retry setting up this database with Enterprise Manager later my by hand running C:oracleproduct10.2.0db_1binemca script
I am obtaining the feeling that I have to do that commandline, and perhaps change some config files. Could anybody please give mediterranean some pointers, or worthwhile guide I'm able to follow? Thanks ahead of time.