Novice, want to install a practice; Now the two problems;
11 g 64 after installation, install the 32-bit version of the client unpack, and PL SQL;
Found two problems:
1 \ product \ 11.2.0 \ dbhome_1/NETWORK/ADMIN no tnsnames. Ora and listener. Ora this two files;
Environment variables without any Settings;

2. According to the online configuration after the client environment variables (path, the oracle_home and tns_admin) after found conflict and oracle server
Found the server listener, all service naming is empty; Tool net configuration assistant can't open, netca command prompt environment variable error;
Now get rid of all the client environment variables refer to keep the client after the path variable path;

Find PL SQL instance name optional. Then turned and made the big morning lane; How to set the environment variable service and client installed on the same machine,

CodePudding user response:

1. \ product \ 11.2.0 \ dbhome_1/NETWORK/ADMIN no tnsnames. Ora and listener. Ora this two files;

No, you manually create a, from somewhere else kao can also

2. According to the online configuration after the client environment variables (path, the oracle_home and tns_admin) after found conflicts and oracle server

How specific configuration?

CodePudding user response:

reference 1st floor wmxcn2000 response:

1. \ product \ 11.2.0 \ dbhome_1/NETWORK/ADMIN no tnsnames. Ora and listener. Ora this two files;

No, you manually create a, from somewhere else kao can also

2. According to the online configuration after the client environment variables (path, the oracle_home and tns_admin) after found conflicts and oracle server

How specific configuration?

Thank you buddy upstairs
Add: a variable name:
ORACLE_HOME variable values: D: \ Oracle_client
The TNS_ADMIN variable values: D: \ Oracle_client \
NLS_LANG variable values: SIMPLIFIED CHINESE_CHINA. ZHS16GBK
Increase the path D: \ Oracle_client;

Restart the computer: service in start-up failure monitoring, command netca error message below
Oracle.net.ca.NetCAFatalException: environment detected error: Oracle home directory in the environment has been set to
"D: \ Oracle_client", the path with the Oracle Net Configuration Assistant to install Oracle
Home directory is different,

CodePudding user response:

ORACLE_HOME variable values: D: \ Oracle_client


If the variable is added, deleted;

CodePudding user response:

The

reference 3 floor wmxcn2000 response:

ORACLE_HOME variable values: D: \ Oracle_client


If the variable is added, deleted;

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Removed, you can see the instance of the
But in the service of listening oracleora11g_home1TNSlistener couldn't start,
PL SQL prompt: ORA - 12541: no listeners;
\ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN no tnsnames ora and listener. Ora this two files

CodePudding user response:

Use netca configuration;

CodePudding user response:

reference 5 floor wmxcn2000 reply:

with netca configuration;

Configured to generate the two files to modify IP 127.0.0.1 for
According to the Internet increases the TNS_ADMIN environment variables;

Find the generated monitor ORACLE_HOME=D: \ \ Administrator \ product \ app. Is there a link between 11.2.0 \ dbhome_2

Login PLSQL as abnormal

CodePudding user response:

What is db_home2?

CodePudding user response:

refer to 6th floor yiyang0925 response:

Quote: refer to the fifth floor wmxcn2000 reply:

Use netca configuration;

Configured to generate the two files to modify IP 127.0.0.1 for
According to the Internet increases the TNS_ADMIN environment variables;

Find the generated monitor ORACLE_HOME=D: \ \ Administrator \ product \ app. Is there a link between 11.2.0 \ dbhome_2

Login PLSQL as abnormal

refer to 7th floor wmxcn2000 response:

db_home2 is what?

D: \ \ Administrator \ product \ app 11.2.0 directory under the installation of automatically generated when

CodePudding user response:

Changed, it is no use,
Feel better pit ah do not understand

CodePudding user response:

I chose the typical installation pl SQL whether can skip the client direct connect server