SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
DB_Alert

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
DB_Alert
Author Message
Ralph Bower



Joined: 07 Nov 2001
Posts: 2

Post DB_Alert Reply with quote

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?

Wed Nov 07, 2001 3:08 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7841

Post Re: DB_Alert Reply with quote

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?

Wed Nov 07, 2001 3:24 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.