RE: How to move a database from Solaris to Linux

[K Gopalakrishnan]

Reinhold,

I am afraid export import is the only way to migrate the
database from one Operating system to another operating Systems
and oracle data files are not compatible across various
operating systems (with a single exception of Solaris-HPUX)

If you are using Solaris (or HP UX) you can copy the data files
to HP UX( to Solaris if you use HP) and recreate the control
files and you can open the database. I don't know Oracle
Support's stand on this type of migration.

I am developing a tool which will do the migration
from one operating system to another operating system
(Basically it will read block by block and write to
the another operating system file format) and you can
copy (or binary FTP) the file to the target operating
system and recreate the control file and you are set to go

I don't have much experience in DB/2 and I can not
comment about that compatibility issues in DB/2. But
different operating systems uses different file formats
to store the data and oracle also has to follow the
rules to read/write the data files in those operating
systems.

If you have after interconnect (read GB n/w) you can
copy the tables over dblink and this will be much faster
than conventional export and Import. I don't have the
exact figures .. but this will reduce the downtime if you
have faster interconnect.

Why don't you file an enhancement request with oracle
seeking this ? :-)


Best Regards,
K Gopalakrishnan
Bangalore, INDIA


-Original Message-
Wagner
Sent: Thursday, September 20, 2001 1:00 AM
To: Multiple recipients of list ORACLE-L


Christopher,

i don't consider Solaris and Linux as different OS. IMO they are at
least similar if not equal from the DBMS point of view. I don't see any
reason why the data files should be different on Solaris, Linux or any
other UNIX OS.

I know from DB/2 that the data files are binary compatible on all OS and
I can't believe that's not true for Oracle.

regards

Reinhold

Christopher Spence wrote:

> You cannot move data files from one OS to a different one due to the
> differences in how they write to files.
>
> Import and Export is generally the accepted way to do this.
>
> "Do not criticize someone until you walked a mile in their shoes, that way
> when you criticize them, you are a mile a way and have their shoes."
>
> Christopher R. Spence
> Oracle DBA
> Phone: (978) 322-5744
> Fax:(707) 885-2275
>
> Fuelspot
> 73 Princeton Street
> North, Chelmsford 01863
>
>
>
> -Original Message-
> Sent: Wednesday, September 19, 2001 12:47 PM
> To: Multiple recipients of list ORACLE-L
>
> Hi all,
>
> we have to move a 135 GB Oracle 8.0.6 database from Solaris 7 to Linux.
> We tried a simple restore of the database files from the last offline
> backup (tape) as we did it many times between equal systems.
>
> After creating the new control file on the target system the database
> could not be started, becaue Oracle thinks that the system data file
> isn't really a data file!
>
> This means i have to do an export/import! I assume an export time of
> round about 10 hrs. Is there any easier way?
>
> TIA
>
> Reinhold Wagner
>
>


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Reinhold Wagner
  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 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 subscribing).


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: K Gopalakrishnan
  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 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 subscribing).

RE: How to move a databse from Solaris to Llinux

[Guy Hammond]

Maybe they're logically the same, but that doesn't mean they are
physically the same. Off the top of my head, I seem to recall that SPARC
and x86 architectures have different "endianness", which might be a
factor.

g



-Original Message-
Sent: Thursday, September 20, 2001 9:00 AM
To: Multiple recipients of list ORACLE-L


Christopher,

i don't consider Solaris and Linux as different OS. IMO they are at 
least similar if not equal from the DBMS point of view. I don't see any 
reason why the data files should be different on Solaris, Linux or any 
other UNIX OS.

I know from DB/2 that the data files are binary compatible on all OS and

I can't believe that's not true for Oracle.

regards

Reinhold

Christopher Spence wrote:

> You cannot move data files from one OS to a different one due to the
> differences in how they write to files.
> 
> Import and Export is generally the accepted way to do this.
> 
> "Do not criticize someone until you walked a mile in their shoes, that
way
> when you criticize them, you are a mile a way and have their shoes."
> 
> Christopher R. Spence 
> Oracle DBA
> Phone: (978) 322-5744
> Fax:(707) 885-2275
> 
> Fuelspot
> 73 Princeton Street
> North, Chelmsford 01863
>  
> 
> 
> -Original Message-
> Sent: Wednesday, September 19, 2001 12:47 PM
> To: Multiple recipients of list ORACLE-L
> 
> Hi all,
> 
> we have to move a 135 GB Oracle 8.0.6 database from Solaris 7 to
Linux. 
> We tried a simple restore of the database files from the last offline 
> backup (tape) as we did it many times between equal systems.
> 
> After creating the new control file on the target system the database 
> could not be started, becaue Oracle thinks that the system data file 
> isn't really a data file!
> 
> This means i have to do an export/import! I assume an export time of 
> round about 10 hrs. Is there any easier way?
> 
> TIA
> 
> Reinhold Wagner
> 
> 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reinhold Wagner
  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 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 subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Guy Hammond
  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 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 subscribing).

Re: Error in creating tablespace

[ASHRAF SALAYMEH]

Hi List,

I tryed to create the tablespace from svrmgr30
as satar naghshineh told me.
But i still face the same error...
CREATE TABLESPACE PAYROLL
DATAFILE 'C:\PAYROL.ORA' SIZE 10M
SQL> /
ERROR at line 1:
> > ORA-19502: write error on file "C:\PAYROL.ORA",
> > blockno 1 (blocksize=2048)
> > ORA-27069: skgfdisp: attempt to do I/O beyond the
> > range of the file
> > OSD-04026: Invalid parameter passed.
> > O/S-Error: (OS 64) The specified network name is

Any one can tell me what I have to do?

Regards,
Ashraf
--- satar naghshineh <[EMAIL PROTECTED]> wrote:
> Salaam Ashraf Jon,
> 
> It appears that Oracle has a problem writing to the
> C
> drive to create the datafile on the very first
> block.
> This error is usually the result of a size issue
> over
> 4gb for the datafile or a file that has been
> autoextended. In your case, it appears it doesn't
> like
> the command (maybe some character is being passed
> through the command?). 
> 
> Delete the file and re-try it again. try doing this
> in
> svrmgrl80 and put a ; at the end.
> 
> Good Luck,
> Satar Naghshineh
> 
> 
> 
> --- ASHRAF SALAYMEH <[EMAIL PROTECTED]>
> wrote:
> > Hello list,
> > 
> > I'm using Personal Oracle8 Database and Win98
> > Platform
> > 
> > I issued this command from Sqlplus8.0 :
> >  
> >CREATE TABLESPACE PAYROLL
> >DATAFILE 'C:\PAYROL.ORA' SIZE 10M
> > SQL> /
> > 
> > I am trying to create new tablespace Payroll but I
> > have got this error!
> > 
> > 
> > CREATE TABLESPACE PAYROLL
> > *
> > ERROR at line 1:
> > ORA-19502: write error on file "C:\PAYROL.ORA",
> > blockno 1 (blocksize=2048)
> > ORA-27069: skgfdisp: attempt to do I/O beyond the
> > range of the file
> > OSD-04026: Invalid parameter passed.
> > O/S-Error: (OS 64) The specified network name is
> no
> > longer available.
> > 
> > 
> > The strange is you can see the PAYROLL.ORA under
> C:\
> > Directory
> > After the error is displayed.
> > 
> > But when you query :
> > 
> > SQL> select tablespace_name
> >  from dba_data_files;
> >  
> > you can find nothing, no tablespace is created at
> > all...
> > 
> > I wish someone can help me to solve this problem.
> > 
> > Best Regards, 
> > Ashraf Salaymeh 
> > 
> 
> 
> __
> Terrorist Attacks on U.S. - How can you help?
> Donate cash, emergency relief information
>
http://dailynews.yahoo.com/fc/US/Emergency_Information/
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: satar naghshineh
>   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 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 subscribing).


__
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: ASHRAF SALAYMEH
  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 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 subscribing).

RE: Determining Oracle status

[Thomas, Kevin]

Raj,

excuse my ignorance of all things shell script like, but when I try to run
this I keep getting the error "CHECK_CONNECT=$$.CHECK_CONNECT: is not an
identified." any thoughts on this one.

Regards,
Kev.

"hit any supermassive black hole to continue"
__

Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
(2nd Floor East - Weirs Building)
Tel: 0141 568 2377
Fax: 0141 568 2366
http://www.calanais.com


-Original Message-
Sent: 18 September 2001 20:30
To: Multiple recipients of list ORACLE-L


Check out the following script.

*** SCRIPT STARTS
HERE*
#!/usr/bin/sh 

###
#
#   Auther  : Raj Sakthi
#   
#   Modification History: 
#   02/23/01: Network Connectivity Checking was added
.   
#
#   *** THIS SCRIPT CHECKS FOR THE AVAILABILITY OF
INSTANCE ALONG WITH THE  
#   *** NETWORK CONNECTIVITY   
  
#
#   Usage   :  Pass SID as parameter.  
# Example   :  sid_run orcl
# 


export CHECK_CONNECT=$$.CHECK_CONNECT
export READY=$$.ready
SID=$1
rm -f $READY
print "
 connect a/aa@$SID
  host touch $READY
 exit " |
 sqlplus /nolog  > $CHECK_CONNECT &
#
# Next we use a timer to check the sqlplus
hanging.
#
((timeout = 60))
while ((timeout -= 1)) && [[ ! -r $READY ]]
do
sleep 1
done
#
# If the file Doesn't exist then we check for internal
connectivity ..
#---
-
if [  ! -f $READY ]
  then
 print "
 connect internal
 exit " |
 sqlplus /nolog > $SID_connect.log
 egrep 'Connected' $SID_connect.log >
/dev/null
  if [ $? = 0 ]
 then
 echo " Problem in Network connectivity of
$SID "
 else
 echo " Instance $SID is not responding "
#
# Here we decide that Database is unavailable Due to
SQLPLUS hanging . 
#---

 exit 86
  fi
fi 
   egrep 'ORA-01034|ORA-12224|ORA-12154'
$CHECK_CONNECT > /dev/null
if [[ $? = 0 ]]; then
   echo "Instance '$SID' is NOT accessible, or invalid
ORACLE_SID"
   rm $CHECK_CONNECT
   rm $READY
#
# Here instance is not availablestaight and
simple..: )
#---
--
   exit 86
else   
#
# Check for INSTANCE availability by the specific
ORACLE error..slick ..eh?!
#-
   grep 'ORA-01017' $CHECK_CONNECT > /dev/null   
  if [[ $? = 0 ]]; then
  echo "Instance '$SID' is UP and Accessible" 
 
   else   
#
#To catch any other  error .
#
  echo "Instance '$SID' is HAVING UNKNOWN ERROR.
\n Verify Instance internal state "
   fi 
fi
rm $CHECK_CONNECT
rm $READY
 END  
regards,
RS


--- Barry Deevey <[EMAIL PROTECTED]> wrote:
> Hi all, 
> 
> I am trying to write a script in unix that
> determines if a specific oracle
> instance is available. I'm trying to avoid using the
> 'ps' command, so I
> thought the easiest method would be to connect via
> sqlplus - If it connects
> its up, if it doesn't then its unavailable. However,
> the problem is that
> when it isn't up, the script hangs and does not
> return anything - I think
> that this is because sqlplus by default gives you 3
> attempts to logon, so
> even though the logon attempt failed, it is waiting
> for you to try again, so
> unfortunately I'm not getting a failed return code. 
> If anybody could tell me how to change this so that
> it only allows 1 login
> attempt before 'kicking you out' or whether there is
> a better method to
> finding out the status of an instance, I would be
> extremely grateful to hear
> from you. 
> 
> TIA for any responses. 
> 
> Best Regards, 
> Barry. 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Barry Deevey
>   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 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 subscribing).

How to find the current instance name?

[Nirmal Kumar Muthu Kumaran]

List,

How to find the current instance name for the session?.

>From svrmgrl, i can using "SELECT name FROM v$database".

What is the equivalant from the ordinary user?

Regards
Nirmal.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nirmal Kumar  Muthu Kumaran
  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 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 subscribing).

RE: Error in creating tablespace

[Nirmal Kumar Muthu Kumaran]

Hi,

Here the following are ERROR details:

1)  > > ORA-19502: write error on file "C:\PAYROL.ORA",
> > blockno 1 (blocksize=2048)


-
ORA-19502
ORA-19502write error on file name, blockno name (blocksize=num)
Cause:A write error was detected on the output file. 
Action:Check that the file is not corrupt and retry the operation. 

-

2)  > > OSD-04026: Invalid parameter passed.
> > O/S-Error: (OS 64) The specified network name is


-
OSD-04026
OSD-04026Invalid parameter passed
Cause:This is an internal error, not normally expected to occur.
Action:Contact Oracle Worldwide Customer Support.

-

So please try to do the action's part from the help.

Regards,
Nirmal

> -Original Message-
> From: ASHRAF SALAYMEH [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, September 20, 2001 12:10 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: Error in creating tablespace
> 
> Hi List,
> 
> I tryed to create the tablespace from svrmgr30
> as satar naghshineh told me.
> But i still face the same error...
> CREATE TABLESPACE PAYROLL
> DATAFILE 'C:\PAYROL.ORA' SIZE 10M
> SQL> /
> ERROR at line 1:
> > > ORA-19502: write error on file "C:\PAYROL.ORA",
> > > blockno 1 (blocksize=2048)
> > > ORA-27069: skgfdisp: attempt to do I/O beyond the
> > > range of the file
> > > OSD-04026: Invalid parameter passed.
> > > O/S-Error: (OS 64) The specified network name is
> 
> Any one can tell me what I have to do?
> 
> Regards,
> Ashraf
> --- satar naghshineh <[EMAIL PROTECTED]> wrote:
> > Salaam Ashraf Jon,
> > 
> > It appears that Oracle has a problem writing to the
> > C
> > drive to create the datafile on the very first
> > block.
> > This error is usually the result of a size issue
> > over
> > 4gb for the datafile or a file that has been
> > autoextended. In your case, it appears it doesn't
> > like
> > the command (maybe some character is being passed
> > through the command?). 
> > 
> > Delete the file and re-try it again. try doing this
> > in
> > svrmgrl80 and put a ; at the end.
> > 
> > Good Luck,
> > Satar Naghshineh
> > 
> > 
> > 
> > --- ASHRAF SALAYMEH <[EMAIL PROTECTED]>
> > wrote:
> > > Hello list,
> > > 
> > > I'm using Personal Oracle8 Database and Win98
> > > Platform
> > > 
> > > I issued this command from Sqlplus8.0 :
> > >  
> > >CREATE TABLESPACE PAYROLL
> > >DATAFILE 'C:\PAYROL.ORA' SIZE 10M
> > > SQL> /
> > > 
> > > I am trying to create new tablespace Payroll but I
> > > have got this error!
> > > 
> > > 
> > > CREATE TABLESPACE PAYROLL
> > > *
> > > ERROR at line 1:
> > > ORA-19502: write error on file "C:\PAYROL.ORA",
> > > blockno 1 (blocksize=2048)
> > > ORA-27069: skgfdisp: attempt to do I/O beyond the
> > > range of the file
> > > OSD-04026: Invalid parameter passed.
> > > O/S-Error: (OS 64) The specified network name is
> > no
> > > longer available.
> > > 
> > > 
> > > The strange is you can see the PAYROLL.ORA under
> > C:\
> > > Directory
> > > After the error is displayed.
> > > 
> > > But when you query :
> > > 
> > > SQL> select tablespace_name
> > >  from dba_data_files;
> > >  
> > > you can find nothing, no tablespace is created at
> > > all...
> > > 
> > > I wish someone can help me to solve this problem.
> > > 
> > > Best Regards, 
> > > Ashraf Salaymeh 
> > > 
> > 
> > 
> > __
> > Terrorist Attacks on U.S. - How can you help?
> > Donate cash, emergency relief information
> >
> http://dailynews.yahoo.com/fc/US/Emergency_Information/
> > -- 
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > -- 
> > Author: satar naghshineh
> >   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 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 subscribing).
> 
> 
> __
> Terrorist Attacks on U.S. - How can you help?
> Donate cash, emergency relief information
> http://dailynews.yahoo.com/fc/US/Emergency_Infor

Are RAID 1+0 and 10 the same thing?

[Shevtsov, Eduard]

Hi List,

is there any difference between 1+0 and 10?

Regards,
Ed
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shevtsov, Eduard
  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 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 subscribing).

RE: Are RAID 1+0 and 10 the same thing?

[K Gopalakrishnan]

Yes. Both are same.



-Original Message-
Eduard
Sent: Thursday, September 20, 2001 4:35 AM
To: Multiple recipients of list ORACLE-L


Hi List,

is there any difference between 1+0 and 10?

Regards,
Ed
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Shevtsov, Eduard
  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 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 subscribing).


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: K Gopalakrishnan
  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 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 subscribing).

RE: How to find the current instance name?

[Cale, Rick T (Richard)]

You probably want to do the following.  v$database.name is the database name
not the instance name. Although
most name the same but not required.

SELECT instance FROM v$thread;

Rick

-Original Message-
Sent: Thursday, September 20, 2001 6:55 AM
To: Multiple recipients of list ORACLE-L


List,

How to find the current instance name for the session?.

>From svrmgrl, i can using "SELECT name FROM v$database".

What is the equivalant from the ordinary user?

Regards
Nirmal.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nirmal Kumar  Muthu Kumaran
  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 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 subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Cale, Rick T (Richard)
  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 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 subscribing).

RE: Bulk collect error

[Nirmal Kumar Muthu Kumaran]

Can you provide simplified resource details

> -Original Message-
> From: Csillag Zsolt [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, September 19, 2001 11:40 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Bulk collect error
> 
> can you provide simlified resource details.
> 
> 
> 
> Hi,
> 
> The following statment works perfectly:
> 
>   Select F.Fofejezet_Megnevezes_Magyar,F.FOFEJEZET_AZONOSITO2,
>  (Select Count(*) from alfejezet where 
> alfejezet.ALFEJEZET_FOFEJEZET_AZONOSITO2= F.Fofejezet_Azonosito2)
> 
>   From Fofejezet F ;
> 
> 
> However when I put this very same statement into a Pl/Sql procedure with 
> Bulk Collect,
> I get PLS-00103 error:
> 
>   Select F.Fofejezet_Megnevezes_Magyar,F.FOFEJEZET_AZONOSITO2,
>  (Select Count(*) from alfejezet where 
> alfejezet.ALFEJEZET_FOFEJEZET_AZONOSITO2= F.Fofejezet_Azonosito2)
> 
> Bulk Collect Into
> Vissza.FoFejezetNev,Vissza.FoFejezetKod,Vissza.Darab
> 
>   From Fofejezet F ;
> 
> 
> Can somebody help me?
> 
> Thank you
> 
> 
> Zsolt Csillag
> Hungary
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Csillag Zsolt
>   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 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 subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nirmal Kumar  Muthu Kumaran
  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 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 subscribing).

