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.
1 comment:
Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.
Post a Comment