32-bit Oracle Client Login 12560 Protocol Adapter Error Resolution

National Day bought a new computer ThinkPad E431,i5 dual core cpu,8g memory, hard disk comparison pit dad 5400 turn 500G, focus on the pre-installed WIN8 64-bit Simplified Chinese version. University bought the first computer Shenzhou notebook, because the Shenzhou computer is cheap, so there is no pre-installed genuine system; After working for the wife bought a computer hp notebook, when a friend opened a shop to do HP computer agent, in order to help him open a Zhang, bought from him, he installed a pirated WinXP. In fact, the heart is still very supportive of the genuine Windows operating system, and the new company to send the work of the computer is very broken, seriously affect the work of the mood, so bought Lenovo ThinkPad, so there is a genuine WIN8 system, and still 64-bit, my memory 8 g, how can also use 32-bit system it! Then it leads to the theme of today ...

Before working with Oracle 11g and PL/SQL developer, because of the use of 32-bit Win7, so there is no trouble. But now with the 64-bit system (WIN8 or Win7 relationship is not big, the solution of this article is applicable, and the author also referred to the solution of the problem Win7 64-bit system solution), can not install 32 Oracle server-side database Ah! Then from the official website under a 64-bit server-side installation program, and then Niang said, 32-bit PL/SQL can not connect 64-bit Oracle database (this can be seen as the Oracle database server program directly with the client function, of course, Oracle also has a dedicated database client program, That is, only the client function, I feel that PL/SQL is not able to connect 64-bit client function, that is oci.dll. It seems that the author encountered the problem, there are countless people encountered, thank the predecessors dug well! To summarize, the 64-bit Windows operating system must be installed on the 64-bit Oracle database server side, and PL/SQL must connect to the 32-bit Oracle database client, then the next Oracle 32-bit client program must be required. I got down and then installed, here's a little note: The second step is to select the administrator. Then the problem arises, not to mention PL/SQL can be connected to Oracle, even sqlplus are not even on, enter the user name password, prompted a tns12560: Protocol adapter error message. I am also Oracle novice ah, find the cause of the problem encountered countless failures, and countless times to ask the Niang. Here's a few words about the Niang. Views: 1, Oracleoradb11g_home1tnslistener This service must start running (note that 11G_HOME1 is related to the version and path of the database you installed); 2, ORACLESERVICEORCL This service must also start running (ORCL is related to your Oracle database name); 3. Variables named Oracle_sid are best set in the environment variables (ORCL is related to your Oracle database name) ; 4, the command to enable and disable the username is alter user Scott account Lock/unlock; (Scott is a user name), 5, the user is enabled for the first logon will prompt to change the default password, the original password can be changed; 6. Someone else did not install the Oracle database 32-bit client program, but installed a instant_client_basic (the name seems to be this, possibly inaccurate) program, and then only the Oracle server side of the network/admin/ folder is copied to the folder in that program, and the PL/SQL OCI library is set toThe program folder can be (here is not very clear, please use this method of the people themselves Baidu, a lot of very whole). But my problem is not solved! After many attempts, it is clear that the Oracle database server configuration is not a problem, with the server side of the sqlplus can properly connect and log into the database. Then open the client's network configuration (NET Manager), found that there is no service, guess is not the problem here? So the server-side network configuration opened, which has been well equipped with two services, one of which is my default ORCL. And then refer to the parameters in the client's network configuration in the configuration of an identical service, here is a small episode, then has been enabled Scott this user, but has not logged in the database, in the configuration of the last step of the test, the default with the Scott user test, the results of the error message was not understood at the time. So with Sqlplus login Scott User (of course this is also used server-side sqlplus), the result is not immediately go in, but prompt to change the default password immediately, this is back to see just the error, the same information! After the change, go to the last step of the configuration and test to indicate that the connection was successful. This time to the client's Sqlplus login user, but still login not up, in the end why? At this time memories of the Niang in the past, vaguely remember someone with the "username/password @ service name" way to log in the database, this way in the previous import and export database was also used, and then use this format to try, Sqlplus finally do not prompt the protocol adapter error, Instead, the connection to the database server is displayed. The last step, start the PL/SQL developer program, do not log on the user, click the Cancel button, directly into the software, in the tool-preferences-connection (in fact, the first interface after entering the preferences, in English friends can find it almost), Oracle Home directory name Select the option that is given in the drop-down list box, the OCI library is the same (note that there must be a client installation directory, such as the path of client_1, such as the word, and you install the client is the path is related, of course, the general drop-down list box gives the option is the client). Then quit the PL/SQL program, reboot and enter, when the login user named Scott, the password is tiger, the database is ORCL, these values are related to personal settings, I give the default value. Then the PL/SQL splash screen shows connected, after a few seconds into the software main form interface, the problem is resolved, you can use the Oracle database under 64-bit system!

The above is the whole process of solving the problem today. Really want to use the 64-bit operating system, but the previous memory is too small, and the 64-bit compatibility problems, so slow to use. Today by the pre-installed genuine 64-bit system of Dongfeng, familiar with, and solve a small problem. Later will be determined to walk on the 64-bit platform, the server from win2008 start there is no 32, and the phone is fast into 64, we developers do not stick to the 32-bit system, of course, if you need, you can use virtual machine, my next article may be to solve the problem of using virtual machine. Hope this article can help to meet the same problem of friends!

32-bit Oracle Client Login 12560 Protocol Adapter Error Resolution