I am facing a problem while installing Cisco Prime Network on Red Hat 6.4
The initial installation was OK. It makes me sure the all requirements form Prime Network Gateway were fulfilled.
Afterwards the installation script handed the installation over to the network-conf script. I chose to install Prime Network Gateway and to install embedded database. Afterwards I set the password for oracle users and the location for the database. Everything went fine until i got over a hundred similar error messages:
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
The locat tnslsnr process is running.
[root@PN ~]# netstat -tupln | grep -i tns
tcp 0 0 :::1521 :::* LISTEN 2936/tnslsnr
So I checked the log:
/db/ora/diag/tnslsnr/PN/listener/trace/listener.log
Thu Dec 11 10:46:58 2014
System parameter file is /db/ora/product/11.2.0/db_1/network/admin/listener.ora
Log messages written to /db/ora/diag/tnslsnr/PN/listener/alert/log.xml
Trace information written to /db/ora/diag/tnslsnr/PN/listener/trace/ora_2936_140197775640320.trc
Trace level is currently 0
Started with pid=2936
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=PN)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listener completed notification to CRS on start
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
WARNING: Subscription for node down event still pending
11-DEC-2014 10:46:58 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=PN)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647296)) * status * 0
Thu Dec 11 10:47:11 2014
11-DEC-2014 10:47:11 * (CONNECT_DATA=(SID=anadb)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=pn400))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.21.1.133)(PORT=50236)) * establish * anadb * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
11-DEC-2014 10:47:11 * (CONNECT_DATA=(SID=anadb)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=pn400))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.21.1.133)(PORT=50237)) * establish * anadb * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
11-DEC-2014 10:47:11 * (CONNECT_DATA=(SID=anadb)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=pn400))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.21.1.133)(PORT=50238)) * establish * anadb * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
11-DEC-2014 10:47:11 * (CONNECT_DATA=(SID=anadb)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=pn400))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.21.1.133)(PORT=50239)) * establish * anadb * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
...
less /db/ora/product/11.2.0/db_1/network/admin/listener.ora
# listener.ora Network Configuration File: /db/ora/product/11.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = PN)(PORT = 1521))
#(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
ADR_BASE_LISTENER = /db/ora
/db/ora/diag/tnslsnr/PN/listener/alert/log.xml
<msg time='2014-12-11T10:47:11.802+03:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='PN'
host_addr='172.21.1.133'>
<txt>TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
</txt>
</msg>
<msg time='2014-12-11T10:47:11.808+03:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='PN'
host_addr='172.21.1.133'>
<txt>11-DEC-2014 10:47:11 * (CONNECT_DATA=(SID=anadb)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=pn400))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.21.1.133)(PORT=50237)) * establish * anadb * 12
505
</txt>
</msg>
<msg time='2014-12-11T10:47:11.808+03:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='PN'
host_addr='172.21.1.133'>
<txt>TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
</txt>
</msg>
<msg time='2014-12-11T10:47:11.809+03:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='PN'
host_addr='172.21.1.133'>
<txt>11-DEC-2014 10:47:11 * (CONNECT_DATA=(SID=anadb)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=pn400))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.21.1.133)(PORT=50238)) * establish * anadb * 12
505
</txt>
</msg>
As far as I see the script is trying to connect to the database but tnslsnr can't recognize the SID anadb
What cat I do to fix this problem?
