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:
Post a Comment