Progress
DataServer
for ORACLE Guide
Connection Troubleshooting
Some reasons that a connection attempt to an ORACLE database might fail are:
- The Progress schema holder is not connected.
- The ORACLE process is not running, or not running correctly. Try to connect with SQL*PLUS to check the status of the ORACLE RDBMS.
- The value of the ORACLE_SID environment variable that started up the ORACLE process is different from the current value of ORACLE_SID.
- The user ID and password combination you provided during connection is invalid for the ORACLE database. If you have three unsuccessful connection attempts in a row, ORACLE does not allow any more connection attempts during the remainder of the Progress session. If this happens, quit your Progress session and restart it to make another connection attempt.
- For a remote DataServer connection failure, you didn’t include the correct name of the host and server in the network. Be sure to enter the same server name you used when you started the broker.
- Error messages about mismatched code pages are caused when -cpinternal and -cpstream do not match the code page that the ORACLE database uses.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |