loopback sqlplus

What does loopback sqlplus means. How do we use loopback sqlplus and when does we use loopback sqlplus. I really appreciate your help. Thanks in advance
hussainkhan22Asked:
Who is Participating?
 
sdstuberConnect With a Mentor Commented:
yourdb =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = yourdb)
    )
  )
0
 
sdstuberCommented:
I think you misread something.

you can create loopback ip addresses,  you can have a loopback adapter for dhcp in windows,  you can create a loop back db link.   but there is no "loopback sqlplus"

0
 
slightwv (䄆 Netminder) Commented:
Just to add to what sdstuber said: The loopback ip address is 127.0.0.1.  You can configure your tnsnames.ora file to use this.

http://en.wikipedia.org/wiki/Loopback
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
hussainkhan22Author Commented:
This is exactly what is told by my team lead " I tried a loopback sqlplus and that worked. "  so now I would like to know what does this mean
0
 
awking00Commented:
Are you possibly referring to flashback?
0
 
slightwv (䄆 Netminder) Commented:
They probably meant they connected through sql*plus using the 127.0.0.1 ip address and it worked.

You will need to ask them what they meant.  We weren't there for the conversation or the context of the conversation.
0
 
sdstuberCommented:
Since your team lead used the phrase, I suggest you ask him/her.
0
 
hussainkhan22Author Commented:
So how do we connect sqlplus using 127.0.0.1 and lastly how can we configure tnsnames file to use loop back adapter
0
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
on the database server add a tnsnames entry for the database and use:  HOST=127.0.0.1

then sqlplus user/password@NEW_ALIAS
0
 
anumosesCommented:
are you speaking about loopback db link? If so loopback -A dblink that connects back to the SAME database.
It is useful for testing
It is useful for connecting as another user in your current session (eg: the loopback link can
connect as scott/tiger while you are logged in as hussain...
0
 
sdstuberCommented:

hussainkhan22 - a little followup.  

You ask a lot of questions based on not understanding what your team lead has said or not knowing how to do the tasks.  You really should discuss this with your lead.

If it turns out you're not qualified for your current position, that's fine.  Move to something else that's better suited but it's a disservice to your employer (and likely to get your position terminated) if you're hiding the fact.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.