Hello, I have followed all the steps in this blog:
https://oracle-livelabs.github.io/adb/shared/adb-speaks-human/workshops/tenancy/index.html?lab=introduction
When I run the last part, appears an error.
My env:
Autonomous AI Database
Workload type: Lakehouse
Database name: MovieStreamWorkshop
Database version: 26ai
Instance type: Always free
Apex Instance: MovieStreamWorkshop
Network:
Mutual TLS (mTLS) authentication: Required
Access type: Allow secure access from everywhere
Access control list: Disabled
# as ADMIN user.
grant execute on DBMS_CLOUD to MOVIESTREAM;
grant execute on DBMS_CLOUD_AI to MOVIESTREAM;
BEGIN
DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
host => 'api.cohere.ai',
ace => xs$ace_type(privilege_list => xs$name_list('http'),
principal_name => 'MOVIESTREAM',
principal_type => xs_acl.ptype_db)
);
END;
EXEC DBMS_CLOUD.CREATE_CREDENTIAL(
CREDENTIAL_NAME => 'openai_credential',
username => 'cohere',
password => 'padYzMdRdR8pKiJcvFnhomsQNY3bkXWFlxyAYnNy');
BEGIN
dbms_cloud_ai.create_profile(
profile_name => 'GENAI',
attributes =>
'{"provider": "cohere",
"credential_name": "openai_credential",
"comments":"true",
"object_list": [
{"owner": "MOVIESTREAM", "name": "GENRE"},
{"owner": "MOVIESTREAM", "name": "CUSTOMER"},
{"owner": "MOVIESTREAM", "name": "PIZZA_SHOP"},
{"owner": "MOVIESTREAM", "name": "STREAMS"},
{"owner": "MOVIESTREAM", "name": "MOVIES"},
{"owner": "MOVIESTREAM", "name": "ACTORS"}
]
}'
);
END;
# as MOVIESTREAM user.
EXEC DBMS_CLOUD_AI.SET_PROFILE('GENAI');
SELECT DBMS_CLOUD_AI.GENERATE(
prompt => 'what is oracle autonomous ai database',
profile_name => 'GENAI',
action => 'chat')
FROM dual;
ERROR:
ORA-20000: ORA-24247: Network access denied by access control list (ACL)
ORA-06512: en "C##CLOUD$SERVICE.DBMS_CLOUD$PDBCS_251109_0", línea 2251
ORA-06512: en "C##CLOUD$SERVICE.DBMS_CLOUD_AI", línea 18346
ORA-06512: en línea 1
https://docs.oracle.com/error-help/db/ora-20000/
20000. 00000 - "%s"
*Cause: The stored procedure 'raise_application_error'
was called which causes this error to be generated.
*Action: Correct the problem as described in the error message or contact
the application administrator or DBA for more information.
Error at Line: 1 Column: 6
Has anyone already resolved this issue?
Thank you!