Oracle installation of 32-bit clients causes a failure to start properly

On the win platform, you need to use Plsql developer access to the same host Oracle,plsql is not supported 64-bit, you need to set the Oracle_home and OCI address, while configuring Tns_admin to Oracle 32-bit clients,

However, this can cause Oracle itself to be affected when the database service starts, and should be the cause of listen.

There are two ways to resolve this:

1, change the 32-bit tnsnames.ora, add:

Listener_tdata =
(ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))

But this method does not feel reasonable, and the name can not be changed is also more depressed,

2, the analysis should be Oracle can not find Listener_tdata this name, with the ultimate method:

sql> create pfile= ' C:\mypfile.ora ' from SPFile;
File created.

Open Mypfile.ora, modify the following line:

*.local_listener= ' Listener_tdata '

Switch

*.local_listener= ' (address_list= (address= (protocol=tcp) (host=127.0.0.1))) '

Sql> create SPFile from pfile= ' C:\mypfile.ora ';

Generate a new SPFile file with Pfile.

Restart Oracle to resolve.