RE: Dedicated Server problem ORA-03113

That is the whole problem, there is no logged errors, or trace files. Everyone can connect via the MTS servers, no problem, however no one can connect via dedicated server. Go figure. Regards Denham -Original Message- Sent: Saturday, June 28, 2003 6:54 PM To: Multiple recipients of list

RE: service name

connect descriptor is more like it, since you may load balance the listener. what is the different any way with destination address? is this an exam question or what? -Original Message- Sent: 29 June 2003 02:44 To: Multiple recipients of list ORACLE-L Hello list does a service name

AW: printing out of Pl/SQL

Hi everybody, Great list ! TNX for your kind support... I will give these hints a try, and let you all know, if they solved my problem. Frank Confidentiality Notes This email and any files transmitted is intended only for the person or entity to which it is addressed and may

RE: Update and Join

Hi Castro, Can you set yourfont size bigger? You are not lawyer right? may be this can help you UPDATE table SET column = something_new WHEREprimary_key_or_just_keyin (select foreign_or_primary_key asusual) AND other_key in (other select foreign_or_primary_key asusual); Sinardy

RE: printing out of Pl/SQL

ok, I have tried this sample in the way : - create or replace procedure PrintTest(I_ROWS IN number) is i_CountedRows number(6); fHandle UTL_FILE.FILE_TYPE; begin

RE: Update and Join

In my opinion, you can try this one. Make a view that joined ITEMLOC and ITEMMAST, and then, you can update that view. Automatically the field "PREFER_BIN" will be updated too. I still using SQL Server 2000, the syntax is like this. CREATE VIEW view_name as select

Caffeine good.

A word to the Wise or the Paranoid -- IO subsystems do not enjoy having their power cord knocked loose while the server's up and running, and Oracle likes it even less. An important lesson in splitting up control files between IO controllers/subsystems/power/etc. When we do get our SAN, I'm

Oracle Verison Information

Hi Listers, I have a peculiar problem. I want to get the version of oracle software with all the patches that are installed without opening the database. Is there any file form which i can extract this information. This is required for both Windows and Solaris Platforms. Any help provided

RE: Oracle Verison Information

