unable to connect pb 12.5 to oracle 11gR2
I am trying to use powerbuilder 12.5 and oracle 11g release 2 for learning purposes but am unable to connect to oracle. Am getting the ORA-12524 error whenever I try to connect the db profile for oracle I have created on powerbuilder. Am certain the db is up and running because I am able to create the old-school odbc on win& via the control panel-administrative tools option.
my db is called orcl,my instance name/sid is still called orcl and I have a servive name called orcl which is linked to a listener which is up and running. From cmd I am able to do "sqlplus hr/hr@Joseph-HP/orcl" and successfully login. What might be causing that error? But am able to connect powerbuilder to my local mysql fine without any problem