| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle connection process
Below is the result of a grep on the output file from truss run on Solaris 8 & Oracle V8.1.6 which shows all the file opens that occured between
Enter user-name: username/password
Connected to:
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
SQL>
open64("./../", O_RDONLY|O_NDELAY) = 8
open64("./../../", O_RDONLY|O_NDELAY) = 8
open64("./../../../", O_RDONLY|O_NDELAY) = 8
open("/etc/mnttab", O_RDONLY) = 9
open("/db08/app/oracle/product/8.1.6/network/admin/sqlnet.ora", O_RDONLY) = 8
open64("/etc/.name_service_door", O_RDONLY) = 8
open("/etc/ttysrch", O_RDONLY) = 9
open("/db08/app/oracle/product/8.1.6/ocommon/nls/admin/data/lx1boot.nlb", O_RDONLY) = 9
open("/etc/ttysrch", O_RDONLY) = 9
open("/db08/app/oracle/product/8.1.6/sqlplus/mesg/sp1us.msb", O_RDONLY) = 3
open("/db08/app/oracle/product/8.1.6/sqlplus/mesg/sp2us.msb", O_RDONLY) = 4
open("/db08/app/oracle/product/8.1.6/sqlplus/mesg/sp1us.msb", O_RDONLY) = 3
open("/db08/app/oracle/product/8.1.6/sqlplus/mesg/sp2us.msb", O_RDONLY) = 4
open("login.sql", O_RDONLY) Err#2 ENOENT
open("/usr/local/sql/login.sql", O_RDONLY) Err#2 ENOENT
open("/usr/local/oracle/login.sql", O_RDONLY) Err#2 ENOENT
open("/home/charliem/sql/login.sql", O_RDONLY) = 9
open("/db08/app/oracle/product/8.1.6/sqlplus/admin/glogin.sql", O_RDONLY) = 12
open("/db08/app/oracle/product/8.1.6/rdbms/mesg/oraus.msb", O_RDONLY) = 12
FWIW - This is for a LOCAL connect & NOT using SQLNET.
HTH & YMMV!
"Farnsworth, Dave" wrote:
>
> Does anyone know of a resource or web site that explains the process of
> logging into an Oracle database. By this, I mean, say that I go into
> sql*plus, type in my name, pwd and SID. What I am curious about is what is
> the order of .ora files(TNSNAMES,SQLNET, or other files) that it reads in
> order to log me into the database. I have been using Oracle for a few
> months and really want to understand this process much better.
>
> Thanks,
>
> Dave
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Farnsworth, Dave
> INET: DFarnsworth_at_Ashleyfurniture.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
-- Charlie Mengler Maintenance Warehouse charliem_at_mwh.com 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 Perl is great. It lets you turn line noise into useful code. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: charliem_at_mwh.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Fri Jun 08 2001 - 09:47:12 CDT
 |
 |