You can see the install log in C:\Program Files\loracle\inventory\logs\appropriate_log Check out the inventory location in solaris for similar files Regards Naveen -Original Message-From: Munish Bajaj [mailto:[EMAIL PROTECTED]Sent: Monday, June 30, 2003 6:13 PMTo: Multiple

RE: Performance

Mladen Gogala scribbled on the wall in glitter crayon: I didn't have the book with me at the time, so I was talking by heart, from my head. As I am getting older, my memory is obviously playing tricks on me. I humbly apologize to everybody whom I might have offended by my bad spelling,

Multiple update

Hi All, Is it possible to update multiple tables in single SQL statement? Note:- we can accomplish this using view(key-preserved view). Is there any other way? Thanks Sami -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City

Re: Oracle Verison Information

install software, patch, repeat, create database. joe Munish Bajaj wrote: Hi Listers, I have a peculiar problem. I want to get the version of oracle software with all the patches that are installed without opening the database. Is there any file form which i can extract this information.

RE: ORA-04031

0.0 -Original Message- Sent: Friday, June 27, 2003 6:10 PM To: Multiple recipients of list ORACLE-L What patch level of 8.1.7 are you on?? --Walt --- Schauss, Peter [EMAIL PROTECTED] wrote: One of our third party applications gave us the following message: ORA-04031: unable

RE: service name

Interesting. From the Oracle Net8 Class Notes, page 2-4 A service name is an alias for a destination address. The service name directly maps to a connect descriptor. I always find networking confusing. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original

RE: Dedicated Server problem ORA-03113

ORA-3113 error is not very easy to track down. It's like ORA-600, but relates to issues in N/W communication with Oracle datbases. There are a number of notes/articles on Metalink discussing this error. Hopefully some of that information helps you. - Kirti --- Denham Eva [EMAIL PROTECTED]

RE: Performance

17:00 get there for 17:50 Stephen Hodgkinson Oracle DBA TotalFina Elf Gas Power Ltd Phone: 01737 27 5564 [EMAIL PROTECTED] ** This email contains information which is confidential. It is for the exclusive use of

RE: Online tech books

All.. I just returned frm vacation, but I wanted to respond to Jonathan Gennick regarding my collection of books.( I managed to delete that message) But, Ive taken some pictures of my collection.. Ive actually purchaced all the books you see! http://162.42.213.232/books/index.html I would just

RE: Multiple update

Hi All, Is it possible to update multiple tables in single SQL statement? Note:- we can accomplish this using view(key-preserved view). Is there any other way? Thanks Sami I don't think so. Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --

Re: printing out of Pl/SQL

Hi SPOOL OUT will only write the SQL*plus output to the default printer on UNIX it is not implemented in SQL*plus for NT. You cannot do what you are trying to do below. UTL_FILE can only read and write clear text files. I am not an expert on windows internals but lpt1 is a device / port so

RE: Connection Problem

Thanks folks (a useful gender-neutral word). Suggestions received were clean up old names files try pinging name and ip address use ip address in names file instead of a name trace. I have 4 Oracles on the machine so I renamed old names files. I then failed to

RE: Connection Problem

spot on, thanks. S.J.C. Fox CRH 0161 601 8723 -Original Message- Sent: 27 June 2003 19:20 To: Multiple recipients of list ORACLE-L A name resolution problem? Symptoms for the site with problems are consistent with not getting consistently consistent service from your name server.

RE: ORA-04031

what the value of your large pool ?? -Original Message- Sent: Monday, June 30, 2003 3:05 PM To: Multiple recipients of list ORACLE-L 0.0 -Original Message- Sent: Friday, June 27, 2003 6:10 PM To: Multiple recipients of list ORACLE-L What patch level of 8.1.7 are you on??

Re: Oracle Verison Information

Hi The O'Reilly book Oracle scripts has a shell script products.sh that does this, although it uses the file unix.rgs instead although for 9iR1 which i can check now this file only contains the line rdbms 9.0.0.0.0 Beta so i guess the install log in $ORACLE_BASE/oraInventory/logs/installActi

RE: Connection Problem

fair point about lack of info. You guessed correctly about contents of tnsnames file. Many thanks. S.J.C. Fox CRH 0161 601 8723 -Original Message- [mailto:[EMAIL PROTECTED] Sent: 28 June 2003 00:04 To: Multiple recipients of list ORACLE-L Try turning on SQL Net tracing to

RE: Online tech books

Wow Bob, That is very impressive! See many of my books mirrored among yours, so you must have good taste ;-) Regards Denham -Original Message- Sent: Monday, June 30, 2003 4:40 PM To: Multiple recipients of list ORACLE-L All.. I just returned frm vacation, but I wanted to respond to

RE: Multiple update

Title: RE: Multiple update instead of trigger on a view ... Is there any constraint in writing one update statement for each table? Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in

RMAN Recovery Question: Restore with loss of control files and no catalo database

Title: RMAN Recovery Question: Restore with loss of control files and no catalo database Hi there everyone, I have read the documentation and I am missing something, I am stuck on two points: (1) How do I recover from a RMAN backup to disk if I have lost all the original database files

RE: Dedicated Server problem ORA-03113

Yeah, so I have discovered when looking on metalink :-) Nice of you to answer anyway, appreciate it. Denham -Original Message- Sent: Monday, June 30, 2003 4:10 PM To: Multiple recipients of list ORACLE-L ORA-3113 error is not very easy to track down. It's like ORA-600, but relates to

Re: Online tech books

Have you really read all books you have in your bookcase??? JP On Monday 30 of June 2003 16:39, you wrote: All.. I just returned frm vacation, but I wanted to respond to Jonathan Gennick regarding my collection of books.( I managed to delete that message) But, Ive taken some pictures of my

RE: printing out of Pl/SQL

So, summa technologiae can be reduced to the simple advice: avoid NT if possible? Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Monday, June 30, 2003 11:05 AM To: Multiple recipients of list ORACLE-L Hi SPOOL OUT will only write the

What are the restrictions in naming an Oracle SID/Database?

What are the restriction in naming an Oracle SID/Database? 1. Can I have special character in SID/Database name? e.g. Is a SID name 'emp_prod' is allowed? 2. What is the maximum size of a SID/Database name in Unix? 3. What is the maximum size of a SID/Database name in Windows? 4. Is there

RE: printing out of Pl/SQL

Hi I came across similar situation few months ago. You could do following in NT environment. 1. Have the UTL_FILE write to a file in directory called 'printdir' (you can name it whatever you like) 2. Write a NT Shell script to check for any file in 'printdir'. if there is one, use 'print

RE: What are the restrictions in naming an Oracle SID/Database?

