Friday 27 March 2015

TNS-12542: TNS:address already in use TNS-12560: TNS:protocol adapter error TNS-00512: Address already in use 32/64-bit Windows Error: 48: Unknown error





c:> sqlplus / as sysdba
 as NO TNS or listener FOUND

c:> exit

Lsnrctl start PROD 

TNSLSNR for 32-bit Windows: Version 10.2.0.3.0 - Production
System parameter file is
D:\oracle\PROD\db\tech_st\10.2.0\network\admin\PROD_erpprod\listener.ora
Log messages written to
D:\oracle\PROD\db\tech_st\10.2.0\network\log\listener.log
Error listening on: (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12542: TNS:address already in use
 TNS-12560: TNS:protocol adapter error
  TNS-00512: Address already in use
   32-bit Windows Error: 48: Unknown error

Listener failed to start. See the error message(s) above...




For this error we did the followings

HKEY_LOCAL_MACHINE --> SYSTEM --> Services --> TCPIP ---> Parameters -->
Create one Key file name as MaxUserPort and Value as 65534 save it .




And then we  gave ipaddress instead of hostname in listener.ora file .




Now start the Listener  as Lsnrctl   start PROD



Now i try to connect the DB as sqlplus / as sysdba  and it  startup as MOUNT stage so  we try to OPEN now its open with out an issue. 

No comments: