ORA-12514 and Net configuration assistant
Posted on 2007-03-29
I am using Oracle 10g on Windows server 2003. I installed the 10g client on a different pc on the network and used the Net Configuration Assistant/Local Net Service Name Configuration tool to configuration the netservice names. Each time I configured a name it would blow up because it is trying to use the system account and the password is wrong. If I change the login to sysman with the correct password it succeeds. I then try to schedule a job to run and get a ORA-12514 error. if I check the net configuration assistant the login is changed back to system.
Another weird piece of the puzzle is if I try to log on to a database through Enterprise Manager from the remote server as sysdba it says Insufficient privileges. If I log on as normal it works. If I go to database server and log on with the same credentials I can connect as sysdba....PLEASE HELP! I cannot for the life of me figure out what is going on. Its like the remote server is trying to resolve my credentials locally.