Hello Community,
I'm just starting with the new Oracle 26AI database server.
I have set up a podman-based instance on my Windows machine using the official enterprise edition.
My objective is to configure and activate the new SELECT AI feature. To do so, I followed the official online guides, but I'm currently stuck with an unpredictable error while creating the profile to interact with the LLM (I'm using Google Gemini).
This is a short description of the executed steps:
- Start the container and install the DBMS_CLOUD & DBMS_CLOUD_AI packages using this command : $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl \ -u sys/<your_sys_password> \ --force_pdb_mode 'READ WRITE' \ -b dbms_cloud_install \ -d $ORACLE_HOME/rdbms/admin \ -l /tmp \ dbms_cloud_install.sql.
- Grant to required Permissions for the database user called “BANK”. (GRANT EXECUTE ON DBMS_CLOUD_AI TO BANK; GRANT EXECUTE ON DBMS_CLOUD TO BANK)
- Configure the ACL using “DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE”. (using the SYS user)
- Create the CREDENTIAL object using the GOOGLE API KEY. (using the PDB user “BANK”)
- Create the AI PROFILE using the configured credentials. (using the PDB user “BANK”)
As I previously mentioned, an error is still being thrown at the profile creation step, saying :
ERROR à la ligne 1:
ORA-20000: ORA-01435: user not found
ORA-06512: à "SYS.DBMS_CLOUD", ligne 2257
ORA-06512: à "SYS.DBMS_CLOUD_AI", ligne 17572
I'm still wondering about the possible causes, since I followed the official guide's instructions:
https://blogs.oracle.com/machinelearning/introducing-natural-language-to-sql-generation-on-autonomous-database
Can anyone help me resolve this issue ?