may i
just say - this resource is worth the minimal effort it took
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of
[EMAIL PROTECTED]Sent: Wednesday, January 28, 2004 12:09
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
!!Please
Title: Message
Help
System
Admin. got a wild hair and changed the hostname on us for a 9ias v2
server.
Now
none of the processes work and getting all kinds of unhandled java exceptions
regarding hostname
oracle.ias.repository.schema.SchemaException:Unable to connect to
Directory
I
Yes,
but how do I fix it? Do I need to reinstall?
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of
[EMAIL PROTECTED]Sent: Friday, January 23, 2004 1:14
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Help - 9ias broke - hostname was
I
think he lucked out and didn't do this on a highly visible system.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of
[EMAIL PROTECTED]Sent: Friday, January 23, 2004 1:14
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Help - 9ias
Obviously. The issue has been whether or not Oracle's data caching
worked well - and was read for prime-time in earlier versions.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of RyanSent:
Wednesday, January 14, 2004 5:14 PMTo: Multiple
-Have them run a stress test and monitor on a non-productional system with sufficient
volume of data : CPU, memory, disk utilization. (show newbie as you do this)
-Look at how the database was put together for maintainability - best practices, etc..
-Look at some of the SQL related to their
If you
go to the Update 9i exam listing - there are no course
requirements.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Hemant K
ChitaleSent: Wednesday, January 14, 2004 9:09 AMTo:
Multiple recipients of list ORACLE-LSubject: Re: ** OCP
It comes out of the total memory of the server - separate from the shared pool - it is
allocated per session - if running parallel processes in a DSS environ. can quickly
consume memory avail. be wary wary careful.
-Original Message-
Mladen Gogala
Sent: Wednesday, January 14, 2004
Title: Message
You
nailed it - you might want to see the info. about it - least it happens to
you.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Niall
LitchfieldSent: Tuesday, January 13, 2004 7:14 AMTo:
Multiple recipients of list
Title: Yep.it's a Monday..
Developer is saying functions are good - all functions referencing
dbms_sql bomb???
Help???
problem with dbms_sql
Compiling function FUN_CHANGE_PASSWORD...
Compilation error on function FUN_CHANGE_PASSWORD:
PL/SQL ERROR 801 at line 1, column 1
Developer is saying that applying patchset 9.2.0.4 broke dbms_sql or changed it so
that they cannot compile their procs referencing dbms_sql. Help?
-Original Message-
Sent: Monday, January 12, 2004 4:27 PM
To: '[EMAIL PROTECTED]'
to developer mailgroup?
1) Please tell me how to
Guys,
Any good doc. on securing data on database on internal network behind firewall with an
application server accessing it in the DMZ. I am thinking Advanced security but would
appreciate something on this subject. I have stored some documents on security from
previous strings but cannot
Would love to know!
-Original Message-
Stahlke, Mark
Sent: Friday, January 09, 2004 11:34 AM
To: Multiple recipients of list ORACLE-L
Greetings,
Does anyone know of a good, readable tutorial on Oracle Warehouse Builder?
I've been searching Google and even looking for books on
Running Oracle 9i and Solaris 2.9.
It appears to me that the solution can be hardware based or Oracle based then. Which
brings up questions about cost versus administration versus reliability. Hmmm.
-Original Message-
Paul Drake
Sent: Friday, January 09, 2004 12:49 PM
To: Multiple
I agree. Spotlight and SQL Navigator interfaces are very straightforward. While you
still have to do the analysis and understand the database architecture it makes it
much easier to gather all the necessary information so that you can concentrate on
resolving the issue and not on gathering
What about a good solid resume with experience showing and a cover letter?
-Original Message-
Joe Testa
Sent: Thursday, January 08, 2004 2:45 PM
To: Multiple recipients of list ORACLE-L
this always amazes me:
# Bachelor's degree in Computer Science, Engineering, or related
FIRST_ROWS would alter the behavior regardless of the number of rows.
-Original Message-
Jay Wade
Sent: Tuesday, January 06, 2004 1:44 PM
To: Multiple recipients of list ORACLE-L
Hello:
I was looking through some OCP questions posted on the web and came across
the one below.
I
Title: RE: for security patches - going to 9.2.0.4
Thanks
so much. This was very well explained and I appreciate the time you took
to share it. I will go through the Metalink and read this over and
test.
Thanks
Again,
Paula
-Original Message-From: [EMAIL PROTECTED]
That
is the case. I do have tablespaces that are locally managed - I did the
migrate with compatible set to 8.1.7. I did startup the database.
However, my system tablespace is dictionary managed - all others are not.
The
migration worked. I have large databases and have been using
I was
just wondering if setting compatible back to 8.1.7 for the CBO reasons was still
necessary?
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Paul DrakeSent:
Friday, December 12, 2003 4:49 PMTo: Multiple recipients of list
Guys,
I saved all of your writing including Todd Boxx, Richard Foote, Wolfgang... about
issues with 9.2.0.4. We are currently on 9.2.0.3 and I understand (although have not
hit it yet) that in this version we could get locks when building indexes. Also, that
basically you need to set your
Hey Bambi - how are ya girl. It is and I changed by oratab to use the 9.2.0 OFA home.
I am thinking perhaps that ##$$%% LD_LIBRARY_PATH again.
-Original Message-
Bellow, Bambi
Sent: Monday, December 08, 2003 5:59 PM
To: Multiple recipients of list ORACLE-L
Make sure your ORACLE_SID
Guys,
I am working through a manual migration from 8i to 9i on Solaris 2.8. I am using the
guide in Note: 159657.1.
I shutdown the 8.1.7 database, copied network and init files - then run
sqlplus / as sysdba
or
sqlplus /nolog
connect sys/jfjfj as sysdba
I get
ORA-12545: Connect failed
Running dbua to upgrade 8.1.7 to 9.2.0 database produces:
ORA-12545: Connect failed because target host or object does not exist.
Very annoying because looking at logs under .../assistants subdirectories and
../admin/upgrade/logs or the alert log - directories doesn't show what the missing
Actually TWO_TASK is not set - I signed in as oracle user and echoed it. Sooo I
think my hope that finally after the many versions I have migrated - Oracle's
assistant is finally ready to rock - is not correct. Mainly, do not get complete
information running the migration that way. I
Guys,
Happy Thanksgiving to everyone. May your bellies be full but your waistline not
expand, may you enjoy the time with your family and friends and avoid any of the other
drama
Thanks so much to everyone for their help and camaraderie.
Just enjoy yaself!
--
Please see the official
- yes esp. during the after-football game libations.
-Original Message-
Sent: Wednesday, November 26, 2003 10:50 AM
To: Multiple recipients of list ORACLE-L
And may you all be back here on Monday, in one piece, safe sound. No DWI's now, you
hear!
Dick Goulet
Senior Oracle DBA
Oracle
Man - I need to switch jobs.
-Original Message-
Sent: Wednesday, November 26, 2003 10:50 AM
To: Multiple recipients of list ORACLE-L
Come to think of it, out fitness center has a special program ... it runs for 8 weeks
and the aim is maintaining the weight ... no points for loosing
No - but seriously - and I am not kidding my Dad sells Herbalife products and could
probably actually help you with this Mladen. Frankly I think the stress - sitting our
jobs entails adds a lot to this. Exercise we all probably really need because our
jobs are so sedentary. Anyway, hang
Why in an IT shop - do us DBA's only seem to understand this? As I see it most
programmers don't understanding data models at all! It makes it easier for them to
ignore the DBA's as being theoretical, academic
-Original Message-
Sent: Thursday, November 20, 2003 1:30 PM
To:
We do
- we have bought their books!!
-Original Message-From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Thursday, November
20, 2003 4:50 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Oracle Magazine Awards
Sorry, I don't have that much "pitiful cash" :)
Guys,
For management reporting has anyone considered OEM V9?? Has anyone installed it - do
you know that it provides a number of reports already defined that can be setup to be
run periodically and available on the web - all with the installation of the OEM V9?
I was thinking this would
I did using OEM Version 2 something on 8i databases. Multiple agents - got it running
- agent management was rather a pain in the ##$$%%% I agree. Still I am thinking this
new version with its bells and whistles might be better.
-Original Message-
Sent: Wednesday, November 19, 2003
Thanks Dick. It is worth a try.
-Original Message-
Sent: Thursday, November 13, 2003 6:35 PM
To: Multiple recipients of list ORACLE-L
To the best of my knowledge, I've done this several times now, you run the
appropriate upgrade script then the utlirp.sql script to migrate from 32
So - this is a stupid question:
We cannot use Oracle's migration utility to go from 32-bit 8.1.7 to 64-bit 9i?
- Hmmm, create database , export, import.
-Original Message-
Sent: Thursday, November 13, 2003 2:49 PM
To: Multiple recipients of list ORACLE-L
It's actually an sql script
I have been working with Oracle on Unix - various platforms since Version 6.X.
For the first time a vendor has sent us an install that installs under the C-shell.
Up until this point I have always worked on and installed under the korn shell.
This introduces a different shell environment in our
me too.
-Original Message-
Sent: Friday, October 24, 2003 3:35 PM
To: Multiple recipients of list ORACLE-L
I am also interested in this paer .
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, October 24, 2003 12:14 PM
List,
All of a sudden our em on the 9ias system v2 won't stop. We even tried to reset the
password and reauthenticate. Searching on metalink does not provide much info.
Anyone deal with stuck em process before?
Thanks,
Paula
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Hey guys - this is funny. Don't respondit is actually a trick...various employers
are using this service to determine how loyal their current DBA's are while the market
is tight
Just kidding
-Original Message-
Sent: Monday, October 20, 2003 1:54 PM
To: Multiple recipients
It was the LD_LIBRARY_PATH - and it burned me bad!
-Original Message-
Sent: Thursday, October 16, 2003 10:20 AM
To: Multiple recipients of list ORACLE-L
stupid question
is the library in $OH/lib?
/stupid question
Raj
Thanks Jared,
Would
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:$LD_LIBRARY_PATH:
export LD_LIBRARY_PATH_64=$ORACLE_HOME/lib
also be correct?
-Original Message-
Sent: Thursday, October 16, 2003 1:59 AM
To: Multiple recipients of list ORACLE-L
This one is incorrect:
Apparently was but my understanding of paths is that it goes from first directory
listed ...down and so it should have picked up the 64 bit
-Original Message-
Sent: Thursday, October 16, 2003 12:10 PM
To: Multiple recipients of list ORACLE-L
Ah, my mistake.
Last night I missed the
Congrats Dennis - I guess easy is always relative and depends on experience. I would
venture that running Oracle with various applications on various platforms in various
organizations provides a wealth of experience - some you wish you never have - all
adding up to a pretty well-rounded
Help,
Recently we cannot successfully run procedure we get the following error:
SQL begin begin_letter_debug(9);end;
2 /
begin ext_letter_debug(9);end;
*
ERROR at line 1:
ORA-06520: PL/SQL: Error loading external library
ORA-06522: ld.so.1: extprocPLSExtProc: fatal: libgcc_s.so.1: open
So the external procedure call not finding a library was due to LD_LIBRARY_PATH.
However, I don't understand why:
-Original Message-
Sent: Wednesday, October 15, 2003 5:47 PM
To: May, James S
Cc: Yoshikawa, Makoto D; Evans, Russ F
Subject:remembered - relinking
Guys,
Running Infrastructure database from 9iv2 release on Solaris
New installation and wish to use same infrastructure database
-However installing 9.0.3 it asks for port, host and password of cn=orcladmin (OID
admini. user)
-I tested using ldap_bind and ldap is running but apparently I have the wrong
Guys,
I setup lsnrstartstop scripts for root that does the su -c to oracle and runs
them. I could run as oracle successfully but using the su - c command brought me this
error:
Oracle ld.so.1: /opt/oracle/product/9.2.0/bin/lsnrctl: fatal: libclntsh.so.9.0: open
failed: No such file or
Hehe
Found a posting from Michael Ault on same subject. Michael - are you there?
Thread Status: Active
RDBMS Version: 9.2.0.1
Operating System and Version: Solaris 2.8 64 bit
Error Number (if applicable):
Product (i.e. SQL*Loader, Import, etc.): OCI
Product Version: 9.2.0.1
Library Paths 32
Guys,
Very impressive discussion. Here's the bottom-line. We cannot afford
to be technically efficient/competent without also understanding the
politics of the organization we work in. As DBA's we cannot just manage
the backups, maintenance, tuning - nor can we ignore the applications
we
Title: Message
Okay,
There
are some e-mail lists. There is also books online that comes with SQL
Server which goes over production support issues as you have named. Where
I work they user Veritas Backupexec which is pretty easy to use so I don't know
about SQL Server's backups. I prefer
Title: RE: equivalent for isdate, isnumeric
to_date, to_number
-Original Message-
From: Shiva Maran [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 25, 2003 11:35 AM
To: Multiple recipients of list ORACLE-L
Subject: equivalent for isdate, isnumeric
Hi All,
I am
Title: RE: URGENT REPORTS
Guys,
This is a stupid question but how is directing DISPLAY for reports with xterminal services versus the VNC route?
-Original Message-
From: Jesse, Rich [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 24, 2003 6:15 PM
To: Multiple recipients of
Title: RE: URGENT REPORTS
Thanks.
-Original Message-From: Binley Lim
[mailto:[EMAIL PROTECTED]Sent: Thursday, September 25, 2003
1:05 PMTo: Multiple recipients of list ORACLE-LSubject:
Re: URGENT REPORTS
An X-DISPLAY application (Reports) needs to
access an X-display
Title: RE: URGENT REPORTS
REP-110: Unable to open file 'alc4.rep'.
REP-1070: Error while opening or saving a document.
REP-0110: Unable to open file 'alc4.rep'.
Title: RE: URGENT REPORTS
Never mind. Was a bad rep_mdmdmd.conf file.
However, does anyone know if there is a way to run reports services without have a DISPLAY variable set? We don't have a dedicated machine for this one purpose.
-Original Message-
From: Stankus, Paula G
Sent:
Title: RE: URGENT REPORTS
Thanks.
-Original Message-From: Johnston, Tim
[mailto:[EMAIL PROTECTED]Sent: Wednesday, September 24, 2003
4:10 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: URGENT REPORTS
Check out Xvfb... It the virtual frame buffer... I think it
Title: FW: ADMN errors in startup sometimes with 9ias - help?
Here is the startup output. Any ideas why we might sometimes get these errors?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Monday, September 22, 2003 7:01 AM
To: [EMAIL PROTECTED]; [EMAIL
Title: RE: download metalink articles - save target as
When I right click on a metalink article to try to save it to a local directory and use save target as - it only provides a blank file. What's the easiest way to save these files locally? I want to because sometimes the more useful ones
Title: RE: download metalink articles - save target as
Oh man!!!
-Original Message-
From: GovindanK [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 22, 2003 2:47 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: download metalink articles - save target as
You need to
Title: RE: YEAAA!!!, drop in number
Hey some relief is better than none.
-Original Message-
From: KENNETH JANUSZ [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 22, 2003 4:55 PM
To: Multiple recipients of list ORACLE-L
Subject: Re:
Title: RE: SQLPLUS with cronjob is giving problem
Dear Sami,
As a matter of fact whatever environ. values are set in your .profile are not in operation through a crontab process.
To deal with this issue we do something that I have seen others do as well. We basically create a
Title: RE: Checking RMAN backup results
Alghough I use the RMAN catalog and so backup success/failure can be seen from there. I find it easiest to write out a log of the entire backup process in my calling script to a specific directory
/dblogs/backups
All my backup scripts are written
Title: RE: Migrating RMAN catalog database to 9.2.0 and supporting 8.0.6
Dear Chip,
Was there a bug number and was it logged in Metalink? Do you know which procedure/package was involved of the top of your head?
-Original Message-
From: Chip [mailto:[EMAIL PROTECTED]]
Sent:
Title: RE: URGENT REPORTS WONT START
It was a problem with 2 things:
1-someone had changed the display on me!
2-conf file was corrupted.
Worked it out but can anyone tell me where I can get more robust descriptions of the conf files and how to edit them and each part of them?
Thanks,
Title: RE: Migrating RMAN catalog database to 9.2.0 and supporting 8.0.6
Found
out it is this:
Errors for PACKAGE BODY DBMS_RCVMAN:
LINE/COL ERROR
-
2256/1 PLS-00593: default value of parameter "PARTIAL_RCV" in body
Title: RE: Migrating RMAN catalog database to 9.2.0 and supporting 8.0.6
Found
the note referencing bug and says it is fixed in 9i. I am running
9.2.0.1.0 and the upgrade catalog on 8.1.7 catalog worked - we will see if
backup actually does. Trying on 8.0.6
-Original Message-From:
Title: RE: Migrating RMAN catalog database to 9.2.0 and supporting 8.0.6
Was
able to upgrade the catalogs as getting "catalog too old error" and found great
note and compatiblity matrix:
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=73431.1
Title: RE: Migrating RMAN catalog database to 9.2.0 and supporting 8.0.6, 8.1.7, 9.2.0
Before I begin
I have an rman catalog currently in 8.1.7
it supports catalogs for databases in 8.0.6
I wish to migrate using database migration assistant to 9.2.0 and keep the older catalogs in-place.
Title: RE: URGENT REPORTS WONT START
Getting error:
REP-50125: Caught exception: java.lang.reflect.InvocationTargetException
One note I found on web said to comment out some tags. Doesn't seem to help.
Any ideas?
Title: RE: making me crazy
Dealing with 2 Oracle Homes - one if which I need to run the listener from and one in which I need to use the tnsnames.ora definitions from and no I can't just copy the tnsnames.ora to the 1st Oracle Home. Even when I set the oracle home from which to run lsnrctl it
Title: RE: making me crazy
Okay guys,
I copied the listener.ora from one ORACLE_HOME to the other ORACLE_HOME - everything in the listener.ora is the same and still get the error TNS-01201
TNS-01201: Listener cannot find executable /opt/oracle/product/9ias/v2/bin/extpr
oc for SID
Title: RE: making me crazy
Think I found solution:
Not only do you have to use fully qualified path in the sid_list - but also in the program statement of the listener.ora
geez. What complicates it is under the same error: TNS-01201 - there are multiple notes, problems solutions.
Sorry
Title: RE: Future demand for DBAs
Again,
Some issues:
-Labor supplied from operations overseas
-Issues of security
-Issues of plain old communication and the role of a DBA requiring communication
-Cost of moving overseas - certainly can't be afforded by all companies
-remote administration
Title: RE: The Coming Job Boom
That's nice but what if the companies outsource overseas in response to this concern - hmmm. Still on the up-side they won't be able to do this in all cases and so overall there will likely be a positive demand for DBA skills in relation to the ageing of our
Title: Message
Yeah,
I really was on a tangent. Actually I was thinking of making a move in my
career to something related to the healthcare industry. I mean analysis is
analysis, diagnostics is diagnostics. With a few manuals and a
certification exam I think I could be just as good as if
Title: RE: The Coming Job Boom
Steve, although it has been years for some of us - we were once the DBA in the diapers so remember to be gentle. I forgot just today.
-Original Message-
From: Orr, Steve [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 29, 2003 3:39 PM
To: Multiple
Title: RE: using developer under Unix versus on PC and then ftp code to Unix
Pros/Cons/Ideas/Experience?
In
using developer on Unix - do you have to use XWindows or an XWindows emulator
like Hummingbird or is it character based tool. How does it perform versus
Windows version? What about security holes with XWindows?
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL
Title: Message
Mladen/Jared - please send. I would be really
grateful.
Thanks,
Paula
-Original Message-From: Mladen Gogala
[mailto:[EMAIL PROTECTED]Sent: Wednesday, August 27, 2003
5:45 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: VPN access to 9ias instance
Title: RE: VPN access to 9ias instance behind firewall
Guys,
When user trys to run our application through a VPN behind the firewall in a url they get an error. They can use ssh to get to host where I installed the application server but not run the application through their browser. Anyone
Title: RE: VPN access to 9ias instance behind firewall
Any
suggestions?
-Original Message-From: Dong, Ping - Raleigh, NC
[mailto:[EMAIL PROTECTED]Sent: Wednesday, August 27, 2003 4:54
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
VPN access to 9ias instance behind
Title: RE: VPN access to 9ias instance behind firewall
Dear
Tanel,
Thanks
for the reply. I have some questions:
-Original Message-From: Tanel Poder
[mailto:[EMAIL PROTECTED]Sent: Wednesday, August 27, 2003
5:49 PMTo: Multiple recipients of list ORACLE-LSubject:
Re: VPN
Title: RE:OT:UNIX: Anyway to run this in the background and return to calling process
$ORACLE_HOME/bin/sqlplus / as sysdba EOD
select ..
exit
EOD
echo this is a test
ps -ef|grep sqlplus
I wish to put that into a unix command but at the same time run it in the background and return
Title: RE:OT:UNIX: Anyway to run this in the background and return to calling process
Never
mind I got it.
-Original Message-From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Friday, August 22, 2003
1:25 PMTo: Multiple recipients of list ORACLE-LSubject:
Title: Message
Thanks,
Hmmm
perl...
Well,
I came up with a loop using while and a ps -ef|grep $pid command but this looks
interesting.
-Original Message-From: Mladen Gogala
[mailto:[EMAIL PROTECTED]Sent: Friday, August 22, 2003 2:04
PMTo: Multiple recipients of list
Title: Message
Thanks
for all the wonderful and interesting responses - esp. Tim Gorman. I think
that is what I needed. Sorry to resurface that old issue again.
Mladen, you too? Did the nuns hit your knuckles with a ruler as
well?
-Original Message-From: Stefick Ronald S Contr
Title: RE: URGENT!!! My 9i databases are not shutting down cleanly/consistently like they used to or starting up
There seems to be a problem with consistent shutdowns in 9i
Oracle 9i 64bit
9.0.1.3.0 - infrastructure database that comes with the application server
9.2.0.1.0 - that is the
Title: RE: URGENT!!! My 9i databases are not shutting down cleanly/consistently like they used to or starting up
BTW,
nothing happening in terms of processes that would hang-up the system.
Also, I have check alert and trace files and there are no obvious errors.
-Original
Title: RE: URGENT!!! My 9i databases are not shutting down cleanly/consistently like they used to or starting up
Which
brings up that thread of - if they are hard to shutdown and possibly going to
crash anyway then . why not just wait some period of time and do the old
shutdown abort.
Title: RE: URGENT!!! My 9i databases are not shutting down cleanly/consistently like they used to or starting up
No
errors in the alert logs, no traces no ORA- but they don't shutdown cleanly
and so I don't get consistent backups (this is every once in awhile).
-Original
Title: RE: Executing Oracle stored proc. over SQL Server linked services
We have installed 9i client and 9i ole db provider and are trying to execute a procedure with input/output variables over a linked service in SQL Server database. We keep getting an error about undefined column. Has
Title: RE: 9ias install - automatic creation of database
Guys,
I am really annoyed with the 9iasV2 install. At one point it asked where I wanted to put the database files and stated that it was not a good policy to put them in the same fs as the Oracle binaries - being a good OFA-compliant
Title: Message
Thanks
for the confirmation - I really believe that was it as well!! - please see
my earlier e-mail.
-Original Message-From: Jack van Zanen
[mailto:[EMAIL PROTECTED]Sent: Tuesday, August 05, 2003 5:24
AMTo: Multiple recipients of list ORACLE-LSubject: RE:
Title: RE: URGENT: Trying to duplicate database from cold backup - auxi
I am with ya.
-Original Message-
From: Freeman Robert - IL [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 05, 2003 5:44 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: URGENT: Trying to duplicate
Title: RE: It's an Oracle Fun Friday!
or Stephen - something even worse
-Original Message-
From: Karniotis, Stephen [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 08, 2003 12:09 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: It's an Oracle Fun Friday!
Interesting web
Title: RE: URGENT: Trying to duplicate database from cold backup - auxi
I have done DR just fine using the same database name and creating (with links or otherwise) the same file system names. This was using a complete backup to restore a database to the same host with a different name and
Title: RE: URGENT: Trying to duplicate database from cold backup - auxi
With DR did use RMAN. Again:
(1) using RMAN worked fine from one host to another of same database
(2) using cold backup and editing backup controlfile worked fine for same host different database name
(3) using RMAN
Title: Message
This
is the type of script I am using:
rman
EOFconnect target rman/[EMAIL PROTECTED]connect catalog
rman/[EMAIL PROTECTED]connect auxiliary sys/[EMAIL PROTECTED]run
{resync catalog;allocate auxiliary channel d1 type disk;allocate
auxiliary channel d2 type disk;set newname
Title: Message
Guys,
When
trying to duplicate database with this script
I have
my auxiliary setup as new database, target setup as old database and am using
duplicate database command along with logfile command to create new
logfiles.
Get
error:
RMAN-06136: ORACLE error from
1 - 100 of 304 matches
Mail list logo