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?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!