Oracle8i finalpatch 2005-02-04 - By Reinhold Binder
Hi Frank,
if I try sqlplus -- I get ORA-24327 (See ORA-24327.ora-code.com)
need expicit attach before authenticating user
It is a db for production (terrible situation).
Reinhold
-- -- Original Message -- --
From: "Frank Grote" <grote@(protected)>
To: "mail_suse" <suse-oracle@(protected)>
Sent: Friday, February 04, 2005 10:29 AM
Subject: Re: [suse-oracle] Oracle8i finalpatch
> Hi!
>
> Does "sqlplus internal" (or what ever!) give you the same error messages?
> Maby svrmgrl is broken.
> Nothing in alert.log?
> Try "ipcs". Are there old shared memory segments from the last run? Kill
> them and try again.
>
> I hope, you don't need this db for production!
>
> Frank
>
> Reinhold Binder schrieb:
> > Hi Frank, hi Paul
> >
> > thanks for your replay!
> >
> > My problem is: I can't startup the SGA -
> > Oracle is not available - and this after installing the
> > patch.
> > I must shutdown database and listener,
> > then I have to install the path - no problems.
> >
> > The next step is - update init.ora (disable systemtrigger).
> >
> > Now I try to restart the database -> SVRMGRL
> > and here I get the problem .
> >
> > Listener is running, but I can't startup Oracle.
> > I don't have a SGA.
> >
> > I hope you can help me.
> >
> > Thank you
> >
> > Reinhold
> >
> >
> >
> > -- -- Original Message -- --
> > From: "Paul Foerster" <paul.foerster@(protected)>
> > To: "mail_suse" <suse-oracle@(protected)>
> > Sent: Thursday, February 03, 2005 6:28 PM
> > Subject: Re: [suse-oracle] Oracle8i finalpatch
> >
> >
> >
> >>Hi Reinhold, hi Frank,
> >>
> >>On 03. Feb, 2005, at 17:43, Frank Grote wrote:
> >>
> >>>What's about "sqlplus internal"?
> >>
> >>... no. The correct syntax is sqlplus "/ as sysdba". The use of both
> >>"svrmgrl" and the pseudo user "internal" is deprecated from versions 8i
> >>and newer. The quoting of the "/ as sysdba" part is operating system
> >>dependant and may vary from OS to OS. You might end up with one of the
> >>following (not complete) list:
> >>
> >>sqlplus "/ as sysdba"
> >>sqlplus '"/ as sysdba"'
> >>sqlplus "'/ as sysdba'"
> >>
> >>It depends on how the shell interprets the parameters and quotes.
> >>
> >>Or you can obviously do
> >>
> >>sqlplus
> >>Username: / as sysdba
> >>
> >>
> >>>Listener is running?
> >>
> >>... internal or sysdba connects do not use the listener unless you
> >>provide the instannce name. In this case you'd need to do it this way
> >>(quoting variations from above apply):
> >>
> >>sqlplus sys@(protected)
> >>
> >>Or, if you have a password file:
> >>
> >>sqlplus "sys@(protected) as sysdba"
> >>
> >>The latter is also used with 9i which requires a password file if you
> >>intend to do an SQL*Net connect, ie. use the listener.
> >>
> >>Hope this helps.
> >>--
> >>cul8er
> >>
> >>Paul
> >>paul.foerster@(protected)
> >>
> >>
> >>--
> >>To unsubscribe, email: suse-oracle-unsubscribe@(protected)
> >>For additional commands, email: suse-oracle-help@(protected)
> >>Please see http://www.suse.com/oracle/ before posting
> >>
> >>
> >>
> >
> >
>
> --
> Weber Data Service IT GmbH
> Frank Grote
> Feilenstr. 31
> 33602 Bielefeld
> Tel.: +49 521/5244-501
> Fax: +49 521/5244-601
>
>
> --
> To unsubscribe, email: suse-oracle-unsubscribe@(protected)
> For additional commands, email: suse-oracle-help@(protected)
> Please see http://www.suse.com/oracle/ before posting
>
>
>
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
|
|
