Hello everyone,
I have installed oracle 12c and when i try to create user i am getting error as below
ORA-65096: invalid common user or role name
Forums says
alter session set "_oracle_script"=true;
it works fine now.
Problem for me is when i try to run shell script it is not accepting above session value.
shell script contains multiple sql where it will drop users and create user and create role. i set up alter session set "_oracle_script"=true; inside the sql script. but i am facing this issue again and again.
I want to make permanetly this value into my DB. Kindly help. I have even changed the parameter value
oracle_script"=true in PFILE. still again and again i am getting the error
ORA-65096: invalid common user or role name
KIndly help to solve this issue
Thanks