get_file_name built-in of forms for web
Hi Friends
Did someone succeed to implement the get_file_name built-in of forms using a
javabean with the wrapper class as suggested by Oracle at Metalink
(Note:74140.1) ?
When I try to compile it, I've got the following error :
MyDialog.java:4: Public class FDialog must be
defined in a file called "FDialog.java".
public class FDialog extends Canvas {
^
1 error
The java source that I tried to compile is given here below :
Bookmark Fixed font Go to End
Doc ID: Note:74140.1
Type: BULLETIN
Status: PUBLISHED
Content Type: TEXT/PLAIN
Creation Date: 16-SEP-1999
Last Revision Date: 05-DEC-2001
PURPOSE
===
The get_file_name built-in of forms is currently not implemented for Web.
You could create a Javabean and use it to implement this functionality
for WebForms.
Attached below are the source code of JavaBean & the Wrapper Class for the
Bean.
CREATING JAVABEAN
=
The Bean uses the following methods and Classes
---
PropertyChangeSupport for the file_name property.
java.awt.FileDialog class is used to show the File Dialog.
firePropertyChange method is called to pass a PropertyChange event to all
classes which are registered as listeners to this class.
addPropertyChangeListener is used by other classes to register themself as
PropertyChangeListener for this class.
---
import java.awt.*;
import java.beans.*;
public class FDialog extends Canvas {
private String file_name ;
private PropertyChangeSupport pcs;
public FDialog() {
file_name = "";
pcs = new PropertyChangeSupport(this);
}
public void set_file_name()
{
Frame frame = new Frame("Sample");
java.awt.FileDialog OpenDlg = new FileDialog(frame, "Open ",
java.awt.FileDialog.LOAD);
OpenDlg.setFile("*.*");
OpenDlg.show();
String old_file_name = file_name;
file_name=OpenDlg.getDirectory() + OpenDlg.getFile();
pcs.firePropertyChange("file_name", old_file_name, file_name);
}
public void addPropertyChangeListener(PropertyChangeListener pcl)
{
pcs.addPropertyChangeListener(pcl);
}
public void removePropertyChangeListener(PropertyChangeListener pcl)
{
pcs.removePropertyChangeListener(pcl);
}
}
-
Thanks for your help
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: ALEMU Abiy
INET: [EMAIL PROTECTED]
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: [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).
Developer6i on Solaris 2.7
Hi friends I just installed forms6i on a unix box with Solaris 2.7 and when I try to execute f60desm, I've got the following error : Segmentation fault (core dumped). Is there any step that I omit or any work around ? Thanks !!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ALEMU Abiy INET: [EMAIL PROTECTED] 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: [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).
Off-topic Perl Question
I know that this is not the forum to ask perl questions. But is there some
one who can help me on how to read two lines at a time using
a Perl script
My script looks like this :
open(FILE_IN, "<$datafile") or die "Cannot open $datafile...\n";
while()
{ chomp;
@fields = split(/;/);
print ("Processing line $. for emission...\n");
PROMPT Processing $. for emission ...
($cField1, $cField2, $cField3) = @fields[0..2];
... and so on
In this case, as you see, it takes only a line at a time and I would to
consider couple of lines at a time.
Is it possible to do it and how ?
Please help.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: ALEMU Abiy
INET: [EMAIL PROTECTED]
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: [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).
SQL-02127 : Precompiler/SQLLIB version mismatch
Once compiled my application under the 8.1.7 Pro*C while connecting to the database, I've got SQL-02127 : Precompiler/SQLLIB version mismatch. Does someone has an idea ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ALEMU Abiy INET: [EMAIL PROTECTED] 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: [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).
Kernel parameters (Sun Solaris)
Hi guys, Is there any guide line or documentation which gives values of OS kernel parameters for Oracle ? What are the recommended values for n instances on which we have p processes and u users each ? Thanks a lot -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ALEMU Abiy INET: [EMAIL PROTECTED] 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: [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).
Data integration script using PERL
Is there someone who wrote a script in a PERL language designed to insert data in Oracle tables by reading data from a text data file ? If so, is it possible to have just an example of it so that I can adapt it for my need. Just not to reinvent the wheel Thanx
Replication question
I'm setting up a basic replication on a 8.1.7 oracle database and I'm wondering if a schema change is also replicated along with data changes. If I modify the structure of a table on the master site, is that modification is propagated to my snapshot site ? Please help
RE: Find out export from remote locations
If you're using a 8.1.7 version of the database with a 8.0.5 version of the Client, it's normal. You've to apply the patch. -Message d'origine- De : Tatireddy, Shrinivas (MED, Keane) [mailto:[EMAIL PROTECTED]] Envoyé : lundi 22 octobre 2001 12:20 À : Multiple recipients of list ORACLE-L Objet : RE: Find out export from remote locations In V$session I am able to find only the session that is connected. But it is not showing anything in program column. Can I find the program, that is being executed(here it is export) from any table? srinivas -Original Message- Sent: Monday, October 22, 2001 6:31 AM To: Multiple recipients of list ORACLE-L Query the V$session table in Server2. -- On Mon, 22 Oct 2001 00:50:18 Tatireddy, Shrinivas (MED, Keane) wrote: >Hi lists, > >Is there any way to find out if any session is doing export from a >remote shell. > >eg: >I am performing this from SERVER1 > >exp userid=sys/pwd@connect_str_ON_SERVER2 file=/tmp/file.dmp >log=/tmp/file.log tables=scott.emp > >this I am doing from my local database to a remote server. > >I am able to do perform export. > >Is there any table to find the above information(IN EITHER SERVER1 OR >SERVER2), means a user is performing export on the database. > >Thnx and regards >srinivas >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Tatireddy, Shrinivas (MED, Keane) > INET: [EMAIL PROTECTED] > >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: [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). > Make a difference, help support the relief efforts in the U.S. http://clubs.lycos.com/live/events/september11.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian INET: [EMAIL PROTECTED] 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: [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.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] 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: [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.com -- Author: ALEMU Abiy INET: [EMAIL PROTECTED] 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: [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).
RE: how to delete instance?
To delete an instance, shutdown the instance and remove all its control, log and database files. To do it properly, remove also all its entries in SQL*Net(Net8) parameter files. That's all. -Message d'origine- De : Seema Singh [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 18 octobre 2001 18:41 À : Multiple recipients of list ORACLE-L Objet : how to delete instance? Hi WHich way is better way to delete Instance? Means shutdown instance/delete all reference files or remove thru dbassist mode and then delete reference files? Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] 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: [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.com -- Author: ALEMU Abiy INET: [EMAIL PROTECTED] 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: [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).
RE: ORA-24323 & ORA-03113 & ORA-01034 & ORA-27101 errors
This is a problem related to NET8 parameter files (tnsnames or listener). Check the parameters in these files. -Message d'origine- De : Okan CIMEN [mailto:[EMAIL PROTECTED]] Envoyé : vendredi 5 octobre 2001 14:35 À : Multiple recipients of list ORACLE-L Objet : ORA-24323 & ORA-03113 & ORA-01034 & ORA-27101 errors Hello, I get strange errors from my DB server. Here are the outputs; $ sqlplus SQL*Plus: Release 8.1.7.0.0 - Production on Thu Oct 5 14:24:07 2000 (c) Copyright 2000 Oracle Corporation. All rights reserved. Enter user-name: internal Connected to an idle instance. SQL> startup force ORA-24323: value not allowed ORA-03113: end-of-file on communication channel When I try to log on as any user I get these messages; SQL> connect anyuser Enter password: ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist SVR4 Error: 2: No such file or directory I am still connected to the server as a user but when I do ps -ef | grep ora_ , I get nothing. Can someone please tell me what path I shall take? Regards Okan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Okan CIMEN INET: [EMAIL PROTECTED] 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: [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.com -- Author: ALEMU Abiy INET: [EMAIL PROTECTED] 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: [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).
RE: running catlog,catproc
I used to run both scripts without any problem while the database is running in a normal mode. -Message d'origine- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Envoyé : mercredi 3 octobre 2001 18:55 À : Multiple recipients of list ORACLE-L Objet : Re:running catlog,catproc I asked that question of OWS some time ago since we appeared to have a problem with the database that pointed in that area. Now they did agree with my diagnoses of the problem and told me that it was possible to run those scripts without the DB being in restricted mode, BUT it could cause some VERY strange behavior for those other sessions running in the database and possibly a crash. Their recommendation was to run them only in restricted mode. Dick Goulet Reply Separator Author: "Tatireddy; Shrinivas (MED; Keane)" <[EMAIL PROTECTED]> Date: 10/3/01 7:40 AM Hi lists Is it mandatory that catlog.sql, catproc.sql should be run while database is in restricted mode. should I run them while db is running in normal mode (users are logged in )? any problems!!! errors !!! regards, srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] 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: [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.com -- Author: INET: [EMAIL PROTECTED] 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: [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.com -- Author: ALEMU Abiy INET: [EMAIL PROTECTED] 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: [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).
RE: running catlog,catproc
Nope -Message d'origine- De : Tatireddy, Shrinivas (MED, Keane) [mailto:[EMAIL PROTECTED]] Envoyé : mercredi 3 octobre 2001 17:40 À : Multiple recipients of list ORACLE-L Objet : running catlog,catproc Hi lists Is it mandatory that catlog.sql, catproc.sql should be run while database is in restricted mode. should I run them while db is running in normal mode (users are logged in )? any problems!!! errors !!! regards, srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] 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: [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.com -- Author: ALEMU Abiy INET: [EMAIL PROTECTED] 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: [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).
RE: changing the internal password
ALTER USER sys IDENTIFIED BY ; -Message d'origine- De : Beatriz Martínez Jiménez [mailto:[EMAIL PROTECTED]] Envoyé : mardi 25 septembre 2001 12:45 À : Multiple recipients of list ORACLE-L Objet : changing the internal password Hello, I am trying to log in the sqlplus (from command line) as the internal user but I can´t remember its password. Is there any way to change it? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ALEMU Abiy INET: [EMAIL PROTECTED] 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: [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).
RE: Snapshot performance issue
I forgot to tell you that I'm working on release 8.1.7 and if I'm not mistaken indexes like 'SNAP_$' do no more exist. Please, correct me if I'm mistaken. -Message d'origine- De : Mike J Kurth [mailto:[EMAIL PROTECTED]] Envoyé : mardi 11 septembre 2001 08:25 À : Multiple recipients of list ORACLE-L Objet : Re: Snapshot performance issue It may be that the name of your index has changed. It is probably something like I_snap$_E I_REF_EMETTEUR. You will need to change the hint to reflect the change. 01 01:40 AM PST Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> cc: I have a view based on the query below which is executed in a reasonable way on the master site but this same view takes hours on the snapshot site. Any idea CREATE OR REPLACE VIEW V_ENTITE_EMETTEUR2 AS select /*+ ORDERED USE_NL(E A SI SY O LF MO AM MR ST) INDEX(E I_REF_EMETTEUR) */ E.COMP_EMETTEUR, E.NOM_STATION, E.REF_EMETTEUR, E.PIRE, E.PIRE_CALCULEE, E.HAUT_SOL_ANT, E.AZIMUT, E.ELEVATION, E.OWNER, E.CODE_INTERNE_TS, E.CODE_INTERNE_TC, E.DEP_CODE_GESTION, SY.COMP_SYSTEME, SY.NOM_SYSTEME, O.COMP_OPERATEUR, O.CODE_OPERATEUR, SI.COMP_SITE, SI.REF_SITE, SI.NOM_SITE, A.COMP_ANTENNE, A.NOM_ANT, MO.REF_MODU, AM.REF_AMPLI, MR.REF_MAT_RECEPT, LF.CODE_ETAT, ST.CODE from t_station E, t_antena A, t_site SI, t_system SY, t_operator O, t_lf_states LF, v_station_modu MO, v_station_ampli AM, v_station_recept MR, t_status ST where E.COMP_SYSTEME = SY.COMP_SYSTEME and E.COMP_OPERATEUR = O.COMP_OPERATEUR and E.COMP_SYSTEME = O.COMP_SYSTEME and E.COMP_SITE = SI.COMP_SITE and E.COMP_ANTENNE = A.COMP_ANTENNE and E.COMP_EMETTEUR = MO.COMP_EMETTEUR (+) and E.COMP_EMETTEUR = AM.COMP_EMETTEUR(+) and E.COMP_EMETTEUR = MR.COMP_EMETTEUR(+) and not (E.SUPPR_A_ANALYSER_FAE is not null and E.SUPPR_A_ANALYSER_FAE = 'O') and E.TYPE_STATION = LF.COMP_ETATS and E.COMP_STATUS = ST.COMP_STATUS(+) and exists (select 1 from v_mygroup_users where E.owner=user_name and rownum<=1); - Abiy Alemu Phone: (+33) 1-58 17 04 56 Fax: (+33) 1-58 17 04 54 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike J Kurth INET: [EMAIL PROTECTED] 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: [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.com -- Author: ALEMU Abiy INET: [EMAIL PROTECTED] 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: [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).
Snapshot performance issue
I have a view based on the query below which is executed in a reasonable way on the master site but this same view takes hours on the snapshot site. Any idea ? CREATE OR REPLACE VIEW V_ENTITE_EMETTEUR2 AS select /*+ ORDERED USE_NL(E A SI SY O LF MO AM MR ST) INDEX(E I_REF_EMETTEUR)*/ E.COMP_EMETTEUR, E.NOM_STATION, E.REF_EMETTEUR, E.PIRE, E.PIRE_CALCULEE, E.HAUT_SOL_ANT, E.AZIMUT, E.ELEVATION, E.OWNER, E.CODE_INTERNE_TS, E.CODE_INTERNE_TC, E.DEP_CODE_GESTION, SY.COMP_SYSTEME, SY.NOM_SYSTEME, O.COMP_OPERATEUR, O.CODE_OPERATEUR, SI.COMP_SITE, SI.REF_SITE, SI.NOM_SITE, A.COMP_ANTENNE, A.NOM_ANT, MO.REF_MODU, AM.REF_AMPLI, MR.REF_MAT_RECEPT, LF.CODE_ETAT, ST.CODE from t_station E, t_antena A, t_site SI, t_system SY, t_operator O, t_lf_states LF, v_station_modu MO, v_station_ampli AM, v_station_recept MR, t_status ST where E.COMP_SYSTEME = SY.COMP_SYSTEME and E.COMP_OPERATEUR = O.COMP_OPERATEUR and E.COMP_SYSTEME = O.COMP_SYSTEME and E.COMP_SITE = SI.COMP_SITE and E.COMP_ANTENNE = A.COMP_ANTENNE and E.COMP_EMETTEUR = MO.COMP_EMETTEUR(+) and E.COMP_EMETTEUR = AM.COMP_EMETTEUR(+) and E.COMP_EMETTEUR = MR.COMP_EMETTEUR(+) and not (E.SUPPR_A_ANALYSER_FAE is not null and E.SUPPR_A_ANALYSER_FAE = 'O') and E.TYPE_STATION = LF.COMP_ETATS and E.COMP_STATUS = ST.COMP_STATUS(+) and exists (select 1 from v_mygroup_users V where E.owner=user_name and rownum<=1); - Abiy AlemuPhone: (+33) 1-58 17 04 56Fax: (+33) 1-58 17 04 54
Limiting the number of concurrent SQL*PLUS connections
Hi folks Is it possible to limit the number of SQL*PLUS connections on 7.3.4 version of Oracle database ?
NT backup script question
I have a NT cold backup script but I would like to add at last a winzip or any other compress command. Any idea from someone who has already done this ? Thanx
Restore from copied control, redo and data files
The NT box on which we had about 4 instances (Oracle 7.3.4) has crashed. I don't know the state of the files while the crash but I have copies of all control, redo and data files with the initialization file. I know that I have to reinstall the Oracle Engine but I don't really know the procedure to restore all my instances. Can somebody help me in this respect ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ALEMU Abiy INET: [EMAIL PROTECTED] 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: [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).
RE: Simple SQL Query Question
Your
query also seems working, not a novice's solution :--)
Thank
you
-Message d'origine-De : novicedba
[mailto:[EMAIL PROTECTED]]Envoyé : lundi 2 juillet 2001
14:05À : Multiple recipients of list
ORACLE-LObjet : Re: Simple SQL Query
Question
select decode(emm_freq,0,1,emm_freq) *
decode(rec_freq,0,1,rec_freq) valuefrom (select count(emission_freq)
emm_freq,count(reception_freq) rec_freq from test where
station='STAT2')
VALUE 3
I am selecting from a view which as you see has
the counts of both the columns
I am using decode to replace '0' with '1' ,
without this step the answer would be improper
for example
for stat2 the inner view will fetch values 3 and
0 when multiplied will give 0
to overcome this I replace 0 with 1
Hope this serves the purpose
cozI am anoviceOracle Certifiable DBBS
- Original Message -
From:
ALEMU Abiy
To: Multiple
recipients of list ORACLE-L
Sent: Monday, July 02, 2001 3:30
PM
Subject: RE: Simple SQL Query
Question
For example for a table like this
one,
STATION
EMISSION_FREQ
RECEPTION_FREQ--
-
-- STAT1
192.5
193.5 STAT2
192.5 STAT2 194
STAT1
193.5
194.5
STAT2 195
I
would like to have a value for STAT1 which is equal to 2*2=4 and for
STAT2 equal to 3*1=3
-Message d'origine-De : novicedba
[mailto:[EMAIL PROTECTED]]Envoyé : lundi 2 juillet
2001 11:15À : Multiple recipients of list
ORACLE-LObjet : Re: Simple SQL Query
Question
SELECT
STATION,EMISSION_FREQ,RECEPTION_FREQ,DECODE(SUBSTR(NVL(TO_CHAR(RECEPTION_FREQ),'NONE'),1,1),'N',EMISSION_FREQ*1,EMISSION_FREQ*2)
VALUEFROM TEST;
STATION
EMISSION_FREQ RECEPTION_FREQ
VALUE--
-
--
-STAT1
192.5
193.5
385STAT2
192.5
192.5STAT2 194
194STAT2
193.5
194.5
387STAT2 195
195
I did not understand what you meant by 'And I would like to select the
number of frequencies, sort of count(*), for a given station and multiply
that value by 2 '
so what I
have done is
if
the reception_freq is null
(that would mean there is only emission_freq )
then
value=emission_freq*1
else
value=emission_freq*1
end
if
Hope this is
what you wanted
cozI am anoviceOracle Certifiable DBBS
- Original Message -
From:
ALEMU Abiy
To: Multiple
recipients of list ORACLE-L
Sent: Monday, July 02, 2001 1:00
PM
Subject: Simple SQL Query
Question
I've a
table with the following structure and sample data :
Station
Emission_Freq
Reception_Freq
-
--
STAT1
192.5
193.5
STAT2
193
STAT2
194
STAT2
193.5
194.5
STAT2
195
And I would
like to select the number of frequencies, sort of count(*), for a given
station and multiply that value by 2 if the station has Emission
frequency and reception frequency and multiply by one if the station has
only the emission frequency or only the reception frequency. I
don't know how to use a condition in SQL. I'm sure that it's
possible to do it but I don't know how. Can anybody help me
?
@biy @lemu
[EMAIL PROTECTED]
Database Administration
Engineer
France
RE: Simple SQL Query Question
Thank you Harsh, your query seems working -Message d'origine- De : Harsh Agrawal [mailto:[EMAIL PROTECTED]] Envoyé : lundi 2 juillet 2001 14:05 À : Multiple recipients of list ORACLE-L Objet : RE: Simple SQL Query Question Hi ALEMU Abiy, Try out this : select count(*)*2 FREQC from sample1 where station='&ST' and emission_freq is not null and reception_freq is not null having count(*) > 0 union select count(*)*1 FREQC from sample1 where station='&ST' and ( emission_freq is not null and reception_freq is null) or ( emission_freq is null and reception_freq is not null) having count(*) > 0 / Result: When ST=STAT1 Result = 4 When ST=STAT2 Result = 3 As reqrd by u. Hope this will help u. Bye - Harsh -Original Message- Sent: Monday, July 02, 2001 2:20 PM To: Multiple recipients of list ORACLE-L Well, then decode would be the only option, as suggested by other members. Case is not supported. rgds amar -Original Message- Sent: Monday, July 02, 2001 2:00 PM To: Multiple recipients of list ORACLE-L I'm using Oracle 7.3.4, so is it possible to use CASE statements ? -Message d'origine- De : Amar Kumar Padhi [mailto:[EMAIL PROTECTED]] Envoyé : lundi 2 juillet 2001 10:57 À : Multiple recipients of list ORACLE-L Objet : RE: Simple SQL Query Question select count((case when (nvl(emission_freq, 0) != 0 and nvl(reception_freq, 0) != 0) then 1 else null end)) * 2 + count((case when (nvl(emission_freq, 0) != 0 and nvl(reception_freq, 0) != 0) then null else 1 end)) * 1 as "total" from am39 where station = ''; rgds amar -Original Message- Sent: Monday, July 02, 2001 11:30 AM To: Multiple recipients of list ORACLE-L I've a table with the following structure and sample data : StationEmission_FreqReception_Freq --- STAT1192.5193.5 STAT2193 STAT2194 STAT2193.5194.5 STAT2195 And I would like to select the number of frequencies, sort of count(*), for a given station and multiply that value by 2 if the station has Emission frequency and reception frequency and multiply by one if the station has only the emission frequency or only the reception frequency. I don't know how to use a condition in SQL. I'm sure that it's possible to do it but I don't know how. Can anybody help me ? @biy @lemu [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Database Administration Engineer Groupe CRIL TECHNOLOGY <http://www.criltechnology.com/images/cril.gif> France -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harsh Agrawal INET: [EMAIL PROTECTED] 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: [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.com -- Author: ALEMU Abiy INET: [EMAIL PROTECTED] 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: [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).
RE: Simple SQL Query Question
Okay
but how do you use DECODE with the count(*) ? For example the query
below doesn't work
SELECT
decode(reception_freq, null, 1, 2)*count(*) from
my_table
where
station = 'STAT1' ;
-Message d'origine-De : Amar Kumar Padhi
[mailto:[EMAIL PROTECTED]]Envoyé : lundi 2 juillet 2001
13:20À : Multiple recipients of list
ORACLE-LObjet : RE: Simple SQL Query
Question
Well, then decode would be the only option, as suggested by other
members. Case is not supported.
rgds
amar
-Original Message-From: ALEMU Abiy
[mailto:[EMAIL PROTECTED]]Sent: Monday, July 02, 2001
2:00 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Simple SQL Query
Question
I'm using Oracle 7.3.4, so is it possible to use
CASE statements ?
-Message d'origine-De : Amar Kumar Padhi
[mailto:[EMAIL PROTECTED]]Envoyé : lundi 2 juillet 2001
10:57À : Multiple recipients of list
ORACLE-LObjet : RE: Simple SQL Query
Question
select
count((case when (nvl(emission_freq, 0) != 0 and nvl(reception_freq, 0) !=
0)
then 1 else null end)) * 2 +
count((case when (nvl(emission_freq, 0) != 0 and nvl(reception_freq, 0) !=
0)
then null else 1 end)) * 1 as "total"from
am39
where station = '';
rgds
amar
-Original Message-From: ALEMU Abiy
[mailto:[EMAIL PROTECTED]]Sent: Monday, July 02,
2001 11:30 AMTo: Multiple recipients of list
ORACLE-LSubject: Simple SQL Query
Question
I've a
table with the following structure and sample data :
Station
Emission_Freq
Reception_Freq
-
--
STAT1
192.5
193.5
STAT2
193
STAT2
194
STAT2
193.5
194.5
STAT2
195
And I would
like to select the number of frequencies, sort of count(*), for a given
station and multiply that value by 2 if the station has Emission
frequency and reception frequency and multiply by one if the station has
only the emission frequency or only the reception frequency. I
don't know how to use a condition in SQL. I'm sure that it's
possible to do it but I don't know how. Can anybody help me
?
@biy @lemu
[EMAIL PROTECTED]
Database Administration
Engineer
France
RE: Simple SQL Query Question
For example for a table like this one, STATION EMISSION_FREQ RECEPTION_FREQ-- - -- STAT1 192.5 193.5 STAT2 192.5 STAT2 194 STAT1 193.5 194.5 STAT2 195 I would like to have a value for STAT1 which is equal to 2*2=4 and for STAT2 equal to 3*1=3 -Message d'origine-De : novicedba [mailto:[EMAIL PROTECTED]]Envoyé : lundi 2 juillet 2001 11:15À : Multiple recipients of list ORACLE-LObjet : Re: Simple SQL Query Question SELECT STATION,EMISSION_FREQ,RECEPTION_FREQ,DECODE(SUBSTR(NVL(TO_CHAR(RECEPTION_FREQ),'NONE'),1,1),'N',EMISSION_FREQ*1,EMISSION_FREQ*2) VALUEFROM TEST; STATION EMISSION_FREQ RECEPTION_FREQ VALUE-- - -- -STAT1 192.5 193.5 385STAT2 192.5 192.5STAT2 194 194STAT2 193.5 194.5 387STAT2 195 195 I did not understand what you meant by 'And I would like to select the number of frequencies, sort of count(*), for a given station and multiply that value by 2 ' so what I have done is if the reception_freq is null (that would mean there is only emission_freq ) then value=emission_freq*1 else value=emission_freq*1 end if Hope this is what you wanted cozI am anoviceOracle Certifiable DBBS - Original Message - From: ALEMU Abiy To: Multiple recipients of list ORACLE-L Sent: Monday, July 02, 2001 1:00 PM Subject: Simple SQL Query Question I've a table with the following structure and sample data : Station Emission_Freq Reception_Freq - -- STAT1 192.5 193.5 STAT2 193 STAT2 194 STAT2 193.5 194.5 STAT2 195 And I would like to select the number of frequencies, sort of count(*), for a given station and multiply that value by 2 if the station has Emission frequency and reception frequency and multiply by one if the station has only the emission frequency or only the reception frequency. I don't know how to use a condition in SQL. I'm sure that it's possible to do it but I don't know how. Can anybody help me ? @biy @lemu [EMAIL PROTECTED] Database Administration Engineer France
RE: Simple SQL Query Question
I'm using Oracle 7.3.4, so is it possible to use CASE statements ? -Message d'origine-De : Amar Kumar Padhi [mailto:[EMAIL PROTECTED]]Envoyé : lundi 2 juillet 2001 10:57À : Multiple recipients of list ORACLE-LObjet : RE: Simple SQL Query Question select count((case when (nvl(emission_freq, 0) != 0 and nvl(reception_freq, 0) != 0) then 1 else null end)) * 2 + count((case when (nvl(emission_freq, 0) != 0 and nvl(reception_freq, 0) != 0) then null else 1 end)) * 1 as "total"from am39 where station = ''; rgds amar -----Original Message-From: ALEMU Abiy [mailto:[EMAIL PROTECTED]]Sent: Monday, July 02, 2001 11:30 AMTo: Multiple recipients of list ORACLE-LSubject: Simple SQL Query Question I've a table with the following structure and sample data : Station Emission_Freq Reception_Freq - -- STAT1 192.5 193.5 STAT2 193 STAT2 194 STAT2 193.5 194.5 STAT2 195 And I would like to select the number of frequencies, sort of count(*), for a given station and multiply that value by 2 if the station has Emission frequency and reception frequency and multiply by one if the station has only the emission frequency or only the reception frequency. I don't know how to use a condition in SQL. I'm sure that it's possible to do it but I don't know how. Can anybody help me ? @biy @lemu [EMAIL PROTECTED] Database Administration Engineer France
Simple SQL Query Question
I've a table with the following structure and sample data : Station Emission_Freq Reception_Freq - -- STAT1 192.5 193.5 STAT2 193 STAT2 194 STAT2 193.5 194.5 STAT2 195 And I would like to select the number of frequencies, sort of count(*), for a given station and multiply that value by 2 if the station has Emission frequency and reception frequency and multiply by one if the station has only the emission frequency or only the reception frequency. I don't know how to use a condition in SQL. I'm sure that it's possible to do it but I don't know how. Can anybody help me ? @biy @lemu [EMAIL PROTECTED] Database Administration Engineer France cril.gif
RE: Help for Unix text file processing
But if I want to conserve the carriage return -Message d'origine- De : Jared Still [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 7 juin 2001 12:36 À : Multiple recipients of list ORACLE-L Objet : Re: Help for Unix text file processing Do it with Perl. If you don't know it, it's time to learn. This script will do it: #!/usr/bin/perl -pw chomp; next if /^\s+$/; $_ =~ s/^\s+(.*)$/$1\n/; run as my_script file_to_fix.txt > fixed_file.txt Jared On Wednesday 06 June 2001 07:55, you wrote: > > Hey all, > > > > I am looking for some commands like ( grep, egrep, sed etc) to do the > > following on a Unix box. > > > > 1. Command to take out all the blank line from a text file. The blank > > line may include tabs and whitespaces. > > 2. Command to take out the trailing and starting blanks and tabs from the > > each line of the text file. > > 3. Command for the above two tasks combined. > > > > Thanks in advance. > > > > Dharminder Kumar > > This e-mail and any attachments may contain confidential and privileged > information. If you are not the intended recipient, please notify the > sender immediately by return e-mail, delete this e-mail and destroy any > copies. Any dissemination or use of this information by a person other than > the intended recipient is unauthorized and may be illegal. Unless otherwise > stated, opinions expressed in this e-mail are those of the author and are > not endorsed by the author's employer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] 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: [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.com -- Author: ALEMU Abiy INET: [EMAIL PROTECTED] 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: [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).
RE: unhandled user-defined exception
Title: unhandled user-defined exception Add an EXCEPTION to your code and try to trap the error 6510 -Message d'origine-De : Venugopal, R (GEP, Contractor) [mailto:[EMAIL PROTECTED]]Envoyé : jeudi 17 mai 2001 13:25À : Multiple recipients of list ORACLE-LObjet : unhandled user-defined exception Hi Gurus I am getting the error attached below when trigger fires. what could be the reasons for this error. DB error: ORA-06510: PL/SQL: unhandled user-defined exception Thanks in Advance Venu
RE: Unix
Use textedit -Message d'origine- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Envoyé : lundi 14 mai 2001 16:01 À : Multiple recipients of list ORACLE-L Objet : Unix How can I modify a Unix file in an other editor not using vi, for instance I would like to use a Windows based editor? Roland Sköldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [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.com -- Author: ALEMU Abiy INET: [EMAIL PROTECTED] 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: [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).
RE: OT: shell script to compare nos.
But this does not work for real numbers, ex: 2.51 ot 2.01, it compares only
integers
-Message d'origine-
De : lerobe - Lee Robertson [mailto:[EMAIL PROTECTED]]
Envoyé : mercredi 11 avril 2001 12:31
À : Multiple recipients of list ORACLE-L
Objet : RE: OT: shell script to compare nos.
Why not simply do the following passing two parameters to the script eg.
call the script test.sh and call it so
test.sh 2 1
This results in output "VAR1 is greater than VAR2"
then
test.sh 1 2
this results in output "VAR2 is greater than VAR1"
Cheers.
#!/bin/ksh
VAR1=$1
VAR2=$2
if [ "$VAR1" -gt "$VAR2" ]
then
echo "VAR1 is greater than VAR2"
else
echo "VAR2 is greater than VAR1"
fi
-Original Message-
Sent: 11 April 2001 10:01
To: Multiple recipients of list ORACLE-L
Hi
I'm sure there are better ways but awk does the trick
echo $var1 $var2 | awk '{ if ( $1 > $2 ) { print "1"} else { print"0" } }'
cheers alex
> Hello,
>
> I need some help in comparing 2 nos. in a unix shell.
>
> 1) e.g var1="7.04.03"
>and var2="7.05"
>
> I want to test:-
>
> if [ "$var2" > "$var1" ];then
>then $var2 version is greater than $var1"
> fi
>
> 2) 2nd condition is :-
>
> var1="7.04.03"
> var2="7.04.02"
>
> I want to test:-
> if [ "$var1" > "$var2" ];then
>then $var1 version is greater than $var2"
> fi
>
> Can some one send me a code?
>
> How can I do the above in shell? Can you please help me, a seemingly
simple
> one!
>
>
> Raja
>
>
>
> Get 250 color business cards for FREE! at Lycos Mail
> http://mail.lycos.com/freemail/vistaprint_index.html
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Alex Apostolopoulos
INET: [EMAIL PROTECTED]
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: [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).
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.
If you have received this communication in error, please
re-send this communication to the sender and delete the
original message or any copy of it from your computer
system.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: lerobe - Lee Robertson
INET: [EMAIL PROTECTED]
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: [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.com
--
Author: ALEMU Abiy
INET: [EMAIL PROTECTED]
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: [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).
Installing Oracle817 in parallel with an existing Oracle734
Hi friends, What are the steps to follow in order to install Oracle817 on Windows NT in parallel with an existing database with 7.3.4 version ? @biy @lemu [EMAIL PROTECTED] Database Administration Engineer Cril Telecom Software France
RE: ORA-27101: shared memory realm does not exist
Solaris 7 -Message d'origine- De : Henry Poras [mailto:[EMAIL PROTECTED]] Envoyé : lundi 26 mars 2001 17:58 À : Multiple recipients of list ORACLE-L Objet : RE: ORA-27101: shared memory realm does not exist What is the OS? -Original Message- Sent: Monday, March 26, 2001 10:41 AM To: Multiple recipients of list ORACLE-L I have this error when I try to connect to a 8.1.7 database instance. I don't really know what's happening. To give just an information, on the server machine I've 2 database engines (7.3.4 and 8.1.7) and on both engines there are 2 or more instances running. I've only one listener.ora file for both engines, with the correct ORACLE_HOMES Thank you folks ... @biy @lemu [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Cril Telecom Software France -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henry Poras INET: [EMAIL PROTECTED] 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: [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.com -- Author: ALEMU Abiy INET: [EMAIL PROTECTED] 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: [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).
ORA-27101: shared memory realm does not exist
I have this error when I try to connect to a 8.1.7 database instance. I don't really know what's happening. To give just an information, on the server machine I've 2 database engines (7.3.4 and 8.1.7) and on both engines there are 2 or more instances running. I've only one listener.ora file for both engines, with the correct ORACLE_HOMES Thank you folks ... @biy @lemu [EMAIL PROTECTED] Cril Telecom Software France
db_name, instance_name, service_names and the sqlnet alias
What is the relation between db_name, instance_name, service_names and the sqlnet alias for an instance. 'Cause in my init.ora file I fdefined the following things db_name = "db1" instance_name=inst1 service_names=service1 And I defined an entry in my tnsnames.ora file, for my instance as following : cs_inst1 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = TCPCOM) (PROTOCOL = TCP) (Host = alpha) (Port = 1527) ) ) (CONNECT_DATA = (SID = db1) (GLOBAL_NAME = cs_inst1) ) ) But I cannot connect to my instance by the following command . sqlplus system/manager@cs_inst1 I've no error message. It seems working indefinitely. What did I miss? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ALEMU Abiy INET: [EMAIL PROTECTED] 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: [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).
RE: Replicating between Solaris / NT
Yes, It works perfectly. We tried it for a one-directional replication. Master site on a Unix box and the snapshot on an NT (both have 7.3.4 of Oracle engine). -Message d'origine-De : Rahul Dandekar [mailto:[EMAIL PROTECTED]]Envoyé : jeudi 22 mars 2001 17:38À : Multiple recipients of list ORACLE-LObjet : Replicating between Solaris / NT Nandini, Can we replicate between two databases on different OS? Should not be a problem I guess. But still curious... Has anyone tried? 816 Solaris <>816 NT -Rahul
RE: Free Oracle DBA tests on the web
Dead link -Message d'origine- De : Ron Rogers [mailto:[EMAIL PROTECTED]] Envoyé : mardi 20 mars 2001 19:32 À : Multiple recipients of list ORACLE-L Objet : Re: Free Oracle DBA tests on the web Andrey ' Electronic books can be found at: RUSSIAN FREE BOOKS HTML FORMAT_+++ http://docs.rinet.ru/ ROR mª¿ªm >>> [EMAIL PROTECTED] 03/20/01 12:36PM >>> Hi DBAs ! I'm looking for some FREE Oracle DBA / developer resources on the web : self-tests , OCP preparations materials , articles , books , etc ... Please share your resources ! Thanks a lot in advance . Andrey . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] 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: [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.com -- Author: ALEMU Abiy INET: [EMAIL PROTECTED] 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: [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).
