oracle 8.1.7.4 .
Thanks,
ak
My boss want me to give kill session privilage one
of the developer here . He doesn't have any dba privilage to see session or
anything . Is there any way I can give likited access to him.
Thanks,
ak
Thanks for reply everybody ,
I was not closing the file , which was causing write not to flush . Solved
now
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, November 18, 2003 10:59 AM
AK,
Do you get INVALID_MAXLINESIZE
. ( this is not a OAS/IAS report ).
Thanks
-ak
How to recycle sbtio.log . Is it same way as
alert.log ?
-ak
what is max filesize for utl_limit.fopen ? I am
unable to past beyond 51K .
-ak
truck_id
load
date_delivered
blah
blah
from
to
This takes care of split cargo ( consigment ) .
-Ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, November 06, 2003 6:44 AM
I remember seeing this question asked on another forum some time
Is there any tool out there that can convert pro*c
codeto pl/sql ?
thanks,
-ak
Is it a freeware :)
-ak
- Original Message -
From:
Karniotis, Stephen
To: Multiple recipients of list ORACLE-L
Sent: Thursday, October 30, 2003 9:24
AM
Subject: RE: proc to pl/sql
Actually
there is. It is called a
consultant.
Because
ha ha ha ha ha ha ha ;)
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, October 28, 2003 5:54 PM
Don't get me wrong, I've recently changed positions and am not interested,
but what are phone skills? I know how to use a phone, and I
S Does it mean that a network with 100 computers of 1 cpu each is almost
equivalent to 100 cpu giant computer ??
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, October 27, 2003 4:39 PM
Rich,
That really isn't 'grid', but I think
to run { restore
databse; recover database } from rman and then apply remaing archived logs from
a separated disk ( not a rman backup ).
Thanks,
-ak
Thanks Dennis for Reply,
My confusion is , does RMAN sees only those archived logs which are backup
using rman or it can use current archived log as well stored in original
format at other disk ?
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent
Thanks Ron ,
This worked . But do you know why it happens . As I said its happening third
time with me . My unix screen behaves weired sometimes it doesn't print any
character I type and some time it prints characters which I never type ( in
this particular case ).
Thanks,
-ak
- Original
. ( here I get confused , since I dont have
latest control file , what are implication , and what should I do )
5. connect to rman
6. run ( set until ...; restore db ; recover
db ; )
Thanks,
-ak
I am also interested in this paer .
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, October 24, 2003 12:14 PM
List,
Anyone has the copy of Steve Adams' 'Seven deadly sins in Oralce' paper.
I
guess Steve presented this in OOW '01
restore.
oyaa i do have free(man)'s guide but that's for 9i .
Thanks,
-ak
- Original Message -
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, October 24, 2003 11:15 AM
AK - This sounds like a disaster recovery test. Be sure to buy Robert
Freeman's Oracle9i RMAN Backup
is there any way trigger I can write so that no
body can compile object (package/procedure) and alter table during business
hours in 8.1.7.4 db.
-ak
and which sql makes server HOT
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 23, 2003 2:14 PM
1) What does it mean to grokkk?
2) What is the answer to the question of life, universe and everything?
3) What happened
This happening with me 3 rd time on this hp box .
When I do ls -alt I can see a file in current directory but when I try to open
it (vi/cat ) it says no such file or directory . I am same user who
created the file . ( no permission problem )
Any idea ??
-ak
/home/ak/myscripts
Same here ,
I delete few mails in evening and they show up
again in morning . I doubted myself 2-3 times ;)
-ak
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, October 22, 2003 8:44
AM
Subject: Re
why one can't do same on widoz as well ?
works well .
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, October 21, 2003 8:44 AM
is this a Unix box?
if so, log on as the oracle account to the Unix server. Then in
sqlplus, login
Hi Guys ,
I have been recently tasked to write up
procedures and steps / documentation for disaster recovery of db/system
.
Any help , pointers ,links related to this is
highly appreciated .
Thanks,
-ak
OCP DBA 8i
Looks like Tanel Podar is hiding some where or
restraining fromanswering ? Missing his highly sophisticated answers
;)
-ak
There is a toll schema manager by quest . Have a look at that as well. I
haven't used it though.
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 10:24 AM
Hi All,
Client would like me to propose a solution
Congrates Dennis ,
Get set for 9i upgrade soon. 10g is on the way :)
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 12:24 PM
I just passed the Net8 Administration OCP exam. This was my last exam, so
I
suppose I
only if your backupset size is more then total_arc_log_file_sizes .
Otherwise there will be more then one pieces , rite ( ??)
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, October 15, 2003 1:19 PM
With RMAN, can I use 'copy
Is it okay to resize datafile while user activity
is going on ? version 8.1.7.4 hp-ux .
-ak
Rajesh ,
I think in 9i dataguard this task became little easier . It doesn't take
that much time to change role of database from primary to standby and vice
versa . That's what doc says I haven't tried it myself though.
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L
to 0 this table is still coming in my list of monitored exntents
which doesn't have room for next growth.
Question is , when does oracle calcs next space
requirement ? It looks like its precalculated .
-ak
Just curious ,
If Ibuy named user licence and use some
application to connect using same user (Just like any app server with
connection pooling ) does the cost multiply to no of
user_connecting_to_app_server or no_of_users_actually_connected to
database( mean schemas) ??
-ak
I think
' begin
mystorageArray.field_''i'' := 1;
end; ';
will not recongize mystoragearray as a variable .
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 11:49 AM
Im on 8.1.7. Is it possible to do
This will set your current schema to act like sys so that you no longer
need a qualifier like sys.v_$instance . This is another way to avoid public
sunonym . ( btw, do the people here use public synonym , i see tom kyte is
against it )
-ak
- Original Message -
To: Multiple
where can I get binaries for perl DBI and DBD for
hp-ux 9000 . I dont have pre requisite for building binaries from source
.
Thanks,
-ak
How to one subcribe to
Comp.database.oracle newsgroup . Can it be added into outlook
directly .
thanks,
-ak
I don't remember appearing this one in exam .
-Ak
OCP 8i
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, September 29, 2003 2:34 PM
Can anyone recall whether the Oracle Intelligent Agent figured on the
Oracle8i OCP Network Administration
(numer or value error) -- get proper exception
result=false
return result;
end;
same can be done for isDate as well.
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 25, 2003 8:34 AM
Hi All,
I am
In US it is called take the exam while in INDIA it is give the exam . ug
need ANSI english .
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, September 24, 2003 2:14 PM
Give or take the exam? Makes a big difference
program work.
-ak
- Original Message -
From:
Stephane Paquette
To: Multiple recipients of list ORACLE-L
Sent: Friday, September 19, 2003 8:59
AM
Subject: Reducing the number of
databases
Hi,
We have around 120
databases. Most applications have 5
che/apache/htdocs/.. . I want it to look for
index.html in c:/myweb/ .
Am i missing something here .
-ak
Never mind, its working .
-ak
- Original Message -
From:
AK
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, September 16, 2003 11:39
AM
Subject: oracle Apache
thought about playing with apache ( shipped in
oracle cd ) . It's a win 2000 system
Is there some changes in default archivelog file
format with oracle 9i ?
-ak
is generated then you can first install same
version of databases asoriginally thenrecover till current date and
migrate to 9i finally . But yeah during 9i migration I guess you will need some
downtime .
-ak
- Original Message -
From:
Chindarkar, Chetan (CONS FIN ,
Contractor
Title: Message
You can user perl package manager in activestate .
from ppm command prompt issue "search dbi" or "search dbd" and then issue
install dbd /dbi.
-ak
- Original Message -
From:
Mladen
Gogala
To: Multiple recipients of list ORACLE-L
--
Author: AK
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail
:
AK
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, August 27, 2003 9:09
PM
Subject: oracle sessions from term
server
Hi Guys ,
we have forms/report application installed
on windows terminal servers and user access application from
Congrates Arup !!! You doing a great job .
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 28, 2003 7:54 AM
Just came to know from CTOUG news that Oracle has chosen Arup Nanda(our
List member) as DBA of the Year
I am sure you guys might have some nice
perl/shell script to analyze alert log for errors or potential problem . Can you
share it with me /list .
Ohh thanks in advance guys .
-ak
with some sql*net setting ?? Any
help in this regard is highly appreciated .
thanks,
-ak
Title: International Language Support Experiences?
we have been using utf8 char set for international
support in the database .
-ak
- Original Message -
From:
David Wagoner
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, August 27, 2003 11:34
AM
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
). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: AK
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list
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
entry for one update statement ??
-ak
from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: AK
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
Does OEM 9.2.0.1 works well with 8.1.7.4 database ?
or in general with all versions of databases (7.3,8.0,8i,9i ) ? Does it
recognise underline db version and sends commands appropriately . Any Idea
?
thanks,
-ak
a stripe size of 32k on 3
disks can make 12 block read at parallel .
I think Ahmed Alomari has some good stuff on io
tuning in book 'Oracle and Unix performance tuning '.
-ak
- Original Message -
From:
Matthew Zito
To: Multiple recipients of list ORACLE-L
Sent
Is there any command on hp-ux which can tell me on
what disks particular file is striped on and stripe size .
Hp-ux ( 11 )
Thanks,
ak
that's rite . But what if you want to change something in param file for
this db .
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 14, 2003 4:44 PM
Hi!
But it really doesn't matter much, which init file was used during
select new_time(sysdate,'GMT','PST') from dual;
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, August 12, 2003 4:39 PM
I need some help to convert a GMT date into PST date and take care of all
Day
Light saving etc. Is there any
Is there a way to find which init.ora is a running
db is using ?
-ak
100 instances woh . If you are in 9i look at possibilities like context
or label security . or creating another schema .
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, August 06, 2003 9:24 PM
I have not heard installing
labor is just like another raw material . when America can dump chemical ,
weapons , plastic and electronic on name of free trade to all over world ,
why are we scarred when someone else is dumping labor ??
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
Dennis ,
One can always find good and bad programmers any whre in world . But in this
thread competency is brought up only bacause of cheap labor they are
concerned .
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 14, 2003 2
se changes to the target dbs .
Are there any similer tools , to compare with
?
Thanks,-Ak
How to diiferentiate views and tables in all_tables
and all_tab_columns . which column and what criteria can return only tables
??
-ak
Now , what is your server configuration ? windows , sun ,
hp ?? memory ??
-ak
- Original Message -
From:
Dilip Patel
To: Multiple recipients of list ORACLE-L
Sent: Thursday, August 07, 2003 3:54
PM
Subject: Re: 100 instances on same server
Thanks Dennis ,
But I am looking something for oracle application server .
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, August 06, 2003 10:14 AM
AK - My favorite for people that are new to Oracle, or even databases
Avnish ,
As far as log buffer is considered , look at how much redo ur generating .
That will be help you in finding optimal size of log buffer .
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, August 05, 2003 4:54 PM
What
Any good book on oracle 9iAS for beginners which
covers installation , configurations etc .
There is too much in oracle docs .
-Ak
One more thing to look at , if there were any object or tablespace in
nologging mode earlier ?
-ak
- Original Message -
From:
Munish Bajaj
To: Multiple recipients of list ORACLE-L
Sent: Friday, August 01, 2003 4:24
AM
Subject: RE: Redo Logs Problem
I've
it mean
that all transactions which started before issuing alter tablespace read
only should be finished ??
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 30, 2003 5:44 PM
Ah, one I have the answer to, as I had a similar
?
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, July 31, 2003 9:09 AM
What we found is that it doesn't matter which tablespace the session
causing the wait is accessing. As explained to me (by Dan Fink I
believe), Oracle doesn't
This is happening 3rd time with me so I have to
figure out what's wrong . When I issue the givensql first time i get
an error as shown . After that I copy and paste it again and it works second
time . Any clue what should be the reason ? btw, it happens with any sql ..not
just this one .
grant create any trigger to xyz ;
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, July 31, 2003 12:59 PM
My brain is not working todayI cannot figure out how to allow one user
to look at the source code (i.e. trigger_body
by any session . Now here i am confused ..
How does this thing is secure, cuz any session can
say my context is "MANAGER' or "CLERK" or whatever . Isn't it back to the roles
initially where any session can say heyyy enable role "MANAGER" ( offcourse if
its granted ).
-ak
oops looks like i missed "using package ..."
part in doc and shoot the question . Not this makes little sens
;)
sorry guys .
-ak
- Original Message -
From:
AK
To: [EMAIL PROTECTED]
Sent: Thursday, July 31, 2003 1:41
PM
Subject: global context
We us
://www.orafaq.net
--
Author: AK
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list
Answe is 4 disks . to keep each member on different disks .
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 30, 2003 10:19 AM
Hi all,
What is the correct answer for this?
Q If you have 2 redo log groups with 4 members
In that case you dont need more then 1 member per group . :)
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 30, 2003 12:14 PM
I thought you need to preserve the groups, not (necessarily) the members.
If you have each group
why does it take long time to turn a tablespace
read only . I issued the command 10 mins back , its still not returned .
There is almost no activity in db .
8.1.7.4
hp-ux
-ak
We are using AQ for long time . No problems so far .
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, July 28, 2003 8:29 PM
Hi,
I am looking at using Oracle AQ to post messages.I know they are just like
any other database table
Not sure but this might have something to do with charset (if toad can
handle clob??? ) . what is db charset ? is it utf8 .
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 29, 2003 8:19 AM
Hi,
I have Oracle 8i Enterprise
Hi
where can I find steps ( procedure ) for upgrading
from 8.1.7 to 9i .
Thanks,
-ak
Hi Guys ,
I am new to this clustering concept. Just trying to
understand few basics . Need ur help .
what is differece between oracle running on sun /hp
cluster with 2 nodes and oracle with RAC running
on 2 nodes ?
thanks,
-ak
Try to give this index initial sufficient space so that it does not
autoextend the extents.
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, July 28, 2003 9:09 AM
I asked this last week, but I have a little more info this week.
I
so what happens when first node goes down , oracle instance (processes )
will start on other node ? OS will take care of everything ?
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, July 28, 2003 9:29 AM
ak,
As I understand
Now this one is difficult folks ..
what is average age of an experienced oracle dba
?
-ak
where can i find a script to find segments which
can't extend due tolow of space in tablespace .
-ak
Does index rebuild generates new statistics as well
? How does that can hit performance intermediately if I want to rebuild few
indexes daily just to finish everything in 5 days .
-ak
will still have trace of error . One thing to make sure is autonomous
block always do a commit or rollback of its work before exiting .
begin
xxx
xxx
exception
call errorlog; -- this is autonomous
rollback;
end ;
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L
You will have to write separate batch script or use some tool to back them
up to tape .
Yes, RMAN can do it all for you if setup accordingly to delete xyz days old
archived log;
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 23
The only reason I wanted to build the indexes was
to relocate them to another tablespace ( LMT ) so that I can get rid of high
fragmentation and start living .
-ak
- Original Message -
From:
Tanel
Poder
To: Multiple recipients of list ORACLE-L
Sent: Wednesday
Yeap , Thanks Dennis . I am keeping that in mind .
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 23, 2003 2:54 PM
AK
Even though you can rebuild indexes online, it is a good idea to
perform
this task when the table
while rebuilding indexes i gave parrallel 2 . But I
see there are four ora_p00 processes . ???
-ak
Thanks KG for the info . You guys rock .
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, July 21, 2003 11:39 PM
AK:
Very much possible and very simple if you are using Linux or Windoze. I
think there is a note on Metalink
is it possible to change maxsize of autoextend
datafile ? how ?
never mind got the answer.
- Original Message -
From:
AK
To: [EMAIL PROTECTED]
Sent: Tuesday, July 22, 2003 2:26
PM
Subject: maxsize
is it possible to change maxsize of autoextend
datafile ? how ?
Is it possible to setup RAC in one box only. Just
to play with it . Dont have more hardware .
-ak
1 - 100 of 206 matches
Mail list logo