SQL/MySQL/ORACLE DBA Learning

Oracle VM virtualBox can I install on Ram 8 computer?

Yes

I want to insert data from table 2 to table 1 ,table 2 has extra data what will be the insert query ??

Extra data or extra columns??

Data

Merge statement is better

selam

Insert into table1 select column1,column2 from tabel2

Use where condition to control extra data

Hi all , i am having issue where applciation is on ununtu 22.04 and trying to connect to db which 2012 sql server version. There is a issue is popping when connecting to db side : fbinOpenConnectioni: Exception while opening connection Connection Timeout Expired. The timeout period elapsed during the post-login phase. The connection could have timed out while waiting for server to complete the login process and respond; Or it could have timed out while attempting to create multiple active connections. The duration spent while attempting to connect to this server was + (Pre-Login] initialization=9: handshake=4: [Login] initialization =0; authentication=0; [Post-Login] complete = 14000;

Hmm it’s the delay in connection.. Ping sql server from your application server.. might be you have not opened it for application server.. something is stopping application

They successfully pinged from the app server (source) server . There is nothing on sql server logs either

telnet the port from ubuntu server

I will ask them tomorrow.

you will ask others to do work.. so late night around 2:00 you were not working ?

if it is microsftSEL Server then its default will be TCP port 1433

I can telnet ubuntu machine ip adress with port 1433 on destination win os sql server 2008r2 right ?

no dear.. you need telnet Sql port from application server

Okay from the source (application server ) , i need to test telnet sqlserver instance name portnumber ?

👉👉👉We urgently require PLSQL local trainers for Hyderabad, Bangalore, Gurgaon and Experience more than 5 years

Why do search in telegram? Please get these requirements from dedicated job seekers portal

Please give me notes for Oracle it's advance levels

How to minimise the backup time of 200 gb data in mysql