Hello!
I have been messing around with Oracle and APEX in an OCI free tier for a while and decided to install the 23ai VM to setup an APEX app or two on a locally hosted service. I setup the VM a few weeks ago, and evidently changed the SYS password to something I don't recall. I do remember reading about issues with passwords and special characters, so I probably did something stupid and changed out special characters on an existing password.
I exported one of my APEX apps from OCI and imported it into the local 23ai setup. However, I noticed an error where I was showing BLOB >4k characters in length. I think I need to run:
begin
sys.validate_apex;
end;
/
I can't run that as my schema user, or system. I was attempting to reset the SYS password, so I connected like this (I can't copy/ paste from my window, so some of this is abbreviated):
$ echo $TWO_TASK
freepdb1
$ sqlplus / as sysdba
ORA-01017: invalid credential or not authorized
Enter user-name: system
Enter password:
Connected to: Oracle Database 23ai
SQL> alter user sys identified by password;
ORA-01031: insufficient privileges
What am I missing that would allow me to reset this password? Thanks!