Steps for connecting to a RAC Database using SCAN Name | Oracle rac scan listener| scan vip

[@rajatsanwal9919]

Sir, Created two node cluster on Oracle Virtual box environment. Installed Oracle client on the host machine. But not all able to do tnsping via scan name. Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = racdb))) TNS-12545: Connect failed because target host or object does not exist

[@monday6740]

Good example, ... but speed can be a bit higher. Audio can be improved as well, especially the person asking questions.

[@miteshkokare8381]

Hello Wysheid, How oracle login works in background?

[@wysheid2009]

Hi Mitesh, if you are asking about the connection sequences then its is this way Scan_name--> node vip--> node_listener--> database instance Let me know if you could not understand your question well

[@miteshkokare8381]

Thank you Wyshied actually my question was how oracle login/connection works?...what happens in background when we enter username and password while doing login and hit enter?..in terms of SGA and PGA. What happens in oracle to create an instance?

[@oraclemanconsulting]

So much time is taken to watch the typing and typos, it would flow a lot better if all typing was calls to scripts, showing the commands, SQL, and all, correctly, also with SQL*Plus "col" commands to better format the output for us

[@ziadfawzi]

Thank you so much.

[@malinisethi6591]

Please speak cleary your voice is not clear.