Configure Oracle Analytics Server with ATP DB Service

AlexMO

Hi all,

I'm installing an Oracle Analytics Server Instance and I want to configure it using an ATP DB according to this documentation:

https://docs.oracle.com/en/middleware/bi/analytics-server/install-config-oas/configuring-product.html#GUID-E61F5ECE-CAA5-4635-A022-CC4BC9214F42

These are the steps I'm trying to perform:

1. Create RCU schemas in silent mode
2. Configure OAS using existing schema created in step 1

In the step 1 I ran the command line:

./rcu -silent -responseFile /home/opc/.rcu/rcuResponseFile.properties

but it failed with error message:

" IO Error: Undefined Error

ERROR - RCU-6090 Connection step validation failed.

CAUSE - RCU-6090 Skipping main operation: failed to connect to database because database details were missing or invalid.

ACTION - RCU-6090 Provide correct database details and try again. "

See in attached file the sample of my response file.

rcuResponseFile_Sample.txt

Uploaded Dec 27, 20234.49 KB

thanks for your help.

Alex

RanaAshutosh-Oracle

Please check below points :

=> User id, RCU is using, can log into the database (work with DBA to ensure user id is active and has active permissions - test by attempting to log onto the database using the user id and credentials assigned).

=> ensure the Host you are installing OAS on (the server you are running RCU as a step in\of the installation process) can access the target DB.

=> make sure the Listener is running and accepting requests to the correct database. Verify the listening port. Telnet from the install host server to the host running the database listener and port.

=> verify there are no Firewalls blocking access. During the install process RCU should directly access the database listener and not route through Load Balancers, proxies, or other filtering devices. 

RCU must be able to connect to and log onto the target database with adequate permissions to create the desired schema.

SteveF-Oracle

@AlexMO

In addition to the basics above...

For ATP, you need to use the TP Consumer Group for connections.

Administering Oracle Analytics Server

https://docs.oracle.com/en/middleware/bi/analytics-server/administer-oas/certification-rcu-databases.html#GUID-C9ED165F-C3F5-4477-B2CF-C9F246C47413

You can host the mid-tier schemas created by Repository Creation Utility (RCU) on a variety of database types.

You also should use a normal user, not 'Admin' (which you have in your response file).

You can review additional information here:

Creating Schemas for WebLogic Server on an ATP-S Database

AlexMO

Hi @RanaAshutosh-Oracle ,

=> I'm using ADMIN user in RCU. It's the one provides while provisioning the instance.

=> I've an sql developer installed in the host from where I'm running RCU. I can acces to the target DB throught SQL Developer.

=> Every thing is up and running on DB.

=> How can I check for firewalls?

Thanks

Gianni Ceresa

How can I check for firewalls?

You don't need to do it...

You said you have SQL Developer on the host where you are running the RCU comment (and I assume you aren't connected remotely somewhere else to run the RCU but it's really executed locally) and you can connect to your ATB database just fine.

Gianni Ceresa

As you have SQL Developer on the same host, is that a Windows OS? (I assume you are using a certified OS, right?)

What version of OAS are you installing?

Did you try with the graphical interface of the RCU just to work on your connection details? The RCU in silent mode can be a bit "picky" on how your provide the password for example.

AlexMO

@SteveF-Oracle,

I've been able to connect to the ATP instance and create RCU schemas using additional instructions given by this link: https://docs.oracle.com/en/middleware/fusion-middleware/12.2.1.4/rcuug/repository-creation-utility.html#GUID-22C3AC9D-2F27-49ED-B983-8F4FC94C5501 (Settings to connect to an Autonomous Transaction Processing Database)

@Gianni Ceresa, I'm using OL8, I'm Installing OAS 7. I've been able to run RCU in graphical mode despite several warnings about unsufficient rights. But this is expected behaviour according to some documentation.

Now I'm facing a nexw issue during the step 2 (Configure OAS using existing schema created in step 1).

I run the config.sh in silent mode and the configuration fails at the step:

[CONFIG] [Oracle_Analytics_Configuration] [Add default service instance]:2023-12-28T11:22:46.802+0000 Creating BI Service Instance

These are some output errors which draw my attention:

[CONFIG] [Oracle_Analytics_Configuration] [Add default service instance]:2023-12-28T11:30:08.781+0000 INFO: DSS web service is not available: Connection refused (Connection refused)

...

[CONFIG] [Oracle_Analytics_Configuration] [Add default service instance]:2023-12-28T11:30:08.783+0000 INFO: Could not find file /opt/opc/config/domains/bi/config/fmwconfig/biconfig/DSS/features.json

...

[CONFIG] [Oracle_Analytics_Configuration] [Add default service instance]:2023-12-28T11:30:08.843+0000 WARNING: Can not connect DB with URL jdbc:oracle:thin:@<my_service_name>?TNS_ADMIN=<My_Wallet_Directory_Path>

...

[CONFIG] [Oracle_Analytics_Configuration] [Add default service instance]:2023-12-28T11:30:08.925+0000 SEVERE: Error Reported in Metadata Plugin is: Internal error has occurred: Cannot create PoolableConnectionFactory (No more data to read from socket)

Any idea?