What version of Oracle and operating system/type are you using.Is this
the Clarify help desk application?
If it is Clarify, you can contact their support and open a case with them.
They have some additional indexes, etc. that they recommend that helped us
quite a bit with our Clarify
[EMAIL PROTECTED] wrote:
Hi,
I have a report which was taking 48 minutes. So I added rule hint in that
now it is taking 14-15 min but, still it's not acceptable.. Is there any way
I can elimintae these nested loops or Can I replace them with hash joins. or
is there any other way to
my guess is that the instance is rolling back transactions which, were
interupted
when u shutdown the db.
--
From: chal_ping[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Wednesday, June 19, 2002 2:18 PM
To: Multiple recipients of list ORACLE-L
Informix? Your a ways from home. :)
If I
remember correctly you just need some parentheses:
create trigger cmst_trigUPDATE on cmstfor each
row( execute procedure sp_cmst_upd ( ) );
Surround your actions with parens and you must
call your procedure with empty parens if there are no
Also
check out www.informix.com/documentation
to find the online docs.
Informix guide to SQL: Syntaxwill give you the
complete run down.
-Original Message-From: Bob Lofstrand
Sent: Wednesday, June 12, 2002 11:26 AMTo:
'[EMAIL PROTECTED]'Subject: RE: URGENT Off-topic
go into server manager (svrmgrl) and connect internal, and then kill
the processes
or you can do it the really nasty way (assuming this is Unix) and just
start killing processes at the OS level
--- [EMAIL PROTECTED] wrote:
I third party replication production spurred a runaway process on my
Hi
Connect internal should be able to connect, shouldn't it??
Jack
johanna.doran@sun
smack a couple of those sessions at the UNIX level and
login right quick. make sure beforehand that this will
not lead to data corruption or anything nasty like
that. and if it does, have a heart to heart with your
manager about this app.
hth,
jack silvey
--- [EMAIL PROTECTED] wrote:
I
The
answer to this is Oracle profiles. Set the max number of sessions per user using
profiles. You may need to bounce the db to set resource_limit = true in
init.ora.
Regards: Ferenc Mantfeld Senior Performance Engineer Siebel
Performance Engineering Melbourne, 3000, VIC,
Australia È
Ferenc, you dont display your mobile number anymore, i was hoping to
call you from my cell phone, just kidding.
Joe
Ferenc Mantfeld wrote:
The answer to this is Oracle profiles. Set the max number of sessions
per user using profiles. You may need to bounce the db to set
resource_limit =
Subject:RE: Urgent: Retrieving Disk Space
Why don't you try to 'alter table move' the table to the tablespace it
should be in. If no other objects are beyond the block of the block 0 of the
segment, you should be able to resize the system01.dbf file. If something
else got created and is owned
:23 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Urgent: Retrieving Disk Space
Why don't you try to 'alter table move' the table to the tablespace it
should be in. If no other objects are beyond the block of the block 0 of the
segment, you should be able to resize the system01
Hi
What has grown?
you don't mention datafiles. So if there is only the three types of files
you mention there I can only assume that the part that has grown is the
number of archive logs. These are needed for recovery since last backup and
can not be thrown away. can be zipped though.
If
All the files you mention here are critical files.
What is the Temp File Size. Did u see that. Why did the table not get
created.
Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420
Fax : +971 (4) 397 6262
HP : +971 (50) 745 6019
Live to
Thanx Jack,
The size of System01.dbf has grown from 1GB to 4GB
The size of temp01.dbf is around 1GB now.
Best Regards,
Aleem
-Original Message-
Sent: Tuesday, June 04, 2002 1:18 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: Urgent: Retrieving Disk Space
Hi
Aleem,
Did you mention control files, redo log files, archive log files with
recovery in mind?
If so, you probably don't need it.
Read next if you have all the files for the database on this one poor hard
drive:
Review the cause for create table as select... command. If it is the
message like
that the SYSTEM01.dbf does indeed belong to the
SYSTEM tablespace. !!!
--
From: Abdul Aleem[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Tuesday, June 04, 2002 4:03 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Urgent: Retrieving Disk Space
: Tuesday, June 04, 2002 1:18 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Urgent: Retrieving Disk Space
Hi
What has grown?
you don't mention datafiles. So if there is only the three types of files
you mention there I can only assume that the part that has grown is the
number
Ganesh,
The query didn't get completed because of the disc space.
Temp01.dbf size is about 1GB
System01.dbf size is nearly 4GB against last nearly 1GB
Aleem
-Original Message-
Sent: Tuesday, June 04, 2002 1:53 PM
To: Multiple recipients of list ORACLE-L
Subject:RE
, June 04, 2002 2:13 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: Urgent: Retrieving Disk Space
Aleem,
Did you mention control files, redo log files, archive log files with
recovery in mind?
If so, you probably don't need it.
Read next if you have all the files
last nearly 1GB
Aleem
-Original Message-
Sent: Tuesday, June 04, 2002 1:53 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Urgent: Retrieving Disk Space
All the files you mention here are critical files.
What is the Temp File Size. Did u see that. Why did
To: Multiple recipients of list ORACLE-L
Subject:RE: Urgent: Retrieving Disk Space
Hi,
Autoextend is on for system tablespace (why?).
What's the default tablespace for the account the developer used to create
the object (system?), if not system his objects should not go to system
tablespace so
!
Aleem
-Original Message-
Sent: Tuesday, June 04, 2002 2:13 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Urgent: Retrieving Disk Space
Aleem,
Did you mention control files, redo log files, archive log files with
recovery in mind?
If so, you probably don't need it.
Read
files there, which is probaly your case.
--
Alexandre
The size of temp01.dbf is around 1GB now.
Best Regards,
Aleem
-Original Message-
Sent: Tuesday, June 04, 2002 1:18 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Urgent: Retrieving Disk Space
Hi
What has grown
: RE: Urgent: Prodution
database recovery
[EMAIL PROTECTED
Don't know whether this is of any use, but could it be that you still have a
hardware fault that is causing your restore to become corrupted?
Regards
David Lord
-Original Message-
From: Hand, Michael T [mailto:[EMAIL PROTECTED]]
Sent: 30 May 2002 10:23
To: Multiple recipients of
Thanks David,
You hit the nail on the head. Hardware problems are preventing the backup
files from restoring normally. We've got several hardware experts on site
this morning going over the disk/filesystem with a fine-tooth comb. File
header dump shows file_id mismatch which disappeared in 2
1-800-223-1711 for the US
Dave
-Original Message-
Sent: Friday, April 26, 2002 9:04 AM
To: Multiple recipients of list ORACLE-L
Could any of you send me the 1-800 no. and also the other phone no. for contacting
Oracle support.
Thanks,
Ashoke
--
Please see the official ORACLE-L FAQ:
The number I have is 1-800-223-1711.
--- Mandal, Ashoke [EMAIL PROTECTED]
wrote:
Could any of you send me the 1-800 no. and also the
other phone no. for contacting Oracle support.
Thanks,
Ashoke
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author: Mandal, Ashoke
http://www.oracle.com
Under Services (on left side)
.. Select Support
Under Services Information (on right side)
.. Select Contact Support Services
You will then get the appropriate numbers you seek.
John
[EMAIL PROTECTED] wrote:
Could any of you send me the 1-800 no. and also the other
Of course, if you don't have a CSI, good luck getting support! :-)
-Original Message-
Sent: Friday, April 26, 2002 10:28 AM
To: Multiple recipients of list ORACLE-L
1-800-223-1711
1-415-506-1500
Reply Separator
Author: Mandal; Ashoke [EMAIL
Hello List,
I am seeing Locks and the OS process is SNP process , I have to run the same
job which will refresh the MVs. I am stuck due to the locks on the database
, when I have tried to kill the session , it says me its is Marked for kill.
Can anybody suggest me what to do ???
Its one kind of
Hello,
Check alert.log. If there is a related error or if a trace is generated,
forward them to list.
Big Planet wrote:
Hi
Guys ,I am getting this
weired result after executing stored proc . When I run a particuler stored
proc which returns two refcursors ( inside proc theres are dynamic
-581-6217
Common sense will not accomplish great things.
Simply become insane and
desperate.
-Original Message-
From: Anjo Kolk [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, March 14, 2002 12:25 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Urgent need
: Thursday, March 14, 2002 12:25 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Urgent need information on
Buffer busy wait P3 value
231, need a CR version of the block but found
the current version of the
block
and that is being modified at this moment
220
231, need a CR version of the block but found the current version of the block
and that is being modified at this moment
220, looking for current version of block but that is bein modified
210, basically the same as 220.
Anjo.
Arun Chakrapani wrote:
Can somebody please let me know what the
PROTECTED]]
Sent: Thursday, March 14, 2002 12:25 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Urgent need information on Buffer busy wait P3 value
231, need a CR version of the block but found the current version of the
block
and that is being modified at this moment
220
In general the title of what is in P1 P2 and P3 is in P1TEXT P2TEXT
and P3TEXT. In this case, it just says 'id.'
The documentation is also unhelpful:
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76961/apa3.htm#264253
Event Name P1 P2 P3
will not accomplish great things. Simply become insane and
desperate.
-Original Message-
From: Anjo Kolk [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, March 14, 2002 12:25 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Urgent need information on Buffer busy wait P3 value
231, need
.
-Original Message-
From: Anjo Kolk [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, March 14, 2002 12:25 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Urgent need information on Buffer busy wait P3 value
231, need a CR version of the block but found the current version
:25 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Urgent need information on Buffer busy wait P3
value
231, need a CR version of the block but found the current version
of the
block
and that is being modified at this moment
220, looking for current version
Subject: Re: Urgent need information on Buffer busy wait P3
value
231, need a CR version of the block but found the current version
of the
block
and that is being modified at this moment
220, looking for current version of block but that is bein
modified
210, basically
Sundeep,
if my memory serves me rigth that bug was fixed with 8.1.7.2 patch. Have a look at the
bug list.
Regards,
Ed
We have an issue with compiling PL/SQL code. The
compilation gives PLS-00201 identifier must be
declared on a certain column which exists in the
table (a describe or
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group)
Subject: RE: URGENT Help on tracking unauthorized login to Oracle
of list ORACLE-L
Subject: Re: URGENT: need help by point in time recovery
This reminds me of something I always wanted to try to work
out. It seems like you should be able to rebuild part of a
db, so that the recovery of a certain tables data would be
faster. That way you don't
: Thursday, February 14, 2002 8:14 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: URGENT: need help by point in time recovery
This reminds me of something I always wanted to try to work
out. It seems like you should be able to rebuild part of a
db, so
Message-
From: Ray Stell [SMTP:[EMAIL PROTECTED]]
Sent: Friday, February 15, 2002 1:38 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: URGENT: need help by point in time recovery
On Fri, Feb 15, 2002 at 10:03:48AM -0800, Dejam, Ruth wrote:
We use that method for our 8.0.6
)
Subject: RE: URGENT Help on tracking unauthorized login to Oracle
Database
Title: URGENT: need help by point in time recovery
Hi
Volker...
You
should be able to do this... Just make sure you use a "using backup
controlfile" on your recover command... Alternatively, you could mount the
database and rename the datafiles instead of recreating the controlfile...
Don't do #1 or #5. Make sure you don't restore redo logs in #2. Step #4 -
Startup Mount
Step #6 -
recover database
until
Title: RE: URGENT Help on tracking unauthorized login to Oracle Database
To
track users who tried and logged into the database :
SQL
audit session;
I
don't know in which section you can find that in the Administrator
Guide.
Rivaldi
-Original Message-From: Mandal, Ashoke
Title: RE: URGENT Help on tracking unauthorized login to Oracle Database
The
SQL reference has some information...
http://docs.oracle.com/cd_database_generic_8.1.7/server.817/a85397/state10b.htm#2059074
HTH
Tim
-Original Message-From: Behar, Rivaldi
[mailto:[EMAIL PROTECTED
Title: RE: URGENT Help on tracking unauthorized login to Oracle Database
Hi all,
I have never done this particular activity but by following the clues given
in this
thread AND BY reading the documentation I was able to make this work. The
steps I followed were.
1. change the initializaion
Title: RE: URGENT Help on tracking unauthorized login to Oracle Database
Hi
Revaldi and Joe (Testa),
I went
through the followingAdministrator's guide.
Oracle8i Administrator's
GuideRelease 2 (8.1.6)Part Number
A76956-01
I could
only see chapter 24 on 'Auditing database Use' and under
Administrators guide
chapter on auditing.
joe
Mandal, Ashoke wrote:
Greetings,
We have a database with very sensitive data. Our management wants me to find out the
way to secure this data from unauthorized login and track these users who tried to
login to this database.
Is there any way
Joe,
We referred the auditing option. My understanding is that you can track the oracle
users using database auditing feature once the users are logged into the database.
But my requirement is to track the users who tried to login to the database but could
not login due to wrong password.
Title: RE: URGENT Help on tracking unauthorized login to Oracle Database
I have an idea for a poor man's version of what you are looking for. Turn on listener logging to a level high enough where you can see the text of the net traffic. With some creativity or a copy of Sed Awk you'll
I stand by my original statement, look at auditing unsuccessful connections.
joe
Mandal, Ashoke wrote:
Joe,
We referred the auditing option. My understanding is that you can track the oracle
users using database auditing feature once the users are logged into the database.
But my
Title: RE: URGENT Help on tracking unauthorized login to Oracle Database
Administrators guide.
Chapter on auditing.
Audit session.
Rivaldi
-Original Message-
From: Mandal, Ashoke [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 08, 2002 12:54 PM
To: Multiple recipients of list
- Original Message -
i need to insert /update / retrieve a image (GIF/JPEG/TIFF) to/from this
table.
i went thro' the DOCS also . but i don't find any example to do this .
can anyone help me to do this ?
any sample scripts please ?
please refer to chapter 9 Internal Persistent
7.1.6?? You mean 8.1.6 right?
Go to technet.oracle.com ( free registration if you don't have an account )
and go to the software section. You should find what you need there.
HTH
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, January 13,
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 09, 2002 07:40
hello everybody ,
would someone give me an example to insert/retrieve a bolb ?
please refer to Oracle9i Application Developer's Guide - Large Objects
(LOBs) at
Go to
Metalink and do a search for your first argument to the 600 error, there a
number of people who have had the same problem as you.
Regards
Lee
-Original Message-From: Bunyamin K. Karadeniz
[mailto:[EMAIL PROTECTED]]Sent: 08 January 2002
09:55To: Multiple recipients of
Probably a catalog corruption. It is possible that the
package exists in obj$ and doesn't in procedure$. Open
a tar. Although try setting _system_trig_enabled in
FALSE.
Regards,
--- Bunyamin K. Karadeniz
[EMAIL PROTECTED] wrote:
What can I do ? Urgent please
SQL drop package
Sent: Tuesday, January 08, 2002 12:20
PM
Subject: RE: URGENT , ORA-00600 WHEN
DROPING A PACKAGE
Go
to Metalink and do a search for your first argument to the 600 error, there a
number of people who have had the same problem as you.
Regards
Lee
-Original
HI Ken,
Two ideas
1.Have you tried using a default value on the column?
2.Load the data and then go back and do a mass update.
[EMAIL PROTECTED] wrote:
I need to load a constant date into a column (01/01/2002) and I need to use
direct path loading. I tried:
creation_date
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, November 29, 2001 02:00
If you have more than 300 or 400 connections, should consider MTS.
not really
they already use the connection pooling of WebLogic, so doing it twice won't
really
what is your processes parameter set to?
--- Rao, Maheswara [EMAIL PROTECTED]
wrote:
List
The environment : Oracle 817 : Solaris 7 : Memory -
4 GB. WebLogic Vesrion:
6.1
In the WebLogic Connection pool, when we try to open
the connections beyond
246, we are getting this error - ORA
Deepak,
Processes parameter is set to 1000.
Rao
-Original Message-
Sent: Wednesday, November 28, 2001 5:05 PM
To: Multiple recipients of list ORACLE-L
what is your processes parameter set to?
--- Rao, Maheswara [EMAIL PROTECTED]
wrote:
List
The environment : Oracle 817 :
8.1.7.1 has bug related to memory leak on all UNIX platforms, I think. Also
it has bug related to the maximum number of 536 concurrent active sessions.
I had applied patch 8.1.7.2.1 and problems went away.
If you have more than 300 or 400 connections, should consider MTS.
Something to think
Jeroen
it might indicate that your batch program is busy and
doing stuff. the wait event you have mentioned is a
idle wait event. In your next run, i would recommend
that have breakpoints coded in the batch that writes
into a error/log table about status and where the pgm
has reached. also write
Huh? Jared, did your search reveal that OFS is available for platforms
other then Windows?
The white papers and doc that I read stated Windows only because it's tied
into Microsoft Cluster Server. IMHO, I think the Oracle folks took a look
at MS Cluster Server and realized that it wouldn't
I must have been hallucinating, I can't find it now.
Here are some interesting links I came across while looking:
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=107487.1
Hmmm...doesn't that mean someone owes me a beer?
-Original Message-
Sent: Friday, November 09, 2001 4:27 PM
To: [EMAIL PROTECTED]; Grabowy, Chris
I must have been hallucinating, I can't find it now.
Here are some interesting links I came across while looking:
On Thursday 08 November 2001 11:20, you wrote:
I just recently installed Oracle Fail Safe 3.1.2 on W2K, Oracle 8.1.7 for a
...
It is for Windows only, because it ties into Microsoft Cluster Server. And
it was very cool, we failed each node back and forth many times with no
problems. Granted
Small addition to the instruction below:
Sometimes, when trying to delete Oracle home directory (say D:\Ora8i), you
may get an error, saying could not delete some oracle .dll (don't remember
the exact name) from d:\Ora8i\bin directory - file is in use.
This may happen, because MSDTC (Microsoft
[SMTP:[EMAIL PROTECTED]]
Sent: Friday, October 26, 2001 08:00 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: URGENT -- db already exist ???
Small addition to the instruction below:
Sometimes, when trying to delete Oracle home directory (say D:\Ora8i), you
may get an error
It's in the Registry. You will need to use 'oradim' or one of it's
variants to delete this SID from the system.
HTH,
Mike
---
===
Michael P. Vergara
Oracle DBA
Guidant Corporation
(909) 914-2304
-Original
Try running oradim
-Original Message-
Sent: Thursday, October 25, 2001 5:10 PM
To: Multiple recipients of list ORACLE-L
Hi all,
I created a 815 database on NT4. Since there is
something wrong with it, I used db config assist to
delete it. When I tried to create a database with
Gotta love Microsoft. Here's some instructions I got off this list from
Novice DBA a while back on how to properly delete an Oracle Database on
NT/2000:
Clearing up the System after an incomplete or improper installation of
Oracle
With 8i you could use the net 8 assistant, or manually edit the
listener.ora file to make the changes
HTH
Peter
At 09:45 PM 22/08/2001, you wrote:
OS: NT
4.0
I need to delete the TNS Listener service . and
create a new one .
How can I do that ?
TIA
Bunyamin
Selam Bunyamin,
If you don't want to remove them by installer, you can remove by manually.
to remove( as I remember ), go to
registry:
- HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services
- HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services
- HKEY_LOCAL_MACHINE\SYSTEM\ControlSet002\Services
to
)
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, August 22, 2001 4:35
PM
Subject: Re: URGENT PLEASE ! tns service
deletion and recreation
Selam Bunyamin,
If you don't want to remove them by installer, you can remove by manually.
to remove( as I remember ), go
On Thu, 16 Aug 2001, [EMAIL PROTECTED] wrote:
Dear DBA's, Can Any one of you tell me how to populate a table
with Simplified Chinese Language. My database character set is
also Simplified Chinese.
I'm not sure what you are struggling with.
Do you not know how to create these characters?
When you say you are not archiving what do you mean exactly? If you shut
off auto archiving that does not shut off archiving. We had that problem.
The log gets full and auto archiving does not run to clean out the archive
log so the system hangs.
Ron Smith
-Original Message-
Sent:
Chark(sp?) -
Is your listener running?
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
Sairlao, Chark
Attached are a couple of export import scripts I received earlier from a
member of the user group.
Hope they help.
Ron Smith
-Original Message-
Sent: Monday, August 13, 2001 10:56 AM
To: Multiple recipients of list ORACLE-L
Hi all,
I sent this last Friday. Maybe not too
Leslie,
This is what works for me on Oracle 7.3.4.4 on HP-UX
(zcat /extdisk/exp1/acc_per_06300200.dmp.Z \
/extdisk/exp1/export_pipe ); \
imp parfile=/extdisk/exp1/newpar.par
Maybe you can try this if your Sun has zcat.
I have never seen a pipe work for a while and then fail. I think
it is
Jared Still wrote:
Many things that are easier on unix with Perl are simply
not possible on Windoze without Perl. ( unless you want
to program in C or VB. Ugh on both counts )
Ask me how I know. ;)
Jared
well always being one to raise to a challenge:
how do you know?;-)
--
Bill
well always being one to raise to a challenge:
Cuz I find myself working on a number of databases
than run on: you guessed it, windoze.
Simple stuff like checking the amount of space available
on a filesystem and sending mail to the DBA's cell phone
if it reaches a critical stage for some
On Wednesday 01 August 2001 18:30, [EMAIL PROTECTED] wrote:
And if you have written a .bat file since the late '80s, brush up on your
DOS commands.
Forget many of the DOS commands; Learn Perl.
Learn to use the Win32, Win32::AdminMisc and Win32::Daemon
Perl modules.
Many things that are
Look at the parameter mts_dispatcher in the init.ora.
Probably you'll see this:
mts_dispatchers =
(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
I suggest you to choose on the Database Assistant the
option of generating the scripts. And before running
these, renmark the parameter.
there are two parameters infact that need to be removed(commented) from init
file.
mts_dispatcher
mts_server
thanks for all replies. problem goes away.
Saurabh Sharma
[EMAIL PROTECTED]
http://www.geocities.com/saurabh00pc/stride.html
- Original Message -
To: Multiple recipients of list
There's not a database on the server yet, that's
true. Oracle is just trying to start the instance with the initSID.ora file it
has. Are you using MTS? If not, the way to fix the problem is to remove the
MTS_DISPATCHERS parameter from your initSID.ora file. To make this work, when
the db
Subject: Re: Urgent..DB creation
problem..
There's not a database on the server yet, that's
true. Oracle is just trying to start the instance with the initSID.ora file it
has. Are you using MTS? If not, the way to fix the problem is to remove the
MTS_DISPATCHERS parameter from your
instead of haing the database created while in the assitant tool, have
the scripts saved and then edit them.
its a great learning experience.
joe
Saurabh Sharma wrote:
Hi all,
i'm having a problem in creating new database through database config
assistant. after giving all information
Why don't you try it?
Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 25, 2001 8:35 AM
Dear All,
Can anyone of you help me for the following.
I want to
Hello Rangachari,
Oracle9i supports the ANSI join syntax. I just finished an
article on it that should appear in the Nov/Dec (I think)
issue of Oracle Magazine.
Best regards,
Jonathan Gennick
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com *
Try dbv help=y
Or click here :
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/
a76955/ch09.htm#1936
(found by searching for 'dbv' at
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage :)
HTH,
Regards,
- Kirti Deshpande
Verizon Information Services
You missed some of the parameter or environmental
settings.
--- Sadzakovic Slavica [EMAIL PROTECTED] wrote:
Red Hat 6.2
Oracle 8.1.6.1
192MB of RAM
While running dbassist, ORA-03113 EOF on
communication channel appears
(progress bar shows between 65%
and 75%). What might be
201 - 300 of 394 matches
Mail list logo