Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 75 Insurance
- 537.7K On-Premises Infrastructure
- 138.7K Analytics Software
- 38.6K Application Development Software
- 6.1K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.3K Infrastructure Software
- 105.4K Integration
- 41.6K Security Software
Wrong database name is displayed in SQL worksheet on OCI console

I created an Autonomous transaction database in the cloud free tier account yesterday. I used "Database Actions" to connect to this database ocilabsdb1. But when I query the database "select * from v$database" with the "admin" user in the SQL worksheet icon, I geta different database name "fefypod" created in 2020.
Could you please help?
Kind regards
Chak Jagannathan
Answers
-
Hi,
TNSNAMES, I thought it would be easier to understand if you could upload the connection command and the query to V$.
Regards,
-
Hi
Thanks for the reply. I am using downloaded wallet folder and using it to connect to DB login details screen in SQL worksheet.
-
Hello,
I am also using SQL*Developer and still getting the same output. Please find attached my screenshots. I am not using any tnsnames.ora.
Thanks
Chak
-
Apologies. I am using tnsnames.ora from the credentials wallet file. I have not unzipped the "Wallet_OCILABSDB1_1.zip" file in the "C:\Users\chak_\Downloads" folder. The entries are as follows:
ocilabsdb1_high = (description= (retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=adb.us-ashburn-1.oraclecloud.com))(connect_data=(service_name=g93d08a6f4b6744_ocilabsdb1_high.adb.oraclecloud.com))(security=(ssl_server_cert_dn="CN=adwc.uscom-east-1.oraclecloud.com, OU=Oracle BMCS US, O=Oracle Corporation, L=Redwood City, ST=California, C=US")))
ocilabsdb1_low = (description= (retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=adb.us-ashburn-1.oraclecloud.com))(connect_data=(service_name=g93d08a6f4b6744_ocilabsdb1_low.adb.oraclecloud.com))(security=(ssl_server_cert_dn="CN=adwc.uscom-east-1.oraclecloud.com, OU=Oracle BMCS US, O=Oracle Corporation, L=Redwood City, ST=California, C=US")))
ocilabsdb1_medium = (description= (retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=adb.us-ashburn-1.oraclecloud.com))(connect_data=(service_name=g93d08a6f4b6744_ocilabsdb1_medium.adb.oraclecloud.com))(security=(ssl_server_cert_dn="CN=adwc.uscom-east-1.oraclecloud.com, OU=Oracle BMCS US, O=Oracle Corporation, L=Redwood City, ST=California, C=US")))
ocilabsdb1_tp = (description= (retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=adb.us-ashburn-1.oraclecloud.com))(connect_data=(service_name=g93d08a6f4b6744_ocilabsdb1_tp.adb.oraclecloud.com))(security=(ssl_server_cert_dn="CN=adwc.uscom-east-1.oraclecloud.com, OU=Oracle BMCS US, O=Oracle Corporation, L=Redwood City, ST=California, C=US")))
ocilabsdb1_tpurgent = (description= (retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=adb.us-ashburn-1.oraclecloud.com))(connect_data=(service_name=g93d08a6f4b6744_ocilabsdb1_tpurgent.adb.oraclecloud.com))(security=(ssl_server_cert_dn="CN=adwc.uscom-east-1.oraclecloud.com, OU=Oracle BMCS US, O=Oracle Corporation, L=Redwood City, ST=California, C=US")))