Re: Are RAID 1+0 and 10 the same thing?

[Deepender Kr Gupta]

There is no diff between RAID 10 and 1+0.
but 10 and 01 are different. out of which 10 is better than 01..

--deepender

- Original Message -
Date: Thursday, September 20, 2001 5:05 pm

> Hi List,
> 
> is there any difference between 1+0 and 10?
> 
> Regards,
> Ed
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Shevtsov, Eduard
>  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 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 subscribing).
> 



---
Information transmitted by this E-MAIL is proprietary to Wipro and/or its Customers and
is intended for use only by the individual or entity to which it is
addressed, and may contain information that is privileged, confidential or
exempt from disclosure under applicable law. If you are not the intended
recipient or it appears that this mail has been forwarded to you without
proper authority, you are notified that any use or dissemination of this
information in any manner is strictly prohibited. In such cases, please
notify us immediately at mailto:[EMAIL PROTECTED] and delete this mail
from your records.

RE: How to find the current instance name?

[Nirmal Kumar Muthu Kumaran]

No. By default SID and GLOBAL_NAME is same, but *NOT* necessarily.

But in my case these two are different.

Any ideas.

Nirmal

> -Original Message-
> From: Ramasubramanian, Shankar (Cognizant)
> [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, September 20, 2001 3:10 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: How to find the current instance name?
> 
> select * from global_name;
> 
> -Original Message-
> Sent: Thursday, September 20, 2001 4:25 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> List,
> 
> How to find the current instance name for the session?.
> 
> From svrmgrl, i can using "SELECT name FROM v$database".
> 
> What is the equivalant from the ordinary user?
> 
> Regards
> Nirmal.
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Nirmal Kumar  Muthu Kumaran
>   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 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 subscribing). <<
> File: InterScan_Disclaimer.txt >> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nirmal Kumar  Muthu Kumaran
  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 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 subscribing).

Red Hat 7.0 and raw devices

[Shevtsov, Eduard]

Hi List,

Does this couple live together? Do I need to install any additional patches
from RH in order to support raw devices? Are there any limitations on the
kernel?
And I have the same questions about SuSe7.0.

Thanks in advance for any info,
Ed
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shevtsov, Eduard
  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 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 subscribing).

RE: How to find the current instance name?

[Ramasubramanian, Shankar (Cognizant)]

select * from global_name;

-Original Message-
Sent: Thursday, September 20, 2001 4:25 PM
To: Multiple recipients of list ORACLE-L


List,

How to find the current instance name for the session?.

>From svrmgrl, i can using "SELECT name FROM v$database".

What is the equivalant from the ordinary user?

Regards
Nirmal.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nirmal Kumar  Muthu Kumaran
  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 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 subscribing).


This e-mail and any files transmitted with it are for the sole use of the intended 
recipient(s) and may contain confidential and privileged information.
If you are not the intended recipient, please contact the sender by reply e-mail and 
destroy all copies of the original message. 
Any unauthorised review, use, disclosure, dissemination, forwarding, printing or 
copying of this email or any action taken in reliance on this e-mail is strictly 
prohibited and may be unlawful.

Visit us at http://www.cognizant.com

RE: How to find the current instance name?

[Nirmal Kumar Muthu Kumaran]

i cann't access V$ views as an ordinary user, rt?

> -Original Message-
> From: Cale, Rick T (Richard) [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, September 20, 2001 3:20 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: How to find the current instance name?
> 
> You probably want to do the following.  v$database.name is the database
> name
> not the instance name. Although
> most name the same but not required.
> 
> SELECT instance FROM v$thread;
> 
> Rick
> 
> -Original Message-
> Sent: Thursday, September 20, 2001 6:55 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> List,
> 
> How to find the current instance name for the session?.
> 
> From svrmgrl, i can using "SELECT name FROM v$database".
> 
> What is the equivalant from the ordinary user?
> 
> Regards
> Nirmal.
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Nirmal Kumar  Muthu Kumaran
>   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 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 subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Cale, Rick T (Richard)
>   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 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 subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nirmal Kumar  Muthu Kumaran
  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 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 subscribing).

AW: How to find the current instance name?

[Schoen Volker]

select * from v$instance;

Volker Schoen
E-Mail: mailto:[EMAIL PROTECTED]
http://www.inplan.de



-Ursprüngliche Nachricht-
Von: Nirmal Kumar Muthu Kumaran [mailto:[EMAIL PROTECTED]] 
Gesendet: Donnerstag, 20. September 2001 14:50
An: Multiple recipients of list ORACLE-L
Betreff: RE: How to find the current instance name?


No. By default SID and GLOBAL_NAME is same, but *NOT* necessarily.

But in my case these two are different.

Any ideas.

Nirmal

> -Original Message-
> From: Ramasubramanian, Shankar (Cognizant)
> [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, September 20, 2001 3:10 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: How to find the current instance name?
> 
> select * from global_name;
> 
> -Original Message-
> Sent: Thursday, September 20, 2001 4:25 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> List,
> 
> How to find the current instance name for the session?.
> 
> From svrmgrl, i can using "SELECT name FROM v$database".
> 
> What is the equivalant from the ordinary user?
> 
> Regards
> Nirmal.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Nirmal Kumar  Muthu Kumaran
>   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 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 subscribing). <<
> File: InterScan_Disclaimer.txt >>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nirmal Kumar  Muthu Kumaran
  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 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 subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Schoen Volker
  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 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 subscribing).

TNS Names connection takes lot of time - HELP

[Dharani Ravi]

Dear friends,

Oracle Version 8.1.6
OS Sun Ver 8

>From one of the client machines if I telnet and
execute sqlloader for loading data without connection
string the process takes 5 minutes to complete (25 lac
rows).  However if I use connection string (connect
scott/tiger@test), then the process takes 1 hour to
complete.  In listener.ora file the protocol is
defined as TCP.  The client is in the same network.

Why it takes one hour if I use connection string ? 
Could anyone pl help ?

Thanks in advance.

Dharan

__
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dharani Ravi
  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 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 subscribing).

Re: Error in creating tablespace

[Ron Rogers]

Ashraf,
I know that it sounds far fetched but do you have contigous free space to write the 2 
K block that Oracle will try to write on the "C" drive. Do you have any virus 
protection turned on that prevents you from writing in the "root" directory? Try the 
same command in a sub directory.
Please post the findings when you get an answer.
Thanks,
Ron
ROR mª¿ªm

>>> [EMAIL PROTECTED] 09/20/01 05:10AM >>>
Hi List,

I tryed to create the tablespace from svrmgr30
as satar naghshineh told me.
But i still face the same error...
CREATE TABLESPACE PAYROLL
DATAFILE 'C:\PAYROL.ORA' SIZE 10M
SQL> /
ERROR at line 1:
> > ORA-19502: write error on file "C:\PAYROL.ORA",
> > blockno 1 (blocksize=2048)
> > ORA-27069: skgfdisp: attempt to do I/O beyond the
> > range of the file
> > OSD-04026: Invalid parameter passed.
> > O/S-Error: (OS 64) The specified network name is

Any one can tell me what I have to do?

Regards,
Ashraf
--- satar naghshineh <[EMAIL PROTECTED]> wrote:
> Salaam Ashraf Jon,
> 
> It appears that Oracle has a problem writing to the
> C
> drive to create the datafile on the very first
> block.
> This error is usually the result of a size issue
> over
> 4gb for the datafile or a file that has been
> autoextended. In your case, it appears it doesn't
> like
> the command (maybe some character is being passed
> through the command?). 
> 
> Delete the file and re-try it again. try doing this
> in
> svrmgrl80 and put a ; at the end.
> 
> Good Luck,
> Satar Naghshineh
> 
> 
> 
> --- ASHRAF SALAYMEH <[EMAIL PROTECTED]>
> wrote:
> > Hello list,
> > 
> > I'm using Personal Oracle8 Database and Win98
> > Platform
> > 
> > I issued this command from Sqlplus8.0 :
> >  
> >CREATE TABLESPACE PAYROLL
> >DATAFILE 'C:\PAYROL.ORA' SIZE 10M
> > SQL> /
> > 
> > I am trying to create new tablespace Payroll but I
> > have got this error!
> > 
> > 
> > CREATE TABLESPACE PAYROLL
> > *
> > ERROR at line 1:
> > ORA-19502: write error on file "C:\PAYROL.ORA",
> > blockno 1 (blocksize=2048)
> > ORA-27069: skgfdisp: attempt to do I/O beyond the
> > range of the file
> > OSD-04026: Invalid parameter passed.
> > O/S-Error: (OS 64) The specified network name is
> no
> > longer available.
> > 
> > 
> > The strange is you can see the PAYROLL.ORA under
> C:\
> > Directory
> > After the error is displayed.
> > 
> > But when you query :
> > 
> > SQL> select tablespace_name
> >  from dba_data_files;
> >  
> > you can find nothing, no tablespace is created at
> > all...
> > 
> > I wish someone can help me to solve this problem.
> > 
> > Best Regards, 
> > Ashraf Salaymeh 
> > 
> 
> 
> __
> Terrorist Attacks on U.S. - How can you help?
> Donate cash, emergency relief information
>
http://dailynews.yahoo.com/fc/US/Emergency_Information/ 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com 
> -- 
> Author: satar naghshineh
>   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 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 subscribing).


__
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/ 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: ASHRAF SALAYMEH
  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 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 subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
  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 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 informa

Re: How to find the current instance name?

[Gene Sais]

I use the following:
select instance_name from gv$instance;

>>> [EMAIL PROTECTED] 09/20/01 06:55AM >>>
List,

How to find the current instance name for the session?.

>From svrmgrl, i can using "SELECT name FROM v$database".

What is the equivalant from the ordinary user?

Regards
Nirmal.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Nirmal Kumar  Muthu Kumaran
  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 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 subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gene Sais
  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 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 subscribing).

RE: Are RAID 1+0 and 10 the same thing?

[Shevtsov, Eduard]

thanks for the reply. I share your opinion but believe there is some minor
difference.
According to Gaja's article: 

It must be noted here that RAID 10 is a derivative of RAID 1+0 with similar
performance and availability characteristics, but with some implementation
differences.

I'm curious what implementation differences did Gaja mention?

Regards,
Ed

>  
>  Yes. Both are same.
>  
>  
>  
>  -Original Message-
>  Eduard
>  Sent: Thursday, September 20, 2001 4:35 AM
>  To: Multiple recipients of list ORACLE-L
>  
>  
>  Hi List,
>  
>  is there any difference between 1+0 and 10?
>  
>  Regards,
>  Ed
>  --
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shevtsov, Eduard
  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 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 subscribing).

RE: How to find the current instance name?

[Mark Leith]

Right, or that is how it *should* be anyway :)

Take a look at the following:

SQL> create user test identified by test default tablespace users quota
unlimited on users;

User created.

SQL> grant connect to test;

Grant succeeded.

SQL> desc V$Instance
 Name  Null?Type
 -  ---
 INSTANCE_NUMBERNUMBER
 INSTANCE_NAME  VARCHAR2(16)
 HOST_NAME  VARCHAR2(64)
 VERSIONVARCHAR2(17)
 STARTUP_TIME   DATE
 STATUS VARCHAR2(7)
 PARALLEL   VARCHAR2(3)
 THREAD#NUMBER
 ARCHIVER   VARCHAR2(7)
 LOG_SWITCH_WAITVARCHAR2(11)
 LOGINS VARCHAR2(10)
 SHUTDOWN_PENDING   VARCHAR2(3)
 DATABASE_STATUSVARCHAR2(17)
 INSTANCE_ROLE  VARCHAR2(18)

SQL> select instance_name from v$instance;

INSTANCE_NAME

sales

SQL> connect test/test@sales
Connected.
SQL> select instance_name from v$instance;
select instance_name from v$instance
  *
ERROR at line 1:
ORA-00942: table or view does not exist

SQL> connect sys/sys@sales
Connected.
SQL> create view instance as select instance_name from v$instance;

View created.

SQL> create public synonym instance for sys.instance;

Synonym created.

SQL> connect test/test@sales;
Connected.
SQL> select * from instance;

INSTANCE_NAME

sales

This is just one work around that I can think of now, not sure of any others
that there may be though..

HTH

Mark

-Original Message-
Kumar Muthu Kumaran
Sent: Thursday, September 20, 2001 13:50
To: Multiple recipients of list ORACLE-L


i cann't access V$ views as an ordinary user, rt?

> -Original Message-
> From: Cale, Rick T (Richard) [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, September 20, 2001 3:20 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: How to find the current instance name?
>
> You probably want to do the following.  v$database.name is the database
> name
> not the instance name. Although
> most name the same but not required.
>
> SELECT instance FROM v$thread;
>
> Rick
>
> -Original Message-
> Sent: Thursday, September 20, 2001 6:55 AM
> To: Multiple recipients of list ORACLE-L
>
>
> List,
>
> How to find the current instance name for the session?.
>
> From svrmgrl, i can using "SELECT name FROM v$database".
>
> What is the equivalant from the ordinary user?
>
> Regards
> Nirmal.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Nirmal Kumar  Muthu Kumaran
>   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 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 subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Cale, Rick T (Richard)
>   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 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 subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nirmal Kumar  Muthu Kumaran
  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 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 subscribing).

-- 
Please see the official OR

RE: How to find the current instance name?

[Cale, Rick T (Richard)]

You can if you grant select privs.

-Original Message-
Sent: Thursday, September 20, 2001 8:50 AM
To: Multiple recipients of list ORACLE-L


i cann't access V$ views as an ordinary user, rt?

> -Original Message-
> From: Cale, Rick T (Richard) [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, September 20, 2001 3:20 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: How to find the current instance name?
> 
> You probably want to do the following.  v$database.name is the database
> name
> not the instance name. Although
> most name the same but not required.
> 
> SELECT instance FROM v$thread;
> 
> Rick
> 
> -Original Message-
> Sent: Thursday, September 20, 2001 6:55 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> List,
> 
> How to find the current instance name for the session?.
> 
> From svrmgrl, i can using "SELECT name FROM v$database".
> 
> What is the equivalant from the ordinary user?
> 
> Regards
> Nirmal.
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Nirmal Kumar  Muthu Kumaran
>   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 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 subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Cale, Rick T (Richard)
>   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 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 subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nirmal Kumar  Muthu Kumaran
  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 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 subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Cale, Rick T (Richard)
  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 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 subscribing).

Oracle error after recovery

[Smith, Ron L.]

I did a complete recovery of an Oracle instance.  Everything looked great
but when I bounced the instance
and tried to bring it back up I got the following Oracle error.  I have
checked everything.  There are no other
instances running.
 
Any ideas?
 
Ron
 
ORA-00205: error in identifying control file
'/stk0103/m001/oradata/conv/control1.ctl'
ORA-09782: sfifi: another instance has the same database mounted.
SVRMGR> exit
Server Manager complete.
  oracle@conv:> oerr ORA 09782
09782, 0, "sfifi: another instance has the same database mounted."
// *Cause:  In non-shared disk systems, database cannot be mounted shared.
// *Action: Shutdown the other oracle instance and try again.  The name
//  of the other instance was dumped to the trace file. 

 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Smith, Ron L.
  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 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 subscribing).

RE: Red Hat 7.0 and raw devices

[Vadim Gorbounov]

Hi, Ed, 
RH can handle raw devices, some kernel 2.2 need raw device patch, my current
RH7.1 (2.4.2 ) and RH6.2 (2.2.19),  had everything in place. Check if the
raw utility is present.
1. Create partitions (fdisk).  Important to set partition type to something,
not recognizable by RH, I set to 90
2. Bind rawdevice like:
 /usr/bin/raw /dev/raw/raw1 /dev/hda9  
3. Set ownership and mode:

 /bin/chmod 600 /dev/raw/raw1  
 /bin/chown oracle /dev/raw/raw1   
Steps 2 and 3 shoud be done every time when machine reboots.
RH7.1  has startup script ready, I just put chmod and chown into it. Check
/etc/init.d and /etc/sysconfig directories
reboot & enjoy. 

Vadim Gorbounov
Oracle DBA 


-Original Message-
Sent: Thursday, September 20, 2001 8:40 AM
To: Multiple recipients of list ORACLE-L


Hi List,

Does this couple live together? Do I need to install any additional patches
from RH in order to support raw devices? Are there any limitations on the
kernel?
And I have the same questions about SuSe7.0.

Thanks in advance for any info,
Ed
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shevtsov, Eduard
  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 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 subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vadim Gorbounov
  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 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 subscribing).

ORA-600 when querying DBA_SOURCE, ALL_SOURCE.

[Thomas Jeff]

Title: ORA-600 when querying DBA_SOURCE, ALL_SOURCE.





And yes, I've got a TAR logged with Oracle on this, but I wonder if 
any of you have seen anything like this before.   Whenever we try to query
any of the *_SOURCE views we get an ORA-600.   If you look at the
view text for DBA_SOURCE:


select u.name, o.name, 
decode(o.type#, 7, 'PROCEDURE', 8, 'FUNCTION', 9, 'PACKAGE',
11, 'PACKAGE BODY', 13, 'TYPE', 14, 'TYPE BODY',
'UNDEFINED'), s.line, s.source
from sys.obj$ o, sys.source$ s, sys.user$ u
where o.obj# = s.obj#
and o.owner# = u.user#
and o.type# in (7, 8, 9, 11, 13, 14)
union
select u.name, o.name, 'JAVA SOURCE', s.joxftlno, s.joxftsrc
from sys.obj$ o, x$joxfs s, sys.user$ u
where o.obj# = s.joxftobn
and o.owner# = u.user#
and o.type# = 28;


I can query either side of the UNION separately and it works fine.
It's when the whole shembang is queried where the ORA-600 occurs.


And I've rebuilt with catalog, etc.   Doesn't help.   We are on
IBM RS600, AIX 4.3.3, 8.1.7.0, on UTF8, FWIW.  



Jeffery D Thomas
DBA
Thomson Information Services
Thomson multimedia Inc.


Email: [EMAIL PROTECTED]
DBA Quickplace: http://gkmqp.tce.com/tis_dba

Better Way Of DeFragmentation

[Harvinder Singh]

Hi,

