Hi Listers,
I had OEM repository on my
database installed on my PC.
Accidentally I dropped the
database. Now I have recreated the database. But an not able to use this
database to create New OEM repository as the OEM config assistant says that the
database already had a repository instal
Thanx a lot Arup,Kirti,Arun and others.
"It worked"
Thanx a lot once again.
i accidentally deleted my mails.
sorry i couldn't thank everyone in person.
Thanx and Regards,
Jp.
15-07-2003 13:25:15, "Arunkumar" <[EMAIL PROTECTED]> wrote:
>
>Fire the following commands .
>
>1) startup pfile='d:
Thanks, but I am _not_ looking for culprits ... and I will be collecting
this data over a week so collecting traces is not an option. I have queries run
by research dept that routinely scan millions of rows, multiple times a
day ... EMC should be happy though ...
Thanks
again
Raj
-O
As user sys, issue
CREATE SPFILE FROM PFILE;
This will create the spfile. You must have started the database using the
pfile to use this command.
HTH.
Arup Nanda
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, July 14, 2003 10:59 PM
>
Try OEM it has a couple of ways to help you do this.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, July 14, 2003 11:19 PM
> make spfile from pfile;
>
> something like that.
>
> I would suggest just deleting it altogether. :)
>
make spfile from pfile;
something like that.
I would suggest just deleting it altogether. :)
- Kirti
--- Prem Khanna J <[EMAIL PROTECTED]> wrote:
> Guys,
>
> i have a 9iR2/win2k test instance.
> i just renamed CONTROL01.CTL once and tried to start the instance.
>
> SQL>startup
> But
USE shortcut like soft link for unix
-Original Message-
Sent: 15 July 2003 10:59
To: Multiple recipients of list ORACLE-L
Guys,
i have a 9iR2/win2k test instance.
i just renamed CONTROL01.CTL once and tried to start the instance.
SQL>startup
But it gave a ORA-00205 error.
so i removed
Guys,
i have a 9iR2/win2k test instance.
i just renamed CONTROL01.CTL once and tried to start the instance.
SQL>startup
But it gave a ORA-00205 error.
so i removed CONTROL01.CTL from INIT.ORA file and started the instance
SQL>startup pfile='d:\oracle\admin\pe92\pfile\init.ora'
Now it worked fin
Hello folks,
Recently, I employed a similar approach in our test
database to figure out the problematic queries during
a certain load test. I used a logon trigger with just 2
statements :
alter sessi
Pete,
Even as a rabid Perl fanatic, I still use KSH to install statspack.
I just modified the stock scripts a bit so they will run without user
input.
You can do it in Perl, but ksh is probably the tool for this job.
Jared
Peter Barnett <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/
Hello folks,
Recently, I employed a similar approach in our test
database to figure out the problematic queries during
a certain load test. I used a logon trigger with just 2
statements :
alter sessio
Hello Martin,
You can create a sequence in Oracle and assign it to
the table. You don';t have to create trigger on it.
Hope this helps
Raju.
sorry for my english too :)
--- pfeffer <[EMAIL PROTECTED]> wrote:
> hi
> i run oracle8 on w2000 advanced server.
> my question is how to create a aut
I looked through the copy of the C program file I sent and spotted the
following "error":
if(i + 1 < p_hdr.no_fields) write(out, "::", 1);
There should only be one ":" in the string ... unless you want "::", in
which case, change the 1 to 2. This isn't really an error since only one
":" is goin
I am mucking through my first real perl script. When
it is finished it will install statspack on all of the
database throughout the company. That's a gob of
databases!
To run in batch mode statspack requires two define
statements:
define default_tablespace = tablespace_name
define tempora
Depending upon the version, you may be able to use the analytical functions (8.1.6+)
to achieve what you want. I don't have a ready example, but the Oracle docs are pretty
good. If you want a less elegant solution, use an inline query, sort by the reverse
order (asc or desc depends on your requi
Attached (I hope)
is a C prog I slapped together to take the contents of a DBF file and blow it
out to a SQL Loader dat file. I got most of the info from
asktom.oracle.com. He has a package posted there to read a DBF file
and insert rows into an oracle table. It is a robust, general-purpo
Looks like foxpro files . Trying to open using odbc
driver .
-ak
- Original Message -
From:
Stephen
Lee
To: Multiple recipients of list ORACLE-L
Sent: Monday, July 14, 2003 11:54
AM
Subject: RE: dbf and cdx files
Are the dbf
files dbase files? If so, I
Don
Well, if you changed the password, then you should have the new password.
Don't post them, because everyone on the internet will have them.
What is your Oracle version?
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, Ju
If you are using Microsoft Transaction Server, then be aware that there
is a crucial patch to 9i that enables it to work correctly. Oracle
shipped a wrong dll oramts.dll with 9i that breaks MTS. I tried 3 times
with metablink to find out what was wrong before the software supplier
pointed this out.
Hi Barbara
> After an upgrade from Oracle 7.3.4 to 8.1.7.4 on
> OpenVMS, some (but not all) of our batch jobs are
> suffering severe performance degradation. One of our
> critical jobs went from 3 hours to 9 hours elapsed
> time.
>
> The reason is obvious. The solution is not. One of
> our jobs
hi
i run oracle8 on w2000 advanced server.
my question is how to create a auto increment primary key for this table:
id number(5)
name varchar(12)
id should auto increment after inserting a new datarow
must i create a trigger ?
excuse my bad english
thx
martin
--
Please see the official ORACLE-L F
A simple ps -ef|grep lsnr will work.
Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX: 816-300-1800
-Original Message-
Sent: Friday, July 11, 2003 11:20 AM
To: Multiple recipients of list ORACLE-L
Hi
When I try to see listener process on Linux box by ps -ef |grep tns .It
doen't s
Dear Guang Mei:
Thanks for your message. Your suggestion is very helpful. After reviewing all possible
uesers, I have locked them. Now I have only one concern that if nobody knows my
database's sys and system's password, there should be no way to unlock these accounts.
Am I complete right?
Thanks!
Yes, as well as SQL*Plus and ODBCTST.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Monday, July 14, 2003 2:59 PM
To: Multiple recipients of list ORACLE-L
Hum, does tnsping resolve the service correctly?
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each
hi
is there a statement like last in mysql ?
last returns a specified number of rows from a select.
means if i do a select and i want only the last 3 lines.
thx
martin
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: pfeffer
INET: [EMAIL PROTECTED]
Fat City Network Service
Toss paradox in too..
YOu might be able to find and old dbf to ascii test converter utility.it
"might" still run in a DOS box on WIndoze...
Old excel version from Office 95 might be able to open them. You would need
to set up 95 or 98 to install...
either wayugly
-Original Message--
Are the dbf files
dbase files? If so, I have something that you might be able to use or
adapt to your purposes.
-Original Message-From: AK
[mailto:[EMAIL PROTECTED]Sent: Monday, July 14, 2003 1:29
PMTo: Multiple recipients of list ORACLE-LSubject: dbf
and cdx files
I hav
Hum, does tnsping resolve the service correctly?
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan
AK,
do you
think it would be easier to ask the person who sent you the file how it is
formatted rather than asking us to guess? tough for us to figure out what
they are.
Tom Mercadante Oracle Certified Professional
-Original Message-From: AK
[mailto:[EMAIL PROTECTED]Sent:
The dbf are databases of Fox, Clipper or DBase. And the
cdx, I am not sure but maybe are index.
You can open the dbf's with Microsoft Excel,
DBU or DBASE. In excel select data type DBase.
>>> [EMAIL PROTECTED] 07/14/03 12:29PM
>>>
I have got some *.cdx and *.dbf files to load . Any
Idea
9.2.0.1.0 On Win 2K.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Monday, July 14, 2003 1:54 PM
To: Multiple recipients of list ORACLE-L
I've seen this happen with older versions of the sqlnet client (Different application,
same
symptom). What vers
clipper/dbase III/foxbase/foxpro?
joe
AK wrote:
I have got some *.cdx and *.dbf files to load . Any Idea what are
these files and how can I open them ?
-ak
--
Joseph S Testa
Chief Technology Officer
Data Management Consulting
p: 614-791-9000
f: 614-791-9001
--
Please see the official ORAC
I have got some *.cdx and *.dbf files to load . Any
Idea what are these files and how can I open them ?
-ak
Hi Don,
I wrote a paper for securityfocus.com a while ago that described a
simple security scanner for Oracle, there is also a script you can run
with the paper. You can get the link on my Oracle security papers page
on my site at www.petefinnigan.com/orasec.htm, the paper is near the top
and is c
Title: RE: Estimating User Load on the system
Thanks John ... this is precisely (the logoff trigger) is what I am in middle ot writing down ... except that I am taking everything from v$sesstat instead of selective stuff. I can then filter out what I don't need.
Raj
--
Raj,
Assuming that these users will logoff normally (for the most cases), you
could have a database level LOGOFF trigger that captures the following
'stats' from these sessions (out of v$MYSTAT):
CPU used by this session (Cpu time used)
user commits (Number of transactions - figuratively!)
phy
I've seen this happen with older versions of the sqlnet client (Different application,
same
symptom). What version of the client are you using?
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan
You will need to grant privileges directly to B and C on A's objects.
Since B and C use PL/SQL code, other users only need to have execution
permission on B and C's procedures. Using AUTHID CURRENT USER in the
creation of the stored programs would require that the stored programs
execute under th
List gurus,
Are there any oracle user groups in Bangalore, INDIA? My nephew is an upcoming Oracle
DBA. He would like to participate in user meetings relevant to Oracle in Bangalore
area.
Any help will be greatly appreciated.
Thanks,
Govind
--
Please see the official ORACLE-L FAQ: http://www
To All, especially any WEB developers out there.
We've a WEB based application that uses MS DTC. OK, so we turned on XA in the
database, but the web servers do not want to play with our normal ONmase setup.
Instead they only want to work with a TNSNAMES.ORA file in the appriopriate pla
Title: RE: Estimating User Load on the system
Thanks Dennis,
I have periodic (10 mins) snapshots taken of following views ...
1. gv$session
2. gv$sesstat
3. gv$transaction
4. gv$sess_io
5. gv$sysstat
Now, I really _can't_ use Statspack, because it tells me overall score. I need to comput
I'll add my favourite - and currently overlooked - point. Network. Not the
entire network as a whole, but specific server things like NIC performance,
protocol stack performance, MTU (see recent excellent post by Matt on jumbo
frames), and all that jazz.
my 2¢
Ciao
Fuzzy
;-)
> -Original Me
Raj
I'll second Jared's idea. Don Burleson in his book Oracle9i
High-Performance Tuning with STATSPACK makes a strong point that looking at
system load must start with the underlying system. Any look at Oracle
performance must begin with an understanding of what the system load was at
that time.
I'm going to ask the obvious question:
Have statistics been generated for the schemas in question?
It's assumed that you're now using CBO, and if stats have
not been generated, then CBO is making assumptions about the
nature of your data.
Jared
On Monday 14 July 2003 07:54, Barbara Baker wrote
Load on a system is in general comprised of three components:
CPU, memory and IO.
If you have something in place to track those on a per user
basis, then you're doing well. You might consider also tracking
other users, so that you have a basis for comparison.
Jared
On Monday 14 July 2003 07:04
Oracle 8.1.7.4
OpenVMS 7.2-1
DIGITAL TCP/IP Services for OpenVMS Alpha Ver
V5.0A-ECO 3
After an upgrade from Oracle 7.3.4 to 8.1.7.4 on
OpenVMS, some (but not all) of our batch jobs are
suffering severe performance degradation. One of our
critical jobs went from 3 hours to 9 hours elapsed
time.
In earlier versions of Oracle with the "TEMP" tablespace being
Dictionary-Managed but
Contents=TEMPORARY, I could "recreate" or "shrink" the temporary segment
without
an Instance restart by executing an "ALTER TABLESPACE TEMP DEFAULT STORAGE
(PCTINCREASE 0)"
-- ie any ALTER command for the sto
Just to update you all...
I am not having any problems if I setup a db
link from 9i to 8i and get the data then enable the constraints.
Oracle asked me to create a test case for
them. I have sent them all the information they have asked for.
Thanks,
Surendra
-Original
Message-F
Title: Estimating User Load on the system
I have been asked to compute the load put on the system by a 'select group of userids'. I know these users and have put something in place where I sample periodically following
1. session stats
2. session io
3. system stats
4. number of sessions
5. v
Don,
The users need acces to the data that is in the database or what is
the purpose of the database?
I would change the privileges of the users to "CREATE SESSION" only
and revoke all others. Then I would use "ROLES" that have select
privileges on the tables that they need acces to. By creati
1)Expert One-on-One (Thomas Kyte)
2) Oracle doc. performance tuning guide.
3) High Performance tuning with Statpacks. (Don Burleson)
4) Scaling Oracle8i
4) Oracle Internals Locks,latche,waits,memory (Steve Adams).
And finally this mail group...
- Original Message -
To: "Multiple rec
Hi Stefan,
since 8 (i?):
have a look at AUTHID CURRENT USER in the docs.
This enables using of database roles.
Greetings,
Guido
>>> [EMAIL PROTECTED] 14.07.2003 14.30 Uhr >>>
Hi list
I was wondering if there is any way to get the following to work:
User A owns all tables, users B,C own PL/SQ
Title: RE: Privileges and PL/SQL code
That's what I was afraid of 8-{ ... oh
well.
Since
we have several developer's working on local copies of the code in schemas B, C,
etc.,
I
guess I have to grant privileges to all schemas.
Thanks
for the quick response.
Stefan
Stefan Jahnke Consulta
Title: RE: Privileges and PL/SQL code
If you don't want to do that, create your pl/sql code under schema A and grant execute on those to B and C.
Sorry ... that's the only way to go ...
Raj
Rajendra dot Jamada
Hi list
I was wondering if there is any way to get the following to work:
User A owns all tables, users B,C own PL/SQL code to access A's tables.
To work with A's tables from user B and C, I would like to create a role to
contain all the object privileges and grant these to B and C.
Didn't use
55 matches
Mail list logo