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!
No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.
Your password has been sent to:email@example.com
To follow this tag...
Thanks! We'll email you when relevant content is added and updated.
Share this item with your network: