tag:blogger.com,1999:blog-12703605671249446072011-04-21T18:45:02.682-07:00Business Intelligence and the things I learn along the way.mlthompshttp://www.blogger.com/profile/00131627624748772473noreply@blogger.comBlogger21100tag:blogger.com,1999:blog-1270360567124944607.post-55448345004737240152009-02-24T15:36:00.000-08:002009-02-24T16:01:30.995-08:00I recently installed a new Oracle11g database on my Linux server. I noticed<br />when starting it for the first time I got the following two messages:<br /><br />ORA-00119: invalid specification for system parameter LOCAL_LISTENER<br />ORA-00132: syntax error or unresolved network name 'LISTENER_ORA11GR1'<br /><br />After a bit of research I found that Oracle needs an entry in the tnsnames.ora<br />for the listener where you are using a non-default port number (1522 in my case).<br /><br />The new entry will look like:<br /><br />LISTENER_ORA11GR1 = (ADDRESS = (PROTOCOL = TCP)(HOST = soleil)(PORT = 1522))<br /><br />After adding this entry the instance started fine.<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/1270360567124944607-5544834500473724015?l=busintel.blogspot.com' alt='' /></div>mlthompshttp://www.blogger.com/profile/00131627624748772473noreply@blogger.com0tag:blogger.com,1999:blog-1270360567124944607.post-79557880690457321812008-11-19T16:46:00.000-08:002008-11-19T17:05:53.478-08:00Here is a list of common Oracle HS errors I've come across. Hopefully these notes will help save time finding the causes.<br /><br /><br />Oracle Errors: ORA-28545, ORA-02063<br /><br />SQL> desc my_table@my_db_lnk<br />ERROR:<br />ORA-28545: error diagnosed by Net8 when connecting to an agent<br />NCRO: Failed to make RSLV connection<br />ORA-02063: preceding 2 lines from MY_DB_LINK<br /><br />Cause: listener was not restarted. Run lsnrctl reload.<br /><br /> ---------------------------------------<br /><br />Oracle Errors: ORA-28545, ORA-02063<br /><br />SQL> create database link my_db_lnk connect to "scott" identified by<br />"tiger" using 'MY_TNS_ALIAS';<br /><br />Database link created.<br /><br />SQL> desc my_table@my_db_lnk<br />ERROR:<br />ORA-28545: error diagnosed by Net8 when connecting to an agent Unable to retrieve text of NETWORK/NCR message 65535<br />ORA-02063: preceding 2 lines from MY_DB_LNK<br /><br />Cause: HOST and/or PORT in tnsnames.ora is incorrect<br /><br /> ---------------------------------------<br /><br />Oracle Errors: ORA-28545, ORA-02063<br /><br />ERROR:<br />ORA-28545: error diagnosed by Net8 when connecting to an agent<br />Unable to retrieve text of NETWORK/NCR message 65535<br />ORA-02063: preceding 2 lines from MY_DB_LINK<br /><br /><br />Cause: Problem found on AIX and Oracle10g. Need to add the ENVS=LIBPATH line ( as below) in the listener.ora.<br /><br />(SID_DESC=<br /> (SID_NAME=MY_SID)<br /> (ORACLE_HOME=/u01/oracle/product/10.2.0.2)<br /> (PROGRAM=hsodbc)<br /> (ENVS=LIBPATH=/u01/oracle/product/10.2.0.2/lib32)<br /> )<br /><br /> ---------------------------------------<br /><br />Oracle Errors: ORA-28500, ORA-02063<br /><br />select CUSTOMER from my_view<br /> *<br />ERROR at line 1:<br />ORA-28500: connection from ORACLE to a non-Oracle system returned this message:<br />[Generic Connectivity Using ODBC]DRV_InitTdp: errors.h (1997): ;<br />(SQL State: 00000; SQL Code: 0)<br />ORA-02063: preceding 3 lines from MY_DB_LINK<br /><br /><br />Cause: The DSN in the $ORACLE_HOME/hs/admin/init.ora is incorrectly defined.<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/1270360567124944607-7955788069045732181?l=busintel.blogspot.com' alt='' /></div>mlthompshttp://www.blogger.com/profile/00131627624748772473noreply@blogger.com0