- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Database Connection Error in ProC Program
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-14-2010 09:10 AM
тАО10-14-2010 09:10 AM
Database Connection Error in ProC Program
EXEC SQL CONNECT :user_id IDENTIFIED BY :password USING :server_name ;
Here is the error with logging messages:
19938-12:59:28.428-log DRM Server : Started
19938-12:59:28.429-log Database Username: drm_mich2
19938-12:59:28.429-log Database Password: drm_mich2
19938-12:59:28.429-log Database Server: db_mich2
19938-12:59:28.429-log Before call to TableCache in main
19938-12:59:28.429-log Before ConnectToDatabase_i call in TableCache
19938-12:59:28.429-log Entering ConnectToDatabase_i
19938-12:59:28.429-log user_id = 'drm_mich2'
19938-12:59:28.430-log password = 'drm_mich2'
19938-12:59:28.430-log server_name = 'db_mich2'
19938-12:59:28.953-log Unable to connect to SYBASE database (code = -12154; erro
r = Error while trying to retrieve text for error ORA-12154
)
19938-12:59:28.953-log User = drm_mich2, PWD = drm_mich2, SVR = db_mich2
19938-12:59:28.953-log After ConnectToDatabase_i call in TableCache
19938-12:59:28.954-log Unable to connect to database, shutdown the DRM server
19938-12:59:28.954-log Unable to connect to database, shutdown the DRM server.
Why am I getting this database connection error and how do I resolve it?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-14-2010 07:50 PM
тАО10-14-2010 07:50 PM
Re: Database Connection Error in ProC Program
ORA-12154
should find many things.
> [...] Error while trying to retrieve text
> for error ORA-12154 [...]
That sounds to me as if the Oracle stuff
wasn't installed (or configured, or used)
properly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-14-2010 09:24 PM
тАО10-14-2010 09:24 PM
Re: Database Connection Error in ProC Program
"Unable to connect to SYBASE "
"error ORA-12154"
Sybase, Oracle or sloppy programmer.
You wrote "When running a different one of our programs with the same username, password, and database server in the same environment,"
Exactly how much the same is that environment?
Exact same login on same box... one command works the other not? Or different login / shell perhaps?
as per my reply to your other topic... KISS.
Step away from the program as a variable factor.
Just try 'sqlplus' or tnsping.
Does that work?
If not, fix that!
If yes, check the Oracle Listener.log file server side.
As Steven remarks .... "Error while trying to retrieve text for error ORA-12154" that suggest that the oracle environment is not properly setup, notably NLS stuff
# env | grep NLS
# env | grep ORA
Compare broken environment with functional one.
Now if it is truly one and the same environment as suggested....
Hope this helps some,
Hein
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-15-2010 01:17 AM
тАО10-15-2010 01:17 AM
Re: Database Connection Error in ProC Program
if you try :
sqlplus drm_mich2/drm_mich2@drm_mich2
do you connect to the remote database ?
if not, check listener up and from the client :
tnsping drm_mich2
any positive ?
Regards
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-15-2010 05:13 AM
тАО10-15-2010 05:13 AM
Re: Database Connection Error in ProC Program
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-18-2010 04:22 AM
тАО10-18-2010 04:22 AM