We have to defragment one of our production databases..(objects are not
properly sized)..
Since i can't shutdown database for more than 2 hrs and database is read
only and  DML 
statements run thru batch jobs 2 days in month. We r thinking of using the
following scheme.

1) export the particular application schema name NMDD of production
database.
2) On second machine run the DDL script which creates all the objects with
proper sizing.
3) Import the data from export taken in step 1.
4) take the cold backup of 2nd machine.
5) copy the backup files from 2nd machine to production machine.

Is there any better way to get rid of fragmentation without using any third
party tool..
or Is there any flaw in above procedure.

Thanks
-Harvinder
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Harvinder Singh
  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 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 subscribing).

Question on Gaja's Raid Document

[Rao, Maheswara]

List,

While reading Gaja's excellent document on Implementing Raid on Oracle
Systems, Gaja mentions the following in his document.

"The degree of striping in the DATA and INDX volumes should also consider
factors such as data/index partitioning, availability requirements and
support for parallel operations. Please note that 16 datafiles placed on 16
individual drives can support a 16-way parallel operation (if you have
memory and CPU to support it and your controller is not out of capacity
because all 16 drives engaged at the same time). The same cannot be
concluded with 16 datafiles placed on a 16-way RAID volume with 16 drives.
The degree of parallelism that you deploy on a 16-way volume will be
significantly less, when compared to the former configuration of 16
individual drives. This factor should be factored, when making "degree of
striping" decisions, which in turn controls the number of volumes on your
system. "

Question:

Why the degree of parallelism is less on a 16-way volume compared to 16
individual drives?

Thanks,

Rao
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rao, Maheswara
  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 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 subscribing).

Re: Two Instances at one oracle Server

[tday6]

I'm sure that someone will correct me if I'm wrong but:

The database is the physical datafiles laid out on the storage devices -
hard disks;
The instance is the logical constructions (SGA) that exist, hopefully, in
RAM;
The services are the NT operating system equivalent of UNIX processes which
run the Oracle engine against the instance to access the database.

In theory, an instance could be used to access multiple databases; however,
in practice, DBAs set up one instance that will be used to access one
database (and no other database).

Also, databases could, in theory, be accessed from multiple instances;
however, in practice, DBAs set up a database to be accessed from only one
instance (and no other instance).

Microsoft NT sets up the service so that it executes against one, given
instance.  However, NT will allow multiple services.

So, you can have two databases, two instances, and two services on the same
NT server.  You'll also need two listeners and two services to run those
listeners.

You'll probably need to read the manuals for the exact details.



   

Nirmal Kumar   

Muthu KumaranTo: Multiple recipients of list ORACLE-L  



.com.qa> cc:   

Sent by: Subject: Two Instances at one oracle 
Server   
root@fatcity.  

com

   

   

09/19/2001 

03:55 AM   

Please 

respond to 

ORACLE-L   

   

   





Guru's

In my test oracle server, i created two different database with SID
'orclsvr' and 'ora817'.

Is't possisle to create two oracle database instances on the same server?.

Presently am able to create only one instance at a time either for the sid
'orclsvr' or 'ora817'.

Oracle Server 817 on Win NT4 based.

Regards,
Nirmal.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nirmal Kumar  Muthu Kumaran
  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 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 subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  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 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 subscribing).

iMT indexing

[Bill Tantzen]

Hi!

I'm just getting started with interMedia Text, and I have a question about
indexing.  I have a table with an id column as a primary key, and a second
column which holds xml-tagged text.  I understand how to create an index
which allows me to to CONTAINS...WITHIN style searches on discrete zone
sections, but I would like to do more complicated searches, using various
combinations of tagged fields.

For instance, let's say I have a  field, and a  field.
I want to search on each of these fields, so I have statements like so:

ctx_ddl.add_zone_section ( 'book_grp', 'description', 'description' );
ctx_ddl.add_zone_section ( 'book_grp', 'title',   'title'   );

But say, for example, that I want to do a keyword search on a number of
different fields.  If I try to add something like:


ctx_ddl.add_zone_section ( 'book_grp', 'keyword', '...whatever...' );
ctx_ddl.add_zone_section ( 'book_grp', 'keyword', 'description' );
ctx_ddl.add_zone_section ( 'book_grp', 'keyword', 'title'   );

I receive the following error:

ORA-2: interMedia Text error:
DRG-12206: tag description already exists in section group BOOK_GRP
ORA-06512: at "CTXSYS.DRUE", line 126
ORA-06512: at "CTXSYS.CTX_DDL", line 221

Now, in the documentation I have read, I have seen statements such as "Tags
are unique across the sections of a section group" which indicates that I
can't do what I would like to do, but I have also seen statements such as
"ZONE sections can enclose other sections, including themselves, and can be
enclosed by other sections" which does sound like what I would like to do...

Hence, I'm confused.  There don't seem to be any good examples around that
take you beyond the most basic.

Any suggestions on how I might be able to create an index as described
above?  Or if you can point me to a good print or web resource, that would
also be much appreciated!

Thanks in advance!
Bill

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Tantzen
  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 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 subscribing).

RE: Oracle error after recovery

[Mercadante, Thomas F]

Ron,

Are you running under NT?  If so, try and stop and restart the services.  I
have seen something similar.  The error really was not with the control
files, but some hidden "handle" that the services actually locked.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Thursday, September 20, 2001 10:25 AM
To: Multiple recipients of list ORACLE-L


I did a complete recovery of an Oracle instance.  Everything looked great
but when I bounced the instance
and tried to bring it back up I got the following Oracle error.  I have
checked everything.  There are no other
instances running.
 
Any ideas?
 
Ron
 
ORA-00205: error in identifying control file
'/stk0103/m001/oradata/conv/control1.ctl'
ORA-09782: sfifi: another instance has the same database mounted.
SVRMGR> exit
Server Manager complete.
  oracle@conv:> oerr ORA 09782
09782, 0, "sfifi: another instance has the same database mounted."
// *Cause:  In non-shared disk systems, database cannot be mounted shared.
// *Action: Shutdown the other oracle instance and try again.  The name
//  of the other instance was dumped to the trace file. 

 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Smith, Ron L.
  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 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 subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  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 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 subscribing).

Re: Oracle error after recovery

[tday6]

I assume that you've done a ps -ef | grep ora to see that there are no
oracle processes running.

Check the date/time stamp of that control file and compare it to your other
copies of the control file.  I assume also that you do have other copies of
the control file.  If the stamp is different, rename the offending control
file, copy one of the good control files to that location, and restart the
database.

If that doesn't work then I'm out of answers.



   

"Smith, Ron

L."  To: Multiple recipients of list ORACLE-L  



com> cc:   

Sent by: Subject: Oracle error after recovery  

root@fatcity.  

com

   

   

09/20/2001 

10:25 AM   

Please 

respond to 

ORACLE-L   

   

   





I did a complete recovery of an Oracle instance.  Everything looked great
but when I bounced the instance
and tried to bring it back up I got the following Oracle error.  I have
checked everything.  There are no other
instances running.

Any ideas?

Ron

ORA-00205: error in identifying control file
'/stk0103/m001/oradata/conv/control1.ctl'
ORA-09782: sfifi: another instance has the same database mounted.
SVRMGR> exit
Server Manager complete.
  oracle@conv:> oerr ORA 09782
09782, 0, "sfifi: another instance has the same database mounted."
// *Cause:  In non-shared disk systems, database cannot be mounted shared.
// *Action: Shutdown the other oracle instance and try again.  The name
//  of the other instance was dumped to the trace file.



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Smith, Ron L.
  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 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 subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  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 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 subscribing).

RE: Question on Gaja's Raid Document

[Guy Hammond]

Because a single datafile may be striped across 16 disks. In the case of
16 datafiles on 16 disks, Oracle knows that they are separate files, but
it is down to you to set the degree of parallelism, because Oracle can't
know about your underlying physical configuration. With a stripe set, a
single data file is likely to span all disks, therefore all heads would
be used in when Oracle wants to read a lot of blocks sequentially. The
only scope for acceleration on such a configuration would be for the
RAID drivers to make the OS reads underlying the Oracle reads faster,
effectively getting filesystem blocks in parallel (rather than Oracle
blocks) and passing them on.

g



-Original Message-
Sent: Thursday, September 20, 2001 3:20 PM
To: Multiple recipients of list ORACLE-L


List,

While reading Gaja's excellent document on Implementing Raid on Oracle
Systems, Gaja mentions the following in his document.

"The degree of striping in the DATA and INDX volumes should also
consider
factors such as data/index partitioning, availability requirements and
support for parallel operations. Please note that 16 datafiles placed on
16
individual drives can support a 16-way parallel operation (if you have
memory and CPU to support it and your controller is not out of capacity
because all 16 drives engaged at the same time). The same cannot be
concluded with 16 datafiles placed on a 16-way RAID volume with 16
drives.
The degree of parallelism that you deploy on a 16-way volume will be
significantly less, when compared to the former configuration of 16
individual drives. This factor should be factored, when making "degree
of
striping" decisions, which in turn controls the number of volumes on
your
system. "

Question:

Why the degree of parallelism is less on a 16-way volume compared to 16
individual drives?

Thanks,

Rao
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rao, Maheswara
  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 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 subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Guy Hammond
  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 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 subscribing).

Re: ORA-600 when querying DBA_SOURCE, ALL_SOURCE.

[JOE TESTA]

oracle's 
answer will be patch to 8.1.7.2, thats what we were told just recently on a 
different ora-600 error.>>> [EMAIL PROTECTED] 09/20/01 10:45AM 
>>>
And yes, I've got a TAR logged with Oracle on 
this, but I wonder if any of you have 
seen anything like this before.   Whenever we try to query 
any of the *_SOURCE views we get an 
ORA-600.   If you look at the view text for DBA_SOURCE: 
select u.name, o.name, 
decode(o.type#, 7, 
'PROCEDURE', 8, 'FUNCTION', 9, 'PACKAGE', 11, 'PACKAGE BODY', 13, 'TYPE', 14, 'TYPE BODY', 
'UNDEFINED'), s.line, 
s.source from sys.obj$ 
o, sys.source$ s, sys.user$ u where o.obj# = s.obj# and o.owner# = u.user# and o.type# in (7, 8, 9, 11, 13, 14) union select u.name, o.name, 'JAVA SOURCE', s.joxftlno, s.joxftsrc 
from sys.obj$ o, x$joxfs s, 
sys.user$ u where 
o.obj# = s.joxftobn and 
o.owner# = u.user# and 
o.type# = 28; 
I can query either side of the 
UNION separately and it works fine. It's when the whole shembang is queried where the ORA-600 
occurs. 
And I've rebuilt with catalog, 
etc.   Doesn't help.   We are on IBM RS600, AIX 4.3.3, 8.1.7.0, on UTF8, 
FWIW.  
 Jeffery D Thomas DBA Thomson Information 
Services Thomson multimedia 
Inc. 
Email: [EMAIL PROTECTED] DBA Quickplace: http://gkmqp.tce.com/tis_dba 
 

RE: Better Way Of DeFragmentation

[Miller, Jay]

I assume you intend to also:
.5) Clone database to second machine
.6) Drop all objects in schema on 2nd machine
4.5) Take cold backup of 1st machine

With those caveats, it looks fine.

Jay Miller

-Original Message-
Sent: Thursday, September 20, 2001 10:35 AM
To: Multiple recipients of list ORACLE-L


Hi,

We have to defragment one of our production databases..(objects are not
properly sized)..
Since i can't shutdown database for more than 2 hrs and database is read
only and  DML 
statements run thru batch jobs 2 days in month. We r thinking of using the
following scheme.

1) export the particular application schema name NMDD of production
database.
2) On second machine run the DDL script which creates all the objects with
proper sizing.
3) Import the data from export taken in step 1.
4) take the cold backup of 2nd machine.
5) copy the backup files from 2nd machine to production machine.

Is there any better way to get rid of fragmentation without using any third
party tool..
or Is there any flaw in above procedure.

Thanks
-Harvinder
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Harvinder Singh
  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 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 subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Miller, Jay
  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 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 subscribing).

Re: Oracle error after recovery

[Dale Edgar]

Hi Ron

> I did a complete recovery of an Oracle instance.  Everything looked great
> but when I bounced the instance
> and tried to bring it back up I got the following Oracle error.  I have
> checked everything.  There are no other
> instances running.

Do you still have a sgadef.dbf  hanging around? Try stopping the
instance and moving/renaming this file. Oracle Note 18070.1 on Metalink may
also have a bit of useful information for you on this problem.

Regards
Dale
--
DataBee - Oracle DataBase Subsets
The simple and easy way to create small versions of large Oracle databases.
http://www.databee.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dale Edgar
  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 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 subscribing).

RE: ORA-600 when querying DBA_SOURCE, ALL_SOURCE.

[Mark Leith]

Title: ORA-600 when querying DBA_SOURCE, ALL_SOURCE.



Works 
OK with 8.1.7 on Win2K.. What do all you unix bigots think of that then 
 :P
 
Mark

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Thomas JeffSent: 
  Thursday, September 20, 2001 15:45To: Multiple recipients of list 
  ORACLE-LSubject: ORA-600 when querying DBA_SOURCE, 
  ALL_SOURCE.
  And yes, I've got a TAR logged with Oracle 
  on this, but I wonder if any of you 
  have seen anything like this before.   Whenever we try to 
  query any of the *_SOURCE views we 
  get an ORA-600.   If you look at the view text for DBA_SOURCE: 
  select u.name, o.name, 
  decode(o.type#, 7, 
  'PROCEDURE', 8, 'FUNCTION', 9, 'PACKAGE', 11, 'PACKAGE BODY', 13, 'TYPE', 14, 'TYPE 
  BODY', 'UNDEFINED'), 
  s.line, s.source from 
  sys.obj$ o, sys.source$ s, sys.user$ u where o.obj# = s.obj# and o.owner# = u.user# and o.type# in (7, 8, 9, 11, 13, 
  14) union 
  select u.name, o.name, 'JAVA 
  SOURCE', s.joxftlno, s.joxftsrc from sys.obj$ o, x$joxfs s, sys.user$ u 
  where o.obj# = 
  s.joxftobn and 
  o.owner# = u.user# and o.type# = 28; 
  I can query either side of 
  the UNION separately and it works fine. It's when the whole shembang is queried where the 
  ORA-600 occurs. 
  And I've rebuilt with 
  catalog, etc.   Doesn't help.   We are on IBM RS600, AIX 4.3.3, 8.1.7.0, on 
  UTF8, FWIW.  
   Jeffery D Thomas DBA Thomson Information 
  Services Thomson multimedia 
  Inc. 
  Email: [EMAIL PROTECTED] DBA Quickplace: http://gkmqp.tce.com/tis_dba  
  

Re: Better Way Of DeFragmentation

[tday6]

Consider going to tablespaces where all the extents are of a uniform size.
I.e., all objects in any one tablespace have the same INITIAL and NEXT
storage parameters.  These tablespaces will never need to be defragmented.

I'm not sure that your outlined procedure will work.  I think that your
cold backup from the 2nd machine will be out of synch (timestamp-wise) with
your control files.  It may be possible to do some recovery to overcome
this but I'm not familiar with that.

You could do an export from the 2nd machine, drop the tablespace(s) on the
1st machine, and do in import.

If you have data that is changing a lot over time, then you could get set
all the objects' NEXT parameter to a uniform size and the tablespaces will
coalesce naturally over time.



   

Harvinder Singh

   <[EMAIL PROTECTED]>

Sent by: cc:   

[EMAIL PROTECTED] Subject: Better Way Of 
DeFragmentation
   

   

09/20/2001 10:35 AM

Please respond to  

ORACLE-L   

   

   





Hi,

We have to defragment one of our production databases..(objects are not
properly sized)..
Since i can't shutdown database for more than 2 hrs and database is read
only and  DML
statements run thru batch jobs 2 days in month. We r thinking of using the
following scheme.

1) export the particular application schema name NMDD of production
database.
2) On second machine run the DDL script which creates all the objects with
proper sizing.
3) Import the data from export taken in step 1.
4) take the cold backup of 2nd machine.
5) copy the backup files from 2nd machine to production machine.

Is there any better way to get rid of fragmentation without using any third
party tool..
or Is there any flaw in above procedure.

Thanks
-Harvinder
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Harvinder Singh
  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 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 subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  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 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 subscribing).

RE: Two Instances at one oracle Server

[Nirmal Kumar Muthu Kumaran]

No.. Not necessary for more listeners.
One listener is enough to listen many servers. 

Nirmal.

> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, September 20, 2001 5:51 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: Two Instances at one oracle Server
> 
> I'm sure that someone will correct me if I'm wrong but:
> 
> The database is the physical datafiles laid out on the storage devices -
> hard disks;
> The instance is the logical constructions (SGA) that exist, hopefully, in
> RAM;
> The services are the NT operating system equivalent of UNIX processes
> which
> run the Oracle engine against the instance to access the database.
> 
> In theory, an instance could be used to access multiple databases;
> however,
> in practice, DBAs set up one instance that will be used to access one
> database (and no other database).
> 
> Also, databases could, in theory, be accessed from multiple instances;
> however, in practice, DBAs set up a database to be accessed from only one
> instance (and no other instance).
> 
> Microsoft NT sets up the service so that it executes against one, given
> instance.  However, NT will allow multiple services.
> 
> So, you can have two databases, two instances, and two services on the
> same
> NT server.  You'll also need two listeners and two services to run those
> listeners.
> 
> You'll probably need to read the manuals for the exact details.
> 
> 
> 
>  
> 
> Nirmal Kumar
> 
> Muthu KumaranTo: Multiple recipients of
> list ORACLE-L  
> 
> 
> .com.qa> cc:
> 
> Sent by: Subject: Two Instances at one
> oracle Server   
> root@fatcity.
> 
> com
> 
>  
> 
>  
> 
> 09/19/2001
> 
> 03:55 AM
> 
> Please
> 
> respond to
> 
> ORACLE-L
> 
>  
> 
>  
> 
> 
> 
> 
> 
> Guru's
> 
> In my test oracle server, i created two different database with SID
> 'orclsvr' and 'ora817'.
> 
> Is't possisle to create two oracle database instances on the same server?.
> 
> Presently am able to create only one instance at a time either for the sid
> 'orclsvr' or 'ora817'.
> 
> Oracle Server 817 on Win NT4 based.
> 
> Regards,
> Nirmal.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Nirmal Kumar  Muthu Kumaran
>   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 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 subscribing).
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   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 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 subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nirmal Kumar  Muthu Kumaran
  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 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 subscribing).

RE: Oracle error after recovery

[tday6]

