RE: changing the datbase server name and IP number

You may also need to indclude sqlnet.ora as well. -Original Message- Sent: Friday, March 23, 2001 06:41 To: Multiple recipients of list ORACLE-L As long as you are keeping the DB_NAME's the same you should be able to get by with changing the listener.ora and tnsnames.ora files. You

Re: Best Practice ?

Hi ! It all depends on your OPTIMIZER_MODE. I guess you will be using CHOOSE and if that is the case I would recommend analyzing the tables indexes (or ANALYZE_SCHEMA) for + or - 10 % change. - Original Message - To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, March 25,

Re: Connect internal password ?

Associate that second user to the 'dba' unix group. - Original Message - To: 'lzDBA' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, March 26, 2001 4:06 PM Hi guys, (WITH SOLARIS 7 and ORACLE 8.1.6) After I create a new user that can access SVRMGRL and with user

RE: Connect internal password ?

I try to restrict other user from accessing other than sqlplus, by creating new group for them and inside my /appl/Oracle8i/bin/bla bla bla rwxrw- so i can not mix those with dba group do you have any sugestion? -Original Message- Sent: Monday, 26 March 2001 6:57 PM To: [EMAIL

RE: Unix question

For single character replacement (or removal) use "tr". For string to string replacement use sed. echo $var | tr "e" "o" -or- echo $var | sed "s/e/o/g"# (the '/g' means globally) Mandar Ghosalkar [EMAIL PROTECTED] wrote: check this question from korn faq at

Re: changing internal password

You use the orapwd utility to change the remote internal password on unix. The default file name is $ORACLE_HOME/dbs/orapw$ORACLE_SID. Also, when you log in as internal locally, you don't need a password as long as the id you log in with is part of the dba unix group. Nihar [EMAIL PROTECTED]

Help...Rollback Segmenst Grow?

Gurus 1) I am doing some data movement involving a table creation based on another table create table userid.pm_stage_lg_arch tablespace user_data as select *from userid.pm_stage_lg where entry_timestamp= to_date('06-feb-01 11:00:00','DD-MON-YY HH24:MI:SS'); This creates a

RE:

Read the documentation on the 'orapwd' utility. Michael Armstead Database Administrator, OCP-Certified Corporate Finance Information Systems Glaxo SmithKline -Original Message- From: Nihar [SMTP:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 4:41 AM To: Multiple

ORA-27101: shared memory realm does not exist

I have this error when I try to connect to a 8.1.7 database instance. I don't really know what's happening. To give just an information, on the server machine I've 2 database engines (7.3.4 and 8.1.7) and on both engines there are 2 or more instances running. I've only one listener.ora file

RE: ORA-27101: shared memory realm does not exist

What is the OS? -Original Message- Sent: Monday, March 26, 2001 10:41 AM To: Multiple recipients of list ORACLE-L I have this error when I try to connect to a 8.1.7 database instance. I don't really know what's happening. To give just an information, on the server machine I've 2

OLAP again

Hi Our product uses quite complex data model and we are looking for ways to speed up data access, especially large reports in the range of 25,000+ records. One of the ideas was to look into OLAP, or now Business Intelligence, tools. After some reading it seems to me that OLAP is completely

Source Code about Java Classes

Hi all, Does anyody knows how to find the source code about Forms java classes (oracle.forms.ui), i've looked for it at OTN, Technet and Metalink, and haven't found no documentation about it. Thanks in advance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

Doc on migrating to Oracle 8.1.6 on Solaris

Hi, I checked OTN and they do not have doc on migrating to 8.1.6 for Solaris. Does anyone know where I can get this? All I found on OTN is which has no info on migration Sun SPARC Solaris 2.x, Release 8.1.5 HTML PDF Installation Guide HTML PDF Administrator's

Oracle DBAs with AIX experience needed in Florida..

Position: Oracle DBAs with AIX experience Location: Ft Lauderdale, Florida Industry: Resorts Salary: Up to 95K Description: These positions are with a major entity in the resorts industry that needs Oracle DBAs who have AIX experience to provide database support. These are staff

RE: Unix question

this is ksh93 syntax (at least on Sun): 1453:oracle@e6500b ksh1453:oracle@e6500b var=tester1453:oracle@e6500b echo ${var//e/o}ksh: ${var//e/o}: bad substitution 1453:oracle@e6500b dtksh1453:oracle@e6500b var=tester1453:oracle@e6500b echo ${var//e/o}tostor1453:oracle@e6500b

RE: ORA-27101: shared memory realm does not exist

Abiy, I'm not positive, but it appears that the server's Shared Memory may not be configured. Is the database started and open? I'm assuming not...if in fact Oracle can't allocate the SGA in Shared Memory. You may need to reconfigure your Shared Memory settings and recompile the UNIX

RE: ORA-27101: shared memory realm does not exist

If this is NT I have had this error as well. Mine was an error in the init.ora parameters, I forgot to comment something out. Kevin -Original Message- Sent: Monday, March 26, 2001 10:58 AM To: Multiple recipients of list ORACLE-L What is the OS? -Original Message- Sent:

RE: Which is faster??

Direct patch sqlldr (and insert-append) do allow indexes - its just that you get slugged a little more on rollback and redo... I don't have any metrics to compare - typical usage of either tends be to the ol' a) drop ind, b) load, c) redindex hth connor --- Martin Kendall [EMAIL PROTECTED]

