Title: Message
Well,
that is because of your understanding of the word "failover". Don't be confused,
there are other words
in
desperate need of redefinition, too. One of them is "unbreakable".
To
make the long story short, "FAILOVER=ON" makes possible for Oracle*Net to
skip the non-func
So I have RAC setup ( Solaris 2.8 , Veritas DBE/AC 3.5 MP1 and HDS disks if you are interested) and I am attempting to setup my failover and loadbalancing from a client.
I brought down VLDBN1
and Thought I should fail over to VLDB2 ... but I did not.
Here is what I have in my tnsnames.ora
Title: Message
unable to allocate space of size 48 (couple of time
50).
run as root too so no ulimits ...
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly perso
I sure hope so. Then he/she should be publicly tarred & Feathered.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Tuesday, August 26, 2003 4:45 PM
To: Multiple recipients of list ORACLE-L
I doubt they will ever find the real guy behind this.
Tanel.
--
Viktor,
By using an inline view, count_web does indeed become a column.
Did you try the query?
Jared
Viktor <[EMAIL PROTECTED]>
08/26/2003 01:29 PM
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
cc:
Subject: Re: SQL HELP!!!
Jared,
T
select id, received_date,
count(count_non_web) non_web_count,
count(count_web) web_count
from
(select id, to_char(received_date, '-mm') received_date,
(case when seq_no <= 4000 then 1 else null end) count_non_web,
(case_when seq_no > 4000 then 1 else null end) count_web
from t
where received_da
No need to do it quite the way you are attempting.
c:> namesctl dump_tnsnames c:\temp\tnsnames.txt
worked fine for me. The default server is ns_ns1
Had I wanted to do this from another server, say ns2, I would
have gone directly into namesctl, then issued the command
'set server ns_ns2'
Jar
Jared,
I had a temporary brain freeze :), thanks much! I have modified it a bit, and it seems to be working fine! One other small thing. Is there a quick wahy to calculate percentage of web/non-web and vice-versa in the same select after the column "sums"?
select distinct id, received_date, su
Title: Message
Are
you sure that your swap space is sufficient?
--Mladen GogalaOracle DBA
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Jamadagni, RajendraSent: Tuesday, August 26, 2003 5:59
PMTo: Multiple recipients of list ORACLE-
You're MUCH too merciful! We should start by infecting him or her with
worms and viruses of the biologic type. :-)
-Original Message-
Sent: Tuesday, August 26, 2003 4:09 PM
To: Multiple recipients of list ORACLE-L
I sure hope so. Then he/she should be publicly tarred & Feathered.
Dic
select id, received_date,
count(count_non_web) non_web_count,
count(count_web) web_count,
(count(count_non_web) / count(*) * 100) non_web_count_percent,
(count(count_web) / count(*) * 100) web_count_percent
from
(select id, to_char(received_date, '-mm') received_date,
(case when seq_no <= 4000
Why the table was created with initial extent as 1700M,
but dba_extents says the first extent is 8M only?
SQL> select initial_extent from dba_tables where table_name='BSIS';
1782579200
SQL> select bytes from dba_extents where segment_name='BSIS' and extent_id=1;
8388608
SQL> select bytes
Title: Message
Nope,
you're the first. What happened? Segmentation violation? If that is so, I'd like
to know, because
not
all of my trace files are small.
--Mladen GogalaOracle DBA
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Jamad
No doubt im in the wrong ball field here but this is what I have
Windows 2k
Server1 Ns1 on 8.1.7.4
Server2 Ns2 on 9.2.0.1.0
[server1]
C:\> start \\server1\bin\namesctl dump_tnsnames C:\mytnsnames.txt
It creates an empty file on my (remote) machine
>From the server C:\> namesctl dump_tnsnames C:
Define "based"?
--
Mladen Gogala
Oracle DBA
-Original Message-
Tanel Poder
Sent: Tuesday, August 26, 2003 4:44 PM
To: Multiple recipients of list ORACLE-L
AFAIK, Apples unix is based on [Open|Free]BSD as well.
Tanel.
Note:
This message is for the named person's use only. It ma
Dave,
Thanks much! I appreciate your help. One other thing I might have forgotten is there a way to calculate non_web_count - to - total %
and web_count - to total %
so in this way:
output would be like:
ID YEAR NON WEB % WEB %NON-WEB
AC 2003-01 47 9
Jared,
Thanks for your fast reply! Sorry if I didn't explain myself clear enough. Unfortunately count_web is not a column, id||yr||seq_no||ck is a combination of 4 columns that make up a primary key. if seq_no >4000, in a id||yr||seq_no||ck row, it's a "web row", if not then it's not. what I woul
Hi!
In one migration of about 600GB DB I used 2 dblinks (loading different
partitions in parallel with separate statements), then added 3rd link after
what the bottleneck seemed to be the network. (I saw full network
utilization from perfmon on windows, wasn't too much of a wait interface
user bac
I'm not sure I entirely understand the result you are trying to achieve.
Perhaps this will help
select received_date, msno, sum(count_web), hardcopy
from (
select id ,
to_char(received_date, '-mm') received_date,
id||yr||seq_no||ck MSNO
CASE WHEN seq_no > 4000 t
Hi!
What do you customers care about? Usability and uptime of their app or
utilization of your server?
If you use direct exp and imp method:
1) you read data from disk (server process from oracle datafiles)
2) you write data to disk (expfile)
3) you read data from disk (ftp reading expfile)
4) yo
Laura, I really believe that you should take the 10046 and then contact
Hotsos.
It may and probably will save you some time and aggravation. They're not
very expensive,
around $50 per file analyzed.
--
Mladen Gogala
Oracle DBA
-Original Message-
Burton, Laura
Sent: Tuesday, August 26,
dump_tnsnames can take a path/filename arg
ie. namesctl dump_tnsnames $ORACLE_HOME/network/admin/tmpnames.txt
John Kanagaraj <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/26/2003 12:29 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[E
Yes starting from db version 8.1.7 for 11i. For 8.1.6 there was no such
requirement IIRC.
I tried to be smart and ignored the recommendation once when upgrading to
8.1.7 - the result, some queries which were using a view (which name I don't
remember anymore) got extremely slow. I learned a lesson.
Thanks for your input. Discussion here is to keep maximum use of dblinks for
data load/transfer from one server to another.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 26 Aug 2003 12:49:27 -0800
You can also close the dbl
He's with Saddam, Mullah Omar and UBL.
--
Mladen Gogala
Oracle DBA
-Original Message-
Tanel Poder
Sent: Tuesday, August 26, 2003 4:45 PM
To: Multiple recipients of list ORACLE-L
I doubt they will ever find the real guy behind this.
Tanel.
- Original Message -
To: "Multipl
I have a vendor application that is running slow. I looked at the code
through a product called SQLab and found that most of the code has a
ROW_ID hint coded in it. My understanding is that this hint will
prevent the code from using indexes even though the tables and indexes
are analyzed. I modi
Hello,
I was wondering if someone can help me with a report. I am stuck figuring out what I can do to complete it. Here is what I need to do:
for a given date range, i..e. start_date - end_date ('01/01/2003', '12/31/2003'), I need to count all "web", and "non-web" records. If seq_no > 4000, th
You can also close the dblink to avoid having many open idle sessions on the
remote database.
alter session close database link dblink;
Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tel. (514) 499-7999 7470 and (514) 925-7187
[EMAIL
Title: RE: Performance Problem
Funny ...
I have tkprof give up analyzing a 4.2G tracefile on a 64bit platform. anyone else experienced this??
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expresse
AFAIK, Apples unix is based on [Open|Free]BSD as well.
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, August 26, 2003 8:24 PM
>
> And of course, there's the other free UNIXes - the BSDs (OpenBSD, FreeBSD,
> NetBSD). Tragically
I doubt they will ever find the real guy behind this.
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, August 26, 2003 10:19 PM
> For all you virus/worm lovers out there, justice do come:
>
> FBI Subpoenas Arizona ISP In Sobig
Title: Message
The current situation is that some rebels still
suggest storing your database on non-protected storage and come ask for help
here when their entire database (including last 3 months archivelogs) crashes
with this single disk..
Tanel.
- Original Message -
From:
Liunx was initially meant to be a posix standard and minix compatible OS
running on 386 for hackers and computer enthusiasts. Even Linus himself
didn't predict it's growth and current status at first. At first it wasn't
even completely independent, it used minix formatted filesystems etc..
But even
Laura,
You might find the problem by checking the things you plan to check, and
by following the advice of the book you're using. But the odds are very
good that you will not. At least not for a long time...
Any application program on your system can tell you where it is spending
its time. Let it
Roger,
1. Space management can be specified for a tablespace, not a segment. Create
ASSM tablespace and alter table ... move there.
2. Locally managed tablespace, I guess. Oracle doesn't need NEXT_EXTENT and
PCT_INCREASE then.
HTH
Vadim
-Original Message-
Sent: Tuesday, August 26, 2003
I was
not getting result from set_ev because I used set_ev(sid,serial,10046,8,null)
instead of set_ev(sid,serial,10046,8,'')
I
thought that null and '' can be used without
difference.
Stephane Paquette
Administrateur
de bases de donnees
Database
Administrator
Standard
Life
www.s
Hi,
I have the following output when I querying dba_tables.
Question 1: This table is created using manual management method, right?
What do I do in order to turn it to Automatic segment-space management?
Question 2: How come there are no values for NEXT_EXTENT and PCT_INCREASE?
Tha
Tanel,
A quick question? How many open dblinks you have used at one time without
any issues? Default setting in init.ora is 4(if I am not wrong) and I never
used it more than that. If Dennis wants to use more than 4 dblinks at one
time, he should modify this param(open_dblinks) in init.ora, rig
Tanel
Thanks for the ideas. My simple mind says that by fully utilizing the
hardware I can minimize the overall time. But today we were on a conference
call with the application vendor and they were touting their utility for
handling this. Everyone around the table seemed pretty impressed, so ma
Bob,
I understand what you are saying (and your pain). My suggestion would be to
use the 'namesctl dump_tnsnames' command to dump out the current Onames
repository to the PC's $TNS_ADMIN dir via a login script or SMS. You might
want o rename the current TNSNAMES.ORA file just prior to that as
dump
No, I had read not to analyze the sys tables in the 'TIP' section of the
book I am using as a reference (Oracle Performance Tuning/Tips &
Techniques). As I stated earlier, I also made sure that I analyzed all
the tables and indexes that were involved, because I had read that
leaving a table 'un'an
This would be alot of extra work and downtime compared to export/import but...
1) upgrade to AIX 4.3.3 You might want to think about using AIX 64 bit here
(you can still run Oracle on 32 bit if you want).
2) upgrade to 8.1.7.4
3) AIX 4.3.3 is binary compatable with 5.1, so you _could do
For all you virus/worm lovers out there, justice do come:
FBI Subpoenas Arizona ISP In Sobig Probe
Easynews says it's cooperating with the bureau to find the person
who uploaded the virus to a Usenet group it hosts.
informationweek.com/story/showArticle.jhtml?articleID=13800091
Dick Goulet
Sen
linux from unix?
>
> From: "Mladen Gogala" <[EMAIL PROTECTED]>
> Date: 2003/08/26 Tue PM 02:34:28 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: Re: OT - Linux books ??
>
> Different from what? It's very different from NT kernel.
>
> --
> Mladen Gogala
> Orac
Different from what? It's very different from NT kernel.
--
Mladen Gogala
Oracle DBA
-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, August 26, 2003 1:40 PM
To: Multiple recipients of list ORACLE-L
i thought linux was just unix designed to run on a PC. how different is the
kernel
If you cannot recover the database, you *** CAN *** take a cold backup
and open it elsewhere, on a 5.2 box, for example. You only have to make sure
that you loaded the right post_wait extensions. I advise you to use the ones
from 9.2. Boot the machine in 32 bit mode. No migration is necessary, col
Did you analyze the sys schema by mistake. This can stop the fastest
database. We had a contractor do that to an 8.0.5 database once, and only
once.
Ruth
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
> Burton, Laura
> Sent: Monday, August 25, 2003 4
Turn off the machine.
--
Mladen Gogala
Oracle DBA
-Original Message-
Sent: Tuesday, August 26, 2003 1:34 PM
To: Multiple recipients of list ORACLE-L
Hi Gang ,
I have some upgrade script from vendor ( no source code ) which calling some
procs . Now I am getting "buffer overflow, limit
looks like internally from proc its setting dbms_output.enable();
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, August 26, 2003 11:04 AM
> talk about unprofessional... this stuff should never go into production.
which vendor is i
Forgot the smiley!
And, to make up for that, I ran a simple test and found that 'set
serveroutput off' solves the problem.
My code:
BEGIN
dbms_output.put_line('sysdate: ' || sysdate);
END;
/
with serveroutput on started dumping data to the screen in about 5 seconds.
With serveroutput off I h
The SCO Linux litigation that is raging right now is such a nightmare of FUD
and absurd legal process. For starters, SCO's UNIX implementation is dead
in the water - not only was it the worst UNIX I've ever worked with, but
even SCO has no plans to aggresively continue development on it. Only th
I am sure you will pissed of , if I turn off your machine . ;)
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, August 26, 2003 10:44 AM
> Turn off the machine.
>
> --
> Mladen Gogala
> Oracle DBA
>
>
>
> -Original Message-
> Se
talk about unprofessional... this stuff should never go into production. which vendor
is it? ill aviod?
cant you juse set serveroutput off? to turn off the output?
>
> From: Kevin Toepke <[EMAIL PROTECTED]>
> Date: 2003/08/26 Tue PM 01:44:42 EDT
> To: Multiple recipients of list ORACLE-L <[EMA
Just fyi - it seems that Oracle had realized this in advance and has
specifically instructed the Oracle Applications 11i installations to set
this to 2000.
John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)
Listen to great, commercial-free christian music 24x7x365 at
http://www.klove.com
** The
The Linux kernel is totally different, though you will find some code in it
that is from System 4 UNIX.
Linux is technically not a UNIX, thought it looks and feels and acts like
one. It's also worth noting that all of the UNIXes have, at this point,
significant differences in terms of their inte
Mladen Gogala scribbled on the wall in glitter crayon:
> AIX phased out in favor of Linux? I believe that SCO asked for
> injunction to prevent IBM
> from distributing AIX, and there is a whole saga around SCO and Linux.
> According to some,
> Unix variants are like higlanders: there can be only
contact the vendor and ask them to remove the dbms_output calls?
-Original Message-
Sent: Tuesday, August 26, 2003 1:34 PM
To: Multiple recipients of list ORACLE-L
Hi Gang ,
I have some upgrade script from vendor ( no source code ) which calling some
procs . Now I am getting "buffer over
AIX phased out in favor of Linux? I believe that SCO asked for injunction to
prevent IBM
from distributing AIX, and there is a whole saga around SCO and Linux.
According to some,
Unix variants are like higlanders: there can be only one. If you ask Mr.
Darl McBride,
it's going to be SCO. Hopefully
i thought linux was just unix designed to run on a PC. how different is the kernel?
>
> From: "Matthew Zito" <[EMAIL PROTECTED]>
> Date: 2003/08/26 Tue PM 01:24:26 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: Re: OT - Linux books ??
>
>
> And of course, ther
I am looking for some expert suggestions for the migration of 300GB database to
different hardware. Currently database is 816 OPS on AIX 4.1 nodes. Database is 32bit
and performance on this system is really slow. Export for 2GB table takes 2 hours. All
the data is on EMC symmetric.
We are plann
Hi Gang ,
I have some upgrade script from vendor ( no source code ) which calling some procs .
Now I am getting "buffer overflow, limit of 100 bytes" error from it . Looks like
they are spitting out debug statmts out with dbms_output . How can I stop this to
happen without touching source co
And of course, there's the other free UNIXes - the BSDs (OpenBSD, FreeBSD,
NetBSD). Tragically, none of these run Oracle (FreeBSD can run Oracle in
Linux emulation mode - which seems backwards at best). And there's OS X,
which is Apple's UNIX, and also runs Oracle.
As far as AIX, I couldn't fin
>From _the Onion_'s what-do-you-think regular feature, when the news
about Uday & Qusay was more recent:
"It's great that we got Uday and Qusay. But what about the eapons-way
of ass-may estruction-day?"
I'm still laughing at that one...
www.theonion.com
Roy Pardee
Programmer/Analyst/DBA
SWFPAC
Hi!
What is your goal? To finish data transfer in the shortest time or keep
hardware utilization maximum during transfer?
I think you should concentrate on keeping the time for doing data transfer
low.
Depending on your network - in case of gigabit (or 10 Gb) you could look at
enabling jumbo fram
Title: DBASSIST HANGS
Hi list,
I manage to install 8.1.7 on RH AS 2.1. From Note 230693.1 I downloaded the jre118_v3 patch from blackdown, applied and the dbassist start, but I'm getting ORACLE NOT AVAILABLE.
No more in metalink.
TIA
Note: Why to deal with Linux is so difficult.
R
Reginald,
No, FGAC (or VPD or RLS, depending on who you ask) is not about columns;
it's about restricting rows. Within the selected rows, all the columns are
visible. Rahul wanted to mask columns without creating views for each user.
This is the only way to do that.
Hope this helps.
Arup
9.2.0.3.0 Enterprise Edition
on Win2K
using the 9.2.0.1.0 client.
export hangs on "exporting object type definitions"
TOAD says that it's trying to 'ALTER TYPE "OE"."ORDER_TYP" COMPILE
SPECIFICATION REUSE SETTINGS'
If I query v$session_wait I get:
SID SEQ#
-- --
E
Rahul:
It sounds like your implementation is very similar, in theory, to Oracle's
Fine Grain Access. Are you re-inventing the wheel?
Reginald W. Bailey
IBM Global Services - ETS SW GDS
I'm Polish and I don't find it offensive. Want some good Polish jokes?
Ken Janusz
Ken Januszewski (prior to 1910)
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, August 26, 2003 11:04 AM
>
> While work related humor has it's place in
Well, IBM has AIX, a very solid and stable version of unix which works
really
well. SCO has become very popular lately and using SCO Unix will turn you
into
the most popular guy on this list. Then there is Irix, made by SGI. HP
actually has
several unix versions Tru64, HP-UX, Tandem Unix, Ultrix,
Rahul,
Glad to know that it worked for you. Yes, I have implemented that and it
works quite well in production.
Just make sure you understand that the columns are not really hidden, just
"masked" - which means they may convey wrong impressions if not used
properly. In my case, I have avoided usin
Is anyone attending the 9i Cram Session on Sunday? If so,
could you please email me off-list?
Thanks,
Brian
[EMAIL PROTECTED]
While work related humor has it's place in the workplace and
on this list, humor for humor's sake should be limited to the
OT list.
There are a *lot* of reasons for this. In the case of this
post, there are folks on this list that will find this offensive.
Thank You,
Jared ( list owner )
On
Yes, it is required in one of our COTS applications.
Inserts into complex views with instead-f triggers.
The views are quite complex, ridiculously so, one might say.
Before setting optimizer_max_permutations=1000, it took a very
long time to parse those views.
Jared
On Tue, 2003-08-26 at 05:44
One thing that the docs don't mention is that '8'
(the default in 8) is also a special boundary value.
Anything less than 80,000 changes some of ways the
optimizer does it work, ie, its not just a reduction
in permutations.
Can't remember the specifics - join orders spring to
mind but there
Corrupting would have been sending the damned dbmssupp.sql and its plb file.
Stephane
-Original Message-
Mladen Gogala
Sent: Monday, August 25, 2003 5:49 PM
To: Multiple recipients of list ORACLE-L
I'm corrupting youth.
--
Mladen Gogala
Oracle DBA
-Original Message-
Stephane
Arun, thanks for suggesting this, this is what i did.
1. created a table to store table names associated column names
and a "security level" for a that column
EMP emp_name 3
EMP emp_sal 5
2. then i granted every users a security level also,
3. then i created a view on the name table
select de
Arun, thanks for suggesting this, this is what i did.
1. created a table to store table names associated column names
and a "security level" for a that column
EMP emp_name 3
EMP emp_sal 5
2. then i granted every users a security level also,
3. then i created a view on the name table
select de
Now that Uday and Qusay have been eliminated, a lot of the lesser-known
family members are coming to the attention of American authorities.
Among the brothers:
Sooflay ..the restaurateur
Guday... the half-Australian brother
Huray the sports f
Title: Message
What
was the final outcome?
Thanks,
Ruth
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Tanel PoderSent:
Monday, August 25, 2003 9:19 PMTo: Multiple recipients of list
ORACLE-LSubject: Re: new server + RAID = ???
I though
Taniel, Binley
Thanks for the excellent suggestions.
At this point we have been testing with two smaller test systems, moving
a single table at a time, but initial indications are that the performance
order is:
1. Perl dump to CSV / ftp / SQL*Loader
2. Copy across database link
3. Export/ ftp
Title: Message
Hi!
Increasing it from it's default won't probaly
help to get a better execution plan, unless you have 10-way or even more
complex joins.
However, having a large value of this parameter
with complex joins can push your parse times (QEP calculations) very
high!
That's why one
Title: RE: Resolved - Row level security and latch waits
Everyone was right ... RTFM and STFW and listening to people on this list always helps.
We are making a better effort with design of the contexts. The developers have been redirected to appropriate sections on the FM.
Raj
---
John - Thanks for the heads-up. My intention is to truncate all tables on
the target system beforehand, so that should reset the HWM. Then I have a
lot of tables to load, so my plan is to load multiple tables simultaneously,
trying for separate RAID sets, but use only a single insert on an individu
Title: Message
So
far, I've had only 2. Everybody hates me and that's the way it should be for a
real DBA. Makes me all
warm
and fuzzy inside.
--Mladen GogalaOracle DBA
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of April
WellsSent: T
Solaris simply requires you to quote your translates
tr '[A-B]' '[a-b]'
-Original Message-
Sent: Tuesday, August 26, 2003 10:10 AM
To: Multiple recipients of list ORACLE-L
what got me for about 2 hours recently was the standard:
tr [A-B] [a-b],(it just means make everything upp
Title: Message
Try
doing strace -af -o /tmp/strace.out dbassist and see what is it waiting
for.
--Mladen GogalaOracle DBA
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ramon
E. EstevezSent: Monday, August 25, 2003 9:54 PMTo:
Multip
so different flavors of linux are more compatible?
i thought the only two unix players out there now are HP and Solaris. who else is out
there?
so is going between unix flavors like going between databases?
>
> From: "Nuno Souto" <[EMAIL PROTECTED]>
> Date: 2003/08/26 Tue AM 09:59:33 EDT
> T
what got me for about 2 hours recently was the standard:
tr [A-B] [a-b],(it just means make everything upper case, now lower cass, its a LOWER
function in SQL) thats even in the oreilly korn shell book.
no solaris has to get cute and make you do:
tr [:upper:] {:lower:]
what i mean by that is s
ah so i was right? wow... with all those posts. I figured i had been mistaken.
>
> From: "Jamadagni, Rajendra" <[EMAIL PROTECTED]>
> Date: 2003/08/26 Tue AM 09:49:34 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Resolved - Row level security and latch waits
>
> T
- Original Message -
> how different is it to administer oracle on different flavors of unix? Im running
> into some annoying nuassances in
syntax between solaris korn shell and hp-unix korn shell.
>
> is it just little syntax differences or is there alot more to it?
> >
You sure it's HP
Title: Resolved - Row level security and latch waits
Thanks everyone for your input, the development email is rewriting their code using application contexts.
your help is greatly appreciated.
Raj
Rajendra dot
Not just Sun - SCO Unixware puts it there too.
-Original Message-
Sent: Tuesday, August 26, 2003 9:45 AM
To: Multiple recipients of list ORACLE-L
administering oracle is not really an issue cause sql*plus is sql*plus
regardless, now from the OS side, Solaris can be a pain to bring scrip
Wonderful.
I would like to add:
10.1.23.1) After explicitly instructing them not to, have an analyst
from the other side of the world call you at home, @ 3a.m., waking up
spouse and children in the process.
Brian
-Original Message-
Tanel Poder
Sent: Monday, August 25, 2003 6:29 PM
Hello All
Im back from the trenches to post a quick request for
help
Ive setup onames on 2 servers and standard applications, (our app and
sqlplus) connect just fine, a problem situation manifests itself when:
1 users need to connect (add a database) to dba studio. They get a error
t
administering oracle is not really an issue cause sql*plus is sql*plus
regardless, now from the OS side, Solaris can be a pain to bring scripts
from other *nixes over to the sun world. I've written scripts that work
flawlessly on linux, port to HP, port to AIX all w/NO changes, move to
sun and
Red Hat Linux Networking and System Administration from Redhat press is
very good.
Fraser Talbot
M-I LLC
Database Administrator
Information Technology
832.295.2245
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, August 26, 2003 7:54 AM
To: Multiple recipients of list ORACLE-L
Both
Title: 8.1.7 + redhat AS 2.1 = trouble
There may be the same issues as with 8.1.7 on RH 7.1 - look on Metalink
for those work arounds and try them on your AS 2.1.
Basically, it has to do with 8.1.7 expecting the standard C libraries
from RH 6.2 which were changed for RH 7.1 and la
Title: RE: virus info
50? They like me more... I had 250 between Friday at 2 pm and Monday at 6 am. Several appear to have even gotten through our virus scan and come to my mail box as complete attachments.
Gives you a warm fuzzy feeling
April Wells
Oracle DBA/Oracle Apps DBA
Corpo
how different is it to administer oracle on different flavors of unix? Im running into
some annoying nuassances in syntax between solaris korn shell and hp-unix korn shell.
is it just little syntax differences or is there alot more to it?
>
> From: Dwayne Cox <[EMAIL PROTECTED]>
> Date: 2003/0
1 - 100 of 122 matches
Mail list logo
