ORA-00119: invalid specification for system parameter LOCAL_LISTENER

Issue:

While startup the RAC database got following the error:

SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'TEST1_LOCAL'

Missing below entry in RAC node tnsnames.ora file below entry.
Just add below entry to tnsname.orafile.

Solutions:

TEST1_LOCAL=
        (DESCRIPTION=
                (ADDRESS=(PROTOCOL=tcp)(HOST=erpdevdb1-vip.xyz.com)(PORT=1551))
        )


7 comments:

Joseph Russo said...

Real estate is the only “product” truly made in America. Orland Park real estate agents Construction, especially of homes and small commercial, industrial, and office buildings, is a cornerstone of our economy. Today, we call this valuable American real estate asset “sustainable communities.”

Saif ur Rahman said...

Check Seo & Web analytics Click On Stateros.com

Saif ur Rahman said...

Listen & Download Mp3 Songs Online on 4SongPK.com

Saif ur Rahman said...

Unblock Youtube Using VideosProxy.com

priti gupta said...

Website is comprehensive as well as informative. I have enjoyed the visit. From www.sendonlinerakhigifts.com

Sridevi Koduru said...

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, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

Praveen Kumar said...

Valuable information thanks for sharing Oracle APPS DBA Online Training