Saturday, May 28, 2022

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor



java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
 ^M
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:489) ~[ojdbc-6.jar:11.2.0.4.0]^M
        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:553) ~[ojdbc-6.jar:11.2.0.4.0]^M
        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:254) ~[ojdbc-6.jar:11.2.0.4.0]^M
        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32) ~[ojdbc-6.jar:11.2.0.4.0]^M
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528) ~[ojdbc-6.jar:11.2.0.4.0]^M
        at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:136) ~[HikariCP-3.2.0.jar:na]^M
        at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:369) ~[HikariCP-3.2.0.jar:na]^M
        at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:198) ~[HikariCP-3.2.0.jar:na]^M
        at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:467) [HikariCP-3.2.0.jar:na]^M
        at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:541) [HikariCP-3.2.0.jar:na]^M
        at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115) [HikariCP-3.2.0.jar:na]^M
        at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) [HikariCP-3.2.0.jar:na]^M
        at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:157) [spring-jdbc-5.1.8.RELEASE.jar:5.1.8.RELEASE]^M
        at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:115) [spring-jdbc-5.1.8.RELEASE.jar:5.1.8.RELEASE]^M
        at org.springframework.jdbc.datasource.DataSourceUtils.ge

Wednesday, August 18, 2021

Neo4j

:play start 

:server status

 create( n:person (name : "Kabir" ) ) return n 

match (n) - [r] -> (m) return n,r, m  LIMIT 1

match ( n:person ) return n 

call apoc.load.json('file:/Users/Public/neoq.json') yield value return value limit 10

Saturday, August 14, 2021

Elastic search

 Inverted index.  

Leaf query 

Compound query 

Inverted Database 

SQL vs DSL 

Table vs Index 

Document vs row 

Leaf query clause match_all 

Dev tools 

Term query 















Saturday, January 16, 2021

cannot find package "github.com/go-sql-driver/mysql"

Golang Error : cannot find package "github.com/go-sql-driver/mysql" in any of: /home/opc/work/go/src/github.com/go-sql-driver/mysql (from $GOROOT) /home/opc/golang/src/github.com/go-sql-driver/mysql (from $GOPATH) Solution : go get -u github.com/go-sql-driver/mysql

Friday, June 26, 2020

AWS Security Mcq

ec2-user@ec2 Permission denied