When I try to login to the Oracle 9i database as sys, I am getting a TNS-12154 error.
Surprisingly, I can log in as SYSTEM and another DBA account.
The reason why I need to get in as SYS is to recompile the STANDARD package, as it has become invalid (?), ORA-6553 error and developers are not able to connect thru their apps.
Can I reset the sys account password (every time i try that, it gives me the ORA-06553 error) or get in as sysdba or sysoper in some other way?