Langsung ke konten utama

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

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

Solution

Verify a TNSNames.ora file exists on the QuickConnect server

By default, the TNSNames.ora file resides in <OracleInstallDirectory>\network\admin
If the TNSNames.ora file does not exist, reference the following guide on how to create one:
https://oracle-base.com/articles/misc/oracle-network-configuration

Set the TNS_Admin environment variable if it is not set:

    Navigate to Control Panel > System
    Select Advanced System Settings
    In the Advanced tab, select Environment Variables
    Under System Variables, click New
    In the Variable name text box, type TNS_ADMIN
    In the Variable value text box, type the location of the TNSNames.ora file
    Click OK to add the variable
    Restart the server
Label:

Komentar

Posting Komentar

Postingan populer dari blog ini

Mounting USB drives in Windows Subsystem for Linux

Windows Subsystem for Linux can use (mount): SD card USB drives CD drives (CDFS) Network drives UNC paths Local storage / drives Drives formatted as FAT, ExFAT or NTFS can be mounted in WSL. For this example, we assume the drive shows in Windows as F:\ If Windows changes the USB drive letter on a subsequent session, you need to repeat this process. The commands are typed into the Windows Subsystem for Linux Terminal. Create a mount location in WSL: $ sudo mkdir /mnt/f Mount the drive in WSL: $ sudo mount -t drvfs f: /mnt/f After this one-time setup, one can create and manipulate files from both Windows and WSL on the same drive. network storage Here we assume: networked storage is already showing in Windows under \\server\share we want to access this network storage from WSL as /mnt/share Create a mount location in WSL: $ sudo mkdir /mnt/share Mount the network share in WSL: $ sudo mount -t drvfs '\\server\share' /mnt/share
Posting Komentar
Baca selengkapnya

FMW 12.2.1.3.0: "ONS configuration failed" or "oracle.ons.NoServersAvailable: Subscription time out"

FMW 12.2.1.3.0: "ONS configuration failed" or "oracle.ons.NoServersAvailable: Subscription time out" Solving To implement the workaround in the Configuration Wizard(config.sh) set the following environment variable before launching config.sh. $ export CONFIG_JVM_ARGS=-Doracle.jdbc.fanEnabled=false
1 komentar
Baca selengkapnya

ERROR ORACLE DB: The version 12.2.0.1.0 of the database that you are using is not a supported version

ERROR ORACLE DB: The version 12.2.0.1.0 of the database that you are using is not a supported version or The specified user may not have sufficient privileges to perform this operation. User should have sysdba or dba privileges. Solution SQL> alter system set db_32k_cache_size = 512M scope=both;
Posting Komentar
Baca selengkapnya