Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: ORACLE-L Digest -- Volume 2003, Number 328

Re: ORACLE-L Digest -- Volume 2003, Number 328

From: Vaishali Karandikar <vaishali.karandikar_at_tatainfotech.com>
Date: Tue, 25 Nov 2003 03:39:25 -0800
Message-ID: <F001.005D7C33.20031125033925@fatcity.com>


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" <adar76_at_inter.net
> Re: Oracle and Firewall "Tanel Poder" <tanel.poder.003_at_m
> Initalization files, etc "VirVit" <virvit_at_prodtorg.udm.ne
> Re: Initalization files, etc Mladen Gogala <mgogala_at_adelphia.
> Re: Initalization files, etc "VirVit" <virvit_at_prodtorg.udm.ne
> AW: Any articles/books that take relational Stefan Jahnke <Stefan.Jahnke_at_bov
> "VirVit" <virvit_at_prodtorg.udm.ne
>
> ------------------------------------------------------------
>
> From: "Yechiel Adar" <adar76_at_inter.net.il>
> 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>&nbsp;</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 title=3Dmkhairy_at_egyptse.com =
> href=3D"mailto:mkhairy_at_egyptse.com">Mohamed=20
> Kamal</A> </DIV>
> <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A =
> title=3DORACLE-L_at_fatcity.com=20
> href=3D"mailto:ORACLE-L_at_fatcity.com">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>&nbsp;</DIV>
> <DIV><FONT face=3D"Arial (Arabic)" size=3D2>I'm trying to install =
> Oracle 8i in my=20
> computer&nbsp;(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>&nbsp;</DIV>
> <DIV><FONT face=3D"Arial (Arabic)" size=3D2>java.exe has generated =
> errors and will=20
> be close by woindows </FONT></DIV>
> <DIV>&nbsp;</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&nbsp; </FONT></DIV>
> <DIV>&nbsp;</DIV>
> <DIV><FONT face=3D"Arial (Arabic)" size=3D2>can you help me =
> ?</FONT></DIV>
> <DIV>&nbsp;</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>&nbsp;</DIV>
> <DIV>&nbsp;</DIV></BLOCKQUOTE></BODY></HTML>
>
> ------=_NextPart_000_028C_01C3B1EB.7C53BF40--
>
>
>
> ------------------------------
>
> From: "Tanel Poder" <tanel.poder.003_at_mail.ee>
> 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" <ORACLE-L_at_fatcity.com>
> 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" <ORACLE-L_at_fatcity.com>
> > 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: oracledbam_at_hotmail.com
> > >
> > > 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: 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).
> > >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Arup Nanda
> > INET: orarup_at_hotmail.com
> >
> > 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: 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).
> >
>
>
>
>
> ------------------------------
>
> From: "VirVit" <virvit_at_prodtorg.udm.net>
> 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 <mgogala_at_adelphia.net>
> 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: virvit_at_prodtorg.udm.net
> >
> > 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: 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).
> >
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Vaishali Karandikar
  INET: vaishali.karandikar_at_tatainfotech.com

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: 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 Tue Nov 25 2003 - 05:39:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US