Dear List,
Could someone tell me how to update the parameter
"maxphys" on sun solaris 8 system. At present it is having a
default value of 128K. I would like to change it to 1MB. There is no such
parameter in /etc/system. I need this parameter to be updated as it seems to be
controlling
Title: Message
May be you try the following:
If you get errors restoring controlfile, You
may ftp the controlfiles manually to the new server and startup mount the
database first. Then, Try your restore database.
-- Janardhana
-Original Message-
From: Spears, Brian
[mai
Title: Message
I am sorry, I thought you are restoring
from Tape. In either case, you connect to target and catalog database on the
new server and see if you can access the backups that were backed up on the
original server.
-- Janardhana
-Original Message-
From: Spears, Br
Title: Message
By default RMAN restores the backup to the
machine from where it is backedup. If you need to restore the backup on to
alternate client, your netbackup admin has to setup the access. You have not mentioned
whether you are using Netbackup or legato or something else. Once the
Dear List,
We have TXN processing system with as many as 900 users log
in at any point of time. We have the necessity to find what OS type the client
is using (Windows 95, NT 2000 etc). I tried thru V$SESSION,
V$SESSION_CONNECT_INFO and V$PROCESS, but couldn't find any useful info
to g
Dear List,
We have TXN processing system with as many as 900 users log
in at any point of time. We have the necessity to find what OS type the client
is using (Windows 95, NT 2000 etc). I tried thru V$SESSION, V$SESSION_CONNECT_INFO
and V$PROCESS, but couldn't find any useful info to g
'direct=y' option. This has limitations
regarding the platform. Not 100% sure of it.
Check with Documentation. It does export very fast.
HTH
GovindanK
--- Janardhana Babu Donga <[EMAIL PROTECTED]> wrote: >
Dear List,
>
> I have a large unarchived decission support dat
,
--
Babu
-Original Message-From: Jacques Kilchoer
[mailto:[EMAIL PROTECTED]Sent: Tuesday, March 25, 2003
6:19 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: Large Export Problem ..
(see comments below)
> -Original Message- >
From: Janardhana Ba
ry 'direct=y' option. This has limitations
regarding the platform. Not 100% sure of it.
Check with Documentation. It does export very fast.
HTH
GovindanK
--- Janardhana Babu Donga <[EMAIL PROTECTED]> wrote: >
Dear List,
>
> I have a large unarchived decission sup
ORACLE-L
Babu
Why not try 'direct=y' option. This has limitations
regarding the platform. Not 100% sure of it.
Check with Documentation. It does export very fast.
HTH
GovindanK
--- Janardhana Babu Donga <[EMAIL PROTECTED]> wrote: >
Dear List,
>
> I have a large una
anks,
-- Babu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Janardhana Babu Donga
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing
y?
[4] Is there any other way to export the full database and eliminate
the
static partitions in a single step?
[5] What is the best way to solve my export problem??
Any ideas are appreciated.
Thanks,
-- Babu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: J
e is a way to RANGE
> partition the table, instead of HASH partitioning.
>
> Appreciate any suggestions.
>
> Thanks,
> -- Babu
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
>
uld like to know if there is a way to RANGE
partition the table, instead of HASH partitioning.
Appreciate any suggestions.
Thanks,
-- Babu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Janardhana Babu Donga
INET: [EMAIL PROTECTED]
Fat City Network Service
any suggestions.
Thanks,
-- Babu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Janardhana Babu Donga
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web h
ORACLE-L
also check "Maximum Jobs per client".
you will find this setting in the Netbackup preferences window (Netbackup
Java console).
-Mandar
> -Original Message-
> From: Janardhana Babu Donga [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 20, 2003 8:44 AM
> T
p up.
I'm speculating here, as you don't really supply enough info
about your environment.
Jared
Janardhana Babu Donga <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
02/20/2003 10:47 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <
channels not reduced the backup time. Iam using Veritas Netbackup.
Thanks in advance for any help.
-- Babu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Janardhana Babu Donga
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.f
the multiple
channels not reduced the backup time. Iam using Veritas Netbackup.
Thanks in advance for any help.
-- Babu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Janardhana Babu Donga
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http
-
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Janardhana Babu Donga
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
---
Title: Partition and primary key
You need
to have 15 to 20gig temp space to do this, assuming you are
equipartitioning the primary key index.
-Original Message-From: NGUYEN Philippe (Cetelem)
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 05,
2003 6:53 AMTo: Multiple reci
Try
this,
Select
table_name,column_name,data_length,data_type
from
dba_tab_columns
where
owner = ''
and
data_type='LONG' ;
--
Babu
-Original Message-From: Ed Bittel
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 05, 2003
6:53 AMTo: Multiple recipients of li
Title: Message
Try
Analyzing the table first and issue the select stmt.
--
Babu
-Original Message-From: Cunningham, Gerald
[mailto:[EMAIL PROTECTED]]Sent: Friday, January 31, 2003
11:56 AMTo: Multiple recipients of list ORACLE-LSubject:
RE: index hint ignored?
I've
t
http://www.orafaq.net
--
Author: Gary Jackson
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 you
an Diego, California-- Mailing list and web hosting services
-----
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the
.
Thanks,
-- Babu
-Original Message-
Sent: Thursday, September 05, 2002 7:18 PM
To: Multiple recipients of list ORACLE-L
Janardhana Babu Donga,
hi, which backup software are u using? as far as i know, you must
setup something in the second node so that MML software can THINK it
RA-19511: sbtrestore: Backup file not found.
RMAN-10031: ORA-19624 occurred during call to
DBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE
Could someone help me in resolving the issue.
Thanks,
-- Babu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Janardhana Babu Donga
INET:
the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Janardhana Babu Donga
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
8.1.7.0.0(64bit) on Sun Sparc Solaris 2.8 (64bit).
Please let me know if anyone has any ideas.
Thanks,
-- Babu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Janardhana Babu Donga
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (85
Babu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Janardhana Babu Donga
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
-
Sent: Monday, June 03, 2002 12:39 PM
To: Multiple recipients of list ORACLE-L
account??
To read kernel memory requires root privs, so don't think there is a way
to do that from the oracle account without some undesirable hack.
Janardhana Babu Donga wrote:
>
> Dear List,
>
>
fully from "oracle" account.
Thanks,
--Babu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Janardhana Babu Donga
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, Cali
-
Sent: Thursday, May 09, 2002 2:06 PM
To: Multiple recipients of list ORACLE-L
Try this: dbms_stats.delete_database_stats();
Janardhana Babu Donga wrote:
>
> I have deleted the statistics from 'SYS' and SYSTEM' as suggested by Suzy
> and made sure that t
Metalink:
Bug:1422285 is a severity 3 bug that was logged for the
dbms_stats.gather_database_stats collecting statistics on the data
dictionary objects (FET$ was the example). This bug is fixed in 9i. A
workaround is to execute dbms_stats.gather_database_statistics +
dbms_stats.delete_schema_stats('SYS').
Janardhan
sages
and e.event not like '%message%client'
order by s.username, upper(e.event);
Janardhana Babu Donga <[EMAIL PROTECTED]>
05/09/2002 11:03 AM
To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
cc: "'[EMAIL PROT
is to execute dbms_stats.gather_database_statistics +
dbms_stats.delete_schema_stats('SYS').
Janardhana Babu Donga wrote:
>
> I have recently changed the analyze script. Earliar it was
> dbms_utility.analyze_schema(...) statement, It is now changed to
> dbms_stats.gather_datab
It is waiting on the event: db file scattered read.
Thanks,
--Babu
-Original Message-
Sent: Thursday, May 09, 2002 11:33 AM
To: [EMAIL PROTECTED]
Cc: Janardhana Babu Donga
Babu,
While you're waiting, run this query to see what you're waiting on.
Jared
select
s.usernam
a last resort. Iam not sure it
would
fix the problem. Please let me know if there is any other way to fix
this
problem.
Thanks,
Babu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Janardhana Babu Donga
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858)
problem here? We will find out.
hth,
jack
--- Janardhana Babu Donga <[EMAIL PROTECTED]> wrote:
> I have recently changed the analyze script. Earliar
> it was
> dbms_utility.analyze_schema(...) statement, It is
> now changed to
> dbms_stats.gather_database_stats();
&
this. Iam thinking of
running catalog.sql and catproc.sql as a last resort. Iam not sure it would
fix the problem. Please let me know if there is any other way to fix this
problem.
Thanks,
Babu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Janardhana Babu Donga
IN
ess. Give that a try. I had
the same problem with DBA_INDEXES and that fixed it.
hth,
Jack
--- Janardhana Babu Donga <[EMAIL PROTECTED]> wrote:
> Dear List,
>
> When I query dba_extents , Iam getting response
> after half an hour to 40
> minutes, but when I query any other
fficial ORACLE-L FAQ: http://www.orafaq.com
--
Author: Janardhana Babu Donga
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
---
: Thursday, May 09, 2002 11:04 AM
To: 'Janardhana Babu Donga'
Babu - Among the suggestions you have received, the one that seems to have
the most merit is whether any of your system tables have been analyzed. Were
I in your position, I would check that out.
Dennis Williams
DBA
Lifetouch, I
dba_extents;
Jared
Janardhana Babu Donga <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
05/09/2002 10:58 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:DBA_EXTENTS problem
Dear List,
Jared,
It is taking 30 to 40 minutes to respond. I just issued again and is sitting
there. Iam sure it would respond after 30 minutes as happenned many times.
Thanks,
-- Janardhana Babu
-Original Message-
Sent: Thursday, May 09, 2002 10:45 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED
same problem with DBA_INDEXES and that fixed it.
hth,
Jack
--- Janardhana Babu Donga <[EMAIL PROTECTED]> wrote:
> Dear List,
>
> When I query dba_extents , Iam getting response
> after half an hour to 40
> minutes, but when I query any other dictionary view
> it is spon
ning catalog.sql and catproc.sql as a last resort. Iam not sure it would
fix the problem. Please let me know if there is any other way to fix this
problem.
Thanks,
Babu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Janardhana Babu Donga
INET: [EMAIL PROTECTE
Jared,
It is taking 30 to 40 minutes to respond. I just issued again and is sitting
there. Iam sure it would respond after 30 minutes as happenned many times.
I would E-Mail after getting the response.
Thanks,
-- Janardhana Babu
-Original Message-
Sent: Thursday, May 09, 2002 11:54 AM
roblem. Iam not getting any clue how to fix this. Iam
thinking of
running catalog.sql and catproc.sql as a last resort. Iam not sure it
would
fix the problem. Please let me know if there is any other way to fix
this
problem.
Thanks,
Babu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.
ng).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Janardhana Babu Donga
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access
with optimizer and DD access. Give that a try. I had
the same problem with DBA_INDEXES and that fixed it.
hth,
Jack
--- Janardhana Babu Donga <[EMAIL PROTECTED]> wrote:
> Dear List,
>
> When I query dba_extents , Iam getting response
> after half an hour to 40
> minutes,
thinking of
running catalog.sql and catproc.sql as a last resort. Iam not sure it would
fix the problem. Please let me know if there is any other way to fix this
problem.
Thanks,
Babu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Janardhana Babu Donga
INET: [EMAIL
ude a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Janardhana Babu Donga
INET: [EMAIL PROTECTED]
Fat Ci
Try querying dba_dependencies...
select referenced_name,referenced_type from dba_dependencies where name =
'your view name';
-- Janardhana Babu
-Original Message-
Sent: Friday, March 15, 2002 2:34 PM
To: Multiple recipients of list ORACLE-L
Hi,
Is there a way of findin
ring" in sybase. I am unable to proceed now.
Could someone help me in establishing a connection to Sybase(ver# 11 on IBM
AIX) from Oracle(817 64-bit on HP-UX 11.0).
ThanksBabu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Janardhana Babu
INET: [EMAIL
I am also facing the same problem. All these disadvantages in 8i standby DB
have been taken care of in oracle 9i version. The other solution could be to
buy an expensive Veritas Cluster server/Database edition.
Thanks,
-- Janardhana babu
-Original Message-
Sent: Wednesday, November 28
Title: rman question
If You
use RMAN to backup, you MUST use RMAN to restore. Once it is restored to the
regular files, you may use Svrmgrl to recover if this is comfortable to you.
But, recovery thru RMAN is easy, just one/two additional commands. Svrmgrl
is not avaialble from Oracle 9 onwa
followed by the regular daily
incremental
>
> backups?
>
> [3]If I follow [2], I may loose the catalog info for 8.1.6.2.0. backups.
> Is the
> 8.1.6.2.0 catalog data useful after upgrading the DB to 8.1.7.1.0?
>
> Could some one please answer my above questions
loose the catalog info for 8.1.6.2.0. backups. Is
the
8.1.6.2.0 catalog data useful after upgrading the DB to 8.1.7.1.0?
Could someone Please answer my above questions and suggest an appropriate
procedure to
upgrade the catalog DB to 8.1.7.1.0.
-- Janardhana Babu
--
Please see the official OR
0.
Thanks,
-- Janardhana Babu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Janardhana Babu
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mai
set. This is just my thought as the tag concept is not of much help. Oracle might have enhanced in 9i, not sure.
Please let me know if it clarified your questions.
Thanks,
-- Janardhana Babu
-Original Message-
From: Joan Hsieh [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 13, 2001 7:11 AM
To:
Title: RE: rman question
You may try duplicate database with the dbname the same as test database using RMAN.
You may need to use the tag command while backing up sothat you can specify the tag while restoring, but, if more than one backupset available with the same tag (it is in most case
How to restore the online logs
in case of failover? Is there any mechanism available to restore to the point of
failure? I believe standby database only applies archived logs (Assuming we
can't archive the current logs in case of failure).
Thanks.
-Original Message-From: JOE TES
the last transaction without production DB downtime, in case of failover/disaster? Iam thinking of this product, but not sure this would solve the Automatic Recovery problem until last transaction with no prod. down time.
Any help would be appreciated.
Thanks,
-- Janardhana Babu
Iam thinking of this product, but not sure this would solve the disaster
Recovery problem until last transaction with no prod. down time.
Any help would be
appreciated.
Thanks,
-- Janardhana
Babu
-Original Message-From: JOE TESTA
[mailto:[EMAIL PROTECTED]]Sent: Friday, Ju
,
-- Janardhana Babu
-Original Message-
From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 28, 2001 8:56 AM
To: Multiple recipients of list ORACLE-L
Subject: Virus again
Did anyone else get that virus crap again?
Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
... Babu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Janardhana Babu
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet ac
rafaq.com
--
Author: Janardhana Babu
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing
Connect to target and catalog databases and issue upgrade catalog command at
RMAN prompt.
You may be asked to enter the command twice, just like password
confirmation.
-- Babu
-Original Message-
Sent: Thursday, March 01, 2001 10:03 AM
To: 'Janardhana Babu'
Cc: Anne Yu
ng).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Janardhana Babu
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet
e EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.
---
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be
tc. If this gives you
any clue, please try to help me.
Thanks...Babu
-Original Message-
Sent: Friday, February 02, 2001 12:55 PM
To: 'Janardhana Babu'
Importance: Low
Try this.. (tailor as necessary)
column sid format 9 heading 'SID'
column osuser format
ng list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subs
ved from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Janardhana Babu
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-
ng list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Janardhana Babu
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858)
le).
There are many users who are locking different rows of the same table at the
same time. I need to find the one who locked my row.
I would appreciate if someone could help me with this.
TIA,
-- Babu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Janardhana Babu
IN
77 matches
Mail list logo
