Categories
Database Development

How to solve Vendor Code 17002 when connecting to a remote Oracle database?

I have an Oracle database 12c standard edition release 12.2.0.1.0 running on a Linux instance of AWS ec2. When I try to connect to it remotely from my machine (macOS) using SQL Developer I get an IO Error: The Network Adapter could not establish the connection Vendor Code 17002 error. connecting using sqlplus from my […]

Categories
Database Development

How to solve Vendor Code 17002 when connecting to a remote Oracle database?

I have an Oracle database 12c standard edition release 12.2.0.1.0 running on a Linux instance of AWS ec2. When I try to connect to it remotely from my machine (macOS) using SQL Developer I get an IO Error: The Network Adapter could not establish the connection Vendor Code 17002 error. connecting using sqlplus from my […]

Categories
Database Development

How to solve Vendor Code 17002 when connecting to a remote Oracle database?

I have an Oracle database 12c standard edition release 12.2.0.1.0 running on a Linux instance of AWS ec2. When I try to connect to it remotely from my machine (macOS) using SQL Developer I get an IO Error: The Network Adapter could not establish the connection Vendor Code 17002 error. connecting using sqlplus from my […]

Categories
Database Development

Vendor Code 17002 when connecting to a remote Oracle database

I have an Oracle database 12c standard edition release 12.2.0.1.0 running on a Linux instance of AWS ec2. When I try to connect to it remotely from my machine (macOS) using SQL Developer I get a Vendor Code 17002 error: connecting using sqlplus from my machine: sqlplus cd2/ @ec2-publicIp.myCloud.compute.amazonaws.com:1522/orcl SQL*Plus: Release 19.0.0.0.0 – Production on […]

Categories
Database Development

Vendor Code 17002 when connecting to a remote Oracle database

I have an Oracle database 12c standard edition release 12.2.0.1.0 running on a Linux instance of AWS ec2. When I try to connect to it remotely from my machine (macOS) using SQL Developer I get a Vendor Code 17002 error: connecting using sqlplus from my machine: sqlplus cd2/EUnDDf6d@ec2-18-252-39-240.us-gov-east-1.compute.amazonaws.com:1522/orcl SQL*Plus: Release 19.0.0.0.0 – Production on Mon […]

Categories
Mastering Development

How to filter date ranges with filter string (SQL Server)

I am trying to filter date ranges based on an input string in SQL Server. — ‘All Years’, ’30’, ’60’, ’90’, ‘2019’, ‘2020’, etc. declare @dateRange nvarchar(20) = ’90’ select [date], [data] from someTable where ( @dateRange = case @dateRange when 30 then date >= getDate() – 30 when 60 then date >= getDate() – […]

Categories
Mastering Development

Adjust Google Column Chart Data in small chunks

I have plotted google charts as belowenter image description here is there any way by which I can show 5-year charts at a one time and adjust the remaining chart in a slider. <html> <head> <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script> <script type="text/javascript"> google.charts.load(‘current’, {‘packages’:[‘bar’]}); google.charts.setOnLoadCallback(drawChart); function drawChart() { var data = google.visualization.arrayToDataTable([ [‘Year’, ‘Sales’, ‘Expenses’, ‘Profit’], [‘2001’, […]

Categories
Mastering Development Software

Problems in dynamically defining “accessors” and data in the React Table

I have a React Table which contains columns of all months of the year + columns containing the current year and four years back. const [tableYears, setTableYears] = React.useState(() => { const year = [] for (var i = 0; i < 5; i++) { year.push(currentYear – i) } return year.map((y) => ({ Header: y.toString(), […]

Categories
Database Development

ORACLE DB Connects only when I do not specify SID

I have an Oracle 19c database in a Unix server. SQLPLUS command connects only when I do not specify the SID. sqlplus system/manager SQL*Plus: Release 19.0.0.0.0 – Production on Mon Jul 20 12:37:30 2020 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Last Successful login time: Mon Jul 20 2020 11:45:41 +05:30 Connected […]

Categories
Linux Mastering Development

Merging two CSV files using AWK

I am currently working on merging two big CVE lists using AWK. If the 1st column in file1.csv matches the 4th column in file2.csv I want to overwrite the 9th column in file2.csv with the 2nd column in file1.csv. If there is not match it should just continue. Snippet from file1.csv: CVE-2007-1234,5.0 CVE-2018-12219,4.5 Snippet from […]