Verbindung Windows-Oracle-Client auf Linux-Oracle-Server nicht möglich - #194336 (Linux)

MarkusH

2022-05-01 16:10

User since
2012-04-08
161 Artikel
BenutzerIn
[default_avatar]

Hallo zusammen,
<GENDERMODE off />
vielleicht gebt es ja den ein oder anderen Oracle-Experten hier im Forum.
Ich habe das Problem, dass ich mit meinem Oracle Client auf Windows10 keine Verbindung zur Oracle-Datenbank, die auf Linux befindet, herstellen kann. Die Fehlermeldung ist "ORA-01017: invalid username/password; logon denied"
Kennt jemand dieses Problem und hat eine Lösung parat?

Daten Server:

OracleLinux 8.5
Oracle 19c (19.14.0.0.0)

Code: (dl )

1
2
3

sqlnet.ora:
#SQLNET.AUTHENTICATION_SERVICES = (NTS)
SQLNET.EXPIRE_TIME = 1

Code: (dl )

listener.ora:
LISTENER =
  (DESCRIPTION_LIST =
	 (DESCRIPTION =
		(ADDRESS_LIST =
			(ADDRESS = (PROTOCOL = TCP)(HOST = vmorcl19)(PORT = 1521))
		)
		(ADDRESS_LIST =
			(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
		)
	 )
  )

Code: (dl )

tnsnames.ora:
orcl19 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = vmorcl19)(PORT = 1521))
    )
    (CONNECT_DATA = (SID = orcl19)(GLOBAL_DBNAME = orcl19))
  )

Daten Client:

Windows 10 21H2
Oracle 19c (19.3.0.0.0)

Code: (dl )

1
2
3

sqlnet.ora:
SQLNET.AUTHENTICATION_SERVICES = (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES)

Code: (dl )

tnsnames.ora:
ORCL19 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = vmorcl19)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl19)
    )
  )

Ein tnsping orcl19 8 liefert

Code: (dl )

TNS Ping Utility for 64-bit Windows: Version 19.0.0.0.0 - Production on 01-MAI-2022 16:06:38

Copyright (c) 1997, 2019, Oracle.  All rights reserved.

Parameterdateien verwendet:
C:\Oracle\network\admin\sqlnet.ora


Adapter TNSNAMES zur Aufl÷sung des Alias verwendet
Verbindungsversuch mit (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = vmorcl19)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl19)))
OK (60 ms)
OK (20 ms)
OK (30 ms)
OK (20 ms)
OK (10 ms)
OK (20 ms)
OK (30 ms)
OK (20 ms)

$q =~ /(bb|[^b]{2})/