Message
as we all know Oracle is unbreakable, so security isn't an issue.
All of these security alerts (see below) that just hit my mailbox must be
just mere formalities :-)
- Dale
http://www.DataBee.com
EMAIL from Oracle below
This e-mail is a critical technical
Just as a possible quick tip:
Have you disabled DML_LOCKs on the most
commonly accessed tables ? Is it possible
to do so on at least some of them ?
Under OPS, some activity which is usually
local latching activity turns into global lock
acquisition. If you have excessive parsing,
with
Title: Message
Hi
Steve
mod_plsql is pretty much a module that allows you to setup communication
between Oracle db and Apache process in a cgi-like way. I have to admin that I
don't know exactly, if the pl/sql engine runs embedded within apache like
mod_perl for instance. But I don't think
snip
Teradata would not be the first product banned. Way back in olden-times the
maker of SQR were banned, but I cannot remember why.
snip
Well, I can answer that. SQR began life as a report writer with procedural
capabilities. It arrived before PL/SQL, and was the first 4GL which provided
I believe SQR was bought by Sybase so Oracle didn't want it at the
conference.
I remember IOUW in Miami (in '91 I think) SQR had an RV outside the
conference hotel because they were not on the exhibit floor
--- Robson, Peter [EMAIL PROTECTED] wrote:
snip
Teradata would not be
Absolutely true !!!
That's why I want to keep most of the things in the database and minimum at users end.
It will be easy for us to maintain and control.
Microsoft tools must be kept away from oracle otherwise our life will be hell. Let's
hope somebody will write a book. (Before that let's
Title: Q: about x$kglob
Hi List,
I've created a view
create view sys.x_$kglob as select * from sys.x$kglob;
This view shows the actual running sql, include procs, functions...
Q: How can I find out which session calls the SQL?
TIA
Volker Schoen
E-Mail: [EMAIL PROTECTED]
After my nightly cold backup and during the database startup I got this error;
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [3051], [82], [73], [], [], [], [], []
ORA-04030: out of process memory when trying to allocate 8389132 bytes (pga
heap,THREAD RECOVERY)
The
Thanks for all the replies. The reason I asked is because dbca calls some of these
items Standard Database Features.
Steve - I think that the mod plsql is the module that let's you generate html using
PL/SQL (htp and htf pl/sql packages).
Jay
[EMAIL PROTECTED] 02/13/03 06:19PM
Thanks
Hmmm - I wonder if we are talking about the same company? The SQR product I
know of came out of a US company called MITI (Long Beach, CA), and was
marketed in UK by SPS. It was originally a report writer for Oracle, but
developed the programming side to such an extent that it became (like
PL/SQL)
select distinct b.sid,
b.serial#,
substr(b.username, 1, 8) USERNAME,
b.process,
substr(c.segment_name, 1, 8) SEGMENT_NAME,
bytes BYTES,
substr(b.osuser, 1, 7) OS_USER,
substr(b.machine, 1, 6) M_NAME,
substr(b.program, 1, 12) PROGRAM
from
Yes it is my understanding he does not have any online redo or archive logs
current or backups. He just has current datafiles
where the database will not start because of no online redo so I can assume
those have been lost,corrupt,etc.
Thanks
Rick
Quick question, I want to find out what sql is currently using my temporary segments. Is their a simple solution. Am getting the ORA-1652 for my locally managed temporary tablespace and I would like to find out what sql is causing this. My temp tablespace is currently 1.2GB.
Oracle 8.1.7.3 on HPUX
Someone suggested a reboot so I figured I would start by just shutting down the Oracle
database service. I restarted the service and the database is up and running. You
gotta love the windoze OS. When in doubt reboot the service or the server.
Dave
-Original Message-
Sent: Friday,
OS and version?
Possibilities from Metalink:
Increase the SHMMAX kernel parameter to 2139095040 (2Gb-8Mb).
See note 70240.1
Jay
[EMAIL PROTECTED] 02/14/03 06:33AM
After my nightly cold backup and during the database startup I got this error;
ksedmp: internal or fatal error
ORA-00600:
The metalink note is out of date - newer versions
of Oracle use the first 31 characters to build histograms.
Of course, if you have a column of URLs for Google search
results which all start with:
http://groups.google.com/groups?hl=engroup=comp.databases.oracle.serv
er
then you may have to
encoded content removed -- binaries not allowed by ListGuru
The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists. If you want a copy of the attachment which was
removed, contact the sender
I think so... Matt Reagan used to run the SQR roundtable discussions at
IOUG back when SQR was allowed on-site
Don't know who owns it now, I could try to ask Matt -- he'd have all
the background and history on it
Rachel
--- Robson, Peter [EMAIL PROTECTED] wrote:
Hmmm - I wonder if we are
8.1.7 on NT. Got it fixed though.
Thanks,
dave
-Original Message-
Sent: Friday, February 14, 2003 6:21 AM
To: Farnsworth, Dave; [EMAIL PROTECTED]
OS and version?
Possibilities from Metalink:
Increase the SHMMAX kernel parameter to 2139095040 (2Gb-8Mb).
See note 70240.1
Jay
same product. and before MITI, it was owned by Sql Solutions.
I still think it was one of the coolest - and easiest - batch
updating/reporting products on the market. I bought it and we converted
about 750,000 lines of Cobol code to Oracle forms and SQR back in the late
80's early 90's. And
From: Janet Linsy [EMAIL PROTECTED]
Date: Thu, 13 Feb 2003 13:59:04 -0800 (PST)
Subject: AT command ??
Hi all,
Can anyone give me some examples of AT command in
windows? Thank you!
Janet
C:AT 00:00 /every:T,W,TH,F,S cmd /c F:\Oradba\b73\cold_backup.cmd
Schedules command file to run at
Dave,
When I've seen this, it's usually because I have added a new database on the
machine and the various SHM kennel settings are no longer appropriate for
all the instances. Have you added a new instance since the last time you
restarted this instance? How long has the machine been up, it
Title: RE: {SPAM?} RE: Teradata baned from IOUG???
SQR is now incorporated in Brio product range ... ask me, those (SQR coding) are some painful memories ...
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Looks like memory leak, and fixing it by restarting Oracle service proves
it.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, February 14, 2003 7:23 AM
Someone suggested a reboot so I figured I
SQR, in its latest form, is currently know as BRIO Reports from Brio
Software. Brio acquired the product line about 2 years ago. SQR is heavily
used in PeopleSoft shops and comes bundled in with the PeopleSoft products.
--
he can also try to force the database open by rebuilding the
controlfile and doing a resetlogs. Since he's already lost the online
logs, resetlogs won't cause him to lose anything anyway.
last time this happened to me, it took about 25 hours straight, lots of
money and Data UnLoader from Field
Title: Message
modperl is an apache modulle that has been coded by Oracle which allows
for the execution of SQL and PL/SQL from the apache server.
Allan
-Original Message-From: Orr, Steve
[mailto:[EMAIL PROTECTED]] Sent: Thursday, February 13, 2003 5:20
PMTo: Multiple
Well if all he really has is *current* on line files then he's dead. He
needs some copy of the database that has been shutdown cleanly and so
has all comitted data on disk. His current online copy presumably won't
start because he can't meet that condition. With the database knowing
that the
My box too. Overblown marketing always makes the opportuity for cynical
humour irresistable. :-)
-Original Message-
Sent: Friday, February 14, 2003 1:59 AM
To: Multiple recipients of list ORACLE-L
Message
as we all know Oracle is unbreakable, so security isn't an issue.
All of these
Well, I wasn't actually correcting you.
Just thought you knew something about dynamic SQL that I
wanted to see. :)
Jared
On Thursday 13 February 2003 10:29, Jamadagni, Rajendra wrote:
hmmm...
I shouldn't work on two emails at the same time anymore... Can't work in
parallel.
The
Query from user. can the following be done in PL/SQL?
I need to be able to lock a table in such a way that not only can no other
session alter any records in the table, but they cannot read the table at
all (i.e. do SELECTs on it) until I'm done with it.
Any SELECT statements would pause
We looked at SQR in 94.
We didn't have need of controlling fonts and such, which I guess
SQR is good at.
The SQR rep could come up with no compelling reason to use SQR
rather than Perl, so simple ( as in not much procedural processing
needed ) reports were done in Sqlplus. Anything complex
Hello,
I'm thinking of going to school to get Oracle
certified. There are 2 schools in my area that are offering Oracle certs
but one offers Oracle 8i courses w/ an upgrade to 9i, while the other offers all
9i courses. If i go to the schools who offers 9i courses, would I miss out
on
I want to subscribe to an entry level Oracle mailing list. Do any of you
know any good ones?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Les Ayudo
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
Title: RE: Lock table and disallow select
Aren't we looking for trouble with this scenario? What if you hold lock for more than few seconds/minutes/hours? I'd ask following questions ...
1. Why?
2. Why?
AFAIK one way to do this is to break the synonym pointing to the database, but any
Title: RE: {SPAM?} RE: Teradata baned from IOUG???
Well,
I see one reason ... (I am no expert in Oracle reports), but it seems more maintainable to write in SQR than in reports (so they claim here). Plus SQR can act asa glorified data loader when a bunch of processing needs to be done on
Quoting Farnsworth, Dave [EMAIL PROTECTED]:
8.1.7 on NT. Got it fixed though.
Thanks,
dave
Dave,
Instead of just telling us it's fixed. Perhaps it would be better if
you actually told us how it got fixed, please.
Thank you.
--
Lyndon Tiu
-Original Message-
Sent:
You could probably fake this by renaming the table or playing with
synonyms, or by revoking privileges, but I don't know of a pl/sql command
or procedure that can prevent a user from performing SELECT against a
table. Even then, I don't think the SELECT statement will ever pause until
the lock
Title: RE: URL for Oracle 9i entry level email lists
This list deals with ALL oracle related issues ... so why you want another one?
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed
Look at the parameter fast_start_parallel_rollback
Also check out metalink Note:144332.1
Parallel query servers get 100% cpu
Rob Pegram
Oracle Certified DBA - 8i, 9i
--- Steve Perry [EMAIL PROTECTED] wrote:
I hope somebody can provide me with more information
on parallel rollbacks.
I've
There was a presentation at the recent HOTSOS conference which showed
a performance gain by placing indexes in tablespaces with a LARGE
blocksize.
HTH YMMV
HAND!
I have a problem query which will not complete. This query is part of a report run
within Oracle Applications.
Our versions are: Oracle Server 8.1.7.4, Apps 11.5.3, HP-UX 11.11
Listed below is the query and the explain plan. I ran full statistics on all the
tables immediately before
We had this problem recently- running 8.1.7 (64-bit) and 9.0.1.3 (32-bit) on
Sun Solaris 2.8. Both databases were registered in the same version
9.0.1.3.0 Listener. Oracle Support eventually told me that Listener
versions below 9iR2 do not support mixed bit versions (64- and 32-bit). You
would
I plan on using a product from IBM called Flashcopy, similar to EMC's BCV
(third mirror). Typically, I put the tablespaces in hot backup via
scripting before splitting the third mirror. How can RMAN be used in a
similar fashion? Can RMAN put the db in a hot backup state so the third
mirror
In Oracle writers do not block readers so even locking the table won't
do it. You could rename the table and do your work on it under the new
name.
Allan
-Original Message-
Sent: Friday, February 14, 2003 9:04 AM
To: Multiple recipients of list ORACLE-L
Query from user. can the
Not to depress you, but at this time, in Florida the DBA job market is
dismal. The best way to move into a DBA job would be do it within your
current organization, i.e. move from developer/sys admin/etc. to DBA. It
would be difficult for an organization to hire a newbie DBA from the
Les,
It depends on what version of Oracle Databases you will be working
with. You won't miss out on information going through the 9i Class
because they will go over features from 8i as well. They are
conclusive of features that have been available before 9i (as long as
they are still in 9i). The
Gene - Hopefully someone will have better ideas than these, but I'll make a
couple of suggestions.
RMAN can issue SQL commands to your target database, so you could try
having it issue the alter tablespace command. Then after you do the backup
you could register the backup with RMAN. Almost
List,
I'm
use to using a standard D=development T=test P=production. So for a
database newly created on development it would be called something like
D24X7. Then when it was created on Production it would be called
P24X7. Or along similar lines.
I'm
working with an other DBA who wants
I have many opinions on certifications... :). First and foremost, why
are you interested in studying Oracle? Is it for the money, or are you
truly interested in working with it? Do you have any experience?
If you aren't sure what you want to do, I suggest learning quite a bit
on your own
I want to strongly recommend the book Perl for Oracle DBA
authored by Andy Duncan (this list's manager) Jared Still.
I've been a DBA for around 7 years have been doing Perl
for longer than that. The code and examples in this book will
be put to good use here; as soon as I get some time to put
9i will cost you more in the long run because you have to take 4 exams
at $150 each plus a $3000 course to get OCP.
8i then upgrade to 9i will cost you less but requires you to take up
to 6 exams at $150 each but no more $3000 course.
--
Lyndon Tiu
Quoting Les Ayudo [EMAIL PROTECTED]:
Title: RE: URL for Oracle 9i entry level email lists
This list seems at like it's a little too advanced
for a beginner. Do you think I should just stick with it for a while to
get familiar w/ some of the Oracle stuff?
- Original Message -
From:
Jamadagni, Rajendra
To:
Are we talking SID or connect string? I seem to remember that there was (or is on
certain OSs) a limit to the length of the SID - so I tend to keep the SIDs short and
sweet. If it is the connect string - then who is it that needs to know it is an
Oracle database? The user? Why? The DBA?
I had
the same arguments with a consultant we had in at one time I compromised with
him. The database files are in a directory called 'oradata' and we use
a
designator of D development, T for Testing, B for Beta, P for Production
and S for Stress Test.
-Original Message-From:
I agree with Raj - why does your user want to do this? Nobody will see the changes
until a commit occurs anyway.
Jay Hostetter
Oracle DBA
D. E. Communications
Ephrata, PA USA
[EMAIL PROTECTED] 02/14/03 10:04AM
Query from user. can the following be done in PL/SQL?
I need to be able
My question was specific to RAC: With a larger block size, is one not
increasing the chances of pinging for the blocks? Or I dont need to worry
about it with Cache fusion? A new worry for me now is that, though the
block size was changed from 2K to 8K, the recommendation was to keep the
SGA the
Title: RE: URL for Oracle 9i entry level email lists
Les,
stick around ... I am no expert, but there is so much to learn ...
Raj
__
Rajendra
Jamadagni
MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot
com
Any opinion expressed here is
At 12:03 PM 11/28/2002 -0800, Tim Gorman wrote:
Q:
How many people use the SYSOPER privilege?
...just
curious...
Please respond only if the answer is
affirmative -- I suspect the number of responses will be quite
small...
P.S. I have never
worked at an place where it is used, of which I'm
I changed my sort_area_size to 1M (down from 5M) and the query completed in 18 seconds.
We had set sort_area_size to 5M at the suggestion of Oracle or other reasons. Looks
like it's time to set it back.
I ran the disk_sorts query and it returned this:
DISK_SORTS AVERAGE_SIZE PEAK_CONCURRENT
Les - I think the demand isn't so good right now, but the whole tech field
is a little depressed. If you can tell a little more about your background,
we could help more, like whether this sounds like a logical next career step
for you. The demand varies a lot by the area of the country, so
Melissa - You didn't mention which system you are on. My comments apply more
to Unix.
Oracle warns not to make the instance name too long. Formerly they
recommended you keep it to 4 characters. Not sure how that would apply
today. It does make your processes long.
My #1 objective is to make
FWIW - this locking scheme is different than some of Oracle's competition.
in SQL Server Sybase writes can block reads. even on those platforms
locks should be at the block or row level, but can escalate to the entire
table. but reads do wait for writes to complete. at least it used to be
that
Title: RE: Database naming conventions
Thanks, I Talking about the SID.
I got my smile for the day, putting version etc. in would certainly add to the absurdity.
-Original Message-
From: Jay Hostetter [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 14, 2003 11:59 AM
To:
Title: RE: Oracle 8i or 9i ?
The $3000 is true if he takes them through 'oracle' university but not if the local community college offers the classes.
What I did (and it seemed to work fine) for my 8i certification is to go to the community college bookstore and just buy the 'official'
One ought to be able to. We haven't tried, since we've been using mod_owa
www.sharemation.com/~dmcmahon/modowa.htm
, for historical reasons. Since it is working well for us
we haven't tried to replace it with mod_plsql.
One reason we went with our own Apache build was because Oracle's version of
There is always DUL if all other options have gone south.
Jack
-Original Message-
Sent: vrijdag 14 februari 2003 15:39
To: Multiple recipients of list ORACLE-L
Well if all he really has is *current* on line files then he's dead. He
needs some copy of the database that has been
School A (www.idtnetwork)which is offering the Oracle 9i cert will cost me
$3595 and does not include the tests. They told me they are an Oracle
University and they are the only ones (besides Oracle) that can give grant
Oracle 9i certs. Is this true? The classes they are offering are:
1Z0007
That is usually done by the application. You can attempt to
acquire a user lock in the share mode (ULS) before executing the
select and lock it in the exclusive mode (ULX) for admin purposes.
That is usually done through DBMS_LOCK package.
-Original Message-
From: John Dunn
OK, I'm reading thru Wolfgang Breitling's Fallacies of the Cost Based
Optimizer from the link below. Of course, I've got questions!
The data presented on pages 5 and 6 just don't jive. How many systems can
do a query with twice as much physical I/O in less than half the elapsed
time and CPU
Title: RE: URL for Oracle 9i entry level email lists
I
think you'll find that everyone on this list was a beginner at one time and I've
had people graciously answer some questions of mine that were pretty basic
(read: stupid :-). At the very least, people will point you to resources
or
Hi all,
Thank you for those sending me AT examples. I
scheduled a job successfully, but it doesn't run at
the scheduled time. The status shows Error. Do I
need to setup something first? (Windows 2000)
By the way, I try to run a backup.bat. I have a,b,c
subdirectories under D:, and I'd like
I concur. I've already recommended the book, this is
a good opportunity to re-iterate my recommendation.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Friday, February 14, 2003 11:35 AM
To: Multiple recipients of list ORACLE-L
Subject: Perl for Oracle
OH yea, thanks for point that out. Forgot aobut the GNOME stuff.
Guess which one I like between GNOME and KDE? (hint, hint). :)
-Original Message-
Sent: Thursday, February 13, 2003 6:43 PM
To: Multiple recipients of list ORACLE-L
Quoting Richard Ji [EMAIL PROTECTED]:
Very detailed
From: Paulo Gomes [EMAIL PROTECTED]
Date: Thu, 13 Feb 2003 12:04:56 -
Subject: Sizing databases
Hi people
Need some to fresh size a new database (9iR2, or other).
Any one happens to know were i can get such tool???
Please
Paulo Gomes
I don't believe there is a one size fit's all tool for
When I quoted the prices, I quoted exam prices alone. Education costs
are extra. FYI - I got my OCx without going to school. Work experience
and self study were all I needed.
--
Lyndon Tiu
Quoting Les Ayudo [EMAIL PROTECTED]:
School A (www.idtnetwork)which is offering the Oracle 9i cert will
Title: RE: Oracle 8i or 9i ?
I'm more ofa windoz SA and have been working
with a little Unix here there for hte past 2yrs (RH, Mandrake,
Solaris). What I really want to accomplish is to switch to Unix and
Databases. My goal is to use my certifcation as a way to get my foot in
the door
John,
No.
Dick Goulet
Reply Separator
Author: John Dunn [EMAIL PROTECTED]
Date: 2/14/2003 7:04 AM
Query from user. can the following be done in PL/SQL?
I need to be able to lock a table in such a way that not only can no other
session alter
thanks
Paulo Gomes
-Original Message-
Sent: sexta-feira, 14 de Fevereiro de 2003 18:05
To: Multiple recipients of list ORACLE-L
From: Paulo Gomes [EMAIL PROTECTED]
Date: Thu, 13 Feb 2003 12:04:56 -
Subject: Sizing databases
Hi people
Need some to fresh size a new database (9iR2,
there is no reason to call the database ora.
I understand the reasoning behind and the desire for naming
conventions.
What happens when your shop decides to go with MySQL (as this list has
been talking about)... will he want to rename the database to
mysqlt24x7? will he even be allowed to
Melissa,
My naming convention is to have the host name and the database instance
follow it. I have been using ORACLE_SID's that are numeric for years since v6
which helps therefore the 02 database on the server brahms.vicr.com is named
brahms2. Makes life easier identifying where you are.
I thought a little about my response and it occurred to me that my point
might have gotten lost in the details. The point was that the asker of the
question might want to refine the question. That is, was the intent to ask
about a particular OS; or was the intent to ask about a particular
Hi.
I've been on digest mode on this list for quite awhile.
When I received the alert from Oracle this morning, I set the list to
NODIGEST.
I'm just now receiving emails realtime.
I'm sure that this subject was already covered on the list today, so I
apologize in advance for posting a probably
Thanks Dennis
for your suggestions. So it appears in my environment, I am best off
sticking w/ my trusty hot backup scripts. Using RMAN for 3rd mirror splits
doesn't appear to benefit me. Using RMAN to backup to a 3rd mirror would
be less efficient than using EMC BCV or IBM Flashcopy, as
CDE? DECWindows?
-Original Message-
From: Richard Ji [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 14, 2003 12:59 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Unix research source ???
OH yea, thanks for point that out. Forgot aobut the GNOME stuff.
Guess which
Title: RE: Database naming conventions
how about just an 'o'
od24x7
op24x7
you could then use 'u' for udb and 'm' for MySQL, and 's' for SQL Server.
-Original Message-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 14, 2003 10:44 AM
To: Multiple
Melissa,
Ask him if he name all his tables TAB..., java class Java...,
his pet CAT... or DOG... etc?
Richard
-Original Message-
Sent: Friday, February 14, 2003 1:44 PM
To: Multiple recipients of list ORACLE-L
there is no reason to call the database ora.
I understand the reasoning
Raj,
I don't know if you read my earlier response to
this issue. The other concern with a larger block size is the possibility of
"buffer busy waits". You mentioned it was an OLTP app with pretty much 1 row
change per statement. Increasing the block size will mean more rows per a single
Paulo
Consider Oracle-Managed Files, a new feature of Oracle9i. This is discussed
in Chapter 3 of the Database Administrator's Guide. This greatly simplifies
your file sizing decisions.
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/omf.htm#
1656
Dennis Williams
DBA, 40%OCP,
e have ORACLE 8.1.7 on NT server and I login as user wirh
administrator privilege. I tried to connect / as sysdba and got
insufficient prvilege. The procedure are:
1. on DOS window
2. sqlplus /nolog
3. connect / as sysdba
ORA-001031 insufficient privileges
I have been recreate the password
You can see that with a full table scan because of multi-block reads.
Generally, assuming blocking reads and multiblock reads, cpu can be low
as this op is not cpu intensive. With the first plan you've got read
the index, 3 blocks average (head, leaf, and branch) then go get the db
block. More
This reminds me something that happened to me about seven years ago. We had
a head honcho (read DBA manager) who just had a sweet slide from DB2 word to
Oracle and as one of the first things he suggested was to rename all the
tables to be prefixed by USERTAB_ and all the views by USERVIEW_, and
Is anybody aware of a freeware metadata repository tool that is configurable
enough to capture metadata attributes that the business would value? For
example, to capture information about columns such as length, aliases, valid
values ... Thanks
--
Please see the official ORACLE-L FAQ:
Title: RE: Oracle 8i or 9i ?
I'm more ofa windoz SA and have been working
with a little Unix here there for hte past 2yrs (RH, Mandrake,
Solaris). What I really want to accomplish is to switch to Unix and
Databases. My goal is to use my certifcation as a way to get my foot in
the
Les,
If you have the self-discipline, another option is to sign up for Oracle
University's Professional Subscription. For $350/year, you can go through as
many of the offered courses as you want, and OCP preparation is one of the
options. The courses are self-paced and online, and each lesson
Title: RE: Oracle 8i or 9i ?
I'm more ofa windoz SA and have been working
with a little Unix here there for hte past 2yrs (RH, Mandrake,
Solaris). What I really want to accomplish is to switch to Unix and
Databases. My goal is to use my certifcation as a way to get my foot in
the
From the readme file, the 8.1.7.4.7. patch for win32 only contains one item
over and above 8.1.7.4.6:
par Bug Base Bug Category Description
\par -
---
\par 2790160 2787968 NET INAPPROPRIATE MESSAGE ON ERROR
Raj, get another cup of coffee, or whatever
your favorite wakeup beverage is. :)
It was 'sqlplus' and 'Perl'.
No Oracle Reports.
Jared
Jamadagni, Rajendra [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/14/2003 07:29 AM
Please respond to ORACLE-L
To: Multiple recipients
hi.
after re-creating the password file, you have to cycle the instance for it
to take effect.
stop and restart the oracle service. (this will kill any connections)
You are better off to login to the instance and perform the shutdown
manually as opposed to just killing the service.
Have you set
Having administrator privileges (actually being a member of
Administrators group) is not enough.
If you want to connect / as sysdba, you should be a member of ORA_DBA
group.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
1 - 100 of 134 matches
Mail list logo