Database

Get Involved. Join the Conversation.

Posts

  • Subrahmanyam Vempati
    BareMetal DB provisioning in OCI3
    Topic posted December 11, 2019 by Subrahmanyam VempatiBronze Trophy: 5,000+ Points, tagged Apex, DBaaS, DBCS 
    Title:
    BareMetal DB provisioning in OCI
    Summary:
    No Shape available for mumbai region for BareMetal DB provisioning in OCI
    Content:

    Hi Team,

    Can anyone please suggest , why there are no shapes available to create BareMetal DB in OCI. I am getting the below message and not able to create the DB system in trail account

    Message: 0 Available Core Count, Node Count

    Thanks,

    Vempati

  • Ted Nanayakkara
    Data Guard configuration with OCI Database with RAC clusters1
    Topic posted November 27, 2019 by Ted Nanayakkara, tagged DBaaS, DBCS, HA, Provisioning, Recovery 
    Title:
    Data Guard configuration with OCI Database with RAC clusters
    Summary:
    Data Guard switchover hung; now having trouble terminating my test database instances
    Content:

    I configured a two node RAC cluster database on OCI using cloud dashboards. 

    I setup a Data Guard configuration for the RAC database using cloud dashboard interface. It setup a standby RAC cluster database on another AD through cloud automation, I tested RAC and Active Data Guard using SQL interactions with read-only on standby nodes. Very impressive. 

    First switchover worked, Second switch over hung. Cloud dashboards seemed to be out of sync with the underlying databases.

    I wanted to terminate these instances and continue testing by recreating same setup. 

    I terminated standby OCI Database instance first. It terminate cleanly.

    The primary database still shows a Data Guard configuration. It won't let me terminate primary Database instance.

    How do I clean this up?

    Cloud dashboard says: 

    You can't terminate the DB System because it includes Data Guard enabled databases. To remove the Data Guard associations, terminate the standby databases.

    But I terminated the standby. It no loger appears on cloud dashboard.

    Is there a way to cleanly undo Data guard association and terminate the primary database instance?

    My OCIDs are:

    ocid1.dgassociation.oc1.iad.abuwcljtupfxwy6o7ljqu6pggvsg2sf3mvkzsyjs2grwe5qki3gkepsc4l6q

    ocid1.dgassociation.oc1.iad.abuwcljtupfxwy6o7ljqu6pggvsg2sf3mvkzsyjs2grwe5qki3gkepsc4l6q

    This is a cloud trial with test database instances. Nothing need to be saved in this account.

    Please advice. Thanks!

     

     

    Version:
    19.4.0.0.190716
    Code Snippet:
  • Karthik Varma
    [Compatibility] Do ojdbc8.jar supports connectivity to...Answered35.0
    Topic posted November 14, 2019 by Karthik VarmaGold Medal: 3,500+ Points, tagged Monitoring, Tip 
    Title:
    [Compatibility] Do ojdbc8.jar supports connectivity to Oracle 12c, 11g & 10g databases?
    Content:

    Using ojdbc8.jar we connect to autonomous databases. Will it provides backward compatibility to older versions?

  • Karthik Varma
    Few Database metrics are not populating the values15.0
    Topic posted October 30, 2019 by Karthik VarmaGold Medal: 3,500+ Points, tagged Monitoring, Performance, REST API 
    Title:
    Few Database metrics are not populating the values
    Content:

    https://docs.cloud.oracle.com/iaas/Content/Database/References/databasemetrics.htm#metrics-keys

    I have tried connecting to Autonomous database with wrong credentials but FailedLogons FailedConnections metrics values are not reflected. (Other metrics like Sessions, CurrentLogons are polulating the values).

    Note: I am using SummarizeMetricsData API to fetch/collect the metric values.

  • Karthik Varma
    Unable to connect to Autonomous data warehouse database...Answered25.0
    Topic posted October 17, 2019 by Karthik VarmaGold Medal: 3,500+ Points, tagged Monitoring, Performance, SQL Dev Web 
    Title:
    Unable to connect to Autonomous data warehouse database where I am able to connect to Autonomous transaction processing database
    Content:

    I think this is weird. I am trying to connect to Autonomous databases from java application and also using SQL developer.

    ATP database

    final static String DB_URL = "jdbc:oracle:thin:@dbtransprocess_high?TNS_ADMIN=C://Users//karthik//Wallet_DBTransProcess";
    final static String DB_USER = "ADMIN;
    final static String DB_PASSWORD = "123456789";
    ADW database
     final static String DB_URL="jdbc:oracle:thin:@databaseapm_high?TNS_ADMIN=C://Users//karthik//Wallet_DatabaseAPM";
      final static String DB_USER = "ADMIN";
      final static String DB_PASSWORD = "abcdefgh";
    Rest of the code is same.
     
    Able to connect to ATP database but not to ADW database.
     
    Error Stacktrace:
    Exception in thread "main" java.sql.SQLRecoverableException: IO Error: Undefined Error
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:854)
    at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:793)
    at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:57)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:747)
    at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:406)
    at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:291)
    at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:206)
    at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:184)
    at com.zoho.listeners.DataSourceSample.main(DataSourceSample.java:72)
    Caused by: oracle.net.ns.NetException: Undefined Error
    at oracle.net.ns.NSProtocolNIO.negotiateConnection(NSProtocolNIO.java:284)
     
    Any inputs?
    Image:
  • Rashmi Rao
    Not able to Upload files using Page in oracle apex...1
    Topic posted October 17, 2019 by Rashmi RaoBronze Trophy: 5,000+ Points, tagged Apex, DBCS 
    Title:
    Not able to Upload files using Page in oracle apex application
    Summary:
    Not able to Upload files using Page in oracle apex application
    Content:

    Hi,

    We are trying to upload files using page which has file browser and submit.
    We are reffering the below source to achieve this.

    Url: https://docs.oracle.com/cd/E14373_01/appdev.32/e13363/up_dn_files.htm#CJAFCIEH

    We have run the application in the debug mode.
    We didn't get any errors in performance check result.

    In reference source ,region type mentioned like HTML.

    For Region:

    Identify the type of region to add to this page - Accept the default, HTML, and click Next.

    Select the type of HTML region container you wish to create - Accept the default, HTML, and click Next.

    But In region type LOV we don't have that exact HTML type. We have HTML 5 Bar chart plug-In. How to get exact HTML type region?

    Please help us in upload file in table using Application page. 


    Regards
    Lokesh Ampanna
     

  • Karthik Varma
    Not able to connect to Autonomous database using Oracle SQL...45.0
    Topic posted October 16, 2019 by Karthik VarmaGold Medal: 3,500+ Points, tagged Monitoring, Performance 
    Title:
    Not able to connect to Autonomous database using Oracle SQL developer
    Content:

    I am getting the below error:

    IO Error: The Network Adapter could not establish the connection

    Any inputs? 

    Image:
  • Karthik Varma
    How to connect to Autonomous Database from Java Application?15.0
    Topic posted October 15, 2019 by Karthik VarmaGold Medal: 3,500+ Points, tagged Doc, Monitoring, SQL Dev Web 
    Title:
    How to connect to Autonomous Database from Java Application?
    Content:

    I have referred this article https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/connect-preparing.html#GUID-3667EC68-930E-4566-95B3-DFA24203A8FF.

    Referred Sample from github: https://github.com/oracle/oracle-db-examples/blob/master/java/jdbc/ConnectionSamples/DataSourceSample.java

    Set the environmental variable TS_ADMIN to ''E:\Oracle Cloud Learnings\Oracle ATP credentials" (This is the directory where my wallet files are located)

    JDK version : 1.8.0_202

    Code:

      final static String DB_URL="jdbc:oracle:thin:@dbtransprocess_tpurgent?TNS_ADMIN=E://Oracle Cloud Learnings//Oracle ATP credentials";
      final static String DB_USER = "XYZ";
      final static String DB_PASSWORD = "abcd";

    Error:

    Exception in thread "main" java.sql.SQLRecoverableException: IO Error: could not resolve the connect identifier  "dbtransprocess_tpurgent"

    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:854)
    at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:793)
    at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:57)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:747)
    at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:406)
    at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:291)
    at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:206)
    at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:184)
    at com.zoho.listeners.DataSourceSample.main(DataSourceSample.java:68)
    I am getting the above error. Any suggestions or anything i missed out? Appreciate your help.
     
    Please let me know, if there is any other way connecting to Autonomous database.
    Image:
  • Karthik Varma
    What is the difference between dataStorageSizeInTBs and...15.0
    Topic posted October 14, 2019 by Karthik VarmaGold Medal: 3,500+ Points, tagged Monitoring, REST API, Storage 
    Title:
    What is the difference between dataStorageSizeInTBs and usedDataStorageSizeInTBs ?
    Content:

    As per the doc, definitions are as below:

    dataStorageSizeInTBs - The quantity of data in the database, in terabytes.

    usedDataStorageSizeInTBs - The amount of storage that has been used, in terabytes.

    Is dataStorageSizeInTBs equals to total size?

  • Karthik Varma
    Which statements will be under monitored SQL tab [Autonomous...Answered15.0
    Topic posted October 10, 2019 by Karthik VarmaGold Medal: 3,500+ Points, tagged Apex 
    Title:
    Which statements will be under monitored SQL tab [Autonomous Database::Service console] ?
    Content:

    I have created few tables using Oracle Apex. Will these queries/statements listed here in monitored SQL tab?

     

    Image: