On 01/20/2004 03:39:25 PM, Bobak, Mark wrote:
You can also use DBMS_SYSTEM.SET_INT_PARAM_IN_SESSION and
DBMS_SYSTEM.SET_BOOL_PARAM_IN_SESSION, in lieu of oradebug.
Thanks, Mark! I've learned something from you today! Who says
that one cannot teach an old bear new tricks.
--
Please see the official
My guess it's firing the first time but is not taking effect during the
current transaction may be because it fires as a recursive sql within the
main sql.
Not a good idea to put this in a trigger.
Regards,
Waleed
-Original Message-
Sent: Tuesday, January 20, 2004 7:19 PM
To: Multiple
on HPUX?
Regards,
Jeroen
-Oorspronkelijk bericht-
Van: Jonathan Lewis
[mailto:[EMAIL PROTECTED]
Verzonden: Saturday, January 10, 2004 6:54 PM
Aan: Multiple recipients of list ORACLE-L
Onderwerp: Re: pga workarea and ora-04030
I think what you've demonstrated
Hi Thomas-
Pretty interested in your method!! I tried it out but I guess I have to
create the WTW_JOB_NOTIFY table and populate it and I can't figure where the
mail notification is used. Assit with the table structure and an explanation
on how this table is used.
Thanks and Cheers,
CSW Simon.
Hi Helmut,
There are so many opinions about this that it's hard to point at one
specific document or recommendation. If anything, start with stuff
written by Graham Wood (who has done a good deal of the work on it),
Bjorn Engsig (ditto), or such guys. Also, Tom Kyte has something about
it in
Helmet,
Mogens makes a lot of good points as normal. As usual it's never as simple as
we'd like it too be and it depends on how your system runs. One thing that is
worth monitoring is changes in statistic values over time.
For example if your buffer cache hit ratio is normally 85% during your
Helmut,
Performance, like beauty, is in the eye of the beholder. Ideal thresholds only
exist in poor tuning courses and poor tuning books. IMHO, the wisest thing to do would
be to collect information at a time when performance is perfectly satisfactory and use
it as a baseline. Then check
Keith,
First of all, please remember that, despite the popular perception that
because data warehouses are read only (they aren't, by the way!), they do
not place great demands on the I/O subsystem.
The real facts are that data warehouses, because much of their I/O activity
is uncacheable due to
You will find a utility add on for statspack at Mogens company site,
www.miracleas.dk. It is called YAPPPACK.
You can use YAPPPACK ( notice the 3 P's, it is not a typo ) to generate
response time graphs for your databases.
There are many different numbers to look at in a statspack report, but
many tools will do that, but if you're on 9i, check out dbms_metadata
package.
joe
[EMAIL PROTECTED] wrote:
Hi all ,
How can I produce extract schema script(tables , tiggers , objects, procedures ...) from database. Any tool , script , idea ?
Thanks
Arslan
--
Please see the official
It turns out that the user had configured TOAD to use a table filter, which causes it
to create and store a query. As you've probably guessed, the query was referencing a
column which no longer exists.
On a related note, I initially tried to capture the failing query using alter system
set
the runaway PL/SQL program mentioned by
Ryan) and takes
3 days to complete.
-Original Message-
From: Tim Gorman
[mailto:[EMAIL PROTECTED]]
Sent: Friday, January 16, 2004 10:54 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: SLA/metrics for RFP for programming
services
How
Title: Re: SLA/metrics for RFP for programming services
Jeff,
As youre aware, whatever metrics you choose will govern their behavior. Completed deliverables is a good start, but if youre looking for well-tuned deliverables you could add a tuning-review gate through which each deliverable has
Helmut,
Register with http://www.oraperf.com; and run those STATSPACK reports
through the YAPP analyzer, which will reformat them in such a way that they
make sense.
All of the ratio stuff on the STATSPACK report is ignored by the YAPP
analyzer, and instead the reformatting looks at things from
Great!!! May be this is your way of solving problems.
--- On Fri 01/09, Mladen Gogala [EMAIL PROTECTED] wrote:
To: [EMAIL PROTECTED]
Date: Fri, 09 Jan 2004 17:04:25 -0800
Just go surfing to CA. Be sure to resemble seal as much as possible and jaws will
come.
Hi
Thanks for the info. Let me try this.
Regards,
B S Pradhan
---
On Mon, 19 Jan 2004 Jared Still wrote :
You must set OSAUTH_PREFIX_DOMAIN=true in the registry to
use externally identified domain accounts.
I can't recall if the default value is true or false, but
try setting it
I would probably go to the http://www.realtimelinuxfoundation.org and see what's there.
The next thing would be to start looking into other RT Unix systems and when all
of the needed information is compiled, I would post an article with the solution on
this list.
On 2004.01.19 09:54, [EMAIL
Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
DENNIS WILLIAMS
Sent: Tuesday, October 28, 2003 3:00 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: rman backup
AK
When you have RMAN back up archived logs, IIRC, in a recovery RMAN first
restores those
Having never done it, I'll just refer you here:
http://www.tldp.org/HOWTO/RTLinux-HOWTO.html
Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
Imagination was given to man to compensate him for what he is not, and
a sense of humor was provided to console him for what he is. --Unknown
Hamid - Are you using sqlplus or sysmgr?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, January 19, 2004 1:49 PM
To: Multiple recipients of list ORACLE-L
Hi list,
when I connect as sys/password as sysdba I get an error not sufficient
privilege
I went through a similar problem with the 904 error. I had to use oradebug
to get a trace file to be produced.
Good luck,
Chris
-Original Message-
Sent: Monday, January 19, 2004 8:14 AM
To: Multiple recipients of list ORACLE-L
It turns out that the user had configured TOAD to use a
Hi
have a look at Chris O'Sullivans tool T.O.Y.S. at
http://www.impacttoys.com that allows you to extract the schema from a
database.
kind regards
Pete
--
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security
I think he is talking about 100GB database. Can PostgreSQL and MySQL handle
that size? We used MySQL in some of the web projects, but it just stores
small set of operational data and later on those data are moved to Oracle as
a permenant store. For small set of data, MySQL is quite good, but it
What is the value of your remote_login_password init parameter?
What is the value of SQLNET.AUTHENTICATION_SERVICES in sqlnet.ora file?
-Original Message-
Hamid Alavi
Sent: Monday, January 19, 2004 2:49 PM
To: Multiple recipients of list ORACLE-L
Hi list,
when I connect as sys/password
sqlplus
-Original Message-
Sent: Monday, January 19, 2004 2:00 PM
To: Multiple recipients of list ORACLE-L
Hamid - Are you using sqlplus or sysmgr?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, January 19, 2004 1:49 PM
To: Multiple
viraj2 wrote:
Hi all,
I was wondering if any one out here knows if there is a good list
(mailing list) for discussing MS Access problems. I am specifically
looking for migrating/converting large Access database into Oracle
database. I need to know what will be the steps to convert such a
At 07:59 AM 1/15/2004, you wrote:
What else can I suggest to help them
collect data that will be informative?
My business card ;-)
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
Ryan,
It's postgres.org. I'm not sure how they generate the operating revenue they
need, but that's why they are not advertising like MySql AB is.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Wednesday, January 14, 2004 5:05 PM
To: Multiple
here it is:
remote_login_password= EXCLUSIVE
sqlnet.authentication=(NTS)
-Original Message-
Sent: Monday, January 19, 2004 2:01 PM
To: Multiple recipients of list ORACLE-L
What is the value of your remote_login_password init parameter?
What is the value of SQLNET.AUTHENTICATION_SERVICES
viraj2 wrote:
Hi all,
I was wondering if any one out here knows if there is a good list
(mailing list) for discussing MS Access problems. I am specifically
looking for migrating/converting large Access database into Oracle
database. I need to know what will be the steps to
Do you have that password in your password file?
-Original Message-
Sent: Monday, January 19, 2004 4:14 PM
To: Multiple recipients of list ORACLE-L
here it is:
remote_login_password= EXCLUSIVE
sqlnet.authentication=(NTS)
-Original Message-
Sent: Monday, January 19, 2004 2:01 PM
the password still is chamge_on_install I could connect as a normal user
means it's there but not enough privilege to connect as sysdba.
-Original Message-
Sent: Monday, January 19, 2004 3:25 PM
To: Multiple recipients of list ORACLE-L
Do you have that password in your password file?
:RE: SYS Privilege
the password still is chamge_on_install I could connect as a normal user
means it's there but not enough privilege to connect as sysdba.
-Original Message-
Sent: Monday, January 19, 2004 3:25 PM
To: Multiple recipients of list ORACLE-L
Do you have that password
Sounds like the old Oracle vs. Ingress battles. Oracle won because it was
better at marketing. All detailed in the book The Difference Between God
and Larry Ellison. I can see it now -- MySQL, the Oracle of the free
databases.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original
Prem - We had no doubt. I always figure when you've studied enough to doubt
your study guide, you're ready to pass the exam.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, January 15, 2004 6:04 AM
To: Multiple recipients of list ORACLE-L
Hi
Use the ORAPWD.EXE utility and create a password file:
Assume your DB name is test:
1. Find any files named testpwd.ora.
2. Delete these file(s)
3. Find orapwd.exe and, at the command line:
c:\oracle\ora92\bin orapwd file=testpwd.ora password=ginger
no spaces before or after the=signs.
The
Janardhana,
Check this link.
http://sunsolve.sun.com/pub-cgi/retrieve.pl?doc=fsalert/23249
From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Janardhana Babu Donga
Sent: Friday, January 16, 2004
12:09 PM
To: Multiple recipients of list
ORACLE-L
Subject: How
-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Oracle vs Mysql
Sounds like the old Oracle vs. Ingress battles. Oracle won because it was
better at marketing. All detailed in the book The Difference Between God
and Larry Ellison. I can see
Title: extracting schema
If you are on 9I, you can use
dbms_metadata.get_ddl. You can also use export/import without data to get schema
definition.
-Original Message- From:
[EMAIL PROTECTED]on behalf of[EMAIL PROTECTED]
Sent: Mon 1/19/2004 5:04 AM To: Multiple recipients of
Dear Friends,
(B
(BThank you so much. Yes i was able to solve this issue..
(B
(BFYI ... I used CONVERT function
(B
(B
that matters.
Jared
DENNIS WILLIAMS [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/19/2004 04:04 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Oracle vs Mysql
Sounds like
Dear All,
I am posting this again as It seems to have got lost
Regards
Sriram Kumar
-Original Message-
Sent: Monday, January 19, 2004 1:26 PM
To: '[EMAIL PROTECTED]'
Importance: High
Dear Guru's,
Firstly, apology if this question sounds silly.
I am intrested in
DENNIS WILLIAMS [EMAIL PROTECTED] wrote:
Sounds like the old Oracle vs. Ingress battles. Oracle won because it
was
better at marketing. All detailed in the book The Difference Between
God
and Larry Ellison. I can see it now -- MySQL, the Oracle of the free
Bzzzt. Oracle won because it
Hi Dennis , thanx a lot for your encouraging words.
my morale being high , let me go ahead with the
next exam .
Thanks and Regards,
Prem.
-Original Message-
From: [EMAIL PROTECTED]
Prem - We had no doubt. I always figure when you've studied
enough to doubt your study guide, you're
Monday, January 19, 2004, 11:04:26 PM, Mladen Gogala ([EMAIL PROTECTED]) wrote:
MG A good compiler support
MG with something similar to long extinct SQL*Module (originally an IBM technology)
I used to use a SQL Module compiler. Not with Oracle though.
It's rare for me to run into someone else who
sent to mailing lists since 12-Jan-2004 were not
redistributed properly. I have since found and fixed the problem, so
this shouldn't happen in the future. I suspect I was only able to
re-send a portion of the missing messages, so my apologies for anyone
who posted a message that didn't make
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/19/2004 04:04 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Oracle vs Mysql
Sounds like the old Oracle vs. Ingress battles. Oracle
When I was doing my OCP exams, I didn't have Dennis to cheer me up, only Heineken.
Not that I'm complaining.
On 2004.01.19 23:34, Prem Khanna J wrote:
Hi Dennis , thanx a lot for your encouraging words.
my morale being high , let me go ahead with the
next exam .
Thanks and Regards,
Hi,
You won't be able to write an Excel format directly but you can create a
.csv file, which Excel will happily read in - you'll just have no real
formatting options.
Look into some of the sql*plus commands like set heading off, set verify
off, set feedback off, set pages 0, set lines 1000,
PRANK
Try with
spool c:\Program*Files\Microsoft*Office\Office\excel.exe
/PRANK
On 2004.01.19 23:44, Mudhalvan, Moovarkku wrote:
Dear Friends,
I am trying to send output from SQLPlus to Excel file. If any
one did the same before please let me know.
Thank You
Mudhalvan M.M
--
Hi,
Years ago, I stole this idea from:
http://www.quest-pipelines.com/newsletter-v3/newsletter_1002.htm
I've used it a few times, mostly to impress
bystanders. It's got size limitations, but kinda cool
anyhow.
QUOTE
Getting SQL Query Results into an Excel Spread Sheet
By Pavel Luzanov
This
When I was doing my OCP exams, I didn't have Dennis to cheer
me up, only Heineken.Not that I'm complaining.
but Mladen , i can't stop with just one : ))
so i better stay away from it during exams.
Regards,
Prem.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
(I'm resending my yesterday's post because it seems to have got lost)
Dennis,
You can have a unique constraint with a non-unique index. This is documented
and expected behaviour.
Actually, it's fairly easy for Oracle to enforce unique constraint using a a
non-unique index. It just traverses to
Thanks for the reply Tim,
I will try to look at the index and bad blocks at the datafile or
restart the database again. The type column for QTY_SOLD_SO is number.
Regards,
Wendry.
-Original Message-
Sent: Saturday, January 17, 2004 9:15 PM
To: 'Wendry'
I would suspect some problems
days to complete.
-Original Message-From: Tim Gorman
[mailto:[EMAIL PROTECTED] Sent: Friday, January 16, 2004 10:54
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
SLA/metrics for RFP for programming servicesHow about specific deliverables
within a specific period
You must set OSAUTH_PREFIX_DOMAIN=true in the registry to
use externally identified domain accounts.
I can't recall if the default value is true or false, but
try setting it explicitly.
Jared
On Sun, 2004-01-18 at 05:49, bhabani s pradhan wrote:
Hi All,
The client machine is an NT machine
Not exactly what you want but i have a script that goes in the opposite
direction. You supply a user / schema name and decide whether to write
output to screen or file and run it. An example is for OUTLN is:
NAME OF USER TO CHECK [ORCL]: OUTLN
OUTPUT METHOD [S/F]: S
FILE NAME FOR
Yeah, you might not be able to open it, but you can nearly always mount it.
Rachel Carmichael wrote:
as opposed to the ever-present Oracle kernel which is arbitrary,
gobbles up all resources in sight and costs the earth to maintain?
--- Noyce, Robert A SITI-ITPSIE [EMAIL PROTECTED] wrote:
Can I also do what you did from the Tree House - in your garden, that is?
Mogens
Gary Goodman wrote:
I'm going to make Mogens clean my garage ... I'm sorry, I meant further
team building ... when he visits for the Symposium in March!
Gary
(817)424-3443 Office
(817)296-8000 Cell
:))
Mogens, you are my hero!
On 2004.01.18 19:34, Mogens Nørgaard wrote:
Yeah, you might not be able to open it, but you can nearly always mount it.
Rachel Carmichael wrote:
as opposed to the ever-present Oracle kernel which is arbitrary,
gobbles up all resources in sight and
Hi Tanel,
Thanks for your inputs. I have given my understanding would
request you to provide your inputs.
There are two kinds of checkpoints that happen( Full checkpoint
and Incremental Checkpoint)
Full Checkpoint happens during
-
Hi,
I found Workflow 2.6.2 on the 9.2.0.1 Database cdrom set.
You get to it by picking
Enterprise Edition and then custom.
-moi
__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
--
Please
Hi!
Use SET TRANSACTION READ ONLY before your run the queries and run them again
(without any commits or rollbacks in the middle). That way you can be sure
that any hidden changes to data won't be reflected.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
Title: Re: any student versions of 'business objects' ab initio or informatica?
Probably best to contact them directly?
I suspect that Ab Initio in particular will be out of reach for this purpose. My understanding is that they choose their customers based on their capability to deliver a data
Title: Re: any student versions of 'business objects' ab initio or informatica?
does business objects = crystal reports? anyone can
use crystal reports?
why are employers picky about people with business
objects knowledge?
https://secure.businessobjects.com/default.asp
- Original
Ryan - Some more thoughts for your consideration.
1. Consider studying Data Warehousing. These tools are deliberately made
easy to use, so shouldn't take much effort, but understanding how to design
a star schema will make data more accessible to any tool. A good start can
be had at
Jay
That is a good one. The question is: How is the uniqueness constraint
being enforced when the index is nonunique? Offhand I would have assumed
your constraint would have been rejected since the index is nonunique --
nope. Then I would have guessed the index would have been converted to a
No.
It is coming in 10g (from Oracle World presentations I attended last year).
- Kirti
--- [EMAIL PROTECTED] wrote:
Is there anyway to rename tablespace in Oracle 9202. Thanks
__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes
Depends what you want to achieve.
A non-unique index enforcing a unique
constraint allows the constraint to be
deferrable - so you could load some
'nearly unique' data against it and find
the duplicates efficiently.
However, a non-unique index requires
one byte per entry more than the
Thanks a lot for your quick response Mr.Jonathan and Mr.Dennis.
One more silly question...
What is the difference(pros cons) between creating PK Vs (UK+NOT NULL) Vs
(UK+check constraint with Not null condition)?
1)
drop table constraint_test;
create table constraint_test(c1 number,c2
Jay,
Remember, both UK and PK are enforced by unique indexes. The important
difference between them is a null value is allowed in UK, not in PK.
In (1), your constraint is specifically named as ct_pk1. Oracle does the for
you:
a) create a unique index ct_pk for you in the default tablespace of
Apparently to celebrate his new marriage, Larry is releasing the new Oracle 10G
Marriage Builder product, it requires plenty of tuning and costs an absolute fortune.
Other features include Parallel nagging, a new wifemon process that never clears
anything up and after 3 months the whole product
I'm having an ora-1555 under Oracle9 database and not
sure what I can do to get rid of it. I had some
recollecions from Oracle8 days , but the things like
adding a new rollback segment or shrinking the
segments I don't think are applicable under the auto
undo management. Besides separating
1. that
Set oracle_sid=blah
Sqlplus user/password
Works on terminal server.
2. I like the workspace memory management features as well.
3. trace file timings in microseconds.
4. Cursor_sharing=similar (still has the odd bug).
5. HTMLDB is marketed for 10g but will install on 9.2
Chris,
I've worked on a large Powerbuilder App for a number of years. We used CBO all
the time under 7.3.2, 7.3.4 and 8.1.7. You're right Powerbuilder per se
requiring RBO is rubbish.
Cheers,
Chris Dunscombe
Quoting Chris Stephens [EMAIL PROTECTED]:
I'm working with a 3rd party vendor
can't beat them, join them...
:)
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message -
Excellent reasoning Nuno. I hadn't thought of that.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Nuno Souto
INET: [EMAIL PROTECTED]
Fat City Network Services
as opposed to the ever-present Oracle kernel which is arbitrary,
gobbles up all resources in sight and costs the earth to maintain?
--- Noyce, Robert A SITI-ITPSIE [EMAIL PROTECTED] wrote:
Apparently to celebrate his new marriage, Larry is releasing the new
Oracle 10G Marriage Builder product,
Hello Mark,
all 3 instances are listening on the same port.
Cheers
Barry.
-Original Message-
Mark Leith
Sent: 16 January 2004 11:14
To: Multiple recipients of list ORACLE-L
Hi All,
I'm helping out a friend of mine who's having problems with connecting from
an NT system to an HP
Ramon,
Take a look at the DBMS_RANDOM package. You can replace the name with a
random number. That ought to do the trick.
Good Luck
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, January 16, 2004 7:49 AM
To: Multiple recipients of list ORACLE-L
Hi
Try to have the SQL Server DBA fired.
- --- Original Message --- -
From: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Fri, 16 Jan 2004 04:59:26
Hi ,
How can i create a job in sql server ?
Rgds.
Arslan.
--
Please see the official ORACLE-L
Firstly Arslan, it should probably be pointed out that this is an Oracle
list, not SQLServer. But, seeing as I deal with both database types, I'll
have a stab at this..
You can create jobs under the SQLServer Agent. If you open up SQLServer's
Enterprise Manager, and navigate to your Server, there
Mark,
The (GLOBAL_DBNAME= l1000.)
entry looks strange. Should there be a '.' in there? I've never seen this
entry in this file. What does : lsnrctl status lsnrctl services show?
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, January 16,
]
Subject: What is Hash Join?
Date: Thu, 15 Jan 2004 20:39:29 +0700
Dear all,
I understand join is for joining two tables, I know nested loops and
sort-merge joins and I know how they work and on what situation theyre
used best at. But I really dont understand hash join, how are they
working
PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of
[EMAIL PROTECTED]Sent: Thursday, January 15, 2004 1:04
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
List problems Is
this still being worked on? I'm not seeing a lot of volume nor
anything I've sent recently. Funny
you sho
First, you may have to quit your job in Oracle...
on 1/16/04 5:59 AM, [EMAIL PROTECTED] at
[EMAIL PROTECTED] wrote:
Hi ,
How can i create a job in sql server ?
Rgds.
Arslan.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tim Gorman
INET: [EMAIL PROTECTED]
Hi!
Note that hash joins are very prone to extreme performance degradation when
statistics outdated (don't reflect real rowcounts/sizes in tables).
When optimizer decides to go with hash join because it thinks that there is
1000 rows in driving table, but there is 100 instead, all driving
I've asked for the out put on a lsnrctl status already, but haven't heard
back from him as yet..
The . does look strange.. Also, what would the impact be to have the
GLOBAL_DBNAME set to the same value for all three instances? Would it not be
better to set it to the same name as the instance name
I don't believe that datafiles in Read Only tablespaces have the scn updated. I've not
tested it, but it is logical.
Daniel Fink
[EMAIL PROTECTED] wrote:
All,
Whenever checkpoint happens datafile header scn and controlfile scn
will be in sink. Is my assumption is right? Is there any
Mark,
I don't think that all three on the same port is a problem - heck - I do it
all the time. I would comment out the GLOBAL_DBNAME entry. It certainly is
not required. And output from lsnrctl would be helpful.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent:
Does his version of TOAD support your Oracle server version ? We tried to
run our (outdated) version of SQL Navigator against a 9i DB and would get
weirdness like this from time to time when accessing the Oracle data
dictionary.
mvg/regards
Jo
Norris, Gregory T [ITS] [EMAIL PROTECTED]
I don't believe a 12154 error has anything to do with the listener. The
request never leaves the client. It has all to do with the fact that sqlnet
on the client can not find the service name in the tnsnames.ora. What is
names.default.domain set to in sqlnet.ora. If there is no sqlnet.ora try
Yep, you're correct, everything is frozen in datafiles when they're in read
only mode (you can have read only datafiles on read only media if you want).
Also, no controlfile records (like checkpoint cnt, checkpoint scn) for read
only datafiles are not changed, I've verified this with controlfile
Whenever checkpoint happens datafile header scn and controlfile scn
will be in sink. Is my assumption is right? Is there any other scenarios
where checkpoint only update controlfile and doesn't update datafile
header? Agreed, during begin backup mode datafile header will be
frozen.. Other
Whenever checkpoint happens datafile header scn and controlfile scn
will be in sink. Is my assumption is right? Is there any other scenarios
where checkpoint only update controlfile and doesn't update datafile
header? Agreed, during begin backup mode datafile header will be
frozen..
Sure. Create the database userid so that it is authenticated externally
(Identfied externally).
Then the userid can log in via SQL*Plus using a / instead of a userid or
password. The OS userid should be a controlled account so that everyone and
his grandmother cannot log into it.
If it is a
Create a dummy user dummy with pw as dummy and only with create session
priv. Execute a sql script which will connect to the username/pw and
which does
not have read privs at os level for others.
May be someone on the list has a better idea.
HTH
GovindanK
On Fri, 16 Jan 2004 10:04:35 -0800,
Ryan wrote:
Is there a way to log into sqlplus without the username and password
available to anyone who wants to grab it?
Try
http://asktom.oracle.com/pls/ask/f?p=4950:8:12188015396454707431::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:142212348066,
--
Bricklen Anderson, Database Administrator
Title: Message
You
can do any of:
sqlplus /nolog
connect user/[EMAIL PROTECTED]
export
TWO_TASK=whatever
sqlplus user
Password: xxx
sqlplus [EMAIL PROTECTED]
Password: xxx
Mark J.
Bobak Oracle DBA ProQuest Company
Ann Arbor,
MI "Imagination
was given to man to compensate him
start
sqlplus then loginif a script is executing start sqlplus with
/nolog
then
issue a connect command in the script...
place
the script in a secure location
-Original Message-From: Ryan
[mailto:[EMAIL PROTECTED]Sent: Friday, January 16, 2004 12:05
PMTo: Multiple
Few ideas:
1) sqlplus
/nolog
connect user/[EMAIL PROTECTED]
2). $HOME/.orapwd
sqlplus user/[EMAIL PROTECTED]
(.orapwd script has to set environment variable
ORAPWD to the password)
3) sqlplus [EMAIL PROTECTED] $HOME/.orapwd
(.orapwd must contain one line, the
password)
Tanel.
601 - 700 of 67344 matches
Mail list logo