ORA-12514 means that the name you specified for the database service 9the Server field) cannot be found in your TNSNAMES.ORA file. The solution: please specify the correct name : I'm trying to set up DB_Alert on a development database to send alerts when : tablespaces fill. I'm using an Oracle 8.1.6 Windows NT database. I can't : connect to my database when I try to set up the space monitor section. The : error reads: Connection to PROD failed. ORA-12514: TNS:Listener could not : resolve SERVICE_NAME given at connect discriptor. Unable to access : DB_ALERT tables in the database. Press OK to continue. I can use SQL/PLUS : to connect with the sys user, but when I set it up in the DB_ALERT it : won't connect. Any ideas would be appreciated?
|