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))
        )


3 comments:

Lisa Jones 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.”

Blog27999 said...

Did you realize there's a 12 word phrase you can tell your man... that will trigger intense feelings of love and impulsive attractiveness for you deep within his heart?

That's because deep inside these 12 words is a "secret signal" that triggers a man's impulse to love, worship and protect you with his entire heart...

12 Words Who Trigger A Man's Love Impulse

This impulse is so built-in to a man's brain that it will drive him to work better than before to take care of you.

As a matter of fact, fueling this dominant impulse is absolutely important to getting the best ever relationship with your man that once you send your man a "Secret Signal"...

...You'll immediately notice him expose his heart and soul to you in such a way he haven't expressed before and he'll distinguish you as the only woman in the world who has ever truly appealed to him.

Realtime Experts said...

Awesome links, it has helped me a lot. Thanks for sharing.
Oracle Apps Technical Training in Bangalore