Ashoke The problem with long SID names or special characters is that the SID is used in a lot of circumstances. For example, on Unix systems, you end up with other characters being concatenated with the SID and this becomes a process name (as in lgwr_ora_$ORACLE_SID). So the issue isn't

RE: What are the restrictions in naming an Oracle SID/Database?

Ashoke, As far as I know, 1) YES 2) depends on your version of Unix. 3) Don't use Windows as a server platform. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Monday, June 30, 2003

RE: RMAN Recovery Question: Restore with loss of control files an

Timothy I will tell you what I've figured out. Perhaps someone else can provide additional information. 1. Some people have reported success in extracting the control file from the RMAN backup. I got stuck on the issue that RMAN wouldn't function unless the target instance was up with

RE: What are the restrictions in naming an Oracle SID/Database?

What are the restriction in naming an Oracle SID/Database? 1. Can I have special character in SID/Database name? e.g. Is a SID name 'emp_prod' is allowed? No You can not use spl char's. SID name should be in alpha's. 2. What is the maximum size of a SID/Database name in Unix? 8 chars 3. What

RE: Online tech books

Yes, Have you read all those books RB -Original Message- Sent: Monday, June 30, 2003 4:50 PM To: Multiple recipients of list ORACLE-L Have you really read all books you have in your bookcase??? JP On Monday 30 of June 2003 16:39, you wrote: All.. I just returned frm

RE: Online tech books

I think he needs to get out more!! ;o) Dave -Original Message- Sent: Monday, June 30, 2003 10:50 AM To: Multiple recipients of list ORACLE-L Have you really read all books you have in your bookcase??? JP On Monday 30 of June 2003 16:39, you wrote: All.. I just returned frm

Why didn't datafile autoextend?

This morning I started getting ORA-1654: unable to extend index CIMXDBIN.CIMX_SESSION_STATE_PK by 128 in tablespace CAPP_IDX in my alert log (8.1.7 on Windows 2000). I checked my tablespace is has one datafile with autoextend enabled. FILE_NAME

RE: Online tech books

My guess is that some of those books are just a fuel reserve, when the weather gets really cold. Given the oil and gas prices today, it does make sense, you know. Bears accumulate fat for winter, while DBAs accumulate books. On the other hands, our cycle is not related to the weather but rather

RE: What are the restrictions in naming an Oracle SID/Database?

Hi Kumar, 3) I believe it is 4 chars. Thanks, Inder -Original Message- Sent: Monday, June 30, 2003 12:35 PM To: Multiple recipients of list ORACLE-L What are the restriction in naming an Oracle SID/Database? 1. Can I have special character in SID/Database name? e.g. Is a SID name

Re: What are the restrictions in naming an Oracle SID/Database?

oh and the stupid reason why??? 8.3 filenames, init1234.ora joe Singh Pushpinder wrote: Hi Kumar, 3) I believe it is 4 chars. Thanks, Inder -Original Message- Sent: Monday, June 30, 2003 12:35 PM To: Multiple recipients of list ORACLE-L What are the restriction in naming an Oracle

Re: Why didn't datafile autoextend?

what about maxextents ? -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, June 30, 2003 9:50 AM This morning I started getting ORA-1654: unable to extend index CIMXDBIN.CIMX_SESSION_STATE_PK by 128 in tablespace CAPP_IDX in my

RE: Why didn't datafile autoextend?

Looks like the size of your datafile is already higher than your MAXBYTES. In additional to setting AUTOEXTEND ON, you should also give it a sufficient MAXSIZE for the datafile. Oracle will autoextend the datafile only up to the max size specified for the datafile. In your case, the max size for

Re: What are the restrictions in naming an Oracle SID/Database?

3). it was 3 for stupid dos/windows platforms way back when i was doing v5 on 386 PC. joe Singh Pushpinder wrote: Hi Kumar, 3) I believe it is 4 chars. Thanks, Inder -Original Message- Sent: Monday, June 30, 2003 12:35 PM To: Multiple recipients of list ORACLE-L What are the

Re: Performance

