Bank name on Oracle 8i

[tostesr1]

Hello everyone,

I'm new here in the forum. And soon dude, I already have an issue that certainly can help me!

I am using Oracle 8i Personal Edition at home, being that, I opted for the default installation of the same (porque not bag muito bank installation).

My question is the following how do I find out the name of the bank or your host string in a default installation?

In my case when I connect to SQL * Plus, just enter with user, password, and the host string.

I need to know because to make a connection through a java code is
necessary the inclusion of the host, port and name of the bank.

Who can give me a help!

[dr_gori]

Welcome TostesR1 !!!!

About your doubt, try to do select in this view:

Select all

SQL> SELECT GLOBAL_NAME FROM GLOBAL_NAME; 
 
GLOBAL_NAME 
--------------------------------------------- 
TAPISUL.US.ORACLE.COM 
 
SQL> 

[tostesr1]

Thanks I managed to know the name of the bank.

But would you like to know tb, the host and the door of my connection?

I know that by default is 127.0.0.1 and the port: 1521.

But I have doubt that the door being using is even that.

[dr_gori]

Well, I do not know if you can figure it out through a select.

I know this information is in the tnnames.ora file (there has the IP, port, etc. of all banks)

[tostesr1]

I already know this file, only in a Default installation oracle does not generate this file.


It only gives examples in the sample folder.