I assumed that it was UNIX because of the direction of the "/".  NT goes "
\".  But, in NT, that would be another thing to try.


   
   
"Mercadante,   
   
Thomas F"   To: Multiple recipients of list 
ORACLE-L  
<[EMAIL PROTECTED]<[EMAIL PROTECTED]> 
   
ate.ny.us>  cc:
   
Sent by:Subject: RE: Oracle error after 
recovery  
[EMAIL PROTECTED]   
   
   
   
   
   
09/20/2001 10:55   
   
AM 
   
Please respond 
   
to ORACLE-L
   
   
   
   
   




Ron,

Are you running under NT?  If so, try and stop and restart the services.  I
have seen something similar.  The error really was not with the control
files, but some hidden "handle" that the services actually locked.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Thursday, September 20, 2001 10:25 AM
To: Multiple recipients of list ORACLE-L


I did a complete recovery of an Oracle instance.  Everything looked great
but when I bounced the instance
and tried to bring it back up I got the following Oracle error.  I have
checked everything.  There are no other
instances running.

Any ideas?

Ron

ORA-00205: error in identifying control file
'/stk0103/m001/oradata/conv/control1.ctl'
ORA-09782: sfifi: another instance has the same database mounted.
SVRMGR> exit
Server Manager complete.
  oracle@conv:> oerr ORA 09782
09782, 0, "sfifi: another instance has the same database mounted."
// *Cause:  In non-shared disk systems, database cannot be mounted shared.
// *Action: Shutdown the other oracle instance and try again.  The name
//  of the other instance was dumped to the trace file.



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Smith, Ron L.
  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 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 subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mercadante, Thomas F
  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 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 subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  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 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 subscribing).

RE: How to move a database from Solaris to Linux

[Vergara, Michael (TEM)]

Reinhold,

One thing to try instead of exporting to files and then importing
from those files is to run exp/imp through a pipe.

Pick a machine, source or destination - my choice would be destination.
Export the remote database to a local pipe, and then import to the 
local database from that pipe.  There are notes and tips on MetalLink
about exporting to a pipe, and Rachel and others have published methods
to this list.

Cheers,
Mike

> -Original Message-
> Sent: Wednesday, September 19, 2001 12:47 PM
> To: Multiple recipients of list ORACLE-L
>
> Hi all,
>
> we have to move a 135 GB Oracle 8.0.6 database from Solaris 7 to Linux.
> We tried a simple restore of the database files from the last offline
> backup (tape) as we did it many times between equal systems.
>
> After creating the new control file on the target system the database
> could not be started, becaue Oracle thinks that the system data file
> isn't really a data file!
>
> This means i have to do an export/import! I assume an export time of
> round about 10 hrs. Is there any easier way?
>
> TIA
>
> Reinhold Wagner
>
>


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Reinhold Wagner
  INET: [EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vergara, Michael (TEM)
  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 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 subscribing).

RE: Two Instances at one oracle Server

[tday6]

True.  However, I find it useful to have one listener per instance so that
I can restrict access to an instance without having to alter the database.


   

Nirmal Kumar   

Muthu KumaranTo: Multiple recipients of list ORACLE-L  



.com.qa> cc:   

Sent by: Subject: RE: Two Instances at one oracle  

root@fatcity.Server

com

   

   

09/20/2001 

11:30 AM   

Please 

respond to 

ORACLE-L   

   

   





No.. Not necessary for more listeners.
One listener is enough to listen many servers.

Nirmal.

> -Original Message-
> From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent:   Thursday, September 20, 2001 5:51 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Two Instances at one oracle Server
>
> I'm sure that someone will correct me if I'm wrong but:
>
> The database is the physical datafiles laid out on the storage devices -
> hard disks;
> The instance is the logical constructions (SGA) that exist, hopefully, in
> RAM;
> The services are the NT operating system equivalent of UNIX processes
> which
> run the Oracle engine against the instance to access the database.
>
> In theory, an instance could be used to access multiple databases;
> however,
> in practice, DBAs set up one instance that will be used to access one
> database (and no other database).
>
> Also, databases could, in theory, be accessed from multiple instances;
> however, in practice, DBAs set up a database to be accessed from only one
> instance (and no other instance).
>
> Microsoft NT sets up the service so that it executes against one, given
> instance.  However, NT will allow multiple services.
>
> So, you can have two databases, two instances, and two services on the
> same
> NT server.  You'll also need two listeners and two services to run those
> listeners.
>
> You'll probably need to read the manuals for the exact details.
>
>
>
>
>
> Nirmal Kumar
>
> Muthu KumaranTo: Multiple recipients of
> list ORACLE-L
> 
>
> .com.qa> cc:
>
> Sent by: Subject: Two Instances at
one
> oracle Server
> root@fatcity.
>
> com
>
>
>
>
>
> 09/19/2001
>
> 03:55 AM
>
> Please
>
> respond to
>
> ORACLE-L
>
>
>
>
>
>
>
>
>
> Guru's
>
> In my test oracle server, i created two different database with SID
> 'orclsvr' and 'ora817'.
>
> Is't possisle to create two oracle database instances on the same
server?.
>
> Presently am able to create only one instance at a time either for the
sid
> 'orclsvr' or 'ora817'.
>
> Oracle Server 817 on Win NT4 based.
>
> Regards,
> Nirmal.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Nirmal Kumar  Muthu Kumaran
>   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 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 subscribing).
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access 

I have another suggestion to check if a database is up

[Aponte, Tony]

Title: encrption of a column in a table, for V7.3



This 
isn't a new post (I lost the original thread asking for help with checking the 
status of the database via sqlplus, but it was hung). 
 
I 
developed this script to run sqlplus within a time limit.  The sample below 
will execute a sqlplus session and will kill it if it's not done in 10 
seconds.  It returns zero of it completes OK or a one if the timer expired 
and the sqlplus session had to be killed.  
 
 
#!/bin/shset -x# Establish 
run-time environment.ORACLE_SID=spt_dev; export ORACLE_SIDORAENV_ASK=NO; 
export ORAENV_ASK. oraenv#-#AlarmHandler() { echo "Got 
SIGALARM, cmd took too long." KillSubProcs exit 
14}#KillSubProcs() { kill ${CHPROCIDS:-$!} if [ $? 
-eq 0 ] ; then    echo "Sub-processes killed." 
;    exit 1 fi}#SetTimer() {  
DEF_TOUT=${1:-10};  if [ $DEF_TOUT -ne 0 ] ; 
then sleep $DEF_TOUT && kill -14 $$ 
& CHPROCIDS="$CHPROCIDS 
$!" TIMERPROC=$!  
fi}#UnsetTimer() {  kill $TIMERPROC}## 
main()#trap AlarmHandler 14#SetTimer 15#sqlplus 
internal/ 



Re: Oracle error after recovery


2001-09-20

Thread
Anjan Thakuria



There is a utility in $ORACLE_HOME/bin/ named sysresv which will
tell you about the instance. Even after having killed all the processes
used by the instance if the shared memory segment is not cleared you might
get that error. To find out which shared memory segment 
I am pasting a portion of a small note that I have written for our group...
use of oradebug...
SVRMGR> oradebug ipc
-- Shared memory --
Seg Id Address   Size
11902  8000  691462144 
-   So 11902 is the id of the shared memory segment
Total: # of segments = 1, size = 691462144
-- Semaphores 
Total number of semaphores = 150
Number of semaphores per set = 150   &
Number of semaphore sets = 1
Semaphore identifiers:
 7798786    -  7798786 is the semaphore
id.
SVRMGR>
 
Once the semaphore ID is got just remove with the command
Use
ipcrm –m  11902  --  < shared memory segment id >
ipcrm –s    7798786  -- < shemaphore id >
 
The above will clear the shared memory segment and the semaphore….
(Well we generally have to remove the above for a instance that is hung
and cannot be got into. In these situations we have to proceed by the method
of elimination. So the following..
At the unix prompt  the following will give all the shared memory
segments and the semaphores present in the system.
(Output from .
/db/app/oracle:>ipcs -b
IPC status from  as of Wed Aug 15 13:35:57 2001
T ID KEY   
MODE   OWNER    GROUP
QBYTES
Message Queues:
q   5400 0x5a000641 -Rrw-rw-rw- alexbkup alexbkup  65535
q    501 0x5a84 -Rrw-rw-rw-
root root  65535
q    603 0x5a000a35 -Rrw-rw-rw-
root root  65535
q    304 0x5a0003dc -Rrw-rw-rw-
root root  65535
q    105 0x5a000457 -Rrw-rw-rw-
root root  65535
q    806 0x5a000cd4 -Rrw-rw-rw-
root root  65535
T ID KEY   
MODE   OWNER    GROUP 
SEGSZ
Shared Memory:
m    800 0x4197 --rw-rw-rw-
root  dba2888704
m  36301 0x0999b640 --rw-rw   oracle 
dba37699584
m  11902 0x0999caa2 --rw-rw   oracle 
dba691462144
m  19603 0x0995b753 --rw-rw   oracle 
dba55001088
m 877104 0x419d --rw-rw-rw- root 
dba2888704
m 198905 0x4194 --rw-rw-rw- root 
dba2888704
m  97406 0x4190 --rw-rw-rw- root 
dba2888704
m  70707 0x0895adcd --rw-rw   oracle 
dba633757696
m  23608 0x416d --rw-rw-rw- root 
dba2888704
T ID KEY   
MODE   OWNER    GROUP
NSEMS
Semaphores:
s 524288 0x4297 --ra-ra-ra- root 
dba 3
s23789569  --ra-ra   oracle 
dba   200
s7798786  --ra-ra   oracle 
dba   150
s12845059  --ra-ra   oracle 
dba   100
s574750724 0x429d --ra-ra-ra- root 
dba 3
s130285573 0x4294 --ra-ra-ra- root 
dba 3
s63766534 0x4290 --ra-ra-ra- root 
dba 3
s46268423  --ra-ra   oracle 
dba   200
s15400968 0x426d --ra-ra-ra- root 
dba 3
So if we have more than one instance running. First we have to find
out the Shared Memory Segment and the Semaphores associated with each one
of these instances. And then we would know which one to clear using the
commands mentioned above.
 
In 8i ORACLE has provided the utility sysrev located in $ORACLE_HOME/bin
in addition to the enhanced output from the oradebug utility.
Once connected the oradebug ipc now creates a trace file in the udump
directory. The trace file gives a lot of information as to the different
areas associated with the SGA.
-
What I am trying to get at is that you might want to check if the shared
memory segment associated with the instance is cleared and if not clear
it.
 
 
HTH
Anjan.
 
Dale Edgar wrote:
Hi Ron
> I did a complete recovery of an Oracle instance.  Everything
looked great
> but when I bounced the instance
> and tried to bring it back up I got the following Oracle error. 
I have
> checked everything.  There are no other
> instances running.
Do you still have a sgadef.dbf  hanging around?
Try stopping the
instance and moving/renaming this file. Oracle Note 18070.1 on Metalink
may
also have a bit of useful information for you on this problem.
Regards
Dale
--
DataBee - Oracle DataBase Subsets
The simple and easy way to create small versions of large Oracle databases.
http://www.databee.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dale Edgar
  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 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 (



2nd DBA or ?


2001-09-20

Thread
O'Neill, Sean


I've been presented with an opportunity to justify requirements for a 2nd
DBA at our site.  As I see it there are an number of paths this presents:

1 - Justify and get a 2nd DBA.  
Pro's: Gives me more time to get involved in other projects as a senior DBA.
Holidays and attendance at courses and seminars etc. easier to take

2 - Outsource this role and activate it when required and justify putting
money into investing in software and/or hardware to allow a single DBA
function to required levels.
Pros: New tools etc. to learn and broader experience gained.  More
bargaining power if required.

I'd like to hear your feedback on which path you'd be inclined to take and
why?.  Also if going it alone what you'd look for software in hardware and
other areas.  Currently 6 NT servers, 10 databases and expanding...


Sean :)

Rookie Data Base Administrator
Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K
[0%] OCP Oracle8i DBA
[0%] OCP Oracle9i DBA
  
Organon (Ireland) Ltd.
E-mail: [EMAIL PROTECTED]   [subscribed: Digest Mode]

Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA

"Nobody loves me but my mother... and she could be jivin' too."  - BB King

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: O'Neill, Sean
  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 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 subscribing).






inspdver... equivalent in 8i and above...


2001-09-20

Thread
Anjan Thakuria



Listers,
I am hoping someone knows the equivalent of inspdver in 8i and
above. Can  you please let me know.
thanks
Anjan





obfuscated data gets corrupted


2001-09-20

Thread
Greg Solomon


Hi

Has anyone else experienced the following ?

Oracle 8.1.6.0.0 on Red Hat 6.2 Kernel 2.2.19

Table X in database A contains data encrypted using obfuscation toolkit.
Table Y in database B is materialised view of table X.

1. When I decrypt table X using o t I get my data.
2. When I decrypt table Y using o t I get an ORA 28232 - Invalid input
length for obfuscation toolkit.
3. When I e.g. select decrypt(col1) from (select * from X@A), I get an ORA
28232 - Invalid input length for obfuscation toolkit.
4. And ... when I export A and import to C and then select decrypt(col1)
from A, I get an ORA 28232 - Invalid input length for obfuscation toolkit. 

For case 1 when I select length(col1), I get 24 for all rows.
For cases 2, 3, and 4 when I select length(col1) rather than decrypt(col1),
I get a variety of numbers from 2 to 24.

Is there any way to access the data without decrypting it on database A
first ?

Thanks in advance
Greg
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Greg Solomon
  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 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 subscribing).






RE: Two Instances at one oracle Server


2001-09-20

Thread
JOE TESTA




ok i give, what is the difference between 
 
1.  shutting down a listener
2.  alter database enable restricted session where only the DBAs have 
restricted session.
 
and without a listener, the local connected people can still connect to the 
database, so you've only stoppped remote connections by stopping the 
listener.
 
 
joe
>>> [EMAIL PROTECTED] 09/20/01 12:20PM 
>>>True.  However, I find it useful to have one listener per 
instance so thatI can restrict access to an instance without having to alter 
the 
database.   
    
Nirmal 
Kumar   
    
Muthu Kumaran    
To: Multiple recipients of list 
ORACLE-L  
    
    
    
.com.qa> 
cc:   
    
Sent by: 
Subject: RE: Two Instances at one 
oracle  
    
root@fatcity.    
Server    
    
com    
   
   
    
09/20/2001 
    
11:30 
AM   
    
Please 
    
respond 
to 
    
ORACLE-L   
   
   
No.. Not necessary for more listeners.One listener is 
enough to listen many servers.Nirmal.> -Original 
Message-> From:   [EMAIL PROTECTED] 
[SMTP:[EMAIL PROTECTED]]> Sent:   Thursday, September 20, 2001 5:51 
PM> To: Multiple recipients of list 
ORACLE-L> Subject: Re: Two Instances at one 
oracle Server>> I'm sure that someone will correct me if I'm wrong 
but:>> The database is the physical datafiles laid out on the 
storage devices -> hard disks;> The instance is the logical 
constructions (SGA) that exist, hopefully, in> RAM;> The services 
are the NT operating system equivalent of UNIX processes> which> 
run the Oracle engine against the instance to access the 
database.>> In theory, an instance could be used to access 
multiple databases;> however,> in practice, DBAs set up one 
instance that will be used to access one> database (and no other 
database).>> Also, databases could, in theory, be accessed from 
multiple instances;> however, in practice, DBAs set up a database to be 
accessed from only one> instance (and no other instance).>> 
Microsoft NT sets up the service so that it executes against one, given> 
instance.  However, NT will allow multiple services.>> So, 
you can have two databases, two instances, and two services on the> 
same> NT server.  You'll also need two listeners and two services to 
run those> listeners.>> You'll probably need to read the 
manuals for the exact 
details.>> 
Nirmal 
Kumar>> 
Muthu Kumaran    
To: Multiple recipients of> list 
ORACLE-L> 
>> 
.com.qa> 
cc:>> 
Sent by: 
Subject: Two Instances atone> oracle 
Server> 
root@fatcity.>> 
com>> 
09/19/2001>> 
03:55 
AM>> 
Please>> 
respond 
to>> 
ORACLE-L>> 
Guru's>> In my test oracle server, i created two different 
database with SID> 'orclsvr' and 'ora817'.>> Is't possisle 
to create two oracle database instances on the sameserver?.>> 
Presently am able to create only one instance at a time either for 
thesid> 'orclsvr' or 'ora817'.>> Oracle Server 817 on 
Win NT4 based.>> Regards,> Nirmal.> --> 
Please see the official ORACLE-L FAQ: http://www.orafaq.com> --> 
Author: Nirmal Kumar  Muthu Kumaran>   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 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 fr



RE: inspdver... equivalent in 8i and above...


2001-09-20

Thread
Cale, Rick T (Richard)




From 
MetaLink
 
 To explain the disappearance of the inspdver utility from 
the Oracle8i.
 
 The inspdver utility is not 
supplied with 
Oracle8i. 
 
 Previous versions of Oracle 
supplied the 'inspdver' utility in the $ORACLE_HOME/orainst 
directory.  It relied on information maintained by the 'orainst' 
utility to display information about which Oracle components were 
installed in a given $ORACLE_HOME directory.
 
 With Oracle8i, the Installer is 
completely new and the 'inspdver'  utility is no longer provided.  
However, information about installed products can be obtained by 
running the Oracle Universal Installer (runInstaller) and clicking on 
the 'Installed Products' button located on the opening 
screen.
 
Rick

  -Original Message-From: Anjan Thakuria 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, September 20, 2001 
  12:45 PMTo: Multiple recipients of list ORACLE-LSubject: 
  inspdver... equivalent in 8i and above...Listers, 
  I am hoping someone knows the equivalent of inspdver in 8i and 
  above. Can  you please let me know. 
  thanks 
  Anjan 





Create user identified by externally


2001-09-20

Thread
Feng, Jun


Hi,

If there is user created using identified by externally, could this user
login to database remotely? If it could, could you please help us?

Thanks,

Jun
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Feng, Jun
  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 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 subscribing).






Re: Oracle error after recovery


2001-09-20

Thread
Gene Sais


shutdown abort also removes the sgadef file.

>>> [EMAIL PROTECTED] 09/20/01 11:30AM >>>
Hi Ron

> I did a complete recovery of an Oracle instance.  Everything looked great
> but when I bounced the instance
> and tried to bring it back up I got the following Oracle error.  I have
> checked everything.  There are no other
> instances running.

Do you still have a sgadef.dbf  hanging around? Try stopping the
instance and moving/renaming this file. Oracle Note 18070.1 on Metalink may
also have a bit of useful information for you on this problem.