Re: DBMS_REPAIR package usage

Thanks for your help! I will definitely try that later today! :D It's really nice to have a full team of people helping me out when I am in a "confused" phrase. And I really do hope that there is not any "I know it's off-topic, but I just couldn't resist .." spam over there. I use my

UNIX CD on NT

Is there a way to read an UNIX CD correctly on NT? I want to use my CD drive (on NT) to get the files and permissions read correctly on UNIX! Thanks, Waleed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network

(Fwd 1 of 2) Re: Forms going away?

fyi (1 of 2) --- Forwarded message follows --- Date sent: Mon, 26 Mar 2001 02:35:24 -0800 Send reply to: O D T U G - D E V 2 K - L @ f a t c i t y . c o m Sriram, Cherokee is not yet available and there are no papers on the Oracle or Technet sites yet, although

(Fwd 2 of 2) Re: Forms going away?

--- Forwarded message follows --- Date sent: Mon, 26 Mar 2001 02:20:18 -0800 T o : O D T U G - D E V 2 K - L @ f a t c i t y . c o m F r o m : d u n c a n . m i l l s @ o r a c l e . c o m We are building a migration facility purely because that was one of the first

Redo Log size used

What can I query to see how much of the redo log file is currently in use? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California--

RE: Help...Rollback Segmenst Grow?

There is no way to stop the use of rollback segments when performing delete operation. Have you considered writing a small PL/SQL procedure to delete the rows? That way, you could commit the work at some interval to control the use of rollback segments. You can certainly shrink them manually as

RE: (Fwd 1 of 2) Re: Forms going away?

The presentation at the below link might also provide you with some additional info. http://www.seouc.org/Details/13.htm Chris "May Oracle be with you...always" -Original Message- Sent: Monday, March 26, 2001 1:21 PM To: Multiple recipients of list ORACLE-L fyi (1 of 2) ---

RE: Why is there air?

On Thu, 22 Mar 2001, Maser, Donna (SEA) wrote: Jared, I am still waiting/hoping for an answer... Why IS there air? - Donna It's to dilute the output from grain eating methane dispensers. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET:

Linux, Sqlplus worksheet?

Title: Linux, Sqlplus worksheet? Hi, I have a user who works on Linux and wants a SQL interface other than command line sqlplus. Since I don't use Linux, I checked my disks for a SQLPLUS Worksheet or OEM version for Linux to no avail. Can anyone recommend a gui/java/etc. SQL processor

Re: do you use SQLJ ?

Oracle has repeatedly stated that PL/SQL is not going away. One good reason for this is that PL/SQL is highly optimized for DML in the database. Java is not, and will not likely ever be as efficient PL/SQL for manipulating large amounts of data. At least IMO. OOP has many benefits, but large

RE: Redo Log size used

Hi Glenn, Try 'log_file_usage.sql' at http://www.ixora.com.au/scripts/redo_log.htm#log_file_usage. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Tuesday, 27 March 2001 5:51 To: Multiple recipients of list

Insert

Hi DBA's, One of my developers just asked me a question, and honestly I don't know what he's talking about. But, it made me think of my own that I do know the answer to or at least I used to:( Anyway, when doing an insert into a table, doesn't it increase performance to delete any

Re: Linux, Sqlplus worksheet?

OEM for linux is available in the 8.1.7 download from technet. Another good place to look is http://www.orasoft.org. Matthew has written a fairly good sql worksheet. They both work off the idea of a sql window and output window. Both give you command history, scrollable output, export of

Re: Redo Log size used

See your alertSID.log by using tail -f alertSID.log Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Mon, 26 Mar 2001 11:51:11 -0800 What can I query to see how much of the redo log file is currently in use? -- Please see the

Re: Linux, Sqlplus worksheet?

Let me rephrase OEM is "free" in accordance with the license restrictions in the development download. Orasoft is GPL for the downloadable version. On Monday 26 March 2001 15:31, you wrote: OEM for linux is available in the 8.1.7 download from technet. Another good place to look is

Execution Plan Qs. of SQL Script ?

Oracle ver 7.3.4.5 CASE 1 - Following query Going for FULL table scan of TAX_DED_AT_SOURCE_TABLE(Synonym=TDS) Table inspite of the presence of the index IDX_TAX_DED_AT_SOURCE_TABLE defined on Fileds(sol_id, cust_id, tds_cert_num, tran_date) SELECT SOL_ID,CUST_ID FROM TDS WHERE

