• Home
• Partners
• Contact

1 (888) 569-7711

Toll-Free:

• Principalm
• Bridges
• Knowledge Base
• Customer Care

Welcome to our Knowledge Base. If you are unable to find a solution to your problem, please feel free to contact our support department using our toll free phone number (1-888-569-7711) or by email (support@discoverysoftware.com)

KB Categories

• Acorn Documentation
  • Bridges
    • ODBC Set-Up
  • Discovery's Acorn
• Compatibility
• Daily Use
• Features
• Installation
• Photos
• Principalm
  • Android
  • iOS (iPhone, iPad, iPod Touch)
• SIS Bridges
• Troubleshooting

ODBC Set-Up: Oracle

To set up an Oracle Server DSN:

1. Open the Windows Data Sources (ODBC) control panel:
   1. From the Start menu, choose Control Panel.
   2. On Windows 2000/XP/Vista, open the Administrative Tools folder.
   3. Double-click the Data Sources (ODBC) icon.
2. This will open the ODBC Data Source Administrator:

Create New Data Source


3. On the System DSN tab, click the Add… button.
   

Choose Driver


4. From the list of drivers that appears, choose Oracle ODBC Driver (this may be named Oracle in [Oracle Home Name] if you have multiple Oracle installations on your computer – in this case it is important to choose the installation that is used for your SIS).
5. If you cannot find a suitable Oracle Driver you may need to install one: Oracle Driver Install
6. Click Finish. The Oracle ODBC Driver Configuration will appear.

Oracle ODBC Drive Configuration


7. For Data Source Name, enter a name for the data source. Remember the name you choose, it is the same name you should enter in the ODBC DSN box in the Extractor. This can be almost anything, typically the name of your SIS will work.
8. Description This can be left blank, but is best used for reference so others will know what this ODBC is used for.
9. TNS Service Name This is the name of the listener for the Oracle server. This information is dependent on server set up and may have typical values based on the SIS you are using:

Generally in this format: [server address]:[port]/[Listener]

PowerSchool:
The [server address] is the ipaddress of your PowerSchool server.
The [port] should be: 1521.
The [Listener] is the name of the Oracle Listener: most likely PSProdDB

SASIxp:
The listener for SASIxp could be anything, the default listener is Listener, please contact your Oracle DBA for more information.

SchoolMAX:
Generally you will only need the service name for connecting to SchoolMAX. Consult your SchoolMAX documentation, or your Oracle DBA for more information.


10. UserID This is the user name used to log onto the Oracle server.
11. Enable Query Timeout: On the Application tab there is a setting with this label, we suggest unchecking this option when setting up if this ODBC DSN. If checked, long queries (ie section information) may cause the extraction to fail. You may see an error window with this text: [Ora]ORA-01013: user requested cancel of current operation
    
12. Once all of this information is entered click the Test Connection button, you will be prompted for the password for the account, click OK
13. If the entries are correct a Connection successful message will appear, your set is finished, click OK numerous times to exit the Administrator.
14. Once set up you are ready to move on to the next stage of Set Up
    

Troubleshooting:
If after examining the error codes below you still cannot find your issue, please email our support department with your issue, and then try this website: Oracle Error Codes. Please be aware that this site is external to the discovery website.

Solution:

1. Open the ODBC Data Source Administrator.
2. Select the appropriate DSN. Click Configure
3. Ensure that “Enable Query Timeout” is unchecked
4. Click OK.
5. Re-rerun the extraction, this error should not appear now.

This error occurs because the query for the requested information is taking a inordinate amount of time to return, so Oracle cancels the query.

Possible solutions:

• IP address of the TNS Listener may be incorrect
• Ensure local machine is connected to the network
• Ensure server machine is powered on and connected to the network

Possible solutions:

• IP address is correct (if any) but the Listener name is probably incorrect
• Ensure Listener is spelled correctly
• Ensure server machine has a listener set up

Possible solutions:

• Oracle administrator will need to ensure that the TNS Listener is running on the server
• This website has some good advice: http://www.dba-oracle.com/t_ora_12541_tns_no_listener.htm

Knowledge base search

Contact support

Toll Free

1 (888) 569-7711

Support hours

Monday-Friday

8:30AM - 3:00PM PST

Start a support request

By email

• Contact Discovery Software
• Privacy Policy