Troubleshooting

Error

Diagnosis

ORA-12154: TNS:could not resolve the connect identifier specified

open tnsnames.ora file and append following line

LISTENER_<PDBNAME> =

(ADDRESS = (PROTOCOL = TCP)(HOST =

FQDN)(PORT = 1521))

<PDBNAME> =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST =

FQDN)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = <PDBNAME>)

))

LoginUser= failed:

05.12.2021 23:45:45 src/p11adm_R2.c[429]

p11_login: C_Login [type=1] returned Error

0x00000102

(CKR_USER_PIN_NOT_INITIALIZED)


PKCS#11 Slot is not initialized.


The CryptoServer PKCS#11 Library R3 is not initialized.

Error CKR_CRYPTOKI_NOT_INITIALIZED occurred


PKCS#11 Slot is not initialized.

ORA-46661: keystore not open in root container


Check the sqlnet.ora file for the configuration, first open wallet in root container.


The listener supports no services


Check the tnsnames.ora file and listener.ora file for configuration



TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

64-bit Windows Error: 61: Unknown error


Start the Listener service by using lsnrctl start command

ORA-28365: wallet is not open


ADMINISTER KEY MANAGEMENT SET

KEYSTORE OPEN IDENTIFIED BY <password>


ORA-01031: insufficient privileges

Either grant the permission to user or run the command using sysdba user

List of errors and its diagnosis