Regards
Dale
--
DataBee - Oracle DataBase Subsets
The simple and easy way to create small versions of large Oracle databases.
http://www.databee.com 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Dale Edgar
  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 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 subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gene Sais
  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 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 subscribing).






RE: 2nd DBA or ?


2001-09-20

Thread
Christopher Spence


Really depends what you need.
Do you need someone day to day or just occassionally?

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Thursday, September 20, 2001 12:30 PM
To: Multiple recipients of list ORACLE-L

I've been presented with an opportunity to justify requirements for a 2nd
DBA at our site.  As I see it there are an number of paths this presents:

1 - Justify and get a 2nd DBA.  
Pro's: Gives me more time to get involved in other projects as a senior DBA.
Holidays and attendance at courses and seminars etc. easier to take

2 - Outsource this role and activate it when required and justify putting
money into investing in software and/or hardware to allow a single DBA
function to required levels.
Pros: New tools etc. to learn and broader experience gained.  More
bargaining power if required.

I'd like to hear your feedback on which path you'd be inclined to take and
why?.  Also if going it alone what you'd look for software in hardware and
other areas.  Currently 6 NT servers, 10 databases and expanding...


Sean :)

Rookie Data Base Administrator
Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K
[0%] OCP Oracle8i DBA
[0%] OCP Oracle9i DBA
  
Organon (Ireland) Ltd.
E-mail: [EMAIL PROTECTED]   [subscribed: Digest Mode]

Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA

"Nobody loves me but my mother... and she could be jivin' too."  - BB King

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: O'Neill, Sean
  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 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 subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christopher Spence
  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 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 subscribing).






RE: inspdver... equivalent in 8i and above...


2001-09-20

Thread
Nirmal Kumar Muthu Kumaran


what is it "INSPDVER"???

> -Original Message-
> From: Anjan Thakuria [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, September 20, 2001 7:45 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  inspdver... equivalent in 8i and above...
> 
> Listers, 
> 
> I am hoping someone knows the equivalent of inspdver in 8i and above. Can
> you please let me know. 
> 
> thanks 
> 
> Anjan
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nirmal Kumar  Muthu Kumaran
  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 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 subscribing).






Re: Oracle error after recovery


2001-09-20

Thread
Mohammad Rafiq


SHUTDOWN ABORT is one of the way to get rid of sgadef.dbf file 
and then startup

MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Thu, 20 Sep 2001 07:30:28 -0800

Hi Ron

 > I did a complete recovery of an Oracle instance.  Everything looked great
 > but when I bounced the instance
 > and tried to bring it back up I got the following Oracle error.  I have
 > checked everything.  There are no other
 > instances running.

Do you still have a sgadef.dbf  hanging around? Try stopping the
instance and moving/renaming this file. Oracle Note 18070.1 on Metalink may
also have a bit of useful information for you on this problem.

Regards
Dale
--
DataBee - Oracle DataBase Subsets
The simple and easy way to create small versions of large Oracle databases.
http://www.databee.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dale Edgar
   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 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 subscribing).


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohammad Rafiq
  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 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 subscribing).






RE: time synchronization


2001-09-20

Thread
Shevtsov, Eduard


Hi Jared and List,

thanks for the reply. I haven't had much info yet as it deals with my next
job. Actually, I only have a list of problem questions from their side. The
problem is that their client application controls all security issues and
among other security restrictions there are time restrictions. E.g. a user
is supposed to do a job only in the desired time intervals.
Unfortunately, the client application use time of local nt workstation where
it's being run. Their SA told me that they had tryed to correct the time
manually. They changed time on the server while the DB was running. (not
sure it's good way) After that they observed strange effect. Oracle became
works slower and slower... And number of active session (v$session.status)
became grow permanently. Eventually they restored the time back. I'm not
sure that the time was the real cause of such side effect but I'm curious if
someone has encountered the same problem.

Thanks for your help,
Ed

>  
>  
>  
>  
>  Eduard,
>  
>  You don't say why the time sync is causing such pain, or how you are
>  syncing up the time.
>  
>  If the synchronization is a problem, check into using ntp or 
>  xntp found
>  at www.ntp.org ( network time protocol )
>  
>  Many shops use this to keep servers in sync.  I use it at home on
>  linux boxes, works great.
>  
>  How is this synchronization affecting your Oracle instances?
>  
>  Jared
>  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shevtsov, Eduard
  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 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 subscribing).






Re: Two Instances at one oracle Server


2001-09-20

Thread
Don Granaman


> Also, databases could, in theory, be accessed from multiple instances;
> however, in practice, DBAs set up a database to be accessed from only one
> instance (and no other instance).

Except for parallel server / real application clusters where multiple instances
against a single database is the norm.

> So, you can have two databases, two instances, and two services on the same
> NT server.  You'll also need two listeners and two services to run those
> listeners.

I'm not sure about NT, but, in general, two listeners are not necessary.  A
single listener can service multiple instances.

-Don Granaman
[OraSaurus - Honk if you remember UFI!]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Don Granaman
  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 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 subscribing).






RE: Create user identified by externally


2001-09-20

Thread
Martin Kendall


Hi Jun,

As I understand it, identified externally means that the Operating System
has
identified the user and the given user must exist as an Oracle user at the
Target DB.

Anyone else fill in the blanks ?

Martin

-Original Message-
Sent: 20 September 2001 18:05
To: Multiple recipients of list ORACLE-L


Hi,

If there is user created using identified by externally, could this user
login to database remotely? If it could, could you please help us?

Thanks,

Jun
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Feng, Jun
  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 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 subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Martin Kendall
  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 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 subscribing).






RE: Create user identified by externally


2001-09-20

Thread
Chen, Bill

Title: RE: Create user identified by externally






yes. make sure 'remote_os_auth...' is set to true in your init.ora
bounce the db to make this effective.


bill


-Original Message-
From: Feng, Jun [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 20, 2001 12:05 PM
To: Multiple recipients of list ORACLE-L
Subject: Create user identified by externally



Hi,


If there is user created using identified by externally, could this user
login to database remotely? If it could, could you please help us?


Thanks,


Jun
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Feng, Jun
  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 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 subscribing).








RE: Two Instances at one oracle Server


2001-09-20

Thread
tday6


LOL.  You want be to give up all my secrets?  OK.  You also have a
maintenance listener which is not on ONAMES or the user's TNSNAMES.ORA.
Your DBA group keeps working without worrying about stepping on users or
having users lock objects. It's simplistic but it works great if your DBA
group is geographically distributed.


   
 
JOE TESTA  
 
<[EMAIL PROTECTED]>   
 
Sent by:  cc:  
 
[EMAIL PROTECTED]Subject: RE: Two Instances at one oracle 
 
omServer   
 
   
 
   
 
09/20/2001 
 
12:52 PM   
 
Please respond 
 
to ORACLE-L
 
   
 
   
 





ok i give, what is the difference between

1.  shutting down a listener
2.  alter database enable restricted session where only the DBAs have
restricted session.

and without a listener, the local connected people can still connect to the
database, so you've only stoppped remote connections by stopping the
listener.


joe


>>> [EMAIL PROTECTED] 09/20/01 12:20PM  >>>
True.  However, I find it useful to have one listener per  instance so that
I can restrict access to an instance without having to alter  the
database.


     Nirmal  Kumar
     Muthu Kumaran     To: Multiple recipients of
list  ORACLE-L
     
     .com.qa>  cc:
     Sent by:  Subject: RE: Two Instances
at one  oracle
     root@fatcity.     Server
     com
     09/20/2001
     11:30  AM
     Please
     respond  to
     ORACLE-L




No.. Not necessary for more listeners.
One listener is  enough to listen many servers.

Nirmal.

> -Original  Message-
> From:   [EMAIL PROTECTED]  [SMTP:[EMAIL PROTECTED]]
> Sent:   Thursday, September 20, 2001 5:51  PM
> To: Multiple recipients of list  ORACLE-L
> Subject: Re: Two Instances at one  oracle Server
>
> I'm sure that someone will correct me if I'm wrong  but:
>
> The database is the physical datafiles laid out on the  storage devices -
> hard disks;
> The instance is the logical  constructions (SGA) that exist, hopefully,
in
> RAM;
> The services  are the NT operating system equivalent of UNIX processes
> which
>  run the Oracle engine against the instance to access the  database.
>
> In theory, an instance could be used to access  multiple databases;
> however,
> in practice, DBAs set up one  instance that will be used to access one
> database (and no other  database).
>
> Also, databases could, in theory, be accessed from  multiple instances;
> however, in practice, DBAs set up a database to be  accessed from only
one
> instance (and no other instance).
>
>  Microsoft NT sets up the service so that it executes against one, given
>  instance.  However, NT will allow multiple services.
>
> So,  you can have two databases, two instances, and two services on the
>  same
> NT server.  You'll also need two listeners and two services to  run those
> listeners.
>
> You'll probably need to read the  manuals for the exact  details.
>
>
>
>
>
>  Nirmal  Kumar
>
>  Muthu Kumaran     To: Multiple recipients of
> list  ORACLE-L
>  
>
>  .com.qa>  cc:
>
>  Sent by:  Subject: Two Instances at
one
> oracle  Server
>  root@fatcity.
>
>  com
>
>
>
>
>
>  09/19/2001
>
>  03:55  AM
>
>  Please
>
>  respond  to
>
>  ORACLE-L
>
>
>
>
>
>
>
>
>
>  Guru's
>
> In my test oracle server, i created two different  database with SID
> 'orclsvr' and 'ora817'.
>
> Is't possisle  to create two oracle database instances on the same
server?.
>
>  Presently am able to create only one instance at a time either for  t



RE: Two Instances at one oracle Server


2001-09-20

Thread
Henry Poras




Well one advantage to playing with the 
listener is if you have to test an application which connects from a client. We 
have some applications where there is no direct connection to the server; 
everything is through the listener. We can change ports on the listener and 
tnsnames.ora to allow just a privileged subset to use the 
application.
 
Henry

  -Original Message-From: JOE TESTA 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, September 20, 2001 
  12:52 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Two Instances at one oracle Server
  ok i give, what is the difference between 
   
  1.  shutting down a listener
  2.  alter database enable restricted session where only the DBAs 
  have restricted session.
   
  and without a listener, the local connected people can still connect to 
  the database, so you've only stoppped remote connections by stopping the 
  listener.
   
   
  joe
  >>> [EMAIL PROTECTED] 09/20/01 12:20PM 
  >>>True.  However, I find it useful to have one listener per 
  instance so thatI can restrict access to an instance without having to 
  alter the 
  database.   
      
  Nirmal 
  Kumar   
      
  Muthu Kumaran    
  To: Multiple recipients of list 
  ORACLE-L  
      
      
      
  .com.qa> 
  cc:   
      
  Sent 
  by: 
  Subject: RE: Two Instances at one 
  oracle  
      
  root@fatcity.    
  Server    
      
  com    
     
     
      
  09/20/2001 
      
  11:30 
  AM   
      
  Please 
      
  respond 
  to 
      
  ORACLE-L   
     
     
  No.. Not necessary for more listeners.One listener is 
  enough to listen many servers.Nirmal.> -Original 
  Message-> From:   [EMAIL PROTECTED] 
  [SMTP:[EMAIL PROTECTED]]> Sent:   Thursday, September 20, 2001 
  5:51 PM> To: Multiple recipients of list 
  ORACLE-L> Subject: Re: Two Instances at one 
  oracle Server>> I'm sure that someone will correct me if I'm 
  wrong but:>> The database is the physical datafiles laid out on 
  the storage devices -> hard disks;> The instance is the logical 
  constructions (SGA) that exist, hopefully, in> RAM;> The 
  services are the NT operating system equivalent of UNIX processes> 
  which> run the Oracle engine against the instance to access the 
  database.>> In theory, an instance could be used to access 
  multiple databases;> however,> in practice, DBAs set up one 
  instance that will be used to access one> database (and no other 
  database).>> Also, databases could, in theory, be accessed from 
  multiple instances;> however, in practice, DBAs set up a database to be 
  accessed from only one> instance (and no other 
  instance).>> Microsoft NT sets up the service so that it 
  executes against one, given> instance.  However, NT will allow 
  multiple services.>> So, you can have two databases, two 
  instances, and two services on the> same> NT server.  
  You'll also need two listeners and two services to run those> 
  listeners.>> You'll probably need to read the manuals for the 
  exact 
  details.>> 
  Nirmal 
  Kumar>> 
  Muthu Kumaran    
  To: Multiple recipients of> list 
  ORACLE-L> 
  >> 
  .com.qa> 
  cc:>> 
  Sent 
  by: 
  Subject: Two Instances atone> oracle 
  Server> 
  root@fatcity.>> 
  com>> 
  09/19/2001>> 
  03:55 
  AM>> 
  Please>> 
  respond 
  to>> 
  ORACLE-L>> 
  Guru's>> In my test oracle server, i created two different 
  database with SID> 'orclsvr' and 'ora817'.>> Is't 
  possisle to create two oracle database instances on the 
 



RE: truncating snapshots


2001-09-20

Thread
Yadav, Shailesh


Henry,

  I think Anita's concerns are valid however in my experience of doing the
refreshes like you plan to do I have not encountered the problem# 2. For
problem# 1 what we do here is check the table you are going to populate the
changes into for existance of that primary key. If found then update the
record with new values else insert into the table. 
  The real catch here would be the deletions. Try to get the deletes before
you do the refresh from the MLOG$xxx at the master site and then use those
primary keys to perform the deletion.
  We have about 100 snapshots that are used to perform the aforementioned
task for over a year without any problems. Let me know if you have any
problem.

HTH,
Shailesh

-Original Message-
Sent: Tuesday, September 18, 2001 11:52 AM
To: Multiple recipients of list ORACLE-L


Henry,

OK, I think I see what you're trying to accomplish. 
By truncating the snapshot between refreshes, the
refresh is essentially populating the snapshot with
only the changed rows from the master site.

Probably not supported, but I can't see that it would
cause any real problems.  The way the refresh
mechanism works, the missing rows on the snapshot site
shouldn't be a problem.  

I see a couple of potential problems, however.

1.  The refresh will pull over all changed rows on the
master site, in your case inserts AND updates.  So if
a row does get updated on the master site, then it
will get refreshed to the snapshot site and your
counts will be off since you'll be treating the update
of an existing row as a newly inserted row.

It all depends on how critical the numbers are for the
developers, because I can assure you it's only a
matter of time before someone updates rows on a table
that should only have inserts ;)

2.  If a fast refresh fails this requires that the
next refresh is a complete refresh, or the snapshot is
recreated, so you will not have a way of getting just
the set of changed rows.  Your procedure will need to
be able to detect this and perform the joins against
the entire table again.

In the long run you're probably much better off
developing your own trigger to populate another table
or setting a flag, as you mentioned.  Just because it
works today doesn't mean that it will work in a newer
release if they change the refresh mechanism.  

HTH,

-- Anita

--- Henry Poras <[EMAIL PROTECTED]> wrote:
> Guess I wasn't too clear. Here's the scoop (there is
> probably a much easier
> way to do this, but I just can't get there from
> here). There is a 10million
> row table on a remote database. Each week, there is
> a change in about
> 5-10,000 rows (inserts). Currently this table is
> brought over to a local
> database. A convoluted query is then run to keep our
> developers happy and
> the result set is entered into another table. The
> query, though convoluted,
> does not use any aggregate functions, just a mess of
> joins. Right now this
> query is run on the complete 10 million row table
> brought over from the
> remote database. What I would like to do is to run
> the query on just the new
> rows, appending this result to the existing data.
> Since the snapshot log
> used for a fast refresh already keeps track of this
> for me I thought it
> might be a nice way to go. (I guess I could always
> flip a flag field, but
> why do extra work if Oracle already does it for me?)
> 
> 
> So my plan was to create a procedure which will
> manually take a fast
> refresh, run the query, check for success, truncate
> the table underlying the
> snapshot view. Since the underlying structure is
> just a table, and the
> master log data transfer is strictly in one
> direction, it looks like it
> should work, but are there any gothchas? It seems to
> be OK on a test system.
> 
> Thanks again.
> 
> Henry
> 
> 
> -Original Message-
> Sent: Sunday, September 16, 2001 9:38 AM
> To: [EMAIL PROTECTED]; Henry Poras
> 
> 
> Henry,
> 
> I'm not sure what you're trying to accomplish by
> truncating the snapshot.  The whole point of the
> refresh process is to keep the snapshot in sync with
> the master site.
> 
> Presumably you are doing a CTAS off of the snapshot
> to
> do your manipulations, so what is the point in
> truncating the snapshot?  I don't have a db handy to
> test whether Oracle detects that the snapshot has
> been
> truncated and does a complete refresh, but if the
> snapshot is very large it would probably be faster
> to
> drop and recreate it than to do a complete refresh.
> 
> A more detailed explanation of the process would
> help.
> 
> HTH,
> 
> -- Anita
> 
> --- Henry Poras <[EMAIL PROTECTED]> wrote:
> > !! Please do not post Off Topic to this List !!
> > 
> > I need to move the changes in a table from one
> > database to another. It
> > seemed that fast snapshots would be a good way to
> do
> > this as the database
> > will automatically keep track of the changes for
> me.
> > The question is that
> > once I move the data to the snapshot side, I need
> to
> > manipula



RE: 2nd DBA or ?


2001-09-20

Thread
Rachel Carmichael

Title: RE: 2nd DBA or ?





second person, you get to have a life



-Original Message-
From: O'Neill, Sean [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 20, 2001 12:30 PM
To: Multiple recipients of list ORACLE-L
Subject: 2nd DBA or ?



I've been presented with an opportunity to justify requirements for a 2nd
DBA at our site.  As I see it there are an number of paths this presents:


1 - Justify and get a 2nd DBA.  
Pro's: Gives me more time to get involved in other projects as a senior DBA.
Holidays and attendance at courses and seminars etc. easier to take


2 - Outsource this role and activate it when required and justify putting
money into investing in software and/or hardware to allow a single DBA
function to required levels.
Pros: New tools etc. to learn and broader experience gained.  More
bargaining power if required.


I'd like to hear your feedback on which path you'd be inclined to take and
why?.  Also if going it alone what you'd look for software in hardware and
other areas.  Currently 6 NT servers, 10 databases and expanding...



Sean :)


Rookie Data Base Administrator
Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K
[0%] OCP Oracle8i DBA
[0%] OCP Oracle9i DBA
  
Organon (Ireland) Ltd.
E-mail: [EMAIL PROTECTED]   [subscribed: Digest Mode]


Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA


