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: sqlplus /@dev.world in oracle 8.1.7.2.1 generates error..Please advise

Re: sqlplus /@dev.world in oracle 8.1.7.2.1 generates error..Please advise

From: Henry Kam <kam1_at_whwpe.lucent.com>
Date: Fri, 04 Oct 2002 14:08:08 GMT
Message-ID: <3D9DCA37.FC584B5B@whwpe.lucent.com>


Paul,Thanks for your suggestion...
I followed the installation instruction of Oracle clinical:

  1. logon as administrator
  2. create the OS USER rxcprod with certain advanced user rights
  3. set the service starting properties
  4. logoff administrator and logon as rxcprod
  5. start PSUB and get the following error ERROR:Daemon error while connecting:/@dev.world ORa-01017 where dev.world is the connecting string.

Oracle clinical creates the Oracle user

           OPS$rxcprod as identified by externally

In my init.ora:
remote_os_authent = TRUE
os_authent_prex = OPS$
o7_dictionary_accessibility = TRUE

Oracle Clinical expects:
after logn as rxcprod as OS USER,
rxcprod should be able to access or connect to oracle database as "/@dev.world"....

Please advise as what to do next....
TIA Paul Drake wrote:

> vze3djdq_at_mail.verizon.net wrote in message news:<3D9B4388.BA2DE9A5_at_mail.verizon.net>...
> > Oracle 8.1.7.2.1 installed on Windows NT4.0 sp6a ...everything works...
> > Installed Oracle clinical 4.0.0 and patched to 4.0.3..
> > Could not start PSUB service(neither by user rxcprod nor
> > administrator)...the errorlog stated
> > ERROR:Daemon error while connecting:/@dev.world
> > ORa-01017
> >
> > Check init.ora: o7_dictionary_accessibility is TRUE (also comfirmed by
> > show parameter o7 in sqlplus)
> > By the way,
> > sqlplus "/@dev.world as sysdba" works!!! but not sqlplus "/@dev.world"
> > !!!
> >
> > Please advise as how to make sqlplus /@dev.world work in this case
> > TIA
>
> connecting as sysdba is using the password file.
> check your password file settings in the init.ora.
Received on Fri Oct 04 2002 - 09:08:08 CDT

Original text of this message

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