Good afternoon.
Over the weekend, our company upgraded their Oracle servers from 9i to 10g, and unfortunately, not everything in the process was smooth.
We're largely unable to connect via ODBC with the new configuration. We moved the servers physically, and the IP addresses, and server names changed.
The SID remained constant, but everything else has seen wild effects and repercussions take place.
For instance, on one of my Java servlets inserting data from a stored procedure, I now get:
java.sql.SQLException: ORA-00372: file 101 cannot be modified at this time
ORA-01110: data file 101: '/u30/oradata/SID/user_name.dbf'
ORA-06512: at "USER_NAME.FORM_INSERTION", line 87
ORA-06512: at line 1
obviously, I've replaces the actual username and SID with the generic "user_name" and SID.
But still, previously on 9i, I didn't get this. I updated my server.xml to reflect the thin client IP reference change.
Also, we can't connect at all to Access via ODBC. I don't think the driver changed, but I wouldn't swear by it. We got one girl's box working with the following:
SID.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.xx.xxx.xxx)(PORT = 1526))
)
(CONNECT_DATA =
(SERVICE_NAME = SID)
)
)
any ideas or solutions on this? I am wide open to suggestion!
One other note, I can no longer even log on to SQL Plus with my schema/credentials!
Thanks!!
Message was edited by:
user515689
Message was edited by:
user515689