"Nobody loves me but my mother... and she could be jivin' too."  - BB King


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: O'Neill, Sean
  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 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 subscribing).








LINUX ORACLE INSTALL ERROR


2001-09-20

Thread
Bunyamin K. Karadeniz




I have succesfully installed oracle 8.0.5 on LINUX 
redhat 7.1 BUT
when I want to run sqlplus or lsnrctl it gives 
SEGMENTATION FAULT error.
and creates core dump files. 
Why does this occur? Has anyone experienced this 
before ?





RE: Better Way Of DeFragmentation


2001-09-20

Thread
Miller, Jay


My understanding that he was copying the control files also - i.e., cloning
the 2nd database back to the first machine.  This works since he said it's
usually read only so there wouldn't have been any changes between when he
cloned 1 to 2 and when he clones 2 to 1.



-Original Message-
Sent: Thursday, September 20, 2001 11:31 AM
To: Multiple recipients of list ORACLE-L


Consider going to tablespaces where all the extents are of a uniform size.
I.e., all objects in any one tablespace have the same INITIAL and NEXT
storage parameters.  These tablespaces will never need to be defragmented.

I'm not sure that your outlined procedure will work.  I think that your
cold backup from the 2nd machine will be out of synch (timestamp-wise) with
your control files.  It may be possible to do some recovery to overcome
this but I'm not familiar with that.

You could do an export from the 2nd machine, drop the tablespace(s) on the
1st machine, and do in import.

If you have data that is changing a lot over time, then you could get set
all the objects' NEXT parameter to a uniform size and the tablespaces will
coalesce naturally over time.



 

Harvinder Singh

   <[EMAIL PROTECTED]>

Sent by: cc:

[EMAIL PROTECTED] Subject: Better Way Of
DeFragmentation
 

 

09/20/2001 10:35 AM

Please respond to

ORACLE-L

 

 





Hi,

We have to defragment one of our production databases..(objects are not
properly sized)..
Since i can't shutdown database for more than 2 hrs and database is read
only and  DML
statements run thru batch jobs 2 days in month. We r thinking of using the
following scheme.

1) export the particular application schema name NMDD of production
database.
2) On second machine run the DDL script which creates all the objects with
proper sizing.
3) Import the data from export taken in step 1.
4) take the cold backup of 2nd machine.
5) copy the backup files from 2nd machine to production machine.

Is there any better way to get rid of fragmentation without using any third
party tool..
or Is there any flaw in above procedure.

Thanks
-Harvinder
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Harvinder Singh
  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 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 subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  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 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 subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Miller, Jay
  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 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 subscribing).






RE: 2nd DBA or ?


2001-09-20

Thread
Miller, Jay


Agreed.  Do you want to ever be able to go on a 2 week vacation at some
point in your life?  Or even 1 week overseas?
 
Then you need a 2nd DBA.
 
It's also much better for the company.  If you should ever decide to seek
greener pastures elsewhere there will be someone familiar with all their
systems and databases.
 

-Original Message-
Sent: Thursday, September 20, 2001 1:56 PM
To: Multiple recipients of list ORACLE-L



second person, you get to have a life 


-Original Message- 
 ] 
Sent: Thursday, September 20, 2001 12:30 PM 
To: Multiple recipients of list ORACLE-L 


I've been presented with an opportunity to justify requirements for a 2nd 
DBA at our site.  As I see it there are an number of paths this presents: 

1 - Justify and get a 2nd DBA.  
Pro's: Gives me more time to get involved in other projects as a senior DBA.

Holidays and attendance at courses and seminars etc. easier to take 

2 - Outsource this role and activate it when required and justify putting 
money into investing in software and/or hardware to allow a single DBA 
function to required levels. 
Pros: New tools etc. to learn and broader experience gained.  More 
bargaining power if required. 

I'd like to hear your feedback on which path you'd be inclined to take and 
why?.  Also if going it alone what you'd look for software in hardware and 
other areas.  Currently 6 NT servers, 10 databases and expanding... 


Sean :) 

Rookie Data Base Administrator 
Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K 
[0%] OCP Oracle8i DBA 
[0%] OCP Oracle9i DBA 
  
Organon (Ireland) Ltd. 
E-mail: [EMAIL PROTECTED]   [subscribed: Digest Mode] 

Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA
  

"Nobody loves me but my mother... and she could be jivin' too."  - BB King 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
  
-- 
Author: O'Neill, Sean 
  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 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 subscribing). 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Miller, Jay
  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 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 subscribing).






query fails when run using microsoft odbc driver


2001-09-20

Thread
Harvinder Singh


Hi,

We have a query which runs fine from sqlplus but return following error when
runs from appliction using
MICROSOFT ODBC Driver:
ora-00904 INVALID COLUMN NAME 

Code of query is:
it seems like  specification of table template_po_map is creating
problem...
how to fix it .

select
   DISTINCT(t_po.id_po),
   t_po.id_eff_date,
   t_po.id_avail,
   t_po.b_user_subscribe,
   t_po.b_user_unsubscribe, 
   t_base_props.n_name,
   t_base_props.n_desc,
   t_base_props.n_display_name,
   t_base_props.nm_name,
   t_base_props.nm_desc,
   t_base_props.nm_display_name,
   te.n_begintype as te_n_begintype,
   te.dt_start as te_dt_start, 
   te.n_beginoffset as te_n_beginoffset,
   te.n_endtype as te_n_endtype,
   te.dt_end as te_dt_end,
   te.n_endoffset as te_n_endoffset,
   ta.n_begintype as ta_n_begintype,
   ta.dt_start as ta_dt_start, 
   ta.n_beginoffset as ta_n_beginoffset,
   ta.n_endtype as ta_n_endtype,
   ta.dt_end as ta_dt_end,
   ta.n_endoffset as ta_n_endoffset
   ,template_po_map.b_RecurringCharge
   ,t_ep_po.c_boris
t_ep_po_c_boris,t_ep_po.c_ExternalInformationURL
t_ep__c_ExternalInformationURL,t_ep_po.c_glcode
t_ep_po_c_glcode,t_ep_po.c_InternalInformationURL
t_ep__c_InternalInformationURL 
from 
   (select GetUTCDate() now from dual)
cdate,
   t_po,t_ep_po, 
   t_effectivedate te,
   t_effectivedate ta,

   t_base_props,
   (SELECT id_po,
decode(MAX(YesNo),1,'Y','N') b_RecurringCharge
FROM
(SELECT
t_pl_map.id_po,

decode(tb.n_kind,20,decode(sign(count(*)),1,1,0),0) YesNo
FROM
t_av_internal tav,
t_pricelist,
t_base_props tb,
t_pl_map,
t_recur,
t_discount,
t_aggregate
WHERE
-- Check currency
t_recur.id_prop(+) =
t_pl_map.id_pi_template and
 
t_discount.id_prop(+) = t_pl_map.id_pi_template and
 
t_aggregate.id_prop(+) = t_pl_map.id_pi_template and
tav.id_acc = 134 AND

t_pricelist.id_pricelist = t_pl_map.id_pricelist AND
tav.c_currency =
t_pricelist.nm_currency_code AND
-- Check cycle type

(t_recur.id_cycle_type is null or
 
t_recur.id_cycle_type = (select id_cycle_type
from
t_acc_usage_cycle, t_usage_cycle
where
t_acc_usage_cycle.id_acc = 134
AND
t_usage_cycle.id_usage_cycle = t_acc_usage_cycle.id_usage_cycle)) AND

(t_discount.id_cycle_type is null or
 
t_discount.id_cycle_type = (select id_cycle_type from t_acc_usage_cycle,
 t_usage_cycle where
t_acc_usage_cycle.id_acc = 134
 and
t_usage_cycle.id_usage_cycle = t_acc_usage_cycle.id_usage_cycle)) AND

(t_aggregate.id_cycle_type is null or
 
t_aggregate.id_cycle_type = (select id_cycle_type from t_acc_usage_cycle,
 



RE: Two Instances at one oracle Server


2001-09-20

Thread
Gene Sais


Another point, multiple listeners on same server require multiple ports.  Who wants to 
manage a sep port for each db :)  I prefer KISS.

>>> [EMAIL PROTECTED] 09/20/01 12:52PM >>>
ok i give, what is the difference between 

1.  shutting down a listener
2.  alter database enable restricted session where only the DBAs have restricted 
session.

and without a listener, the local connected people can still connect to the database, 
so you've only stoppped remote connections by stopping the listener.


joe


>>> [EMAIL PROTECTED] 09/20/01 12:20PM >>>
True.  However, I find it useful to have one listener per instance so that
I can restrict access to an instance without having to alter the database.


   

Nirmal Kumar   

Muthu KumaranTo: Multiple recipients of list ORACLE-L  



.com.qa> cc:   

Sent by: Subject: RE: Two Instances at one oracle  

root@fatcity.Server

com

   

   

09/20/2001 

11:30 AM   

Please 

respond to 

ORACLE-L   

   

   





No.. Not necessary for more listeners.
One listener is enough to listen many servers.

Nirmal.

> -Original Message-
> From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] 
> Sent:   Thursday, September 20, 2001 5:51 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Two Instances at one oracle Server
>
> I'm sure that someone will correct me if I'm wrong but:
>
> The database is the physical datafiles laid out on the storage devices -
> hard disks;
> The instance is the logical constructions (SGA) that exist, hopefully, in
> RAM;
> The services are the NT operating system equivalent of UNIX processes
> which
> run the Oracle engine against the instance to access the database.
>
> In theory, an instance could be used to access multiple databases;
> however,
> in practice, DBAs set up one instance that will be used to access one
> database (and no other database).
>
> Also, databases could, in theory, be accessed from multiple instances;
> however, in practice, DBAs set up a database to be accessed from only one
> instance (and no other instance).
>
> Microsoft NT sets up the service so that it executes against one, given
> instance.  However, NT will allow multiple services.
>
> So, you can have two databases, two instances, and two services on the
> same
> NT server.  You'll also need two listeners and two services to run those
> listeners.
>
> You'll probably need to read the manuals for the exact details.
>
>
>
>
>
> Nirmal Kumar
>
> Muthu KumaranTo: Multiple recipients of
> list ORACLE-L
> 
>
> .com.qa> cc:
>
> Sent by: Subject: Two Instances at
one
> oracle Server
> root@fatcity.
>
> com
>
>
>
>
>
> 09/19/2001
>
> 03:55 AM
>
> Please
>
> respond to
>
> ORACLE-L
>
>
>
>
>
>
>
>
>
> Guru's
>
> In my test oracle server, i created two different database with SID
> 'orclsvr' and 'ora817'.
>
> Is't possisle to create two oracle database instances on the same
server?.
>
> Presently am able to create only one instance at a time either for the
sid
> 'orclsvr' or 'ora817'.
>
> Oracle Server 817 on Win NT4 based.
>
> Regards,
> Nirmal.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> --
> Author: Nirmal Kumar  Muthu Kumaran
>   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



RE: truncating snapshots


2001-09-20

Thread
Henry Poras


Shailesh,
Thanks. My thoughts on #2 are that if the snapshot refresh and the delete
from the master log comprise a single transaction (2 phase commit), then I
shouldn't have a problem. A full refresh might be necessary at some point,
but I could deal with that with some specific, infrequently used code. Of
course I still need to confirm that this is a single transaction. Not quite
sure how to do this. Maybe try a trace, or limit available space on snapshot
so inserts will error. I'll see what happens.

Henry

-Original Message-
Sent: Thursday, September 20, 2001 1:56 PM
To: Multiple recipients of list ORACLE-L


Henry,

  I think Anita's concerns are valid however in my experience of doing the
refreshes like you plan to do I have not encountered the problem# 2. For
problem# 1 what we do here is check the table you are going to populate the
changes into for existance of that primary key. If found then update the
record with new values else insert into the table. 
  The real catch here would be the deletions. Try to get the deletes before
you do the refresh from the MLOG$xxx at the master site and then use those
primary keys to perform the deletion.
  We have about 100 snapshots that are used to perform the aforementioned
task for over a year without any problems. Let me know if you have any
problem.

HTH,
Shailesh

-Original Message-
Sent: Tuesday, September 18, 2001 11:52 AM
To: Multiple recipients of list ORACLE-L


Henry,

OK, I think I see what you're trying to accomplish. 
By truncating the snapshot between refreshes, the
refresh is essentially populating the snapshot with
only the changed rows from the master site.

Probably not supported, but I can't see that it would
cause any real problems.  The way the refresh
mechanism works, the missing rows on the snapshot site
shouldn't be a problem.  

I see a couple of potential problems, however.

1.  The refresh will pull over all changed rows on the
master site, in your case inserts AND updates.  So if
a row does get updated on the master site, then it
will get refreshed to the snapshot site and your
counts will be off since you'll be treating the update
of an existing row as a newly inserted row.

It all depends on how critical the numbers are for the
developers, because I can assure you it's only a
matter of time before someone updates rows on a table
that should only have inserts ;)

2.  If a fast refresh fails this requires that the
next refresh is a complete refresh, or the snapshot is
recreated, so you will not have a way of getting just
the set of changed rows.  Your procedure will need to
be able to detect this and perform the joins against
the entire table again.

In the long run you're probably much better off
developing your own trigger to populate another table
or setting a flag, as you mentioned.  Just because it
works today doesn't mean that it will work in a newer
release if they change the refresh mechanism.  

HTH,

-- Anita

--- Henry Poras <[EMAIL PROTECTED]> wrote:
> Guess I wasn't too clear. Here's the scoop (there is
> probably a much easier
> way to do this, but I just can't get there from
> here). There is a 10million
> row table on a remote database. Each week, there is
> a change in about
> 5-10,000 rows (inserts). Currently this table is
> brought over to a local
> database. A convoluted query is then run to keep our
> developers happy and
> the result set is entered into another table. The
> query, though convoluted,
> does not use any aggregate functions, just a mess of
> joins. Right now this
> query is run on the complete 10 million row table
> brought over from the
> remote database. What I would like to do is to run
> the query on just the new
> rows, appending this result to the existing data.
> Since the snapshot log
> used for a fast refresh already keeps track of this
> for me I thought it
> might be a nice way to go. (I guess I could always
> flip a flag field, but
> why do extra work if Oracle already does it for me?)
> 
> 
> So my plan was to create a procedure which will
> manually take a fast
> refresh, run the query, check for success, truncate
> the table underlying the
> snapshot view. Since the underlying structure is
> just a table, and the
> master log data transfer is strictly in one
> direction, it looks like it
> should work, but are there any gothchas? It seems to
> be OK on a test system.
> 
> Thanks again.
> 
> Henry
> 
> 
> -Original Message-
> Sent: Sunday, September 16, 2001 9:38 AM
> To: [EMAIL PROTECTED]; Henry Poras
> 
> 
> Henry,
> 
> I'm not sure what you're trying to accomplish by
> truncating the snapshot.  The whole point of the
> refresh process is to keep the snapshot in sync with
> the master site.
> 
> Presumably you are doing a CTAS off of the snapshot
> to
> do your manipulations, so what is the point in
> truncating the snapshot?  I don't have a db handy to
> test whether Oracle detects that the snapshot has
> been
> truncated and does a complete refresh, but 



RE: Bulk collect error


2001-09-20

Thread
Csillag Zsolt


Hi,

I think I provided the details you need.
But to be sure : Oracle 8.1.6 Personal edition, cost based optimizer.

The problem is that I can' t TRANSLATE  the package because of PLS-00103 error.
So there should be a syntax problem but I don' t know what I' ve done wrong.

Thanx



At 04:20 2001.09.20. -0800, you wrote:
>Can you provide simplified resource details
>
> > -Original Message-
> > From: Csillag Zsolt [SMTP:[EMAIL PROTECTED]]
> > Sent: Wednesday, September 19, 2001 11:40 PM
> > To:   Multiple recipients of list ORACLE-L
> > Subject:  Bulk collect error
> >
> > can you provide simlified resource details.
> >
> >
> >
> > Hi,
> >
> > The following statment works perfectly:
> >
> >   Select F.Fofejezet_Megnevezes_Magyar,F.FOFEJEZET_AZONOSITO2,
> >  (Select Count(*) from alfejezet where
> > alfejezet.ALFEJEZET_FOFEJEZET_AZONOSITO2= F.Fofejezet_Azonosito2)
> >
> >   From Fofejezet F ;
> >
> >
> > However when I put this very same statement into a Pl/Sql procedure with
> > Bulk Collect,
> > I get PLS-00103 error:
> >
> >   Select F.Fofejezet_Megnevezes_Magyar,F.FOFEJEZET_AZONOSITO2,
> >  (Select Count(*) from alfejezet where
> > alfejezet.ALFEJEZET_FOFEJEZET_AZONOSITO2= F.Fofejezet_Azonosito2)
> >
> > Bulk Collect Into
> > Vissza.FoFejezetNev,Vissza.FoFejezetKod,Vissza.Darab
> >
> >   From Fofejezet F ;
> >
> >
> > Can somebody help me?
> >
> > Thank you
> >
> >
> > Zsolt Csillag
> > Hungary
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Csillag Zsolt
> >   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 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 subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Nirmal Kumar  Muthu Kumaran
>   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 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 subscribing).

Zsolt Csillag
Hungary

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Csillag Zsolt
  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 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 subscribing).






RE: LINUX ORACLE INSTALL ERROR


2001-09-20

Thread
Gogala, Mladen


Yes, many people experienced that before. Oracle 8.0 works on GLIBC 2.0
(there is a compatibility
patch for GLIBC 2.1) and RH 7.1 is a GLIBC 2.2. Can you, please, downgrade
your OS to RH 5.1
or install 8.1.7 or 9i ?
Kindest regards!

-Original Message-
Sent: Thursday, September 20, 2001 2:11 PM
To: Multiple recipients of list ORACLE-L


I have succesfully installed oracle 8.0.5 on LINUX redhat 7.1 BUT
when I want to run sqlplus or lsnrctl it gives SEGMENTATION FAULT error.
and creates core dump files. 
Why does this occur? Has anyone experienced this before ?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gogala, Mladen
  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 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 subscribing).






RE: Create user identified by externally


2001-09-20

Thread
MacGregor, Ian A.


There is an init.oram parameter, REMOTE_OS_AUTHENT. which controls this.  Its default 
value is false.   Setting it to true is begging for trouble.  

BTW, It's "identified externally" not "identified by externally"

Ian MacGregor
Stanford Linear Acccelerator Center
[EMAIL PROTECTED]

-Original Message-
Sent: Thursday, September 20, 2001 10:05 AM
To: Multiple recipients of list ORACLE-L


Hi,

