Home > database >  PLSQL configuration problem
PLSQL configuration problem

Time:09-24


Wrong information and support as shown
Environment variable as follows:
ORACLE_HOME - & gt; D: \ \ product \ 11.2.0 \ app \ kf client_1 \ bin. E: \ \ product \ 11.2.0 \ app \ kf dbhome_1
The Path - & gt; D: \ \ product \ 11.2.0 \ app \ kf client_1 \ bin. E: \ \ product \ 11.2.0 \ app \ kf dbhome_1 \ bin. C: \ ProgramData \ Oracle \ Java \ javapath; C: \ Program Files \ Intel \ iCLS Client \; % SystemRoot % \ system32; % SystemRoot %; % SystemRoot % \ System32 \ Wbem; % SYSTEMROOT % \ System32 \ WindowsPowerShell \ v1.0 \; C: \ Program Files \ Intel \ \ 3.0 \ bin \ x86 OpenCL SDK; C: \ Program Files \ Intel \ Intel (R) Management Engine Components \ DAL; C: \ Program Files \ Intel \ Intel (R) Management Engine Components \ IPT. The % JAVA_HOME % \ bin; % JAVA_HOME % \ jre \ bin. D: \ PLSQL \ instantclient_12_2;
NLS_LANG - & gt; AMERICAN_AMERICA. ZHS16GBK
TNS_ADMIN - & gt; D: \ PLSQL \ instantclient_12_2
Ask where to go wrong, appreciate receiving

CodePudding user response:

The database format, written in the format of the IP/SID

For example: 127.0.0.1/former

CodePudding user response:

reference 1st floor wmxcn2000 response:
database this format, as such the format of the IP/SID

For example: 127.0.0.1/former

Is in tnsnames. Ora change the database name

CodePudding user response:

refer to the second floor qq_24351647 response:
Quote: refer to 1st floor wmxcn2000 response:

The database format, written in the format of the IP/SID

For example: 127.0.0.1/former

Is in tnsnames. Ora in change the database name you


If the tnsnames. Ora defined in the service name, only write the service name in the box,

If tnsnames. Ora is not defined, here can be written as the form of IP/SID,

CodePudding user response:

Ora in tnsnames. Change the database name
If in a tnsnames defines the database network service name, just use the web service name,
May also directly use IP: PORT/service_name
Such as 127.0.0.1:1521/former
  • Related