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
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
Hi Dennis
Just curious: How can you get a degree in Computer Science without taking
much Computer Science ? Are you relating to courses in purely theoretical
CS like computability or formal languages, or do you also refer to things
like relational algebra or CS specific math classes in general ?
Hello!
It's me else one :)
When I setup Email Notifications to sysman (sender's email, smtp server,
etc) it cannon send report to me cause of VD-4280 error: The SMTP Server
could not be connected to. Email server is working properly, configured too.
Mail client from the same machine works fine.
OOPs - It is JIT file.
Yechiel AdarMehish
- Original Message -
From:
Yechiel
Adar
To: Multiple recipients of list ORACLE-L
Sent: Sunday, November 23, 2003 5:49
PM
Subject: Re: Oracle 8i installation
First I second Mladen recommendation to install
9.2.
what do you mean by JIT file??
how can i solve my problem?
- Original Message -
From:
Yechiel
Adar
To: Multiple recipients of list ORACLE-L
Sent: Monday, November 24, 2003 12:14
PM
Subject: Re: Oracle 8i installation
OOPs - It is JIT file.
Yechiel
I have an online backup of my 9i production database on CD. I want to
restore it to my home PC, which has a completely different file structure
and an empty database. I did the backup with rman. I spent most of
Saturday trying this and can not even get rman to look at the backup set on
the CD.
You need SMTP server and it is a different kind of server from the e-mail
server.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, November 24, 2003 11:24 AM
Hello!
It's me else one :)
When I setup Email Notifications
There is a problem installing oracle 8i on P4
machines.
Copy the installation CD to the hard disk. Search for file
named symcjit.DLL and rename to symcjit.old.
Run the installation from the hard disk.
Yechiel AdarMehish
- Original Message -
From:
Mohamed
Kamal
To:
Actually, it is not. SMTP server is an MTA (Mail Transfer Agent). Outlook
is an MUA (Mail User Agent). The layer that frequently sits between MUA and MTA
is called UTA or User Transfer Agent. That is usually a pop3 server, IMAP
server, or monstrocity called simply exchange. Both MTA and UTA are
Or in scripts wherever you see a jre.exe,
you add a nojit to the command.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Yechiel
Adar
Sent: Monday, November 24, 2003
7:29 AM
To: Multiple recipients of list
ORACLE-L
Subject: Re: Oracle 8i
Still you have installation problem? If this is the case delete entry from
registry/uninstalled/delete files from program file directory and installed.
After that if you still run into the same problem you may try
Go to http://java.sun.com/products/jdk/1.1/jre/download-jre-windows.html
and
Hello,
Data-warehouse application using Oracle 8.1.7.4 on HP-UX 11i
Since our ETL process is running for a long time, have been given the task of
partitioning some of huge tables and check the results. So picked the top 5
sessions (in terms of running time) and got the sql used by
Oracle 9.2.0.1 on Windows XP
Im getting
ORA-28595: Extproc agent: Invalid DLL Path
when calling external procedure.
I know, I specified the correct path to my dll, when issuing
CREATE LIBRARY statement.
I noticed (when switched from 8.1.5 on NT to 9.2 on Win2000)
that dll path
Hi,
1) Did you look at the explain plans in both places?
2) What the difference in size of data?
3) How many times did you run the test?
4) Did you try giving the *RULE* hint and see the timing?"Bala, Prakash" [EMAIL PROTECTED] wrote:
Hello,
Data-warehouse application using Oracle
Igor,
I can't remember exactly where I read it, but under Oracle
9i the DLL or SO file(unix) needs to be in either $ORACLE_HOME/bin or
$ORACLE_HOME/lib only.
Dick GouletSenior Oracle DBAOracle Certified 8i
DBA
-Original Message-From: Igor Neyman
[mailto:[EMAIL
List:
We're trying to design a CRM app. We believe we need
3 tables (Prospect/Customer, Private Party, and
Agency) because those 3 kinds of (potential) customers
have different attributes.
The sales rep should know whether they're looking up
cust, private party, or agency. But what if they
On Sun, 2003-11-23 at 23:54, VirVit wrote:
Well. But, I have Oracle installed by default to d:\oracle
It's structure is:
d:\oracle\
admin
oradata
ora92 (it's my home dir)
Since you're on Windoze, the default for both is
%ORACLE_HOME%/database
Jared
--
Please see the official ORACLE-L
Mladen,
I'm surprised at you. You didn't mention that using SPFILE
makes it possible to put your database in a state that will
prevent it from being started.
ie. alter system set shared_pool=1024m scope spfile;
I doubt many systems could handle that.
Kirti and others convinced me to
Actually, it doesn't. The lib needs to be in the LD_LIBRARY_PATH
with which oracle was started. So, you could do a thing like this:
mkdir /home/mgogala/lib;
cp usrslib.so /home/mgogala/lib
chmod -R 755 /home/mgogala/lib
Could you use partitioned table with partitioning key type:
Prospect/Customer, or Private Party, or Agency?
In this case, if end-user knows type he is searching for, the query will
go to specific partition, if not - it'll deal with the whole table.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
Title: Message
This
is new features of 9.2. The same on LINUX.
oerr ORA 2859528595, 0,
"Extproc agent : Invalid DLL Path"// *Cause: The path of DLL supplied
for the extproc execution is invalid.// *Action: Check if the DLL path is
set properly using the
EXTPROC_DLLS//
environment
Title: RE: Initalization files, etc
Jared,
You can do this with PFILE as well. And to resolve a problem there is (not complicated) solution.
Alex.
-Original Message-
From: Jared Still [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 24, 2003 10:05 AM
To: Multiple recipients
But, in this case you can always start it specifying explicitly
PFILE=... (instead of using SPFILE).
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Jared Still
Sent: Monday, November 24, 2003 1:05 PM
To: Multiple recipients of list ORACLE-L
Mladen,
I'm surprised at you.
Oh, there are several ways for that. One of better would be (the guy is on NT)
something like this:
alter system set spfile='c:\winnt\system32\ntoskrnl.exe' scope=both;
REM Make sure that the user oracle is a local administrator on the
REM machine. That is crucial if we want the next step to
Thanks, Igor.
The problem there is that we did not purchase the
partitioning option.
Guess I'll look into the cost for that.
Thanks!
Barb
--- Igor Neyman [EMAIL PROTECTED] wrote:
Could you use partitioned table with partitioning
key type:
Prospect/Customer, or Private Party, or Agency?
In
Title: Legato
It appears that we have one instance of the Legato Media Manager (whatever it is that ships with 9.2) installed and I can't find documentation on the Legato site or the Oracle site on how to get RID of this version. Can happily get rid of 5.5 or earlier, but can't find how to
Jared Still scribbled on the wall in glitter crayon:
Mladen,
I'm surprised at you. You didn't mention that using SPFILE
makes it possible to put your database in a state that will
prevent it from being started.
i do believe he left that as an exercise for the reader.;-)
yet another way
$ORACLE_HOME/bin is where I put my dll.
Whats puzzling is that it works
under 8.1.5/NT or 9.2/Win2000, but not under 9.2/XP.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Goulet,
Dick
Sent:
Randy
First, you may want to investigate your company's attitude toward
recovering their proprietary data on your personal machine.
I can give you some ideas on your task, but my experience is on 1)Unix,
and 2) Oracle 8i.
I would recommend you purchase Robert Freeman's book Oracle9i RMAN
Barbara,
If you are really modeling the data, you should not
be thinking about, or even discussing, tables, SQL,
foreign keys, indexes, partitioning or any other
physical manifestation.
The point of modeling is to determine if you have
accounted for all the data that is needed.
What do
You can keep them in sync with 3 triggers, instead of one.
Actually, I don't even know how would you keep 4 tables in
sync with only a single trigger.
On 11/24/2003 12:44:25 PM, Barbara Baker wrote:
List:
We're trying to design a CRM app. We believe we need
3 tables (Prospect/Customer,
Yeah, I like that.
Think I'll go run that on my SAP systems right now. The
next reboot should be entertaining.
Jared
On Mon, 2003-11-24 at 10:19, Mladen Gogala wrote:
Oh, there are several ways for that. One of better would be (the guy is on NT)
something like this:
alter system set
A couple of folks have mentioned SCOPE=both.
Sorry, there are a number of parameters that
are limited to SCOPE=spfile, so you can still
screw your database up pretty badly.
The only possible solution is to remember to dump
your spfile to pfile after changes, but there's
always the good
Title: Message
Thanks a lot!
Adding EXTPROC_DLLS=
in listener.ora made it working.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Monday, November 24, 2003
1:15 PM
To:
Barbara,
I totally agree with what Jared said. You should, if your customers
have attributes in common (I guess that the address where you send the
invoice is a good common attribute to start with :-)), have a common,
basic 'customers' table (as seen in the sales rep's eye, somebody you
can
With a view and an instead-of trigger.
Works, not recommended, as it gets complex fast.
Jared
On Mon, 2003-11-24 at 10:54, Mladen Gogala wrote:
You can keep them in sync with 3 triggers, instead of one.
Actually, I don't even know how would you keep 4 tables in
sync with only a single
Well!! You didn't say itthat eXtreme Perversion was the
OS.
Dick GouletSenior Oracle DBAOracle Certified 8i
DBA
-Original Message-From: Igor Neyman
[mailto:[EMAIL PROTECTED]Sent: Monday, November 24, 2003 1:20
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
My bad.
Thanks to everyone who replied.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Goulet,
Dick
Sent: Monday, November 24, 2003
3:09 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE:
Actually, since I use HP-UX, I was of the practice to keep a soft link to
all of the SO files that we had in use in a specific directory off of
$ORACLE_BASE. It just saved a ton of other problems. Now since
Oracle in enforcing that my job becomes a touch easier.
Dick GouletSenior Oracle
Thanks, Stephane.
Fortunately for us all, I'm not trying to design this
thing. I'm just trying not to sound too dumb when the
designer asks me questions.
The 3 entities have some things in common, but are
different in scope. (An agency never places an ad,
never has a contract, never gets
I see it referred to on metalink alot. I know its seperate from the rdbms.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California--
RDB was bought from Digital Corporation many years ago. Supposedly a lot of the CBO
was lifted from it.
-Original Message-
[EMAIL PROTECTED]
Sent: Monday, November 24, 2003 1:49 PM
To: Multiple recipients of list ORACLE-L
I see it referred to on metalink alot. I know its seperate from
I would recommend The Data Model Resource Book, Vol. 1. A library of
Universal Data Models for All Enterprises. It has a good started model
for this kind of requirement but doesn't resort to multiple tables for
each relationship. The book alone without the CDROM is under $100 US
and might save
It's another RDBMS... only runs on OpenVMS VAX and Aplha. Used to be owned
by DEC and sold to Oracle a few years back (quite a few years now). Has
many features in common with Oracle Server some of which originally came
from Oracle Rdb and were implemented later on in Oracle Server.
Ken.
The
'explain plan' was obviously different because of the presence of statistics.
The amount of data in both tables were the same.
After
doing a lot of tests and reading, found a better way to get the results faster.
Instead of 'analyze' , am currently
using'dbms_stats.gather_table_stats'
More food for thought:
There is a good chance that the hardware platform is different. I
think that RMAN is not a valid way of changing to a new platform and you
would need to export/import. I'm certain the experts on the list will
correct me if I'm wrong.
Thanks
Stephen
[EMAIL PROTECTED]
Rdb was Digital's database that was coupled with the VMS operating system in
v5 and beyond. It was bought by Oracle in the late nineties because they
wanted a foray into the secure database environment, and Rdb had it all sewn
up, so rather than develop it, they bought it outright. They have
Good catch Stephen. My understanding is that you
-Original Message-
Sent: Monday, November 24, 2003 3:05 PM
To: Multiple recipients of list ORACLE-L
More food for thought:
There is a good chance that the hardware platform is different. I
think that RMAN is not a valid way of changing
My apologies, I bumped the send button.
Stephen - my understanding is that you are correct, the platforms have to be
the same at the binary level - i.e.., both Solaris, both Windows, etc.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, November 24,
does oracle still sell it? why would you buy it over the rdbms?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, November 24, 2003 3:59 PM
RDB was bought from Digital Corporation many years ago. Supposedly a lot
of the CBO was lifted from it.
Friends --
I just had to share this with you! I just got an email recruiting for the
following position:
Oracle 11i Conslutant
There's a list forming in my mind now of things the Account Rep tells the
conslutant on the first day, what the req says, what the response to the RFP
was,
RDB is rdbms (just another rdbms supported by Oracle corp.)
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Ryan
Sent: Monday, November 24, 2003 4:30 PM
To: Multiple recipients of list ORACLE-L
does oracle still sell it? why would you buy it over the rdbms?
- Original
Hi VirVit
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of VirVit
Sent: 24 November 2003 07:54
To: Multiple recipients of list ORACLE-L
Subject: Re: Initalization files, etc
1) What difference between SPFILE and PFILE?
Big one. It's best
Yes Oracle still sells it.
Yes they still develop it - new versions released regularly with new features.
It's integrated with VMS, had clustering for many years, support for Galaxy, existing
applications etc
See http://www.oracle.com/rdb/ http://www.jcc.com/ and more
Bruce
NOTICE: This
I believe it *is* still sold; it is certainly still supported. As to why
you would buy it, I don't know why anyone would have bought it when Digital
was at its prime. I've never liked it. But, it is secure. As of 1993, it
was rated B1, when no other database was higher than C2 (they were bound
www.bookpool.com sells the book for $50. ISBN 0471380237
There is also a Vol. 2 book available.
Dave
-Original Message-
From: Aponte, Tony [mailto:[EMAIL PROTECTED]
Sent: Monday, November 24, 2003 3:05 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: xref table - design
It's still on the price list. Download the latest price list from Oracle
and search for rdb - it's on page 4 out of 9. $40K per cpu - just like
Oracle EE.
Trusted Oracle, to my knowledge, had nothing to do with Rdb. Lots of
useful stuff came into the Oracle code from the Digital guys.
Bellow,
I've got a third party package that connects to Oracle
via OCI and works in HTTP-like (stateless) fashion.
Reviewing raw SQL trace output I don't see a single
commit or rollback there, but there are plenty of
XCTEND tx markers with rlbk=1 (after about every
SELECT statement). Is this normal? Does
Monday, November 24, 2003, 3:49:26 PM, [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote:
rcn I see it referred to on metalink alot. I know its seperate from the rdbms.
Rdb was the database I cut my teeth on. So easy to use. As I
recall, you could create a database with just the following:
CREATE
Reading Cary's Optimizing Oracle Performance, page
91 it says:
A database call with dep=n+1 is the recursive child
of the first SUBSEQUENT (empasis mine) dep=n database
call listed in the SQL trace data stream
Does this apply to the SQL issued from PL/SQL?
I am looking at the simple packaged
Boris
It look like the app's is doing rollback :-(
Have a look in Note 39817.1 Interpreting Raw SQL_TRACE ... for more info.
XCTEND rlbk=(0 or 1) rd_only= (0 or 1)
rlbk : 1 = rollback 0 = commit
rd_only : 1 = read only transaction 0 = none read only
/peter
Boris Dali wrote:
I've got a third
Wait till 10g.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, November 24, 2003 11:29 PM
My apologies, I bumped the send button.
Stephen - my understanding is that you are correct, the platforms have to
be
the same at the binary
Hi!
Rdb was the database I cut my teeth on. So easy to use. As I
recall, you could create a database with just the following:
CREATE DATABASE;
Everything, including the database name, would default. It
was great, especially for learning on.
BTW, you can do this in 9i as well...
Tanel.
up, so rather than develop it, they bought it outright. They have been
telling Digital/Compaq/HP's clients that they were not going to desupport
it
for years, and lots of folks didn't believe them, but, they've lived up to
their words, and even did some development on Rdb (taking it from v5
Hi list,
Need a little help with this, have seen in metalink both ways with and without the
equal (=) sign. What is wrong with this script, am getting an error in SETSIZE; I
removed and the same error.
run
{
allocate channel c1 type disk
format '/u08/backups/rman/BD_%d_%U';
I wrote:
Rdb was the database I cut my teeth on. So easy to use. As I
recall, you could create a database with just the following:
CREATE DATABASE;
Everything, including the database name, would default. It
was great, especially for learning on.
And then Tanel wrote:
TP BTW, you can do
OCI defaults to rollback on transactions on disconnect if
OCITransRollback() has not been called.
Don't ask me for too much detail, as I'm not an OCI programmer,
I just pulled this straight from The Fine Manual.
Jared
On Mon, 2003-11-24 at 16:54, Boris Dali wrote:
I've got a third party
I've forgot to say that it is fully qualified production server with pop3,
smtp, imap protocol support. But there are no events in smtp server logs
from Oracle connection. Oracle cannot connect to it when the network is
okay.
You need SMTP server and it is a different kind of server from the
Have a look at Metalink note 74269.1 How to Test an SMTP Mail Gateway From a Command
Line Interface
This should help determine if the mail connection works outside of OEM - though this
is pretty much covered by the email client working - unless it is doing something
fancy.
Then to obtain
I'am sorry, but right now I don't have access to Metalink cause I'am working
on trial version. If it is not so hard to you, can you post the basics?
Have a look at Metalink note 74269.1 How to Test an SMTP Mail Gateway
From a Command Line Interface
This should help determine if the mail
You might like to give the version of OEM as well - though if you reply to this
message cut the Metalink extracts out to reduce message size
Doc ID: Note:74269.1
Type: BULLETIN
Status: PUBLISHED
Content Type: TEXT/PLAIN
Creation Date: 22-SEP-1999
Last Revision Date: 23-APR-2002
Hello,
On Solaris 8
I can't seem to get the tar command right. I wanted to tar a directory but
EXCLUDE one of the subdirectory in it.
Example:
/home/user01
/home/user01/mark01
/home/user01/mark01/ask.txt
/home/user01/mark01/ghost.txt
/home/user01/mark02
/home/user01/mark02/ask.txt
Hi all,
Would really like to hear any feedback regarding anyone comparing these two .Net data
providers (or even some of the others out there - Datadirect, etc.).
We're at decision making time, and things like the differences in calling stored
procs, returning Ref Cursors, are starting to mean
Just another excuse to read the tar man page. This series of commands
seamed to work in testing. Note the excluded and OK on the tar command
output. As the tar man page states, be careful on the leading and trailing
spaces in the exclude file. As with most Unix commands, DON'T use a - in
the
75 matches
Mail list logo
