Re: Oracle for Windows XP with INTEL inside

Hi Jared,


I find out using oradim to startup the services, it should be like this, you
don't have to use service manager to start the service


oradim -STARTUP -SID sid [-USRPWD password] [-STARTTYPE srvc|inst|srvc,inst]
[-PFILE filename]

oradim -SHUTDOWN -SID sid [-USRPWD password] [-SHUTTYPE srvc|inst|srvc,inst]
[-SHUTMODE a | i | n]

after the service started you can log in as sysdba.


regards,

Sinardy


----- Original Message ----- 
From: "Oracle" <all_about_oracle@xxxxxxxxxx>
To: <jkstill@xxxxxxxxxx>; <SinardyXing@xxxxxxxxxxxxx>
Cc: "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
Sent: Saturday, September 25, 2004 12:20 PM
Subject: Re: Oracle for Windows XP with INTEL inside


> Hi Jared,
>
> I read from AskTom, he said you need to startup Oracle from the service
> manager "FIRST"
> then you can do sqlplus /nolog and connect sys as sysdba then startup.
>
> It works now with my notebook
>
> 1. SERVICE MANAGER start oracle instance (my preference is not automatic
> startup mode)
> I don't have to start the listener
> 2. sqlplus /nolog @startup.sql
>
>
>
>
> ----- Original Message ----- 
> From: "Jared Still" <jkstill@xxxxxxxxxx>
> To: <SinardyXing@xxxxxxxxxxxxx>
> Cc: "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
> Sent: Saturday, September 25, 2004 10:08 AM
> Subject: Re: Oracle for Windows XP with INTEL inside
>
>
> > Though I can't recall seeing that stated anywhere, that is
> > in fact the way it works.
> >
> > If anyone knows of a way to connect as sysdba to a database
> > on *without* listener, I would like to hear about it too.
> >
> > Jared
> >
> >
> > On Sun, 2004-09-19 at 21:08, Sinardy Xing wrote:
> > > Hi guys,
> > > Is that true that you cannot connect to Oracle 9.2.0 on Intel + XP
> machine "WITHOUT A LISTENER?"
> > >
> > >
> > > I got this from metalink
> > >
> > > ---------------------------------
> > >
> > > Problem: You could get an ORA-09352 on version 7.x of the database, an
> ORA-12203 on  version 8.0.x of the database, or an ORA-12560 on version
> 8.1.x of the database.
> > >
> > > Solution: This is because the bequeath connection is not supported on
NT
> terminal server.  Note 66397.1 (INTEL: Windows NT Terminal Server Support)
> shows the  certification.
> > >
> > > ---------------------------------
> > >
> > > Can you please tell me how to startup Oracle 9.2.0 wihtout using
> listener? (on Win XP).
> > >
> > > This is my attempt
> > >
> > > ---------------------------------
> > >
> > > run... cmd
> > >
> > > C:\> set ORACLE_SID=mytest          (I also try set the variable on
the
> System Property, Advanced Tab, User variables)
> > >
> > > C:\> sqlplus /nolog
> > >
> > > SQL> connect system as sysdba
> > > password:.... manager
> > >
> > > ORA-12560: TNS: erro....
> > >
> > > ---------------------------------
> > >
> > >
> > > Thanks in advance
> > >
> > >
> > > regards,
> > >
> > > Sinardy
> > >
> > >
> > > --
> > > http://www.freelists.org/webpage/oracle-l
> >
> > --
> > http://www.freelists.org/webpage/oracle-l
>
>
> --
> http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l

Other related posts: