Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: About Sql*plus

Re: About Sql*plus

From: StefanKapitza <skapitza_at_volcanomail.com>
Date: 17 Jan 2006 12:33:23 -0800
Message-ID: <1137530003.499502.37750@o13g2000cwo.googlegroups.com>

epeppanda_at_yahoo.com.cn wrote:
> Yes,I am on Windows.
> must I using service name like "conn /@ora92 as sysdba" ,when I want to
> connect to oracle as sysdba in sql*plus?
> many example on the book , it just use "conn / as sysdba",no service
> name
> there is no problem in listener ,because I can connected when database
> startup .
> I can't connect as sysdba without service name or connect to idle
> database .
> Why?

maybe you must execute

oradim -edit -sid ora92 -startmode a

to start the database with the Windows Service

regards

stefan Received on Tue Jan 17 2006 - 14:33:23 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US