Establising a connection to sql
By Lori Peters
September 29, 2011

I am having a problem with establishing a connection between Oracle and powerschool.  Can anyone help me? 
I can open up data on the PowerSchool side but when I open Oracle sql Developer to establish a connection and enter the username (psnavigator) and password, I get the following message:
Listener refused connection with the following error:  ORA-12505 TNS:listner does not currently know of SID given in connect descriptor. 
I have tried going into system - security and changing the password in PowerSchool, but it still doesn't work.  I was able to establish a connection this summer so I am wondering if the upgrade to 7.0 changed something.
I have a teacher that is requesting data that I can only get out by running a sql so any help would be appreciated.
Thanks in advance!
Lori Peters
Logan View