I think you just have to keep trying. Maybe at different times. I
experienced the same as you but with the 9i for Linux download.
HTH
Gerardo
-Original Message-
Sent: Monday, September 17, 2001 11:15 PM
To: Multiple recipients of list ORACLE-L
Hi List
Have any of you been
Hi
I get this error ORA-00600 when i try to execute a stored procedure.
The stored procedure gets compiled perfectly but gives this error at
run-time while executing it from a java code. This is what i found in
the alert log.
Tue Sep 18 04:57:14 2001
Errors in file
Also Enlisted as volunteer
Being Physically in INDIA , may NOT be of much help
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Monday, September 17, 2001 10:40 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Way off topic -
select ADD_MONTHS(trunc(your_date),-1)
from dual;
-Original Message-
From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]]
Sent: Monday, September 17, 2001 17:40
To: Multiple recipients of list ORACLE-L
Subject: Subtract 1 month from current date
Can someone tell me how to subtract
A good solution might be to read the eviromental parameters of the UNIX
session. In there you can set the SID and username/password.
From within the Perl code then do:
$data_source=dbi:Oracle: . $ENV{SID};
$dbbscs = DBI-connect($data_source,$ENV{username},$ENV{passwd});
$sqlstmt_tmcode = select
Satar, I'm afraid that I'm going to have to take issue with this. Bad
English food is, I agree, fairly grim, but the same could be said of bad
food everywhere. Have you ever been to New Jersey? All they eat there
are chicken parm subs! London is one of the great places in the world if
you like
Hi sirisha,
ORA-00600
ORA-00600internal message code, arguments: [num], [?], [?], [?], [?], [?]
Cause:This is a catch-all internal message for ORACLE program exceptions.
It indicates that a process has met a low-level, unexpected condition.
Various causes of this message include:
The site below contains a 7 step guide to constructing a Disaster Recovery
Plan. Enjoy =:-0
http://www.w2knews.com/rd/rd.cfm?id=091301-SevenDRPsteps
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
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
Hi,
I'm running a block of PL/SQL in SQL Plus (8.1.7), and when its completed
it says the usual:
PL/SQL procedure successfully completed.
at the end.
I'm spooling the output of the PL/SQL block to a file using
dbms_put.put_line
but I want to get rid of the above line. Anyone know how I can do
-- Hagedorn, Linda [EMAIL PROTECTED] on 09/17/01 15:00:22 -0800
I'm looking for a Perl example passing parameters.
The code below has the userids and passwords hardcoded in clear text in
the system line, parms 3 and 5 (five lines from the bottom), and the
Oracle sid is hardcoded also.
here is a snippet i use to determine if the db is up. u can use any sql script, i
choose to get the db name and compare to sid.
if [ `which sqlplus | grep no sqlplus | wc -l` -eq 0 ]
[ `print \n\n\n | sqlplus -s guest/guest@$sid @$ORABIN/db_get_dbname | grep
Instance_Name | awk '{print
set feedback off
Jared
Steven Hovington
I'm am trying to use an accept statement to grab some info from the user in
an SQL script,
and then use that in a subsequent PL/SQL block. I can do the Accept ok, but
can't sem to
access the variable onside the block. Can anyone point me in the right
direction?
Thanks in advance.
Steven H.
You know, this list is the greatest! I specifically submitted my name to the
OTN site, to be told *apparently* as soon as the version I am interested in
is released - which was 9i for Win2K. Guess what? The first I hear of this
being released was HERE!! Still haven't heard anything from Oracle!!
Title: Deta_default value not getting imported...
We did full export of a database and then imported the same in another database. The issue is that none of the data_default values have been imported. Has anyone encountered this before. Any links, bugs, actions to point to?
Oracle: 8.1.7
I have a materialized view created by user A in schema
A. The view consists of simple table joins and union
statements. I want user B to be able to execute the
refresh on the MV using dbms_mview.refresh.
I've granted select on all the tables to user B along
with creating public synonyms for
7.3.4.5?
Ok, Charlie, now you're too far the other direction. :)
Jared
Charlie
Hi all,
How to ensure our scripts are not changeable by other user, unix and sql
script.
I remember some unix guru said I need Pro C
Can I use embedded Java
Sinardy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinardy
INET: [EMAIL PROTECTED]
Fat City
I wrote:
So what perks if any do you get for being called in on a Saturday?. The
longer I hang around in this DBA field the more it seems to be like a
vocation ;)
Rachel Replied:
From: Rachel Carmichael [EMAIL PROTECTED]
Date: Mon, 17 Sep 2001 13:07:08 +
Subject: Re: The DBA in the IS
Barry,
A while ago, when I wrote a script to do this for a site, I attempted to
login with a bogus userid/password and then checked for the Oracle error
message. Thereby, eliminating a security hole, and not hugely impacting
Oracle by logging in for a simple check.
Also, I was poking around
Has anyone implemented and used RDA? (It's a diagnostic tool from OWS.)
It might be semi-cool ;-) ...Comments?
Steve Orr
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Orr, Steve
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858)
Hi listers ,
I am getting this error while trying to connect to Oracle
Designer2000(1.3.2) on Oracle 8.0.5 -Plattform NT4 :
Ora-03121 : No interface driver connected-function not performed
Does this thing requires the installation of some Oracle patches Any
help would be
Hi,
We're looking for an inexpensive backup agent for our
databases. The databases are 8i and are on Sun boxes
but we're looking to have the agent/client hosted from
an NT box (because it appears to be cheaper that way).
What are your recommendations? Do all of the agents
work through RMAN
Tuesday, September 18, 2001, 1:30:17 PM, you wrote:
SH I'm am trying to use an accept statement to grab some info from the user in
SH an SQL script,
SH and then use that in a subsequent PL/SQL block. I can do the Accept ok, but
SH can't sem to
SH access the variable onside the block. Can anyone
http://pnnonline.org/
...
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Eric D. Pierce
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access /
Hi Barry!
We use the Oracle supplied program tnsping
as in the following shell script snippet :
-
#!/bin/sh
PATH=/bin:/usr/bin:/$ORACLE_HOME/bin
export PATH
# get SQL*NET alias from first argument or use ORCL as default
oradb=${1:ORCL}
Barry,
Do you get the IOUG-A mag? There was a piece of Pro*C code therein (I'm the
author) that did exactly what you want, but does not use SQL*Plus. There is
also 'oiconnect' that should be in $ORACLE_HOME/bin.
Dick Goulet
Reply Separator
Author:
Hi All,
Here is the summary of all the mails I have recieved to Convert an
oracle table into ASCII/Comma delimeted file.
1. Using sqlplus
Set head off
set pages 1000
spool result.lis
Select col1 ||','|| col2 ||','|| col3 from table;
spool off
or
2. Set colsep ,
spool
We tried that but we had times that tnsping would work but the client could
not connect to the database and return data. We changed to a sqlplus call
which read the v$database view. If we could read that, everyone should be
able to connect. That doesn't solve the timeout problem though.
Ron
call support.
joe
Sirisha wrote:
Hi
I get this error ORA-00600 when i try to execute a stored procedure.
The stored procedure gets compiled perfectly but gives this error at
run-time while executing it from a java code. This is what i found in
the alert log.
Tue Sep 18 04:57:14
Title: RE: Determining Oracle status
tnsping $ORACLE_SID works pretty well...
Nick
-Original Message-
From: Barry Deevey [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 18, 2001 8:46 AM
To: Multiple recipients of list ORACLE-L
Subject: Determining Oracle status
Hi all,
Syntax is
imp user/pw@instance file=export.dmp fromuser=PORDSCHEMA touser=TESTSCHEMA
log=import.log
If you call imp help=y you can see all import parameters.
regards
Volker Schoen
E-Mail: mailto:[EMAIL PROTECTED]
http://www.inplan.de
-Ursprüngliche Nachricht-
Von: Smith, Ron L.
tnsping does not check for database up, its nothing more than a ping to a
listener, they only sure way to see if the database is up is to connect to
it.
and its still that way in 9i.
joe
[EMAIL PROTECTED] 09/18/01 02:40PM
Hi Barry!We use the Oracle supplied program tnsping
as in the
Hi,
Use variable
--
Chris J. Guidry P.Eng.
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: [EMAIL PROTECTED]
-Original Message-
From: Steven Hovington [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, September 18, 2001 11:30 AM
To: Multiple recipients of
Just solved it...Duh!
as sys
grant alter any materialized view to User_B;
--- mohammed bhatti [EMAIL PROTECTED] wrote:
I have a materialized view created by user A in
schema
A. The view consists of simple table joins and
union
statements. I want user B to be able to execute the
refresh
Write your own scripts. Not inexpensive considering the labor cost, but
highly satisfactory.
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
Walter K
Go for it! Rman is cheap (free with Oracle) and works well. You can either
run it from OEM (Backup Manager) or directly from the rman prompt or using
shell scripts.
Good luck,
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, September
I have done a couple DBA trips to the UK. For food, I always skip the
restaurants and goto the pubs, the food has always been fresh and just
great!! I usually order the special for the day, just to try different
things. As for people, everyone has always been very polite and friendly.
On one
We use 3-tier architecture to run our application, the middle tier being an
OAS. How many of you have the middle tier on UNIX platform? I want to know
the pros and cons of having my executables kept on unix server which are
then being accessed from a windows based client.
Most of the links I
Barry,
Depending on your shell, start a timer (korn supports TMOUT). If you don't
get a valid response within N seconds (trap the signal), you've got a
problem.
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
Out of curiosity and as a test I scrubbed my 16Mb RAID1 array and set it up
again with 5 x 50Mb redo groups. I ran the following script to generate
lots of redo:
begin
for i in 1..1500 loop
insert into test_table values (mod(i,10));
delete from
Dick,
I haven't seen oiconnect since v7x. I used to use it (as we've discussed
here previously, tnsping and grepping processes for smon, pmon and the like
won't provide you with a definitive answer for a variety of reasons), but
have since switched to actually logging into the database via a
What version of Oracle are you running? I've seen this ORA-00600 mentioned
in two different patchset fixes (but I guess the bugs weren't public, 'cause
I couldn't view any details on them, so I can't be sure that the other
arguments in the 600 are referring to the same type of error you're
Surely, my good man, you jest! I'm just happy that I convinced peoples that
SELECT ANY TABLE, DELETE ANY TABLE, etc were BAD for app accounts.
That's why I need to do all the GRANTs.
Waiting for that first accidental drop of a SYS object...
Rich Jesse System/Database
Title: Message
Sujatha:
I've
never done this myself, but I would think if you set us a second listener on a
different port, it should work from a SQL*Net point of view. However, you'd
probably have problems in the ORATAB file and in the local environment itself
with things like svrmgrl. On
Hi List,
we have about 2 min difference between the time on our db server and the
rest boxes in our network.
Actually, the time on DB server is 2min slow than the network time.It causes
real pain to us.
I think about the following order of time synchronization:
1. Normal shutdown the DB and
Here's mine. Substitute 'user/pass' for 'internal' when running against external
instances...
if sqlplus -s EOF | grep -q XOK
internal
select dummy||'OK' from dual;
EOF
then echo Oracle Instance ${ORACLE_SID} is up.
else echo Oracle Instance ${ORACLE_SID} is down.
fi
I have been given the nice task of creating a view of some data in our database.
This doesn't seem like a major task, but after 2 days of work, I am stumped.
Given table 'table1'
code1,
code2,
date,
value1,
value2
I need to produce a view showing
code1,
code2,
Title: OT: Need Hardware advice under Linux
Hi List,
I want so setup new oracle server (for developement) under linux. I will install RedHat 7.1. What I like to know is what processor should I choose
AMD Athlon 1,4 Ghz or Intel 1,5 Ghz, I would prefer AMD.
Are there any know problems
I have been given the nice task of creating a view of some data in our database.
This doesn't seem like a major task, but after 2 days of work, I am stumped.
Given table 'table1'
code1,
code2,
date,
value1,
value2
I need to produce a view showing
code1,
code2,
Your
were right. If you want to upgrade the copied Oracle, you would have problem.
What we didwas move the executables from environment to environment, so we
only do one time install on development machine, and copy the executables to all
others (test and product).
Jun
-Original
Been getting that error for a long time when I tried getting the Linux
version.
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)
Only a little over 4 years here and a sys admin for 7, but I completely
agree 100%.
What a lot of people neglect is the bugs that he mentioned, yeah it may test
well under development, or under certain testing, and may even run fine for
a while even months, but when one of those new bugs come up
*How* is this related to oracle?
There is an OFF-TOPIC list for this list for these kinds of
posts.. Please keep them there.
Michael B,
Who is not afraid to ask people to keep off-topic stuff off this list.
At 07:46 AM 9/18/01 -0800, Grabowy, Chris wrote:
I have done a couple DBA trips to
I have no problem to download this patch for AIX. I used winzip to unzip
it.
Joan
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joan Hsieh
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
Sometimes you can resolve ORA-600 messages, there are a few documented ones
(not by oracle of course). But generally I would say it to be very good
practice to call Oracle and have a tar in place for it, they do very little
to document ORA-600 messages, there are many combinations.
Although, I
Title: OT: Web Logic Server
Greetings to all.
Are there any Web Logic Guru's out there? Does anyone know of any forums/lists or url's that deal with web logic issues. Searching google seems to only point to bea's site. Anyone out there running 4.5.1? We're having some complications here
Yes, it would work both ways.
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,
Barry:
I've seen responses saying to use TNSPING, but all that does is tell you if
the listener is running on the destination machine. If the listener is up
and no databases are up you will still get a positive response from TNSPING.
So, here's what we do. This ksh function snippet requires
Hi Dba's,
in my company they told me to create a DB on an IBM AIX box.
I'm new on the AIX environment (I come from VMS) and I have only
found the Oracle
installation manual (Oracle7 Installation and Configuration Guide
for IBM RS/6000 ) that seems to me a little confusing.
There is someone,
Good
morning,
I am
investigating Procedural Gateway for IBM's MQ Series. Documentation seems
to be hard to find.Can anyone suggest a resource (links, books, etc) that would
help in this area?
Thanks,
Mike
I neglected to mention that we're trying to backup to
tape. I'm not sure what is involved with configuring a
media manager for Oracle that will allow Rman to work
with a tape drive but it would seem to me at that
point I'm into a 3rd party solution anyway. Yes? No?
What does it take to get a
Don't know how to change it to only 1 login attempt. But I would do a select sysdate
from dual;
after connect via sqlplus. This way if the 1st login failed, the SQL statement will
cause the next two
attemt fail as well and sqlplus will exit.
Richard Ji
[EMAIL PROTECTED] 09/18/01 11:45AM
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
Call 1-800-223-1711, give them your CSI and tell them that I sent you.
-Original Message-
From: Sirisha [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 18, 2001 2:25 AM
To: Multiple recipients of list ORACLE-L
Subject: ORA-00600
Hi
I get this error ORA-00600 when i
I am migrating from 7.3.4 to 8.1.6 (Enterprise Edition) on Solaris 2.8
Before running the migration I took all the tablespaces except SYSTEM and
Rollback offline as recommended.
When I issued Alter database open resetlogs; I got the following message
for almost every file in the database:
File
I'm looking for a Perl example passing parameters.
The code below has the userids and passwords hardcoded in clear text in the
system line, parms 3 and 5 (five lines from the bottom), and the Oracle sid
is hardcoded also. The code has to be changed to 1) read .pwd1 and .pwd2
files
Hi gurus,
I need get the size in bytes of any table!!!
thanks!!!
@lex
Lic. Alexander Ordóñez Arroyo
Caja Costarricense del Seguro Social
Soporte Técnico - División de Informática
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
William,
Views can't prompt the User for values.
Maybe a stored function or procedure would be better? An application
interface could store a User-provided Date in a public packaged variable,
which could be referenced in the Where clause of the view.
Do you want to Group By just Code1,Code2
I don't how to stop after 1st failed attempt, but here is a script that I
use to check if database is up or not.
#!/usr/bin/ksh
#
# dbcheck : Script to check if datbase is up and accessible.
#It tries to connect via SQL*Net (Net8) using a non-existing
userid and password.
#
#
Just SET FEEDBACK OFF.
SQL set feedback off serveroutput on size 2
SQL begin
2 dbms_output.put_line('Foo');
3 end;
4 /
Foo
--- Steven Hovington [EMAIL PROTECTED] wrote:
Hi,
I'm running a block of PL/SQL in SQL Plus (8.1.7), and when its
completed
it says the usual:
PL/SQL
Steve,
Is that 'inside the block' or 'outside the block'? I assume inside.
therefore try:
accept var_a char prompt 'Insert your variable'
declare
local_var varchar2(100) := var_a;
begin
end;
/
Dick Goulet
Reply Separator
Author: Steven
Man, that was one of their most stable releases. Missing some
nice features mind you. I wish I could bring one of my databases
up to that level. I have one on a very buggy release of 7.3.3
but the vendor application that runs on it is not supported higher
then that.
-Original Message-
Interesting! However, if I had shown a real-world example, I think it
would've poked a hole in your excellent idea. Add schema C (and D and
E) onto this example that schema B also needs to access.
Ain't no way in hell the devs are gonna rewrite all of their code to
accommodate Jeff T's
Use sqlplus internal, although this goes away with 9i
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
Steve,
I've used it a couple of times on NT against a test instance.
It seemed to produce some useful information re wait events, tablespace
sizings etc but probably nothing that you wouldn't be collecting anyway.
It does however put them into a nice html report.
Would be useful I imagine for
Check out the following script.
*** SCRIPT STARTS
HERE*
#!/usr/bin/sh
###
#
# Auther : Raj Sakthi
#
# Modification History:
#
Oracle is designed to handle time changes. For
example switching to and from daylight savings. This is because the
archive logging is not dependent on a date. It has its own sequence.
Therefore changing the date and time even while oracle is up is no
problem. I have done this many times for
Title: RE: List of changed objects in the DB
you might want to take a look at Schema Manager from Quest Software (www.quest.com)... it will not only show you what has changed since the last time you used it... but also build you the code to apply and rollback those changes to different
I need to get an 8.0.5 client and an 8.1.7 client working on the same machine.
Currently, the 8.1.7 is the only one installed. This is an NT
winframe/metaframe server running NT 4.0. Some apps use the 8.1.7 client and
some will require the 8.0.5.
Any suggestions before I start the surgery?
A view is simply an SQL statement. In your case you want the user to be
able to specify a specific date. The problem is quite specific: Each
different date makes a new SQL statement. But a view is based on a single
SQL statement, not multiple SQL statements.
It's like saying you want to sew
And you want be able to do it. Views do not prompt, do not execute anything
and do not run marathons. Views are static views of data. Please, read the
fine manual.
-Original Message-
From: William Rogge [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 18, 2001 11:47 AM
To:
Amar,
I've use OAS on both platforms.
The unix variety is easier to maintain for the most part.
The only unix specific difficulties I ran into were caused by case
sensitivity. Many forms were calling other modules with inconsistent
case, and I had to find these and modify them before the
Bruce and List,
probably nothing that you wouldn't be collecting anyway
Yup, it's pretty lightweight as a database monitoring tool... but I don't
think that was the intent. When you consider everything they've brought
together it makes a decent system documentation tool... especially from a
I tried all the suggestions and the only one that worked was updating the global name
directly to the table.
Mario Alberto Ramos
[EMAIL PROTECTED] 17/09/01 16:35
Thank you all for your replies. I bounced the database and still it has
the same problem.
Regards,
Prasad
Hi,
I have 2 big tables, ITEM (is about 1 million rows) and RTNITEM (is about
20K rows)
When I do:
SELECT ITEM.no,
NVL(SUM(ITEM.CUSTSOLD), 0),
NVL(SUM(RTNITEM.CUSTRTN)
FROM ITEM, RTNITEM
WHERE ITEM.no=RTNITEM.no
GROUP BY ITEM.no;
Time to execute above query is to long.
isn't it still simpler to let the schema owner own procedures that access
tables in that schema, and grant execute on the procedures rather grant SIUD
on all tables owned by each schema owner? I'd think there would be fewer
procedures than tables in each schema
From: Jesse, Rich [EMAIL
Hello guru
I need help on this , I got 2 database reside in 2 server , 1 is a AIX
-server , another is a winnt server ,
everything go smooth when I compile my package( which consist of 10
procedure , 10 function inside)in the winnt server , but when I move my
package to another testing
Doug,
I wrote the below without noticing that it was a winframe server.
I haven't used a winframe server before.
So, if it was a normal PC I would do what is below. I would probably do the
same thing on a winframe server - I would just want to try it on a test
server first.
805 on NT is not
Try to use Index for big table ITEM
To avoid full table scan.
Create index item_index on item(no);
This will speed the process...
--- Sinardy [EMAIL PROTECTED] wrote:
Hi,
I have 2 big tables, ITEM (is about 1 million rows)
and RTNITEM (is about
20K rows)
When I do:
SELECT ITEM.no,
Bill Buchan wrote:
Out of curiosity and as a test I scrubbed my 16Mb RAID1 array and set it up
again with 5 x 50Mb redo groups. I ran the following script to generate
lots of redo:
begin
for i in 1..1500 loop
insert into test_table values (mod(i,10));
Dear listers,
I am trying to copy an updated CLOB from a table in one database (let's call
it A) to the equivalent table in another database (called B just to be
original). I have written triggers and procedures to do this (one package
on each database), and I am passing the contents of the
try nested query in place of sort join method...
- Original Message -
Date: Wednesday, September 19, 2001 11:10 am
Try to use Index for big table ITEM
To avoid full table scan.
Create index item_index on item(no);
This will speed the process...
--- Sinardy [EMAIL PROTECTED]
95 matches
Mail list logo