If there is user created using identified by externally, could this user
login to database remotely? If it could, could you please help us?

Thanks,

Jun
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Feng, Jun
  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 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 subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: MacGregor, Ian A.
  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 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 subscribing).






RE: 2nd DBA or ?


2001-09-20

Thread
Farnsworth, Dave


It totally sucks being the only DBA.  Getting a day off is almost not worth
the hassle.  It would be nice to have someone here that I could bounce ideas
off of.  Being able to go to my kids school events without getting hassled
would be a real plus.

Dave

-Original Message-
Sent: Thursday, September 20, 2001 1:31 PM
To: Multiple recipients of list ORACLE-L


Agreed.  Do you want to ever be able to go on a 2 week vacation at some
point in your life?  Or even 1 week overseas?
 
Then you need a 2nd DBA.
 
It's also much better for the company.  If you should ever decide to seek
greener pastures elsewhere there will be someone familiar with all their
systems and databases.
 

-Original Message-
Sent: Thursday, September 20, 2001 1:56 PM
To: Multiple recipients of list ORACLE-L



second person, you get to have a life 


-Original Message- 
 ] 
Sent: Thursday, September 20, 2001 12:30 PM 
To: Multiple recipients of list ORACLE-L 


I've been presented with an opportunity to justify requirements for a 2nd 
DBA at our site.  As I see it there are an number of paths this presents: 

1 - Justify and get a 2nd DBA.  
Pro's: Gives me more time to get involved in other projects as a senior DBA.

Holidays and attendance at courses and seminars etc. easier to take 

2 - Outsource this role and activate it when required and justify putting 
money into investing in software and/or hardware to allow a single DBA 
function to required levels. 
Pros: New tools etc. to learn and broader experience gained.  More 
bargaining power if required. 

I'd like to hear your feedback on which path you'd be inclined to take and 
why?.  Also if going it alone what you'd look for software in hardware and 
other areas.  Currently 6 NT servers, 10 databases and expanding... 


Sean :) 

Rookie Data Base Administrator 
Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K 
[0%] OCP Oracle8i DBA 
[0%] OCP Oracle9i DBA 
  
Organon (Ireland) Ltd. 
E-mail: [EMAIL PROTECTED]   [subscribed: Digest Mode] 

Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA
  

"Nobody loves me but my mother... and she could be jivin' too."  - BB King 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
  
-- 
Author: O'Neill, Sean 
  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 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 subscribing). 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Miller, Jay
  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 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 subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Farnsworth, Dave
  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 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 subscribing).






RE: 2nd DBA or ?


2001-09-20

Thread
Gogala, Mladen


What is "vacation"? 

> -Original Message-
> From: Miller, Jay [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 20, 2001 2:31 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: 2nd DBA or ?
> 
> 
> Agreed.  Do you want to ever be able to go on a 2 week 
> vacation at some
> point in your life?  Or even 1 week overseas?
>  
> Then you need a 2nd DBA.
>  
> It's also much better for the company.  If you should ever 
> decide to seek
> greener pastures elsewhere there will be someone familiar 
> with all their
> systems and databases.
>  
> 
> -Original Message-
> Sent: Thursday, September 20, 2001 1:56 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> second person, you get to have a life 
> 
> 
> -Original Message- 
>  ] 
> Sent: Thursday, September 20, 2001 12:30 PM 
> To: Multiple recipients of list ORACLE-L 
> 
> 
> I've been presented with an opportunity to justify 
> requirements for a 2nd 
> DBA at our site.  As I see it there are an number of paths 
> this presents: 
> 
> 1 - Justify and get a 2nd DBA.  
> Pro's: Gives me more time to get involved in other projects 
> as a senior DBA.
> 
> Holidays and attendance at courses and seminars etc. easier to take 
> 
> 2 - Outsource this role and activate it when required and 
> justify putting 
> money into investing in software and/or hardware to allow a 
> single DBA 
> function to required levels. 
> Pros: New tools etc. to learn and broader experience gained.  More 
> bargaining power if required. 
> 
> I'd like to hear your feedback on which path you'd be 
> inclined to take and 
> why?.  Also if going it alone what you'd look for software in 
> hardware and 
> other areas.  Currently 6 NT servers, 10 databases and expanding... 
> 
> 
> Sean :) 
> 
> Rookie Data Base Administrator 
> Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K 
> [0%] OCP Oracle8i DBA 
> [0%] OCP Oracle9i DBA 
>   
> Organon (Ireland) Ltd. 
> E-mail: [EMAIL PROTECTED]   [subscribed: Digest Mode] 
> 
> Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA
>   
> 
> "Nobody loves me but my mother... and she could be jivin' 
> too."  - BB King 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
>   
> -- 
> Author: O'Neill, Sean 
>   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 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 subscribing). 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Miller, Jay
>   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 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 subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gogala, Mladen
  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 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 subscribing).






how to find privileges granted to a role


2001-09-20

Thread
Davydov, Vitaliy


I'd like to find out what object privileges are granted to a particular
role.
Tried to query role_tab_privs, but no luck.
Thank you.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Davydov, Vitaliy
  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 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 subscribing).






Waking SMON Not Doing Trick


2001-09-20

Thread
Bellefeuille, Wayne S


Back in 8.0 days, we were running into space problems for temp segments
while rebuilding indexes on our large partitioned tables.  Someone on
this list suggested that we use the "wake SMON" approach, which
essentially running the following command from svrmgrl:  noradebug
wakeup .

This worked great.  However, now that we have moved to 8i, we have
started getting the temp segments space problem again.  That is, this
command doesn't seem to be doing its job anymore.

Any ideas?

Wayne Bellefeuille
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bellefeuille, Wayne S
  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 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 subscribing).






RE: Two Instances at one oracle Server


2001-09-20

Thread
JOE TESTA




excellent idea, one that i'll remember for future reference.
 
thanks, joe
>>> [EMAIL PROTECTED] 09/20/01 01:46PM 
>>>LOL.  You want be to give up all my secrets?  
OK.  You also have amaintenance listener which is not on ONAMES or the 
user's TNSNAMES.ORA.Your DBA group keeps working without worrying about 
stepping on users orhaving users lock objects. It's simplistic but it works 
great if your DBAgroup is geographically 
distributed.    
    
JOE 
TESTA   
    
    
erger.com>    
<[EMAIL PROTECTED]>    
    
Sent 
by:  
cc:   
    
[EMAIL PROTECTED]    
Subject: RE: Two Instances at one 
oracle  
    
om    
Server    
    
    
    
09/20/2001  
    
12:52 
PM    
    
Please 
respond  
    
to 
ORACLE-L 
    
    
ok i give, what is the difference 
between1.  shutting down a listener2.  alter database 
enable restricted session where only the DBAs haverestricted 
session.and without a listener, the local connected people can still 
connect to thedatabase, so you've only stoppped remote connections by 
stopping thelistener.joe>>> [EMAIL PROTECTED] 
09/20/01 12:20PM  >>>True.  However, I find it useful to 
have one listener per  instance so thatI can restrict access to an 
instance without having to alter  
thedatabase. 
Nirmal  
Kumar 
Muthu Kumaran 
To: Multiple recipients oflist  
ORACLE-L 
 
.com.qa>  
cc: 
Sent 
by:  
Subject: RE: Two Instancesat one  
oracle 
root@fatcity. 
Server 
com 
09/20/2001 
11:30  
AM 
Please 
respond  
to 
ORACLE-LNo.. Not necessary for more listeners.One 
listener is  enough to listen many servers.Nirmal.> 
-Original  Message-> From:   [EMAIL PROTECTED]  
[SMTP:[EMAIL PROTECTED]]> Sent:   Thursday, September 20, 2001 
5:51  PM> To: Multiple recipients of 
list  ORACLE-L> Subject: Re: Two Instances 
at one  oracle Server>> I'm sure that someone will correct me 
if I'm wrong  but:>> The database is the physical datafiles 
laid out on the  storage devices -> hard disks;> The instance 
is the logical  constructions (SGA) that exist, hopefully,in> 
RAM;> The services  are the NT operating system equivalent of UNIX 
processes> which>  run the Oracle engine against the instance 
to access the  database.>> In theory, an instance could be 
used to access  multiple databases;> however,> in practice, 
DBAs set up one  instance that will be used to access one> database 
(and no other  database).>> Also, databases could, in theory, 
be accessed from  multiple instances;> however, in practice, DBAs 
set up a database to be  accessed from onlyone> instance (and no 
other instance).>>  Microsoft NT sets up the service so that 
it executes against one, given>  instance.  However, NT will 
allow multiple services.>> So,  you can have two databases, 
two instances, and two services on the>  same> NT 
server.  You'll also need two listeners and two services to  run 
those> listeners.>> You'll probably need to read the  
manuals for the exact  
details.>>  
Nirmal  
Kumar>>  
Muthu Kumaran 
To: Multiple recipients of> list  
ORACLE-L>  
>>  
.com.qa>  
cc:>>  
Sent 
by:  
Subject: Two Instances atone> oracle  
Server>  
root@fatcity.>>  
com>>  
09/19/2001>>  
03:55  
AM>>  
Please>>  
respond  
to>>  
ORACLE-L>>  
Guru's>> In my test oracle server, i created two different  
database with SID> 'orclsvr' and 'ora817'.>> Is't 
possisle  to create two oracle database in



RE: 2nd DBA or ?


2001-09-20

Thread
George Hofilena


I agree.  Never heard of that word either.  Is it a new feature in 9i?

George

-Original Message-
Sent: Thursday, September 20, 2001 11:56 AM
To: Multiple recipients of list ORACLE-L


What is "vacation"? 

> -Original Message-
> From: Miller, Jay [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 20, 2001 2:31 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: 2nd DBA or ?
> 
> 
> Agreed.  Do you want to ever be able to go on a 2 week 
> vacation at some
> point in your life?  Or even 1 week overseas?
>  
> Then you need a 2nd DBA.
>  
> It's also much better for the company.  If you should ever 
> decide to seek
> greener pastures elsewhere there will be someone familiar 
> with all their
> systems and databases.
>  
> 
> -Original Message-
> Sent: Thursday, September 20, 2001 1:56 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> second person, you get to have a life 
> 
> 
> -Original Message- 
>  ] 
> Sent: Thursday, September 20, 2001 12:30 PM 
> To: Multiple recipients of list ORACLE-L 
> 
> 
> I've been presented with an opportunity to justify 
> requirements for a 2nd 
> DBA at our site.  As I see it there are an number of paths 
> this presents: 
> 
> 1 - Justify and get a 2nd DBA.  
> Pro's: Gives me more time to get involved in other projects 
> as a senior DBA.
> 
> Holidays and attendance at courses and seminars etc. easier to take 
> 
> 2 - Outsource this role and activate it when required and 
> justify putting 
> money into investing in software and/or hardware to allow a 
> single DBA 
> function to required levels. 
> Pros: New tools etc. to learn and broader experience gained.  More 
> bargaining power if required. 
> 
> I'd like to hear your feedback on which path you'd be 
> inclined to take and 
> why?.  Also if going it alone what you'd look for software in 
> hardware and 
> other areas.  Currently 6 NT servers, 10 databases and expanding... 
> 
> 
> Sean :) 
> 
> Rookie Data Base Administrator 
> Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K 
> [0%] OCP Oracle8i DBA 
> [0%] OCP Oracle9i DBA 
>   
> Organon (Ireland) Ltd. 
> E-mail: [EMAIL PROTECTED]   [subscribed: Digest Mode] 
> 
> Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA
>   
> 
> "Nobody loves me but my mother... and she could be jivin' 
> too."  - BB King 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
>   
> -- 
> Author: O'Neill, Sean 
>   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 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 subscribing). 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Miller, Jay
>   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 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 subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gogala, Mladen
  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 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 subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: George Hofilena
  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 an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a 



Re: Create user identified by externally


2001-09-20

Thread
Anjan Thakuria


Jun,

What I understood was that "identified externally" was that it was
authenticated by the os and therefore only local os users can login onto the
db. Hope input from other listers will help.

A.

"Feng, Jun" wrote:

> Hi,
>
> If there is user created using identified by externally, could this user
> login to database remotely? If it could, could you please help us?
>
> Thanks,
>
> Jun
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Feng, Jun
>   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 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 subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Anjan Thakuria
  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 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 subscribing).






RE: query fails when run using microsoft odbc driver


2001-09-20

Thread
DENNIS WILLIAMS


Harvinder - Are you using descending columns on any of your indexes? I have
heard that Microsoft Access has problems querying tables that use this
feature? Just a thought.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Thursday, September 20, 2001 1:31 PM
To: Multiple recipients of list ORACLE-L


Hi,

We have a query which runs fine from sqlplus but return following error when
runs from appliction using
MICROSOFT ODBC Driver:
ora-00904 INVALID COLUMN NAME 

Code of query is:
it seems like  specification of table template_po_map is creating
problem...
how to fix it .

select
   DISTINCT(t_po.id_po),
   t_po.id_eff_date,
   t_po.id_avail,
   t_po.b_user_subscribe,
   t_po.b_user_unsubscribe, 
   t_base_props.n_name,
   t_base_props.n_desc,
   t_base_props.n_display_name,
   t_base_props.nm_name,
   t_base_props.nm_desc,
   t_base_props.nm_display_name,
   te.n_begintype as te_n_begintype,
   te.dt_start as te_dt_start, 
   te.n_beginoffset as te_n_beginoffset,
   te.n_endtype as te_n_endtype,
   te.dt_end as te_dt_end,
   te.n_endoffset as te_n_endoffset,
   ta.n_begintype as ta_n_begintype,
   ta.dt_start as ta_dt_start, 
   ta.n_beginoffset as ta_n_beginoffset,
   ta.n_endtype as ta_n_endtype,
   ta.dt_end as ta_dt_end,
   ta.n_endoffset as ta_n_endoffset
   ,template_po_map.b_RecurringCharge
   ,t_ep_po.c_boris
t_ep_po_c_boris,t_ep_po.c_ExternalInformationURL
t_ep__c_ExternalInformationURL,t_ep_po.c_glcode
t_ep_po_c_glcode,t_ep_po.c_InternalInformationURL
t_ep__c_InternalInformationURL 
from 
   (select GetUTCDate() now from dual)
cdate,
   t_po,t_ep_po, 
   t_effectivedate te,
   t_effectivedate ta,

   t_base_props,
   (SELECT id_po,
decode(MAX(YesNo),1,'Y','N') b_RecurringCharge
FROM
(SELECT
t_pl_map.id_po,

decode(tb.n_kind,20,decode(sign(count(*)),1,1,0),0) YesNo
FROM
t_av_internal tav,
t_pricelist,
t_base_props tb,
t_pl_map,
t_recur,
t_discount,
t_aggregate
WHERE
-- Check currency
t_recur.id_prop(+) =
t_pl_map.id_pi_template and
 
t_discount.id_prop(+) = t_pl_map.id_pi_template and
 
t_aggregate.id_prop(+) = t_pl_map.id_pi_template and
tav.id_acc = 134 AND

t_pricelist.id_pricelist = t_pl_map.id_pricelist AND
tav.c_currency =
t_pricelist.nm_currency_code AND
-- Check cycle type

(t_recur.id_cycle_type is null or
 
t_recur.id_cycle_type = (select id_cycle_type
from
t_acc_usage_cycle, t_usage_cycle
where
t_acc_usage_cycle.id_acc = 134
AND
t_usage_cycle.id_usage_cycle = t_acc_usage_cycle.id_usage_cycle)) AND

(t_discount.id_cycle_type is null or
 
t_discount.id_cycle_type = (select id_cycle_type from t_acc_usage_cycle,
 



RE: Bulk collect error


2001-09-20

Thread
Jamadagni, Rajendra


What is the definition for Vissza.FoFejezetNev and Vissza.FoFejezetKod and
Vissza.Darab ??

Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art !

*1

This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.

*1

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jamadagni, Rajendra
  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 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 subscribing).






RE: Are RAID 1+0 and 10 the same thing?


2001-09-20

Thread
Gaja Krishna Vaidyanatha


Hi Ed & list,

Actually, I did not mention any "implementation
differences" in the RAID paper, as I did not think it
added much value. At any rate, now that you have
asked, I shall try to deliver.

One of the differences that I allude to in my article,
is that RAID 10 or 1+0 is a striped device whose
segments (or stripe units) are mirrored (RAID 1). But,
when you compare one vendor's implementation to
another's, you may observe that the location and
placement of each RAID 1 segment may be different,
when compared to a RAID 1+0 device. This is purely
dependent on "vendor implementation", which is the
reason why I mention, that they are "functionally
equivalent", but may different in implementation. 

Hope that helps,

Gaja

--- "Shevtsov, Eduard" <[EMAIL PROTECTED]> wrote:
> 
> thanks for the reply. I share your opinion but
> believe there is some minor
> difference.
> According to Gaja's article: 
> 
> It must be noted here that RAID 10 is a derivative
> of RAID 1+0 with similar
> performance and availability characteristics, but
> with some implementation
> differences.
> 
> I'm curious what implementation differences did Gaja
> mention?
> 
> Regards,
> Ed
> 
> >  
> >  Yes. Both are same.
> >  
> >  
> >  
> >  -Original Message-
> >  Eduard
> >  Sent: Thursday, September 20, 2001 4:35 AM
> >  To: Multiple recipients of list ORACLE-L
> >  
> >  
> >  Hi List,
> >  
> >  is there any difference between 1+0 and 10?
> >  
> >  Regards,
> >  Ed
> >  --
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Shevtsov, Eduard
>   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 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 subscribing).


=
Gaja Krishna Vaidyanatha
Director, Storage Management Products,
Quest Software, Inc.
Co-author - Oracle Performance Tuning 101
http://www.osborne.com/database_erp/0072131454/0072131454.shtml

__
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gaja Krishna Vaidyanatha
  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 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 subscribing).






RE: Create user identified by externally


2001-09-20

Thread
Hand, Michael T



However if you actually created the user by using the command:

create user OPS$ABC identified BY externally . . . [See Below]

Oracle8 Enterprise Edition Release 8.0.6.3.0 - Production
PL/SQL Release 8.0.6.3.0 - Production

SQL> create user test identified by externally;

User created.

SQL> grant connect to test
  2  ; 

Grant succeeded.

SQL> connect test/externally;
Connected.


-Original Message-
Sent: Thursday, September 20, 2001 1:05 PM
To: Multiple recipients of list ORACLE-L


Hi,

If there is user created using identified by externally, could this user
login to database remotely? If it could, could you please help us?

Thanks,

Jun
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Feng, Jun
  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 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 subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hand, Michael T
  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 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 subscribing).