Dear Mogens, Wow!!! How creative you and Pete have gotten with my last name!!! Amazing indeed! I bet my Dad suffered from a few hiccups in the past few days. I am still cooking up something big on you my friend - Mogens (pronounced as Moens) Nørgaard (just skip the consanants in the middle and

RE: Why didn't datafile autoextend?

duh. I feel so stupid! It seems that I used OEM to set the MAXSIZE for the datafile and set it to 1900 K Bytes instead of the intended 1900 M Btyes. Thanks!!! -Original Message- Sent: Monday, June 30, 2003 11:16 AM To: Multiple recipients of list ORACLE-L Looks like the size of your

RE: Why didn't datafile autoextend?

Jeff, There are three main reasons why a data file will not autoextend: 1) Maxbytes bytes. If you use the OEM GUI do remember that it defaults to KB. That dog has bitten me more than once. 2) The file system is = 100% full. You can't autoextend nto something that

RE: ORA-04031

600k -Original Message- Sent: Monday, June 30, 2003 11:10 AM To: Multiple recipients of list ORACLE-L what the value of your large pool ?? -Original Message- Sent: Monday, June 30, 2003 3:05 PM To: Multiple recipients of list ORACLE-L 0.0 -Original Message- Sent:

Re: What are the restrictions in naming an Oracle SID/Database?

dh, i meant 4 init1234.ora, i should just quit this field. joe Joe Testa wrote: 3). it was 3 for stupid dos/windows platforms way back when i was doing v5 on 386 PC. joe Singh Pushpinder wrote: Hi Kumar, 3) I believe it is 4 chars. Thanks, Inder -Original Message- Sent:

RE: Those installing Oracle 9i on AIX 5.2L

The APARs I have listed for my 9.2.0.2 install on pSeries is: maint level 02 or greater (oslevel -r) IY22854 IY26778 IY28766 IY28949 IY29965 IY30150 IY34248(bad memory leak in bos.perf.libperfstat 5.1.0.35) IY22844(??? we installed it for SAP; see OSS note 514798 if you run R/3)

RE: Those installing Oracle 9i on AIX 5.2L

Title: Message Interestingly, IBM doesn't seem to come with any decent man pages. It's not just your SA's this time! I installed every single man page package from all 5 of the 5L CD's and can get man pages for most system commands, nothing C-programming related, etc. It's random enough

RE: oraInst.loc question

Title: Message Thanks for the response April. I ended up just hacking Opatch to auto-configure the oraInst.loc files based on which instance of Opatch is being called. Suboptimal still, but better than having to (remember to) manually move 'em myself. I'd forget to tie my shoes in the

RE: What are the restrictions in naming an Oracle SID/Database?

I think it will allow under score as part of SID name but it is not recommended. Thanks, Ashoke -Original Message- Sent: Monday, June 30, 2003 11:35 AM To: Multiple recipients of list ORACLE-L What are the restriction in naming an Oracle SID/Database? 1. Can I have special character

RE: What are the restrictions in naming an Oracle SID/Database?

Actually folks, we've promogulated this idea that a SID and a database name have to be the same. Nothing could be farther from the truth. In a recent attempt to make a new copy of our PeopleSoft database from a BCV copy I found that you can have a different name for the database from the SID.

Re: Filesystem for Linux production database server?

A database running on a single RAID 1 device on a 2 CPU Dell with ext3 on linux is still faster than a database running on a similarly configured Dell box with windows 2000, and several RAID 10 devices. No kidding. Jared Mladen Gogala [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED]

Re: High-availability database question !!!!

