Start PLSQL developer, an error, I on the Internet to find the solution, operation, no success, but by itself around dizzy, ,
1. Have said service did not start, but I have started a .
2. Have said environment variable is set wrong, here I am dizzy now,
Such as ORACLE_HOME: some people the value of the variable is given... \ product \ 10.2.0 \ db_1 \ bin, have a plenty of bin directory at the next higher level... \ product \ 10.2.0 \ db_1 \, some people give the client the decompression directory... \ instantclient_10_2;
Then there is TNS_ADMIN: some people to extract is client directory; Some to D: \ oracle \ product \ 10.2.0 \ db_1 \ NETWORK \ ADMIN, I am not sure who to who wrong, this is my installation directory structure
And PLSQL developer in configuration, also don't know how to fill in the ,
3. My computer is Windows 7 64 - bit, I installed the oracle 10 g and 64 - bit, on the Internet to see someone said PLSQL developer only 32 bit, so the oracle client installed 32 bit, right?
Novice self-study, bosses to solve, thank you,

CodePudding user response:

Are you directly in the tnsnames. Ora configuration inside connection? You use a NetManager configuration test under proper (sid), and then look at the LSNRCTL status

CodePudding user response:

You can try directly in up sqlplus don't log in

CodePudding user response:

refer to the second floor shpery response:

you try directly on the up sqlplus can log in

Can, I especially want to know now is that how to set the environment variable, PLSQL developer in the path of the how to set up, it is not sure a server or client's address,

CodePudding user response:

Oci with 32 bit

CodePudding user response:

1, the client need to install 32-bit
2. Check for tnsnames. Ora file, the reference configuration:
Former=
(the DESCRIPTION=
(ADDRESS=(TCP) PROTOCOL=(HOST=localhost) (1521) PORT=)
(CONNECT_DATA=
https://bbs.csdn.net/topics/(=DEDICATED SERVER)
(SERVICE_NAME=former)
)
)