Thank you very much Regards Vaishali On Mon, 24 Nov 2003, Oracle RDBMS Community Forum wrote:
> ORACLE-L Digest Mon, 24 Nov 2003 Volume 2003, Number 328 > > In This Issue: > > Subject Author > ------------------------------------------- -------------------------------- > Re: Oracle 8i installation "Yechiel Adar" <[EMAIL PROTECTED] > Re: Oracle and Firewall "Tanel Poder" <[EMAIL PROTECTED] > Initalization files, etc "VirVit" <[EMAIL PROTECTED] > Re: Initalization files, etc Mladen Gogala <[EMAIL PROTECTED] > Re: Initalization files, etc "VirVit" <[EMAIL PROTECTED] > AW: Any articles/books that take relational Stefan Jahnke <[EMAIL PROTECTED] > "VirVit" <[EMAIL PROTECTED] > > ------------------------------------------------------------ > > From: "Yechiel Adar" <[EMAIL PROTECTED]> > Date: Sun, 23 Nov 2003 17:59:05 +0200 > Subject: Re: Oracle 8i installation > > This is a multi-part message in MIME format. > > ------=_NextPart_000_028C_01C3B1EB.7C53BF40 > Content-Type: text/plain; > charset="windows-1256" > Content-Transfer-Encoding: quoted-printable > > First I second Mladen recommendation to install 9.2. > IIRC there is one KIT file on the installation disk that you need to = > rename for the installation to succeed. > Also you can use lsnrctl to install the listener service. > do: lsnrctl start listener and it will install the service for you (if = > the service does not exist, at least in 9i). > > Yechiel Adar > Mehish > ----- Original Message -----=20 > From: Mohamed Kamal=20 > To: Multiple recipients of list ORACLE-L=20 > Sent: Sunday, November 23, 2003 10:44 AM > Subject: Oracle 8i installation > > > Hi Group, > > I'm trying to install Oracle 8i in my computer (Windows 2000),after = > installtion it gives me this error=20 > jrew.exe has generated errors and will be close by woindows > > java.exe has generated errors and will be close by woindows=20 > > and i can't found listener service in services so i can't conect to = > the database =20 > > can you help me ? > > thanks > M.Kamal > > > ------=_NextPart_000_028C_01C3B1EB.7C53BF40 > Content-Type: text/html; > charset="windows-1256" > Content-Transfer-Encoding: quoted-printable > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> > <HTML><HEAD> > <META http-equiv=3DContent-Type content=3D"text/html; = > charset=3Dwindows-1256"> > <META content=3D"MSHTML 6.00.2800.1106" name=3DGENERATOR> > <STYLE></STYLE> > </HEAD> > <BODY bgColor=3D#ffffff> > <DIV><FONT face=3DArial>First I second Mladen recommendation to install=20 > 9.2.</FONT></DIV> > <DIV><FONT face=3DArial>IIRC there is one KIT file on the installation = > disk that=20 > you need to rename for the installation to succeed.</FONT></DIV> > <DIV><FONT face=3DArial>Also you can use lsnrctl to install the listener = > > service.</FONT></DIV> > <DIV><FONT face=3DArial>do: lsnrctl start listener and it will install = > the service=20 > for you (if the service does not exist, at least in 9i).</FONT></DIV> > <DIV> </DIV> > <DIV>Yechiel Adar<BR>Mehish</DIV> > <BLOCKQUOTE dir=3Dltr=20 > style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; = > BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px"> > <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV> > <DIV=20 > style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = > black"><B>From:</B>=20 > <A [EMAIL PROTECTED] = > href=3D"mailto:[EMAIL PROTECTED]">Mohamed=20 > Kamal</A> </DIV> > <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A = > [EMAIL PROTECTED] > href=3D"mailto:[EMAIL PROTECTED]">Multiple recipients of list = > ORACLE-L</A>=20 > </DIV> > <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Sunday, November 23, 2003 = > 10:44=20 > AM</DIV> > <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> Oracle 8i = > installation</DIV> > <DIV><BR></DIV> > <DIV><FONT face=3DArial size=3D2>Hi Group,</FONT></DIV> > <DIV> </DIV> > <DIV><FONT face=3D"Arial (Arabic)" size=3D2>I'm trying to install = > Oracle 8i in my=20 > computer (Windows 2000),after installtion it gives me this error=20 > </FONT></DIV> > <DIV><FONT face=3D"Arial (Arabic)" size=3D2>jrew.exe has generated = > errors and will=20 > be close by woindows</FONT></DIV> > <DIV> </DIV> > <DIV><FONT face=3D"Arial (Arabic)" size=3D2>java.exe has generated = > errors and will=20 > be close by woindows </FONT></DIV> > <DIV> </DIV> > <DIV><FONT face=3D"Arial (Arabic)" size=3D2>and i can't found listener = > service in=20 > services so i can't conect to the database </FONT></DIV> > <DIV> </DIV> > <DIV><FONT face=3D"Arial (Arabic)" size=3D2>can you help me = > ?</FONT></DIV> > <DIV> </DIV> > <DIV><FONT face=3D"Arial (Arabic)" size=3D2>thanks</FONT></DIV> > <DIV><FONT face=3D"Arial (Arabic)" size=3D2>M.Kamal</FONT></DIV> > <DIV> </DIV> > <DIV> </DIV></BLOCKQUOTE></BODY></HTML> > > ------=_NextPart_000_028C_01C3B1EB.7C53BF40-- > > > > ------------------------------ > > From: "Tanel Poder" <[EMAIL PROTECTED]> > Date: Sun, 23 Nov 2003 19:44:40 +0200 > Subject: Re: Oracle and Firewall > > If you specify USE_SHARED_SOCKET in registry for your Oracle home and > restart the listener, the 1521 port can be shared between both listener and > database connections (in case of dedicated server). > > That way you won't have port problems with firewall. > > Tanel. > > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Friday, November 21, 2003 6:49 PM > > > > Seema, > > > > This is a typical misconception on the workings of Net8. Port 1521 is only > > used to contact the listener, after that the listener might: > > > > a) create a server process which listens on a port other than 1521 OR > > b) pass the connection to a prespawned server process, again on a > different > > port. > > > > The new port could be 1034, for example. The client process is then > notified > > that the server process is listening on port 1034 and the client process > > then starts communicating through the new port. > > > > Therefore what you see is normal. In fact it is the biggest proble in > > building a firewall around the database server; it just have to have too > > many ports (and mostly unpredictable) open. Here are a few options: > > > > (1) use firewall around the subnet where both app/web server and db server > > exist; not a firewall between them. > > (2) Use TCP Node checking to restrict Net8 traffic to the db server only > > from the app server. > > (3) Use Connection Manager. USing CM, known ports are used for > > communication, typically 1630 and 1631 (or is it 1634?) and only those can > > be opened up for connection. > > (4) Use Shared Servers. The connectiosn pass through the dispatchers. > Since > > the ports used by them can be known, those ports can be opened up. > > (5) Use SSH redirection. > > (6) Use a commercial firewall product that can perform proxy-redirection, > > which preserves the port number in all established connections, even > though > > actual ports used may be different. > > > > If anyone has any more options, I would love to know. > > > > HTH. > > > > Arup > > > > ----- Original Message ----- > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > Sent: Friday, November 21, 2003 10:59 AM > > > > > > > Hi, > > > We are using Oracle817 on Windows with netscreen firewall.I have been > > > noticing after some times applications start connecting form 1521 to > 1034 > > > and so.IS this normal ?I want port 1521 Only in use. How to fix this > > > problem? > > > thx > > > -Seema > > > > > > _________________________________________________________________ > > > Gift-shop online from the comfort of home at MSN Shopping! No crowds, > > free > > > parking. http://shopping.msn.com > > > > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > -- > > > Author: Seema Singh > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > > San Diego, California -- Mailing list and web hosting services > > > --------------------------------------------------------------------- > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: [EMAIL PROTECTED] (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). > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Arup Nanda > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > San Diego, California -- Mailing list and web hosting services > > --------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (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). > > > > > > > ------------------------------ > > From: "VirVit" <[EMAIL PROTECTED]> > Date: Mon, 24 Nov 2003 10:31:58 +0400 > Subject: Initalization files, etc > > Hello. > > I'am a newbie in Oracle, so I have some questions to experts :) > > 1) What difference between SPFILE and PFILE? > 2) Where by default Oracle search these files when instance starts? > 3) Where oracle searches datafiles by default? > 4) Sorry for lame questions :( > > Oracle 9.2.0.4, win2k. > > -- > �������� ������� �������� (VirVit) > Oracle 9i DBA beginner > > > > > > ------------------------------ > > From: Mladen Gogala <[EMAIL PROTECTED]> > Date: Mon, 24 Nov 2003 02:41:13 -0500 > Subject: Re: Initalization files, etc > > On 2003.11.24 01:34, VirVit wrote: > > Hello. > > > > I'am a newbie in Oracle, so I have some questions to experts :) > > > > 1) What difference between SPFILE and PFILE? > > Big one. It's best described in the concepts manual as well as in the DBA guide. > To make long story short, you can modify SPFILE from sqlplus which is not > possible with PFILe. SPFILE is "binary" (quotes are here because it's not very > binary, just a little), > while PFILE is a standard text file. > > > 2) Where by default Oracle search these files when instance starts? > > In %ORACLE_HOME%\DBS directory. > > > 3) Where oracle searches datafiles by default? > > Nowhere. It doesn't search them. Locations of the control files are a mandatory > parameter > in the parameter file (PFILE and SPFILE) and control files contain, among other > things, locations > of all data, temporary and redo log files. > > > 4) Sorry for lame questions :( > > No problem. There is plenty of literature available on OTN (technet.oracle.com) as > well as in > the bookshops just across the wire, like http://www.bn.com (Barnes & Noble). Oracle > has > a site, maintained by the book writer of the year (no, it's not Cary Millsap, it's > like NFL, the best > team never wins. I have quite a few funny stories about NFL and being dead certain > that I know > which team will win, but this is not an NFL mailing list). The site is > http://asktom.oracle.com. > It's maintained by Tom Kyte who answers as many questions as humanly possible. Not > all > answers are useful, but all are factually correct. The good books to read are > probably > 1) Oracle9i DBA Handbook by Kevin Loney and Marlene Theriault (don't shoot, Rachel, > it's French!) > 2) Expert 1-on-1 , Tom Kyte > 3) Practical Oracle 8i (one of the best DBA books ever written, even for a beginner, > pertinent for version 9i > as well), written by J. Lewis > 4) Oracle Administratiion and Management by M. Ault (don't buy Oracle8i Admin. and > Mgmt. as it is obsolete. > > the second edition is much better) > There are other good books, which are not, in my opinion, suitable for a beginner. > 1) Cary Millsap: Optimizing Oracle Performance (excellent book) > 2) Gaja V., Kirti Deshpande, John Kostelac 101 Oracle Performance Tuning (really > great book) > 3) Guy Harrison Oracle SQL High Performance Tuning > > The mandatory parts of the DBA arsenal are also Robert Freeman's RMAN book, Don > Burleson's > Statspack book and last but least, Andy Duncan, Jared Still: Perl for Oracle DBAs > (just for the > lovers of the pathologically eclectic rubish lister) > > > > > Oracle 9.2.0.4, win2k. > > It's not your fault. You may want to try with Linux, though. > > > > > -- > > Поцелуев Виталий Игоревич (VirVit) > > Oracle 9i DBA beginner > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: VirVit > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > San Diego, California -- Mailing list and web hosting services > > --------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (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). > > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vaishali Karandikar INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