I see CIM here a few times. How many users are there here of Apriso CIM? Jared Hemant K Chitale [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/27/2003 09:04 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:

RE: Caffeine good.

And another thing. If in pre 9i days you tried to allocate more than 2gb to the Oracle.exe process, just cause you have 9i and dynamic memory allocation does not mean that os limits have disappeared. Your text file (init.ora) with the incorrect value in it to edit on the other hand, has.

Oracle unlimited concurrent license

My management is claiming that we have an unlimited concurrent users license on one of our AIX machines and that we do not need to upgrade the license when we increase the number of processors. The Oracle web site section on licensing lists only two types of licenses for Enterprise Edition, Named

Re: oracle authentication from windows

Multiple users with the same name may exist in different domain, just as the docs state. Using OSAUTH_PREFIX_DOMAIN = true requires that the domain name be part of the username for externally authenticated accounts. scott/tiger would become your_domain\scott/tiger Jared [EMAIL PROTECTED]

RE: What are the restrictions in naming an Oracle SID/Database?

my test environment is an Oracle 9.2.0 database running on Windows 2000 and it's SID 6 characters.ORA920 :) Nick -Original Message- Sent: Monday, June 30, 2003 9:50 AM To: Multiple recipients of list ORACLE-L Hi Kumar, 3) I believe it is 4 chars. Thanks, Inder

Re: Oracle Verison Information

Hi Munish, in 8i start Oracle Universal Installer and go to Products installed (or something like that) you can then save the list as a text file. In 9i, download Opatch from Metalink and use the following command : opatch lsinventory HTH At 04:43 30/06/2003 -0800, you wrote: Hi Listers,

RE: Oracle unlimited concurrent license

Peter Concurrent licenses were offered years ago. I have not heard of an unlimited concurrent, but it may well be that Oracle Sales sold them one. The key would be finding the sales agreement they and Oracle signed and seeing what it says. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc.

RE: Online tech books

No I have not read them all. Work seems to be getting in the way of my reading... Actually I use most of them on a as needed bases namely a reference. Keep in mind the original point wasnt whether I've read them all but merely my assertation that I purchace a lot of books (particullary

RE: What are the restrictions in naming an Oracle SID/Database?

The maximum length for SID varies depends on Oracle versions and platforms. Check your doc. -Original Message- Sent: Monday, June 30, 2003 6:05 PM To: Multiple recipients of list ORACLE-L my test environment is an Oracle 9.2.0 database running on Windows 2000 and it's SID 6

RE: Oracle unlimited concurrent license

Yes, in versions 5 and 6. Tell them that the money is needed for the transaction processing option (TPO). Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Monday, June 30, 2003 5:10 PM To: Multiple recipients of list ORACLE-L My management

Re: RMAN Recovery Question: Restore with loss of control files and no catalo database

Hi Timothy , I am guessing about the following answers, and I work on 9.2.0.1.0 but anyway here goes : (1) How do I recover from a RMAN backup to disk if I have lost all the original database files (control files, data files and redo logs) In nomount First run SET DBID SET UNTIL SEQUENCE number

Re: What are the restrictions in naming an Oracle SID/Database?

DB_NAME specifies a database identifier of up to 8 characters. The following characters are valid in a database name: alphanumeric characters, underscore (_), number sign (#), and dollar sign ($). No other characters are valid. Oracle removes double quotation marks before processing the database

Re: Oracle unlimited concurrent license

Yes, we have that type of license. Oracle doesn't sell this license anymore, but they did at one time. I can install Oracle on any platform I want, as many servers as I want. 453 users for EE and 400+ for Std Edition. Best look at your contract though to be sure. Jared Schauss, Peter

Re: OEM 9i - saving/copying reports between repositories

I've looked under oem_webstage and other directories but can't seem to find the files. oem_webstage has the index.html that shows the RESULTANT HTML of executing the report, but not the actual code to generate the report. Have since logged a call to Oracle Support. Hope they come up with an

RE: What are the restrictions in naming an Oracle SID/Database?

And clarifying point 1 - at least the underscore is allowed in database and instance names. EMP_PROD would be a valid database and instance name. -Original Message- From: Senthil Kumar D [mailto:[EMAIL PROTECTED] What are the restriction in naming an Oracle SID/Database? 1. Can

RE: What are the restrictions in naming an Oracle SID/Database?

With Oracle 8.1 and above you can have database names and instance names that are at least 8 characters long using Windows NT or 2000. I currently have several databases with 8-character database and instance names, in Oracle 8.1, 9.0, 8.2 on Windows NT and Windows 2000. -Original

DataGuard Logical Standby Benchmark

We are Looking to do an In-house small Benchmark on DataGuard in it's various modes Logical Standby Database Oracle 9.2 Solaris 8 Any experiences of people , approach methodology , dos don'ts , Good Docs , Links ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --

Re: Perl for Oracle DBAs - dbup.pl

FYI, if any of you are using the dbup.pl script from the PDBA toolkit: The solution to Dwayne's problem was to change the following line in dbup.conf from this: %onCallList = ( 'default' = 'corpdba' ); to this: %onCallList = ( '20030101' = 'corpdba', 'default' = 'corpdba'

Re: service name

On Monday 30 June 2003 07:09, DENNIS WILLIAMS wrote: I always find networking confusing. I concur, it's my least favorite part of DBA work. Jared Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, June 30, 2003 2:29 AM To:

Re: printing out of Pl/SQL

And very easy to do in Perl, Windows or *nix. :) http://www.cybcon.com/~jkstill/util/debug_pipe/debug_pipe.html Jared On Friday 27 June 2003 11:04, Arup Nanda wrote: Or DBMS_PIPE - a little easier. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]