Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Still have not got "HOST.PORT.SID"
If your account has any PC applications accessing the Oracle instance in
question then there is probably a tnsnames.ora file on the PC. Look in
there for the information.
You should be able to cd to /var/opt/oracle manually and see if this directory exists and that tnsnames.ora is there. Otherwise, try having the find command you ran run by the Oracle account user from $ORACLE_HOME. Another possibility is to review all your environmental variable for ones associated (TWO_TASK, ORACLE_HOME, etc...) with Oracle for clues. On VMS tnsnames.ora is under ora_root:network.admin and it is possible to use an environmental variable to tell Oracle where to look for sqlnet, but it is there.
If all existing connections are from the database server it is possible that sqlnet version 2 was not configured since sqlnet is not required for local connections. You can check to see that sqlnet ver 2 is in use by issuing a 'ps -ef | grep tnslsnr'. If you find it then version 2 is up and running. The DBA should be able to issue 'lsnrctl status' and tell that the listener is running.
Huaping Luo <huaping_at_pollux.cs.uga.edu> wrote in article
<6jb0jj$q30$1_at_cronkite.cc.uga.edu>...
> Thank all of you who has responded my request.
> Unfortuanately, I have not solved my problem.
>
> My situation: I am writing a program in JAVA. In this program I need to
connect to
> my Oracle database through JDBC thin driver (v7.34 design by Oracle). My
Oracle
> resides in UNIX. I have to put "HOST.PORT.SID" into the connection
statement.
>
> So far as suggested by respondents, I failed to find the file
"tnsnames.ora"
> or "sqlnet.ora". I isssued the command "find . -name tnsnames(sqlnet).ora
-print".
> the search returned nothing, except showing a list of dirctories not
readable.
>
> Does each Oracle server has a port number?
> What is the port number of the default port?
>
> What is the easiest way to connect to an Oracle database?
>
>
> any help or hint will be appreciated.
>
> Huaping Luo
>
>
Received on Wed May 13 1998 - 09:30:38 CDT
![]() |
![]() |