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
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
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
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,
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
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 database of
size 270gig. We do
take coldbackup of database files every
?
[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: Janardhana Babu Donga
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
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
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 unarchived decission support
'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 database of
size 270gig. We do
: 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
-
To REMOVE yourself from this mailing
.
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 hosting services
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 Services-- 858-538-5051 http
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
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.fatcity.com
San Diego
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 [EMAIL PROTECTED]
cc
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
To: Multiple recipients of list
://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
-
To REMOVE yourself
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
Title: Partition and primary key
You need
tohave 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
') 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.orafaq.net
--
Author: Janardhana Babu
send the HELP command for other information (like subscribing).
--
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
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
-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 is the
node
: 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
To REMOVE yourself from this mailing list, send
: 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: [EMAIL PROTECTED]
Fat City Network Services-- (858
) 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: (858) 538-5051
San
--
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 Lists
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 Lists
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,
When I run dmesg command from oracle account on HP-UX 11.0, it responds
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
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, but when I query any other
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 Lists
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 PROTECTED]
Fat City
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
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 PROTECTED]
Fat City Network
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 spontaneous.
Everything else is fine in the database
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
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,
When I query
: 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, Inc.
[EMAIL
: 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
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 spontaneous.
Everything else is fine in the database
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
be the 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();
Is this a problem
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) 538-5051 FAX: (858) 538-5051
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.username username
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_database_stats();
Is this a problem
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 PROTECTED]' [EMAIL PROTECTED]
Subject:RE: DBA_EXTENTS problem
Jared
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').
Janardhana Babu Donga wrote:
I have recently changed the analyze script. Earliar
: 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 they were gone by issuing the query:
select
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 City Network
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 finding out what
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 PROTECTED]
Fat City Network
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
,
-- 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 / Mailing Lists
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 ORACLE-L FAQ
upgrading the DB to 8.1.7.1.0?
Could some one please answer my above questions and suggest an
appropriate
procedure to
upgrade the catalog DB to 8.1.7.1.0.
Thanks,
-- Janardhana Babu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Janardhana Babu
INET: [EMAIL
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
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
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, July 06, 2001 9:46
,
-- 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
=Spl_DB_97cphqgk_1_1, parms=
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: sbtrestore: Backup file not found.
RMAN-10031: ORA-19624 occurred during call to
DBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE
Thanks ... Babu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Janardhana
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 / Mailing Lists
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
Thanks
') 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.orafaq.com
--
Author: Janardhana Babu
INET
, 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 a9heading 'OS-User'
column typeformat a14
ge
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 subscribing).
--
Please see the official ORACLE-L F
).
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
INET: [EMAIL
69 matches
Mail list logo