Re: I could not start OracleOraHome81ManagementServer service

Howard,

Thanks for your reply and sorry for having writen back late because i just came back from my vocation.

The problem is solved! I did the followings. i would like to post it here to share it with all of you.

To copy an Oracle database (suppose orn5qa76) from one to another in different computer or the same computer:

1.	Go to Start -> Run -> Command -> d: -> cd Oracle\Ora81\Bin
2.	type: exp system/manager_at_orn5qa76 and then accept the default by 
           simply pressing Enter key.
3.	In EXPDAT.DMP file: type any dump file name. Ex. Orn5qa76.dmp
If copy in the same computer:
4.	create another database naming as ex. Orn5qa77.
5.	do step 1.
6.	type: imp system/manager_at_orn5qa76 and then accept the default by 
            simply pressing Enter key.
7.	at a point, we should say yes to import entire export file.
If copy in the different computers:
4.	install Oracle server in another computer.
5.	copy that dump file (orn5qa76.dmp) to the directory of
d:\Oracle\Ora81\
            Bin\
6.	create another database naming as ex. Orn5qa77 or orn5qa76 (same
name).
7.	do step 1.
8.	type: imp system/manager_at_orn5qa76 and then accept the default by 
            simply pressing Enter key.
9.	at a point, we should say yes to import entire export file.  

Thank you guys.

Luping

"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:<3bf5c912$0$16936$afc38c87_at_news.optusnet.com.au>...
> Comments embedded.
> HJR
> --
> Resources for Oracle: http://www.hjrdba.com
> ===============================
>
>
> "Roben Zhang" <lzhang_at_opentext.com> wrote in message
> news:208636ca.0111160839.179546e6_at_posting.google.com...
> > Thanks for your reply, Howard.
> >
> > I just tried this command, it was terminated successfully. What is the
> > next i should do? By the way, i have multiple databases in the same
> > computer. I just need to copy one of the databases to another in the
> > same computer. Will this command export all the databases in the
> > computer?
> >
>
> Only the one you connect to, either explicitly (exp
> system/manager_at_SPECIFY_SID_HERE) or implicitly (without a tnsnames alias,
> you connect to whatever ORACLE_SID is set to before invoking export).
>
> > I have visited your web site and tried to follow the instructions of
> > article
> > 'Cloning a Database'. But i was failed to start SQL Plus for the clone
> > in Step 1.
>
> If you can't even start sql plus, we're in deep trouble. Type sqlplus
> /nolog at the command prompt, and then type a connect string. If you need
> help on that, we're in even deeper trouble than I thought, and you'll really
> need to learn some basic first before going any further.
>
> > I have couple of questions in Step 1.
> > 1. I should copy .dbf and .log files from source database to clone
> > database, but
> > not .ctl files (control file), is that right?
>
> Correct. That's what the paper says, and it says it for a reason. The
> Control File contains pointers to the *existing* data files and redo logs.
> Since you are copying them to a new location, it makes no sense to bring
> along the control files as well.
>
> > 2. After i have run the statement:"ALTER DATABASE BACKUP CONTROLFILE
> > TO TRACE"
> > a trace file will be created in the source database location. I
> > should copy
> > it to clone location and then edit it. Is that right?
>
> Correct. If the clone is being made on the same machine as the original
> database, there's strictly speaking no need to move the file. Provided
> that, when it comes to running the script, you explicitly point to where it
> is stored.
>
> > 3. when i edit init.ora file, for LOG_ARCHIVE_DEST (and variants), you
> > marked
> > the source archives must not be overwritten by the clone's. Is that
> > mean i
> > should use special variant for clone's init.ora? What is that
> > variant for
> > clone's.
> >
>
> Wherever you want the clone's archives to be written. Pick a directory.
> Any directory. It really doesn't matter. So long as it's not the same
> directory as where the source database's archives are being written.
>
> > By the way, should i use Database Configuration Assistant to create
> > empty database for clone first or just follow the steps to create
> > folder, copy files, edit files?
> >
>
> Sometimes I despair, I really do. If you were supposed to do that, I would
> have mentioned it, wouldn't I? If you create your own database using the
> Configuration Assistant, it's not exactly going to be a "clone" (i.e., an
> identical copy) of the source, is it? Just follow the instructions as
> written. Don't skip over the bit about using oradim to create the new
> service first.
>
> Regards
> HJR
>
>
> > Sorry for so many questions. But i feel i am learning more and more
> > about Oracle.
> >
> > Thanks again
> >
> > Luping
> >
> >
> > "Howard J. Rogers" <dba_at_hjrdba.com> wrote in message
> news:<3bf42560$0$377$afc38c87_at_news.optusnet.com.au>...
> > > Yes and no. As I pointed out elsewhere when you first raised the
> question
> > > in a different thread, if you are desperate for a GUI, then you can do
> > > export and import using the Management Server. But it reminds me of
> using a
> > > three-ton truck to crack a small peanut.
> > >
> > > Just open a command window, and type "exp system/manager full=y
> > > file=export.dmp" (without the quotes of course) and you're done.
> > >
> > > Regards
> > > HJR
> > > --
> > > Resources for Oracle: http://www.hjrdba.com
> > > ===============================
> > >
> > >
> > > "Roben Zhang" <lzhang_at_opentext.com> wrote in message
> > > news:208636ca.0111151116.2ad3dee6_at_posting.google.com...
> > > > Ed_Stevens_at_nospam.noway.nohow (Ed Stevens) wrote in message
> news:<3bf3c8b8.50755642_at_ausnews.austin.ibm.com>...
> > > > > Is the database containing your repository up and running?
> > > > >
> > > > > On 14 Nov 2001 08:39:42 -0800, lzhang_at_opentext.com (Roben Zhang)
> > > > > wrote:
> > > > >
> > > > > >when i tried to start service OracleOraHome81ManagementServer in
> > > > > >Services of control panel, i got message saying:
> > > > > >
> > > > > >Could not start the OracleOraHome81ManagementServer service on
> > > > > >\\IRIMSQAORC2 (that is my oracle server name).
> > > > > >Error 0203: The system could not find the environment option that
> was
> > > > > >entered.
> > > > > >
> > > > > >From where should i configure that environment option?
> > > > > >
> > > > > >Thanks in advance for your help.
> > > > > >
> > > > > >Roben
> > > >
> > > > After i have created repository through Configuration Assistant of
> > > > Enterprise Manager, I can start service
> > > > OracleOraHome81ManagementServer now.
> > > >
> > > > But when i tried to launch console of Enterprise Manager, i got a
> > > > message saying: "VTK-1002:The Oracle Management Server you are trying
> > > > to connect to is still in the process of initialization. Please wait
> > > > for it to start up completely and then try logging in again." I have
> > > > already started Oracle Management Server. I don't know what else i
> > > > should do before launch to console.
> > > >
> > > > Is that the right place to do database export?
> > > >
> > > > Thanks a lot for your help.
> > > >
> > > > Luping
Received on Fri Nov 23 2001 - 12:33:35 CST