ORA-12514: TNS:listener does not currently know of service

issue:
database is tnspingable, but sqlplus will give below error when login:

ORA-12514: TNS:listener does not currently know of service

cause:

database service is not registered to the listener.

solution:

add service to listener and restart it.

listener entry:

in sid_list_listener:

add

(SID_DESC =

(GLOBAL_DBNAME=myfubardb)

(ORACLE_HOME = /ora00/app/oracle/product/10.2.0/db_1)

(SID_NAME = fubar)

)

 

 

reference:

http://edstevensdba.wordpress.com/2011/03/19/ora-12514/