Re: oracle managerment server cannot start

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 21 Jul 2001 21:17:39 GMT
Message-ID: <a20d28ee.0106290213.7cbf43fb_at_posting.google.com>


knetsys_at_yahoo.com.hk (Priron) wrote in message news:<ff60d1e3.0106280113.608d691b_at_posting.google.com>...
> postbus_at_sybrandb.demon.nl (Sybrand Bakker) wrote in message news:<a20d28ee.0106220135.17aa697f_at_posting.google.com>...
> > knetsys_at_yahoo.com.hk (Priron) wrote in message news:<ff60d1e3.0106212134.127bb210_at_posting.google.com>...
> > > postbus_at_sybrandb.demon.nl (Sybrand Bakker) wrote in message news:<a20d28ee.0106202324.1c1fc69d_at_posting.google.com>...
> > > > knetsys_at_yahoo.com.hk (Priron) wrote in message news:<ff60d1e3.0106201853.1e380c89_at_posting.google.com>...
> > > > > postbus_at_sybrandb.demon.nl (Sybrand Bakker) wrote in message news:<a20d28ee.0106200511.4d8a0261_at_posting.google.com>...
> > > > > > knetsys_at_yahoo.com.hk (Priron) wrote in message news:<ff60d1e3.0106190303.7d05d489_at_posting.google.com>...
> > > > > > > I install oracle 8i server in solaris box and oracle management server
> > > > > > > on winnt 4.0 server. I try to launch the daemon
> > > > > > > OracleOraHome8ManagementServver, but error message is got "Could not
> > > > > > > start the OracleOraHome8ManagerServer service on \\Server. Error 2140:
> > > > > > > An internal Windows NT error occurred."
> > > > > > >
> > > > > > > What should I set to make it start? I am a newbie. Can you give me the
> > > > > > > detail step ?
> > > > > > >
> > > > > > > Priron
> > > > > >
> > > > > > You need to run the Oracle Enterprise Manager Configuration Assistant
> > > > > > on your win t 4.0 server to create an OEM repository.
> > > > > >
> > > > > > Hth,
> > > > > >
> > > > > > Sybrand Bakker, Oracle DBA
> > > > >
> > > > > I have used Enterprise Manager Configuration Assistant to configure
> > > > > repository.
> > > > > and put the SYS as user name and corresponding password in password
> > > > > field. What should I fill in service ?
> > > > > e.g: SERVER:1521:SID
> > > > > where SERVER is my solaris x86 box's host name in which oracle
> > > > > database installed
> > > > > 1521 is port opened that is showed in lsnrctl status
> > > > > SID is service_names listed in initSID.ora in pfile directory
> > > > >
> > > > > All have tried but failed.
> > > > > Any setting is needed for oracle database in solaris side ?
> > > > >
> > > > > Priron
> > > >
> > > >
> > > > No,no and no
> > > > Do you have manuals? If so, please try to read them, it is all
> > > > documented, and the steps you outline here clearly show you either
> > > > didn't read them or don't understand them.
> > > > Don't use the SYS user for the OEM repository. The default is SYSMAN,
> > > > password OEM_TEMP.
> > > > The connection syntax you are trying is completely worong, it is
> > > > servicename *only*.
> > > >
> > > > Regards,
> > > >
> > > > Sybrand Bakker, Oracle DBA
> > >
> > > Finally, I can start the daemon. Thx your help.
> > > However, I cannot fail to login in Enterprise Manager through
> > > "Console" in Enterprise manager.
> > > I have followed the "HELP". Using SYSMAN as login and OEM_TEMP as
> > > Password.
> > > But what should I use in manager server field ? I try to use hostname
> > > of solaris x86 machice and hostname of nt machice and servicename. ALL
> > > are failed
> > >
> > > Priron
> >
> >
> > 'All fail' just doesn't again tell anything. Did your ever configure a
> > listener on Solaris? You need to do so. You can use netasst.sh to
> > configure a listener.
> > This will also configure tnsnames.ora
> > You will need to copy the files sqlnet.ora and tnsnames.ora to NT
> > and/or rerun the Net8 configuration assistant on the server to get an
> > indenticall tnsnames.ora. Copy or ftp will be faster.
> >
> >
> > Regards,
> >
> > Sybrand Bakker, Oracle DBA
>
> Sorry for my stupid
> solaris oracle machince works well with configured tnsnames.ora and sqlnet.ora.
> I follow your insturction to copy both files to nt
> start the oracle enterprise manager console login.
> put sysman/oem_temp with "nt hostname" as management server. It failed to logon.
>
> Could you give me a hint more to pass through it ?
>
> Priron

Let me try to get this clear. To run OEM you need a repository. Oracle recommends creating a separate database for this purpose. In order to create a repository, you need to connect to the *database*, not to the management server.
The architecture of this product is

Management Server (runs on NT) -> OEM repository database -> databases to be managed.

You can connect to the management server only, once you created a repository in the repository database, whichever database that is. Setting up a second database for this purpose is almost mandatory. In your case you probably have one single database on Solaris only. If you don't want to create a separate database you need to connect to the database on Solaris, not to the management server. All this hassle wouldn't have been necessary with a little reading. Apparently you still refuse to read any documentation. You refuse to post specific error messages, other than 'it failed to logon'
With so much lack of cooperation on your side (if I would have had to do this as a consultant I would have earned about a day of money, and it would have been long resolved), this will be my last reply.

Regards,

Sybrand Bakker, Oracle DBA Received on Sat Jul 21 2001 - 23:17:39 CEST

Original text of this message