| 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 problems after change of IP address
--PART.BOUNDARY.spdl139-tr0.4e0a.39fe8789.0001
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Chakaphan,
Thanks for your suggestions. The problem seems to be on DNS resolution level. I have replaced all DNS names in tnslistener.ora and listener.ora by their IP addresses and all works fine.
Koen.
Chakaphan.Supacharuwong%bca.co.th_at_Internet
31/10/2000 02:41
To: Koen Lefever/GKBCCB_at_GKBCCB
cc:
Subject: RE: Oracle connection problems after change of IP address
Hi..
When you connect on the server, do you connect by using SQL net such as
"scott/tiger_at_mydb"? Also did you tried tnsping from your client? How many
Oracle home you have on your client? I hope it might help.
-----Original Message-----
From: Koen Lefever [mailto:Koen.Lefever_at_dexia.be]
Sent: Monday, October 30, 2000 8:25 PM
To: Multiple recipients of list ORACLE-L
Subject: Oracle connection problems after change of IP address
Hi Folks,
I have a problem I'd like to post to this list:
We have an Oracle 7.3.4.0.0 server on a PC with Windows NT 4.0. In this PC was an Ethernet card with IP address A.B.C.D. A Token Ring card was added to the PC with IP address E.F.G.H and the IP address of the Ethernet card was changed from A.B.C.D into I.J.K.L.
When I try to connect to Oracle from the server itself, all is fine. If we try to connect from the network, we get error ORA-12224 (no listener) or ORA-12203. In the listener.ora and tnsnames.ora files are no IP adresses but DNS names. These look fine: if I ping to the DNS name which is in the tnsnames.ora and listener.ora files, I get the correct IP address E.F.G.H for the token ring card. In the Listener.log file, however, I see Oracle is listening to the new Ethernet address I.J.K.L. Oracle should not use the Ethernet card anymore, but we can't throw it out because the backups (on NT level) are taken trhough this Ethernet card. Is there another place in the Oracle configuration where I have to change the IP address into E.F.G.H?
Thanks in advance,
Koen.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koen Lefever INET: Koen.Lefever_at_dexia.be 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). --PART.BOUNDARY.spdl139-tr0.4e0a.39fe8789.0001 Content-Type: text/plain; charset=us-ascii Content-Disposition: attachment; filename="UNKNOWN.htm" Content-Description: UNKNOWN.htm FTBP-Modification-Date: 31 Oct 2000 09:49:00 +0100 FTBP-Object-Size: 3412Received on Tue Oct 31 2000 - 02:49:12 CST
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2650.12">
<TITLE>RE: Oracle connection problems after change of IP address</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>Hi..</FONT>
<BR><FONT SIZE=2> When you connect on the server, do you connect by using SQL net such as "scott/tiger_at_mydb"? Also did you tried tnsping from your client? How many Oracle home you have on your client? I hope it might help.</FONT></P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Koen Lefever [<A HREF="mailto:Koen.Lefever_at_dexia.be">mailto:Koen.Lefever_at_dexia.be</A>]</FONT>
<BR><FONT SIZE=2>Sent: Monday, October 30, 2000 8:25 PM</FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=2>Subject: Oracle connection problems after change of IP address</FONT>
</P>
<BR>
<P><FONT SIZE=2>Hi Folks,</FONT>
</P>
<P><FONT SIZE=2>I have a problem I'd like to post to this list:</FONT>
</P>
<P><FONT SIZE=2>We have an Oracle 7.3.4.0.0 server on a PC with Windows NT 4.0. In this PC was an Ethernet card with IP address A.B.C.D.</FONT></P>
<P><FONT SIZE=2>A Token Ring card was added to the PC with IP address E.F.G.H and the IP address of the Ethernet card was changed from A.B.C.D into I.J.K.L.</FONT></P>
<P><FONT SIZE=2>When I try to connect to Oracle from the server itself, all is fine. If we try to connect from the network, we get error ORA-12224 (no listener) or ORA-12203. In the listener.ora and tnsnames.ora files are no IP adresses but DNS names. These look fine: if I ping to the DNS name which is in the tnsnames.ora and listener.ora files, I get the correct IP address E.F.G.H for the token ring card. In the Listener.log file, however, I see Oracle is listening to the new Ethernet address I.J.K.L. Oracle should not use the Ethernet card anymore, but we can't throw it out because the backups (on NT level) are taken trhough this Ethernet card. Is there another place in the Oracle configuration where I have to change the IP address into E.F.G.H?</FONT></P>
<P><FONT SIZE=2>Thanks in advance,</FONT>
<BR><FONT SIZE=2>Koen.</FONT>
<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Please see the official ORACLE-L FAQ: http://www.orafaq.com</FONT>
<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Author: Koen Lefever</FONT>
<BR><FONT SIZE=2> INET: Koen.Lefever_at_dexia.be</FONT>
</P>
<P><FONT SIZE=2>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=2>San Diego, California -- Public Internet access / Mailing Lists</FONT>
<BR><FONT SIZE=2>--------------------------------------------------------------------</FONT>
<BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail message</FONT>
<BR><FONT SIZE=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT>
<BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB ORACLE-L</FONT>
<BR><FONT SIZE=2>(or the name of mailing list you want to be removed from). You may</FONT>
<BR><FONT SIZE=2>also send the HELP command for other information (like subscribing).</FONT>
</P>
</BODY>
</HTML>
--PART.BOUNDARY.spdl139-tr0.4e0a.39fe8789.0001-- ------------------------------ From: Eugene Shikhman <eugeni_at_bankisrael.gov.il> Date: Tue, 31 Oct 2000 10:52:29 -0000 LISTS ------------------------------ From: Miguel Urosa Ruiz <mur16_at_tid.es> Date: Tue, 31 Oct 2000 09:59:34 +0100 Subject: Re: Error in hotbackup script executed by other user then SYS What about to execute catdbsyn.sql script? HTH Regards, Miguel. Skurský Michal wrote: > Hello, > I have a script (hotbackup from > http://ora.dbasupport.com/oracle/scripts/Detailed/148.shtml) in which cursor > is (for example) declared: > > .... > cursor sidname is > select name > from v$database; > ... > ... > begin > open sidname; > loop > fetch sidname into zsidname; > exit when sidname %notfound; > end loop; > ... > ... > > This script can be executed only from user SYS. With other users (with DBA > role, for example system) generates a series of errors, for example: > > Creating hotbackup script... > from v$database; > * > ERROR on row 5: > ORA-06550: row 5, column 6: > PLS-00201: identificator 'SYS.V$DATABASE' must be declared > > What privilege have to be granted to the user or where is the problem. > > Thanks Michal > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: =?iso-8859-2?Q?Skursk=FD_Michal?= > INET: skursky_at_brn.pvt.cz > > 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). ------------------------------ From: Arul kumar <rakumar_at_mahindrabt.com> Date: Tue, 31 Oct 2000 14:39:46 +0530 Subject: Re: Error in hotbackup script executed by other user then SYS Hi Michal, Try referring V$Database as SYS.V$Database..... or grant SELECT privilege on that obj. directly to that user. Hope this will help. Arul. ------------------------------ From: "Truc Nguyen" <truc_at_nguyen.as> Date: Tue, 31 Oct 2000 10:56:36 +0100 Subject: Problem in Temporary tablespace. This is a multi-part message in MIME format. ------=_NextPart_000_0142_01C04329.3CDCD740 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi listers, We have some average databases in version 8.0.4.2.1. The temporary tablespace is very big (untill 10 gig) but it's very often = full. Does any one know why and how can i get rid of this problem ? Thanks a lot. Nguyen=20 ------=_NextPart_000_0142_01C04329.3CDCD740 Content-Type: text/html; charset="iso-8859-1" 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=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4308.2900" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV> Hi listers,</DIV>
<DIV> </DIV>
<DIV> We have some average databases in version=20
8.0.4.2.1.</DIV>
<DIV>The temporary tablespace is very big (untill 10 gig) but it's very =
often=20 full.</DIV>
<DIV>Does any one know why and how can i get rid of this problem ?</DIV>
<DIV> </DIV>
<DIV> Thanks a lot.</DIV>
<DIV> </DIV>
<DIV> Nguyen </DIV></BODY></HTML>
------=_NextPart_000_0142_01C04329.3CDCD740-- ------------------------------ From: lerobe - Lee Robertson <LEROBE_at_acxiom.co.uk> Date: Tue, 31 Oct 2000 10:52:29 -0000 Subject: RE: RE: IMPORT ERRORS Correction - it IS IGNORE=Y > Lee Robertson > Acxiom > Tel: 0191 525 7344 > Fax: 0191 525 7007 > Email: lerobe_at_acxiom.co.uk > -----Original Message----- From: Nagadevi Kavali [mailto:Nagadevik_at_coreobjects.com] Sent: 31 October 2000 08:50 To: Multiple recipients of list ORACLE-L Subject: RE: RE: IMPORT ERRORS Correction.......... If you want to create tables first and then import on top of it, you should give IMPORT=Y as one of your import parameter, which ignores any object creation errors. NRK. DBA/Database Architect CoreObjects -----Original Message----- Thankappan Sent: Tuesday, October 31, 2000 1:21 PM To: Multiple recipients of list ORACLE-L Hi! sorry if I am 'too late'.. But try exporting (in the 1st place!) with compress=N option explicitly set. This way it won't require a 'large' initial extent. Else create the table 'manually' and import with ignore=N Hope I've been useful! ------------- Original Message -------------- Hamid Alavi <HamidA_at_aimdirect.co.nz> wrote: To:Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> From:Hamid Alavi <HamidA_at_aimdirect.co.nz> Date:Mon, 30 Oct 2000 13:00:55 -0800 Subject:RE: IMPORT ERRORS Tom, This means your tablespace hasn't enough space check the data file for that tablespace or add another data file to that specific tablespace, hope it helps -----Original Message----- Sent: Tuesday, 31 October 2000 09:00 To: Multiple recipients of list ORACLE-L Perhaps the storage is already used up? Try this: alter TABLESPACE IQ01IDX01 coalesce; select bytes from dba_free_space where tablespace_name='IQ01IDX01' order by bytes desc; Check to see if there is enough contiguous free space in the tablespace for all of your indexes. ----- Original Message ----- To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
 |
 |