coalesce tablespace


2001-09-20

Thread
Sandi . McClary


We have tablespaces in acceptance and production that are being resized for
growth.  Pctincrease is set at 0.  Would it also help to coalesce the
tablespace?  What are the benefits of this command?
Thanks,
Sandi

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  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 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 subscribing).






Re: how to find privileges granted to a role


2001-09-20

Thread
Sandi . McClary



DBA_ROLE_PRIVS provides roles granted to users and to roles.





   
 
"Davydov,  
 
Vitaliy" To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
Subject: how to find privileges granted 
to a role  
Sent by:   
 
root@fatcity.  
 
com
 
   
 
   
 
09/20/01   
 
01:05 PM   
 
Please 
 
respond to 
 
ORACLE-L   
 
   
 
   
 




I'd like to find out what object privileges are granted to a particular
role.
Tried to query role_tab_privs, but no luck.
Thank you.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Davydov, Vitaliy
  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 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 subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  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 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 subscribing).






RE: 2nd DBA or ?


2001-09-20

Thread
Thater, William


At 02:55 PM 9/20/2001, you wrote:
>What is "vacation"?

it's the time you don't spend sitting at your desk, but dialed in sitting 
in a hotel room. too bad that none of the ones i can afford have 
comfortable chairs.;-)





--
Bill "Shrek" Thater  ORACLE DBA
Telergy,Inc.   [EMAIL PROTECTED]

You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.

No extensible language will be universal.  - T. Cheatham



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Thater, William
  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 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 subscribing).






RE: Better Way Of DeFragmentation


2001-09-20

Thread
tday6


True.  If he clones the whole database each way.  My understanding was that
he planned just to move the schema into a dummy database, resize the
objects, do a cold backup, and move the datafiles from the cold backup that
contained the appropriate tablespaces.  I don't think that that would work.



   
 
"Miller, Jay"  
 
<[EMAIL PROTECTED]>   
 
Sent by:  cc:  
 
[EMAIL PROTECTED]  Subject: RE: Better Way Of 
DeFragmentation
   
 
   
 
09/20/2001 02:31   
 
PM 
 
Please respond to  
 
ORACLE-L   
 
   
 
   
 




My understanding that he was copying the control files also - i.e., cloning
the 2nd database back to the first machine.  This works since he said it's
usually read only so there wouldn't have been any changes between when he
cloned 1 to 2 and when he clones 2 to 1.



-Original Message-
Sent: Thursday, September 20, 2001 11:31 AM
To: Multiple recipients of list ORACLE-L


Consider going to tablespaces where all the extents are of a uniform size.
I.e., all objects in any one tablespace have the same INITIAL and NEXT
storage parameters.  These tablespaces will never need to be defragmented.

I'm not sure that your outlined procedure will work.  I think that your
cold backup from the 2nd machine will be out of synch (timestamp-wise) with
your control files.  It may be possible to do some recovery to overcome
this but I'm not familiar with that.

You could do an export from the 2nd machine, drop the tablespace(s) on the
1st machine, and do in import.

If you have data that is changing a lot over time, then you could get set
all the objects' NEXT parameter to a uniform size and the tablespaces will
coalesce naturally over time.





Harvinder Singh

   <[EMAIL PROTECTED]>

Sent by: cc:

[EMAIL PROTECTED] Subject: Better Way Of
DeFragmentation




09/20/2001 10:35 AM

Please respond to

ORACLE-L









Hi,

We have to defragment one of our production databases..(objects are not
properly sized)..
Since i can't shutdown database for more than 2 hrs and database is read
only and  DML
statements run thru batch jobs 2 days in month. We r thinking of using the
following scheme.

1) export the particular application schema name NMDD of production
database.
2) On second machine run the DDL script which creates all the objects with
proper sizing.
3) Import the data from export taken in step 1.
4) take the cold backup of 2nd machine.
5) copy the backup files from 2nd machine to production machine.

Is there any better way to get rid of fragmentation without using any third
party tool..
or Is there any flaw in above procedure.

Thanks
-Harvinder
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Harvinder Singh
  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 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 subscribing).


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  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 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 th



Re: how to find privileges granted to a role


2001-09-20

Thread
tday6


You'll probably want to pare this down.  It shows all privileges granted to
a particular role or user.  It takes one parameter, the role or privilege
being queried for.  It's not mine, but unfortunately I didn't document
where I picked it up.

--spool c:\project\listings\grantsfor&&1

set linesize 132 pagesize 66 verify off
ttitle "List Grants for User or Role "&&1 skip 2
column name heading 'Name'
column role heading 'Role'
column tname heading 'Table'
column priv heading 'Privilege'
select
substr(o.username,1,8) name,
o.granted_role role,
t.table_name tname,
t.privilege priv
from user_role_privs o,
user_tab_privs t
where
o.granted_role=t.grantee
order by 1,3,2
/
select o.granted_role role,
s.privilege priv
from
role_sys_privs s,
user_role_privs o
where
o.granted_role=s.role
/
select username name,
privilege priv
from
user_sys_privs
/

--spool off




   

"Davydov,  

Vitaliy" To: Multiple recipients of list ORACLE-L  



data.com>cc:   

Sent by: Subject: how to find privileges granted 
to a  
root@fatcity.role  

com

   

   

09/20/2001 

03:05 PM   

Please 

respond to 

ORACLE-L   

   

   





I'd like to find out what object privileges are granted to a particular
role.
Tried to query role_tab_privs, but no luck.
Thank you.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Davydov, Vitaliy
  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 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 subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  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 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 subscribing).






RE: Waking SMON Not Doing Trick


2001-09-20

Thread
Norwood Bradly A


Steve Adams has a script, but I don't know if it works 8i

http://www.ixora.com.au/scripts/sql/post_smon.sql


-Original Message-
Sent: Thursday, September 20, 2001 1:56 PM
To: Multiple recipients of list ORACLE-L


Back in 8.0 days, we were running into space problems for temp segments
while rebuilding indexes on our large partitioned tables.  Someone on
this list suggested that we use the "wake SMON" approach, which
essentially running the following command from svrmgrl:  noradebug
wakeup .

This worked great.  However, now that we have moved to 8i, we have
started getting the temp segments space problem again.  That is, this
command doesn't seem to be doing its job anymore.

Any ideas?

Wayne Bellefeuille
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bellefeuille, Wayne S
  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 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 subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Norwood Bradly A
  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 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 subscribing).






RE: coalesce tablespace


2001-09-20

Thread
Van M. Etheridge


Sandi

It is my understanding that you can use the coalesce option of the alter
tablespace command to force neighboring free extents to be coalesced
regardless of the default pctincrease setting for the tablespace.

Van

-Original Message-
Sent: Thursday, September 20, 2001 3:40 PM
To: Multiple recipients of list ORACLE-L


We have tablespaces in acceptance and production that are being resized for
growth.  Pctincrease is set at 0.  Would it also help to coalesce the
tablespace?  What are the benefits of this command?
Thanks,
Sandi

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  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 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 subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Van M. Etheridge
  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 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 subscribing).






RE: coalesce tablespace


2001-09-20

Thread
Christopher Spence


It would take contiguous free extents and make them larger extents, which
would be more likely to reuse.  Especially if there are many smaller ones,
this moot if using LMT.

It is a very quick procedure and good to do occasional, you can check in
dba_data_files_coalesced to see if the number is far from 100%, if it is
less than 75% or so, just throw a coalesce on the tablespace.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Thursday, September 20, 2001 3:40 PM
To: Multiple recipients of list ORACLE-L

We have tablespaces in acceptance and production that are being resized for
growth.  Pctincrease is set at 0.  Would it also help to coalesce the
tablespace?  What are the benefits of this command?
Thanks,
Sandi

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  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 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 subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christopher Spence
  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 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 subscribing).






RE: LINUX ORACLE INSTALL ERROR


2001-09-20

Thread
Gautam_Reddy


You don't have to downgrade anything for 9i to install. Follow the below
steps

1) When you get errors from OUI installer, open another  telnet window, and
cd to the Oracle Home
2. Use any editor to modify $ORACLE_HOME/bin/genclntsh file, to remove "-z
defs" form it. (If you want to be more careful make a copy of the file
before you edit.) 
3.Then run this script $ORACLE_HOME/bin/genclntsh to create Oracle
libraries.(. ./genclntsh)
4.Go back to OUI error window, and click on "retry" to continue.


Let me know if you run into any problems.

Thx
Gautam 

 


-Original Message-
Sent: Thursday, September 20, 2001 1:56 PM
To: Multiple recipients of list ORACLE-L


Yes, many people experienced that before. Oracle 8.0 works on GLIBC 2.0
(there is a compatibility patch for GLIBC 2.1) and RH 7.1 is a GLIBC 2.2.
Can you, please, downgrade your OS to RH 5.1 or install 8.1.7 or 9i ?
Kindest regards!

-Original Message-
Sent: Thursday, September 20, 2001 2:11 PM
To: Multiple recipients of list ORACLE-L


I have succesfully installed oracle 8.0.5 on LINUX redhat 7.1 BUT when I
want to run sqlplus or lsnrctl it gives SEGMENTATION FAULT error. and
creates core dump files. 
Why does this occur? Has anyone experienced this before ?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gogala, Mladen
  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 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 subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  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 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 subscribing).






RE: 2nd DBA or ?


2001-09-20

Thread
Rachel Carmichael

Title: RE: 2nd DBA or ?





as opposed to a sick day (me, today), when you have surgery and then take pain meds and STILL dial in to the office to check on things?

-Original Message-
From: Thater, William [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 20, 2001 3:45 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: 2nd DBA or ?



At 02:55 PM 9/20/2001, you wrote:
>What is "vacation"?


it's the time you don't spend sitting at your desk, but dialed in sitting 
in a hotel room. too bad that none of the ones i can afford have 
comfortable chairs.;-)






--
Bill "Shrek" Thater  ORACLE DBA
Telergy,Inc.   [EMAIL PROTECTED]

You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.

No extensible language will be universal.  - T. Cheatham




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Thater, William
  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 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 subscribing).








RE: coalesce tablespace


2001-09-20

Thread
Richard Ji


It's dba_free_space_coalesced.

>>> [EMAIL PROTECTED] 09/20/01 04:21PM >>>
It would take contiguous free extents and make them larger extents, which
would be more likely to reuse.  Especially if there are many smaller ones,
this moot if using LMT.

It is a very quick procedure and good to do occasional, you can check in
dba_data_files_coalesced to see if the number is far from 100%, if it is
less than 75% or so, just throw a coalesce on the tablespace.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Thursday, September 20, 2001 3:40 PM
To: Multiple recipients of list ORACLE-L

We have tablespaces in acceptance and production that are being resized for
growth.  Pctincrease is set at 0.  Would it also help to coalesce the
tablespace?  What are the benefits of this command?
Thanks,
Sandi

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: 
  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 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 subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Christopher Spence
  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 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 subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Richard Ji
  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 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 subscribing).






RE: coalesce tablespace


2001-09-20

Thread
Mohammad Rafiq


Following script may be used to check whether coalesing is required or not. 
If lasr column not 100% then coalesce that tbs

select substr(tablespace_name,1,10)TS_NAME,total_extents
"Total_Extnts",extents_coalesced,round(percent_extents_coalesced,0)
from dba_free_space_coalesced
/


MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Thu, 20 Sep 2001 12:21:21 -0800

It would take contiguous free extents and make them larger extents, which
would be more likely to reuse.  Especially if there are many smaller ones,
this moot if using LMT.

It is a very quick procedure and good to do occasional, you can check in
dba_data_files_coalesced to see if the number is far from 100%, if it is
less than 75% or so, just throw a coalesce on the tablespace.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863



-Original Message-
Sent: Thursday, September 20, 2001 3:40 PM
To: Multiple recipients of list ORACLE-L

We have tablespaces in acceptance and production that are being resized for
growth.  Pctincrease is set at 0.  Would it also help to coalesce the
tablespace?  What are the benefits of this command?
Thanks,
Sandi

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
   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 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 subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Christopher Spence
   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 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 subscribing).


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohammad Rafiq
  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 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 subscribing).






Sql to create 'ALTER USER...'


2001-09-20

Thread
Jay Hostetter


Does anybody have a query that will generate the SQL for setting default roles for 
users?  I am trying to set the default roles for users in a test database to match 
those that are in a production database.  The problem is that you must denormalize the 
data from DBA_ROLE_PRIVS into one ALTER USER command.  The type of output I am looking 
for is:

alter user him default role role1,role4,role7;
alter user her default role role4,role5,role7;
etc...

Maybe this is easy and I am just having trouble concentrating this afternoon...

Thank you,


Jay Hostetter
Oracle DBA
D. & E. Communications
Ephrata, PA  USA

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jay Hostetter
  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 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 subscribing).






RE: List of changed objects in the DB


2001-09-20

Thread
Christopher Spence


Have a look at log miner.

That will also help, although you need to go log to log, so if it is a long
period of time, it take a few.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Tuesday, September 18, 2001 1:15 PM
To: Multiple recipients of list ORACLE-L

Hi all,

is it possible to identify only those objects that have changed since a
given date? Wait ... I know last_ddl_timestamp but we would like to EXCLUDE
stored code which has been recompiled and INCLUDE only those procedures/
functions/ packages that were created.

any ideas?

TIA
Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art !


*2

This e-mail message is confidential, intended only for the named
recipient(s) above and may contain information that is privileged, attorney
work product or exempt from disclosure under applicable law. If you have
received this message in error, or are not the named recipient(s), please
immediately notify corporate MIS at (860) 766-2000 and delete this e-mail
message from your computer, Thank you.

*2

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jamadagni, Rajendra
  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 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 subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christopher Spence
  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 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 subscribing).






RE: 2nd DBA or ?


2001-09-20

Thread
Thater, William


At 04:50 PM 9/20/2001, Rachel Carmichael wrote:

>as opposed to a sick day (me, today), when you have surgery and then take 
>pain meds and STILL dial in to the office to check on things?

yes, that's a sick day all right.  vacations are when you don't take the 
pain meds.;-)




--
Bill "Shrek" Thater  ORACLE DBA
Telergy,Inc.   [EMAIL PROTECTED]

You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.

No extensible language will be universal.  - T. Cheatham



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Thater, William
  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 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 subscribing).






Best Uses for Oracle Designer 2000?


2001-09-20

Thread
David Wagoner









Is anyone out there deriving much benefit from Oracle Designer
2000?  My company has the product
and I set it up but it looks like the initial investment in learning the
product and creating everything in the repository will be extremely
time-consuming.  So, please tell me
your favorite uses for Designer.

 

 

Thanks,

 

David

 

David B. Wagoner

Database Administrator

Arsenal Digital Solutions Worldwide Inc.

4815 Emperor
Blvd., Suite 110

Durham, NC
27703

Tel. (919)
941-4645

Fax (919)
474-0695

Email mailto:[EMAIL PROTECTED]

Web http://www.arsenaldigital.com/

 

 
***  NOTICE  ***

This e-mail
message is confidential, intended only for the named recipient(s) above and may
contain information that is privileged, work product or exempt from disclosure
under applicable law.  If you have
received this message in error, or are not the named recipient(s), please
immediately notify the sender at (919) 941-4645 and delete this e-mail message
from your computer.  Thank you.

 











Upgrade to 8.1.7.2 on Linux -- an interesting happening


2001-09-20

Thread
Weaver, Walt


Today we upgraded one of our 8.1.7.0.1 _STANDARD EDITION_ distributions on a
test server to 8.1.7.2.

An interesting thing happened.

After we brought up the test database we had running on the machine, it came
up indicating that we were running the _ENTERPRISE EDITION_ of Oracle. A
query of v$option showed that we were, indeed, running the Enterprise
Edition of Oracle.

Just for grins, we restored the old 8.1.7.0.1 distribution, brought up the
old database, and it was running under the Standard Edition.

Has anyone else done an upgrade to 8.1.7.2? Anyone notice the same thing?

We think it's great of Oracle to provide us a patch allowing us to
seamlessly switch to the Enterprise Edition.

Somehow, though, I don't think that's what they're trying to do here...

--Walt Weaver
  Bozeman, Montana
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Weaver, Walt
  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 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 subscribing).






Re: Upgrade to 8.1.7.2 on Linux -- an interesting happening


2001-09-20

Thread
Rodd Holman


Maybe it's a way for Larry to get more $$.  Next they will send out an 
audit ferret and say that everyone who applied the patch now owes them 
for an upgrade. ;-)

Rodd

>> Original Message <<

On 9/20/01, 5:20:19 PM, "Weaver," Walt <[EMAIL PROTECTED]> wrote 
regarding Upgrade to 8.1.7.2 on Linux -- an interesting happening:


> Today we upgraded one of our 8.1.7.0.1 _STANDARD EDITION_ distributions 
on a
> test server to 8.1.7.2.

> An interesting thing happened.

> After we brought up the test database we had running on the machine, it 
came
> up indicating that we were running the _ENTERPRISE EDITION_ of Oracle. A
> query of v$option showed that we were, indeed, running the Enterprise
> Edition of Oracle.

> Just for grins, we restored the old 8.1.7.0.1 distribution, brought up 
the
> old database, and it was running under the Standard Edition.

> Has anyone else done an upgrade to 8.1.7.2? Anyone notice the same thing?

> We think it's great of Oracle to provide us a patch allowing us to
> seamlessly switch to the Enterprise Edition.

> Somehow, though, I don't think that's what they're trying to do here...

> --Walt Weaver
>   Bozeman, Montana
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Weaver, Walt
>   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 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 subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rodd Holman
  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 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 subscribing).






Re: Create user identified by externally


2001-09-20

Thread
Anjan Thakuria



Thanks Bill,
Will it be something like this /@.. An example will
really help.
Anjan.
"Chen, Bill" wrote:
 
yes. make sure 'remote_os_auth...' is set to true in your
init.ora
bounce the db to make this effective.
bill
-Original Message-
From: Feng, Jun [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 20, 2001 12:05 PM
To: Multiple recipients of list ORACLE-L
Subject: Create user identified by externally
Hi,
If there is user created using identified by externally,
could this user
login to database remotely? If it could, could you please
help us?
Thanks,
Jun
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Feng, Jun
  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 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
subscribing).





    
  1   2    >  
  
  

    

      
    
    
 1 - 100 of 115 matches
    

    
Advanced search


Search the list




    
    

      

                               Site Navigation
      
      

        
The Mail Archive home
        

          oracle-l - all messages
        

          oracle-l  - about the list
        
Expand
      
    

    

      

  				Mail list logo