Re: Using HS

It must be a silly environment issue. Are you using a Merant driver on the Sun to SQL server (I was not aware that there is such a Merant driver), or are you using SQL*NET to get to the NT where HS is activating Merant? - If Merant driver is on the Sun, I would check the listener environment.

OPS Setup Steps ?

Have a Single Instance Database ( ORA 8.1.7 )Running on a 2-node Cluster ( Digital Unix 5.1) Any Doc. Listing Steps to Convert it into a 2 instance OPS Database ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City

Re: Single Code Table or Separate Code tables dilemma

- Original Message - As to the encapsulation: Yes things should be encapsulated, fine. But are you saying you do not use any queries in your encapsulating procedures? I am using cursors ( mostly implicit ). Have you ever seen an app that was completely encapsulated? Yes, I had.

RE: Linux, Sqlplus worksheet?

OEM will do just fine. It's available on 8.1.7 -Original Message- Sent: Monday, March 26, 2001 4:00 PM To: Multiple recipients of list ORACLE-L Hi, I have a user who works on Linux and wants a SQL interface other than command line sqlplus. Since I don't use Linux, I checked my

RE: IOUG university

Well, I haven't been to any classes taught by Cary Millsap, but I worked with Cary in the late '80's. One of the sharpest individuals I've ever worked with, very personable, friendly, and down to earth. I would imagine his classes/seminars are very useful. I've been to seminars put on by Gaja

RE: Redo Log size used

Hi Glenn, Yes, your query is fine, and does just what you think. Please see http://www.ixora.com.au/q+a/0102/06135327.htm for the meaning of cpodr_bno. Please see http://www.ixora.com.au/tips/tuning/log_buffer_size.htm for the relationship between log blocks and the log buffer. @ Regards, @

Re: Source Code about Java Classes

Sergio, It doesn't seem to likely that Oracle will provide the source for their products. Jraed On Mon, 26 Mar 2001, Sergio Boix Moriano wrote: Hi all, Does anyody knows how to find the source code about Forms java classes (oracle.forms.ui), i've looked for it at OTN, Technet

Solaris security ?

Hi guys, (With - Solaris 2.7) Do you have any solution how to allow "non owner" to perform backup ? with "tar command" For example: myfile.txt rw--- can you solve this puzzled ? If you think I need to write a unix script would you please teaching me and showing me the steps ?

RE: how to store orace errors in database (UNIX scripting challen

Ok guys, spent my weekend on learning sed. heres what i hv cooked up, just for fun a shell script to get all ora errors into a SDF format, which can be uploaded into a table using sql*loader. issues faced and asking for answers * how to insert a new-line. so broke the sed into next line to

Execute priv to an isolated procedure inside a package

Hi friends, One cannot grant execute privilege to a specific procedure/function inside a package, but only for all or nothing that is in that package. Anybody has an idea how this limitation can be overcomed. One idea is to create a separate stand-alone procedure that will just be a wrapper

RE: IOUG university

I saw Cary present in Copenhagen VERY smart man.. father of OFA :) Gaja we all know from this list -- and I know very few (if any) people who know more about performance tuning than he does Dave Ensor also -- yes a stand-up comic, but he also is one of the most knowledgeable men about

RE: ===CPU, memory script(need help)

select NAME, VALUE from sys.v_$sga; vmstat (solaris command) Sinardy -Original Message- Sent: Monday, 26 March 2001 8:12 PM To: [EMAIL PROTECTED] Importance: High Hi Gurus, does anyone has a script that detects in a database where a lot CPU is being used and

Curious /etc/system settings in Solaris

Hello all, One of the database servers that I am currently working on is a Sun 6500, running Solaris 2.7. It's a fairly large machine, with 20 gig of memory. It's being used for development and testing for multiple applications. When I began installing our particular versions of Oracle

help!!! data migration

hi ppl, i want to migrate oracle database from solaris to NT and vise versa.. can anybody tell me the best way to do it. my database sixe is around 25GB. thanks - NIHAR SANGHVI NetMagic Solutions Pvt. Ltd. 22,Nirlon Complex,Western Express Highway, Goregaon (E), Mumabai 400 063 Phone:

RE: Execution Plan Qs. of SQL Script ?

Kevin wrote - "It is no surprise that the index you mention cannot be used" Qs. WHY ? ( Why is Index IDX_TAX_DED_AT_SOURCE_TABLE on the Table in the Main Query NOT being used in the Absence of the Index on the Table of the Sub-Query ? ) Or am i missing the Obvious ? -Original

olap?

Hallo, Can anyone tell me: What is OLAP and how does it work, a short description, thanks. Roland Skldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

Re: Source Code about Java Classes

Hi all, [EMAIL PROTECTED] wrote: Sergio, It doesn't seem to likely that Oracle will provide the source for their products. I supposed it, but I only want the source for the oracle.forms.ui or the oracle.forms.ui.vbutton. If it's not possible, i would like to have a complete