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

Install jq on Raspberry Pi

jq is a lightweight and flexible command-line JSON processor. jq is like sed for JSON data - you can use it to slice and filter and map and transform structured data with the same ease that sed , awk , grep and friends let you play with text. jq is written in portable C, and it has zero runtime dependencies. You can download a single binary, scp it to a far away machine of the same type, and expect it to work. jq can mangle the data format that you have into the one that you want with very little effort, and the program to do so is often shorter and simpler than you'd expect. $ cd /tmp $ wget https://github.com/stedolan/jq/releases/download/jq-1.5/jq-1.5.tar.gz $ tar xfvz jq-1.5.tar.gz $ cd jq-1.5 $ ./configure && make && sudo make install
Posting Komentar
Baca selengkapnya