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

Home -> Community -> Usenet -> c.d.o.misc -> ORA-01017 : invalid username/password : logon denied

ORA-01017 : invalid username/password : logon denied

From: Olivier Bufalini <bufalini_at_rmm.fr>
Date: Wed, 25 Aug 1999 18:45:17 +0100
Message-ID: <7q16ij$f4j$1@news.entreprises.cegetel.fr>


Hello

I'm installing Oracle8 for Digital Unix. Here is my problem : When I try to connect through the network with a loopback connection (sqlplus login/password_at_fie)
I've got this error :
ORA-01017 : invalid username/password : logon denied. I can log in locally through SQLPlus (sqlplus login/password) or svrmgrl. So what's the matter ? I'm not familiar with oracle install, so I'm probably missing something, but what ?
Thank for the help

My listener.ora look like this :

SQLNET.AUTHENTICATION_SERVICES = (NONE) USE_PLUG_AND_PLAY_LISTENER = OFF
USE_CKPFILE_LISTENER = OFF
LISTENER =
  (ADDRESS_LIST =

        (ADDRESS=

(PROTOCOL=IPC)
(KEY= fie.world)
) (ADDRESS=
(PROTOCOL=IPC)
(KEY= fie)
) (ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = 195.115.46.224)
(Port = 1521)
)

  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = fie.world)
 (SID_NAME = fie)
      (ORACLE_HOME = /donnees/u01/app/oracle/product/8.0.5)
      (PRESPAWN_MAX = 10)
      (PRESPAWN_LIST =
        (PRESPAWN_DESC = (PROTOCOL = TCP) (POOL_SIZE = 10) (TIMEOUT = 0))
  )
)

     )

and my tnsnames.ora like this :

FIE.WORLD =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = fiesta.rmm.fr)(PORT = 1521))     (CONNECT_DATA = (SID = FIE))
  ) Received on Wed Aug 25 1999 - 12:45:17 CDT

Original text of this message

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