oci-database

import { DatabaseClient, requests } from 'oci-database'; import { auth, common } from 'oci-common'; async function listOciDatabases() { try { // Load authentication details from the default OCI config file (~/.oci/config) // Ensure your OCI config file is set up with a profile (e.g., 'DEFAULT') and API key. const provider = new auth.ConfigFileAuthenticationDetailsProvider(); // The region is typically read from the config file, but can be overridden // For example, common.Region.US_PHOENIX_1 const client = new DatabaseClient({ authenticationDetailsProvider: provider }); // Specify the compartment to list databases from. // Replace 'YOUR_COMPARTMENT_OCID' with an actual Compartment OCID. const compartmentId = process.env.OCI_COMPARTMENT_OCID ?? 'YOUR_COMPARTMENT_OCID'; if (compartmentId === 'YOUR_COMPARTMENT_OCID') { console.warn('WARNING: Please set OCI_COMPARTMENT_OCID environment variable or replace placeholder.'); } const listRequest: requests.ListDatabasesRequest = { compartmentId: compartmentId, // You can add filters like lifecycleState, dbHomeId, etc. // lifecycleState: requests.ListDatabasesRequest.LifecycleState.Available }; console.log(`Listing databases in compartment: ${compartmentId}...`); const response = await client.listDatabases(listRequest); if (response.items && response.items.length > 0) { console.log(`Found ${response.items.length} databases:`) response.items.forEach(db => { console.log(`- ${db.dbName} (OCID: ${db.id}, State: ${db.lifecycleState})`); }); } else { console.log('No databases found in the specified compartment.'); } } catch (error) { console.error('Error listing databases:', error); if (error instanceof common.ServiceError) { console.error(`Service Error Details: Status=${error.statusCode}, Code=${error.serviceCode}, Message=${error.message}`); } } } listOciDatabases();