969352 wrote:you can & do connect to a local DB without any listener only by using IPC.
Good Morning to all ;
MAY i know some details about TCP vs IPC connectivity (for DB LINK).
My Questions are ,
When we use TCP connectivity ? and
when we use ICP connectivity ?
IS this right ?
IPC connection does require listener ..
From this thread : https://forums.oracle.com/forums/thread.jspa?threadID=986797 +(final reply from i am al)+
969352 wrote:sqlplus scott/tiger@orcl
OK sb Thanks. I'm clear.
sorry for again asking similar question. I saw your reply (IPC not required for listener).
but i am doing DB link for (materialized view).
When i am connecting to any database using putty (LAN connection only).
Can i use TCP ?
I have OWN virtual machine ( two databases running)TCP is REQUIRED when two different hosts are involved.
Here , Can i use TCP ?
969352 wrote:The instance/DB does the username/password validation.
Anyhow , listener won't check username/password@<net_service_name> . then who will do that ?
ORA-01017 is an Application failure & NOT a database error
SQL> connect user1/user2 ERROR: ORA-01017: invalid username/password; logon denied Warning: You are no longer connected to ORACLE.
969352 wrote:are you unwilling or incapable to use online SEARCH &
Thanks a lot and fine sb.
The instance/DB does the username/password validation.
- Oh ! I don't know really this. May i get any related threads to understand ?
Oracle link n't giving any information about username/password verification
Can i get any related articles (instance/DB* does the username/password validation.) ?*
Thanks sb ..
969352 wrote:For example, when a user is authenticated by the database with a password, a session is established for this user. A session lasts from the time the user is authenticated by the database until the time the user disconnects or exits the database application."
Are you unwilling or incapable to use online SEARCH ?
No. Once again Thanks for kind help. I will read the link.
969352 wrote:have service_name different from tns_alias_name & use the one that works.
If TNS alias_name , net service name is different which one is used to connect DB ?
11g doc says : scott/tiger@net_service_name
10g doc says : scott/tiger@tns_alias_name
_ Please help me ..
I got " One of the most common connect identifiers is a net service name"
- when we use tns_alias_name to connect remote db ?