Re: sqlplus /nolog can't manage instance

It reports a sqlnet error because (I suspect) you're using that bequeath stuff (unnecessarily it seems to me) and haven't configured things correctly.

Try a nice, simple TCP/IP protocol set up, with all the listener.ora and tnsnames.ora and sqlnet.ora, and get that working. Then you can start getting adventurous.

Regards
HJR "Pan Tao" <pantao_fz_at_21cn.com> wrote in message news:ajado9$27kb$1_at_mail.cn99.com...
> Hi, Rogers
> really sorry for my poor expression,
>
> "Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message
> news:3d589da7_at_dnews.tpgi.com.au...
> >
>
> > As for the rest of what you wrote, I'll take it a step at a time:
> >
> > "So in normal case, connect to privileged users will not connect to the
> > database instance".
> >
> > What? Of course privileged users connect to an Instance, just like
> > non-privileged users. There's just one exception: when the database is
> > shutdown, and the privileged user seeks a connection in order to start
it
> > up, then obviously they don't connect to the Instance. They connect to
the
> > Listener, request a Server Process, and that Server Process then goes
> about
> > the business of creating the Instance, mounting the database and opening
> the
> > database.
> I mean to the database is shutdown situation. but For local user (without
> useing
> the alias name) to connect to system, I think the sqlplus dirrectly use
> bequeched
> protocol to connect oracle and listener server is not involved in, since
SID
> is used here and no alias name is proviced.
>
> >
> > "But in my situation, it connects to, so I think there may be some wrong
> > with the privileged setting so priveleged can't be verified normally,
and
> it
> > try to connect to instance to verify it."
> >
> > I honestly haven't a clue what you are talking about here. You mean you
> get
> > a 'connected' response when you connect as a privileged user, but the
> > database is down? Great: you've connected to the Listener, and are ready
> to
> > issue the 'startup' command. If your database is down, you can't connect
> to
> > an Instance, to verify anything, because there isn't one. Perfectly
> normal.
> >
>
> I mean the sqlplus try connect to , but it didn't connectted to the server
>
> and report sqlnet error.
>
> > "I think the user sys and system can also be verify by the user table
> since
> > they can change their password."
> >
> > Naturally. Both SYS and SYSTEM are users with entries in the DBA_TABLES
> data
> > dictionary view. So yes, they can use DATA DICTIONARY authentication.
> SYSTEM
> > is NOT a privileged user, however, and can ONLY use data dictionary
> > authentication. SYS (in 8i) can log on EITHER as a privileged user OR as
> an
> > ordinary dictionary-authenticated user. To log on normally, he does
> 'connect
> > sys/something'. To log on as a privileged user, he does 'connect
> > sys/something AS SYSDBA'. The extra two words invoke the external
> > authentication mechanisms I mentioned earlier: either a password file or
a
> > check to see if you, the NT user, are a member of the ORA_DBA group.
> >
> > Have you read the concepts manual?
>
> just partially now
>
> > HJR
> >
>
>
> My question is if I start the service first, all is OK. I hope just use
> sqlplus /nologin to start the oracle instance locally( in unix,
> it is possible) .So I don't start the oracle instance service and fire up
> sqlplus /nolog , so it reports the error below:
>
> E:\NTDDK\src\general\portio>sqlplus /nolog
>
> SQL*Plus: Release 8.1.7.0.0 - Production on 星期五 8月 9 19:49:59 2002
>
> (c) Copyright 2000 Oracle Corporation. All rights reserved.
>
> SQL> connect / as sysdba
> ERROR：
> ORA-12560: TNS: 协议适配器错误(adapter error)
>
> Now, I chenk the document, it is said:
>
> Oracle services must be started for you to use the Oracle9i database and
its
> products. (I think this means start the oracle instance at least the
oracle
> server should run first)
>
> If so, it is different form unix which I missed it before. For unix,
> administrator can start the oracle just use sqlplus. And if so, I
> have no problem now.
>
> thanks and regards,
> PanTao
>
>
>
Received on Tue Aug 13 2002 - 03:35:04 CDT