Re: Shared Pool Utilization

So it was the MTS. Hadn't thought of that. Jared Tanel Poder [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/27/2003 03:49 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Shared Pool Utilization You're

RE: Alert log....

Re the annoying leading whitespace: If you're doing this with shell, run it through this filter: sed -e 's/^ *//g' -e 's/^ *//g' ( those blanks are a tab and a space, respectively ) If you are doing it in perl simply use s/^\s+// eg. $line =~ s/^\s+//; HTH Jared Post, Ethan

alter system does not work as advertised

Maybe somebody can enlighten me on this, if I do a alter system set session_cached_cursors=100 scope=spfile I get the following message back ERROR at line 1: ORA-02096: specified initialization parameter is not modifiable with this option According to the documentation, by specifying

Re: Grid

no not over the atlantic. its from DC to Boston. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 7:39 PM 10GB over Atlantic? This does cost a lot. At least I assume so, why the heck am I sticking to 512kb in my home

Need help with an error ORA-12640

Guru: I need help with an error ORA-12640. I have a Oracle 8.1.7 database with 8.1.7.4 patch running on Windows 2000. The sqlnet.authentication_services=(NTS) parameter is enabled and we do not want to change the sqlnet.authentication_services=(NONE). The custom SQL application is

Moving Data from Oracle to SQL Server

Hi I am going to be migrating data from Oracle to a SQL server and wanted to know what is the likely variation in database size when its done that is if I had a 10GB Oracle DB, should I expect the SQL server to be a lot bigger, a lot smaller or about the same --

Re: alter system does not work as advertised

Hi! It works in 9.2.0.4 on W2k, so it might be a bug. I've seen other problematic parametrs as well in previous patch levels. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 28, 2003 3:24 AM Maybe somebody can enlighten

Re: oracle sessions from term server

The TCP connection to Oracle server process (or dispatcher) port probably remains alive for some reason. When TCP connection is dropped from OS, the session dies immediately.So you should check why are sessions TCP connections maintained or set sqlnet.expire_time to one hour or smth, to kill

Re: Grid

Hi! It's still quite hard to believe, that it could be anywhere near cheap. Even building 10Gbit locatl Ethernet is currently expensive. You would need 16*655Mb ATM connections for that to do over long range... Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL

Templates

Title: Templates Hello I've a little question about templates. Is it possible to design a template table and reuse this table for other (new) tables? If it is, when you change something on the template, will it also change on the other tables? Regards Tim encoded content removed

RE: OCI wrapper library

Not sure that I understand quite well what you want to do (catching statements? Some la Sybase 'Open Server' ?) but it is possible that what is defined in the OCI FM as 'user defined callbacks' is, partly, what you are looking for (I have never used them); I *think* I have read something once

RE: OT: Hey Jared!! -90 degree OT Joke

Hi, This is my own theory, you can't find this information from Oracle Document. Well... talking about women and men. I believe most women use their left brain more than right brain and most men use their right brain more than left brain. Function of left brain -

RE: Templates

What do you have in mind? Data or structure? If it's a matter of data if you replace 'template' by 'table' and 'table' by 'view' in your question, the answer is yes. If it's a matter of structure (enlarging a column, for instance), the answer is no. You have templates of a sort in PL/SQL, when

RE: Need help with an error ORA-12640

Hi Peter, I think you have to make sure that non - admin user have proper access right to sqlnet.ora(what is the last modified time) tnsnames.ora s.a.b. names.oras.a.b. *.oras.a.b. And of course make sure your listener is started,

V$cache

Hello list, I am using Oracle9i Enterprise Edition Release 9.2.0.1.0 on windows. I get 'object does not exist' error when I try to query the V$cache. The docs say that this is an Oracle9i Real Application Clusters view. But so is V$BH and I am able to query that when connected as sys .

RE: RE: OT: Hey Jared!! -90 degree OT Joke

My own theory is that either male or female don't use their brain much. In fact it's pretty equivalent to the load of a Java-free machine. And perhaps it is just as well as it is. - --- Original Message --- - From: Sinardy Xing [EMAIL PROTECTED] To: Multiple recipients of list

SQL HELP.....

I have a table with the following columns: - item - carton_number -(min) - carton_number -(max) - qty -(sum) - weight -(sum) Item A has qty of 4515 and present in cartons 1 to 1129 Item B has qty of 7255 and present in cartons 1 to 1129 Item C has qty of 400 and present in

Fw: V$cache

Sorry for the trouble list. found out need to run ?\rdbms\admin\catclust.sql thanks - Original Message - To: [EMAIL PROTECTED] Sent: Thursday, August 28, 2003 13:46 Hello list, I am using Oracle9i Enterprise Edition Release 9.2.0.1.0 on windows. I get 'object does not exist'

How to invoke stored procedures from another instance?

Hi listers, Assume that there are two instances in Oracle. Both instances are on different machines and different Oracle versions. There is a table on first instance. Any update on this table should invoke stored procedures on the second instance. This should be real time based. Options

RE: V$cache

You don't have enough privilages -Original Message- Sent: 28 August 2003 17:34 To: Multiple recipients of list ORACLE-L Hello list, I am using Oracle9i Enterprise Edition Release 9.2.0.1.0 on windows. I get 'object does not exist' error when I try to query the V$cache. The docs say

RE: OT: Hey Jared!!

As Robert stirs the pot. ;o) -Original Message- Sent: Wednesday, August 27, 2003 4:59 PM To: Multiple recipients of list ORACLE-L Not being sexist in any way, but it's my experience that Women are much better generalists than men, but that men are much better

RE: OT: Hey Jared!! -90 degree OT Joke

sorry -- I read novels, respond visually to things, do math, remember faces but not names, see details AND the big picture so either I am more highly evolved and use both sides of my brain (not hardly) or the theory needs some modification --- Sinardy Xing [EMAIL PROTECTED] wrote: Hi, This

RE: SQL HELP.....

De-aggregating aggregated values is an endeavour comparable to putting the toothpaste back into the tube. You can't. If you have the detail somewhere, read about MINUS and INTERSECT, or possibly NOT EXISTS. - --- Original Message --- - From: Cabansay, Yoyong [EMAIL PROTECTED]

Re: oracle sessions from term server

Hello, We have a similar situation with our Win2K terminal server-based sessions and our Win2K database server (8.1.7.4.1) although we have not introduced the use of SQLNET.EXPIRE_TIME in this case. As detailed in Metalink Doc ID 151972.1 (Dead Connection Detection (DCD) Explained), there

RE: SQL HELP.....

"Open the cartons and see!" ;-) By the way can you reframe your question? Do you mean that you table stores data as follows: item carton_no qty weight - --- -- A1 410 A 2 4 10 B 1 5 12 B 3 5 12 C 1 35 and so on? RegardsNaveen -Original Message-From:

RE: How to invoke stored procedures from another instance?

Hi listers, =20 Assume that there are two instances in Oracle. Both instances are on = different machines and different Oracle versions. There is a table on = first instance. Any update on this table should invoke stored procedures = on the second instance. This should be real time based.

RE: alter system does not work as advertised

Some parameters just never make it to the data dictionary... In 8i there supposedly is an init.ora parameter called create_stored_outlines = true ... can't find it referenced anywhere though in the data dictionary. use_stored_outlines doesn't show up in the OEM parameter listings either. Oh

Re: Re: Grid

atm is obsolete. cheap is relative. i didnt mean its $20/month or comparable to getting AOL. alot of mid-large businesses have them. From: Tanel Poder [EMAIL PROTECTED] Date: 2003/08/28 Thu AM 03:14:26 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Grid Hi!

RE: Virtual Circuit Status

Hi Erik, MTS uses a common queue for incoming requests (calls) to shared servers, and other queues for responses going back via a dispatcher. These queues and their clients constitute the virtual circuit. When a process is ready to take a request or response from its queue, but finds that there

Re: How to invoke stored procedures from another instance?

RE: OT: Hey Jared!! -90 degree OT Joke

Rachel Carmichael scribbled on the wall in glitter crayon: sorry -- I read novels, respond visually to things, do math, remember faces but not names, see details AND the big picture so either I am more highly evolved and use both sides of my brain (not hardly) or the theory needs some

Re: How to invoke stored procedures from another instance?

For this AQ or possibly streams in 9i would be the best, but there is a bit of work to get either set up and functioning the way you want. The big benefit is done right you cant lose a message from one system to the other. This is fundamentally EAI integration without the messaging server. You

Re[2]: International Language Support Experiences?

Tanel wrote: IIRC, you can't store LOBs in UTF8 since it's a variable width charset? and then Richard wrote: You are correct except it is supported with 8i, make sure compatible parameter is set to 8.1.x. I bumped into this issue very recently. Oracle's direction seems to be to always use

RE: OT: Hey Jared!! -90 degree OT Joke

Hmmm... So you're saying that women aren't in their right mind? Taking it to the off topic list. -Original Message- Sent: Thursday, August 28, 2003 2:59 AM To: Multiple recipients of list ORACLE-L Hi, This is my own theory, you can't find this information from Oracle Document. Well...

Re: perl/shell script for alert log

check http://www.dba-village.com/dba/village/dvp_scripts.ScriptDetails?ScrId=993 - Original Message - From: AK To: Multiple recipients of list ORACLE-L Sent: Wednesday, August 27, 2003 10:44 PM Subject: perl/shell script for alert log I am sure you guys

Congratulations Arup (DBA of the Year)

Just came to know from CTOUG news that Oracle has chosen Arup Nanda(our List member) as DBA of the Year. Congratulations Arup. thought I will share this news with the group. CTOUG Board Member, Arup Nanda, Chosen as DBA of the Year Oracle has chosen our very own CTOUG board member, Arup Nanda,

Results of OCS mailing list survey

Hi folks -- Response to my survey was dismal at best. Am I on that many kill lists? ;-) Anyhow, here are the counts: For: 3 Against: 1 Even though the response was 3:1 for the list, four people will not be able to carry a mailing list, so I will not be adding one at this time. Perhaps as

RE: Congratulations Arup (DBA of the Year)

Title: RE: Congratulations Arup (DBA of the Year) Congratulations Arup !! Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have

RE: How to invoke stored procedures from another instance?

It could be a combination of trigger/pooling. Trigger writes changes locally into some kind queue table. The second instance is pooling this queue table (using db link) at it's own rate without affecting transactions against original table. Also, in this case when network is down, original

RE: VPN access to 9ias instance behind firewall

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

Re: Need help with an error ORA-12640

How does the application connect to the database? username/password or '/'? Jared On Wed, 2003-08-27 at 23:19, Lee, Peter (AZ15) wrote: Guru: I need help with an error ORA-12640. I have a Oracle 8.1.7 database with 8.1.7.4 patch running on Windows 2000. The

RE: Need help with an error ORA-12640

Jarad: username/password Thank in advance, Pete -Original Message- Sent: Thursday, August 28, 2003 8:15 AM To: Multiple recipients of list ORACLE-L How does the application connect to the database? username/password or '/'? Jared On Wed, 2003-08-27 at 23:19, Lee, Peter (AZ15)

alter system dump logfile

Title: alter system dump logfile Hi all, as mentioned in Metalink article, one can use ALTER SYSTEM DUMP LOGFILE ... LAYER 11 OPCODE 3 to dump deleted rows from archived logs. does anyone know 1. what others layers are and what they correspond to? 2. what other opcodes are and what they

RE: How to keep root out?

-Original Message-From: Walter K [mailto:[EMAIL PROTECTED]Sent: Thursday, August 28, 2003 11:34 AMTo: Multiple recipients of list ORACLE-LSubject: How to keep "root" out? So, I'm curious,is there any way to prevent access via "connect internal" or "/ as

Building dynamic sql that will do CSV

I'm trying to build something like this: select 'select '''||TABLE_NAME||','||COLUMN_NAME||''', ''',''', min('||COLUMN_NAME||'),max('||COLUMN_NAME||') from ' ||OWNER||'.'||TABLE_NAME||' where '||COLUMN_NAME||' is not null;' FROM dba_tab_columns WHERE table_name in

Re: oracle sessions from term server

Thanks Tanel , for the reply . Does it mean that windows term server is keeping that tcp connection alive although user session is dropped from OS(windows terminal server ) . Is there a way i can trace this tcp session . Thanks, Ajay - Original Message - From: Tanel

RE: Congratulations Arup (DBA of the Year)

Not being a party pooper but what does DBA of the Year actually mean. What criteria was used. How can Oracle know about a quarter of a million DBA's unless it monitors tars raised. John -Original Message- [mailto:[EMAIL PROTECTED] Sent: 28 August 2003 15:54 To: Multiple recipients of

RE: optimizer_max_permutations

This makes me think of a stat that would be nice to see...it would be nice if I could see how many permutations the database was going through for each sql statement that it parsed. I might have a database that rarely uses more than 1000 permutations and I might have one that typically uses

RE: Building dynamic sql that will do CSV

set colsep ',' might help too. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !

RE: optimizer_max_permutations

turns out the parameter only governs how much time the optimizer can spend looking for the best execution plan... 8 means no limit, OK for small SQL queries but for complex ones parsing can take too long. So this has nothing to do with TEMP space usage after all. sort_area_size is probably

RE: How to keep root out?

Well, you can tell them "NOT" to do that. Theycan write scripts to monitor OS performance, but DBA is the one to monitor DB performance. You can aslo tell them you will be writing scripts to monitor Unix performance and probably make some changes in files in /etc directory.If they insist on

Re: Congratulations Arup (DBA of the Year)

Congrates Arup !!! You doing a great job . -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 28, 2003 7:54 AM Just came to know from CTOUG news that Oracle has chosen Arup Nanda(our List member) as DBA of the Year.

RE: Virtual Circuit Status/wecome back

Steve, Welcome back, we all were missing your participation for long time... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 28 Aug 2003 04:39:47 -0800 Hi Erik, MTS uses a common queue for incoming requests (calls) to shared

Antw: Building dynamic sql that will do CSV

Hi Michael, are you looking for something like: SET COLSEP ','? Greetings, Guido [EMAIL PROTECTED] 28.08.2003 17.49 Uhr I'm trying to build something like this: select 'select '''||TABLE_NAME||','||COLUMN_NAME||''', ''',''', min('||COLUMN_NAME||'), max('||COLUMN_NAME||') from '

Re: How to keep root out?

Sadly for you there is no way to stop them using it, you could check and see of root is part of the dba group and have a sysadmin remove it. and if you succeed then they need only to su - oracle and they can still do it, this may then if configured show up in a su log. I think you need to

RE: How to keep root out?

Well, first of all, root should not be in your dba group... -Original Message-From: Walter K [mailto:[EMAIL PROTECTED]Sent: Thursday, August 28, 2003 8:34 AMTo: Multiple recipients of list ORACLE-LSubject: How to keep "root" out? Just for grins, I'll ask this question...

How to keep root out?

Just for grins, I'll ask this question... Is there any way to keep the Unix "root" user from logging into the database (i.e. connect internal or / as sysdba)? Currently using 8.1.7.4 on Solaris 8 here. We have a couple people in our Unix admin group that feel the need to "help" by writing their

Re: Congratulations Arup (DBA of the Year)

Oracle has chosen our very own CTOUG board member, Arup Nanda, as the DBA of the Year, out of some quarter million DBAs worldwide. There will be a Not taking anything from Arup, but .out of some quarter million DBAs worldwide??? Are you trying to be Comical Ali, the second? -- Please see

RE: How to keep root out?

Walter, First question, why are they logging on as "root" in the first place. That is akin to logging into the database as sys all the time, namely something to be avoided at all cost. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Walter K

RE: Congratulations Arup (DBA of the Year)

Oh no! Somebody's jealous. My guess is CTOUG is the Connecticut Oracle Users's Group. You probably weren't in the running, if your email address indicates you aren't a member. John, we're all very appreciative of you as well. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original

RE: How to keep root out?

rm -r * at root. : -Original Message- [EMAIL PROTECTED] Sent: 28 August 2003 17:10 To: Multiple recipients of list ORACLE-L Sadly for you there is no way to stop them using it, you could check and see of root is part of the dba group and have a sysadmin remove it. and if you succeed

sanity check time...

Ok, i'm a unix guy i don't usually work with windows. well, the Keane office just called and some of the people over there are having trouble connecting to a windows 9i database. when i asked them if the services were running i got a basic huh? so what do i have to run to set up the services?

RE: How to keep root out?

Walter You may be able to approach this from a security aspect. You could discuss with your management whether it is a good idea for the system administrators to be in a database. Depending on the security or SLA requirements of the database, you may have some leverage there. Dennis Williams

RE: How to keep root out?

Help... my database isn't coming up anymore!! ;) Brian -Original Message- Mark Leith Sent: Thursday, August 28, 2003 11:24 AM To: Multiple recipients of list ORACLE-L rm -r * at root. : -Original Message- [EMAIL PROTECTED] Sent: 28 August 2003 17:10 To: Multiple recipients

RE: sql optimization question

Dave: Thanks! That works great. Guang -Original Message- Dave Hau Sent: Wednesday, August 27, 2003 4:29 PM To: Multiple recipients of list ORACLE-L select distinct n.cognateid, m.isirefid,4, linkdate from mt.externallink l, refidmatch m, nametag n where l.objectid = n.geneid and

RE: sanity check time...

Bill, all services should be starting automatically, but you can check the following: From the NT prompt, type NET START. You should see a list of what services are running. All Oracle services start with ORACLE. If things are not running, you can do the obvious - run lsnrctl to get the

RE: How to keep root out?

Should keep the Unix weenies from bugging your database for at least a short time, if all else fails! ;) -Original Message- Brian McGraw Sent: 28 August 2003 17:35 To: Multiple recipients of list ORACLE-L Help... my database isn't coming up anymore!! ;) Brian -Original

Re: oracle sessions from term server

I used to deal with this on a regular basis. Sun servers, PC clients. User reboots PC, session persists. It does not require that the TCP session still exists. We didn't use DCD at the time, as it was kind of buggy. You may want to give that a try now. Jared On Thu, 2003-08-28 at 08:54, AK

Re: How to keep root out?

Thursday, August 28, 2003, 11:34:27 AM, Walter wrote: WK We have a couple people in our Unix admin group that feel the need to help by WK writing their own DB monitoring scripts. Of course, they don't know what they're WK talking about. Why, the dasterdly do-gooders! How dare they!grin You know,

Re: Building dynamic sql that will do CSV

see http://www.cybcon.com/~jkstill/util/dump/dump.html On Thu, 2003-08-28 at 08:49, Michael Kline wrote: I'm trying to build something like this: select 'select '''||TABLE_NAME||','||COLUMN_NAME||''', ''',''', min('||COLUMN_NAME||'), max('||COLUMN_NAME||') from '

Re: How to keep root out?

Walter, Unfortunately, there is no way. You can prevent root from connecting as sysdba by removing the dba group from root userid; but hey, root can "root" it again; he is root, remember, omnipotent. Even if that is successful, he can connect toany dba account, such as "oracle" using "su

RE: sanity check time...

Mercadante, Thomas F scribbled on the wall in glitter crayon: If things are not running, you can do the obvious - run lsnrctl to get the listener running. If you do not see and database services running, you need to determine what services have been created. You can go to the NT Services

RE: Congratulations Arup (DBA of the Year)

Oops, looks like the egg is on my face. Mea culpa, didn't read the messages carefully enough, made assumptions. Apologies all around. Now he slinks back to his cube. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, August 28,

RE: Grid

10-gig ethernet IS hideously expensive, but its the switching that's expensive. The actual bearer circuit is standard dark fiber. 10-gig ethernet is actually kind of a cheat - it uses 4 2.5 gig wavelengths to create the 10-gig throughput. So each port has to be a DWDM or use 4 different

RE: Congratulations Arup (DBA of the Year)

Well, as a person who has survived with Arup one minor and non-exacting project (moving 1TB OPS database from Siemens--HP, from V7--8i, simultaneously, over a single weekend, with rather simple twists, like finding the right patch for Dev 2000 to continue working, utilizing listener load

RE: How to keep root out?

Title: Message Put the following code snippet "if [ "$LOGNAME" = "root" ]; then init 0 fi; in your oraenv. I guarantee you that the SA will no longer be connecting as SYSDBA. --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL

RE: sanity check time...

Bill, Services should be there. Listener service is created, when Oracle is installed. And database service is created when database is created, using oradim, and has database name as part of the service name: OracleServicedatabase_name. Tell them to check if services are running, check

RE: How to keep root out?

Title: Message but this assumes that oracle owner has privs to run init ... am not sure any root worth hir salt would let this happen. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in

RE: How to keep root out?

LOL ROTFLMAO. That is something to try!! RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 8/28/2003 12:04 PM Put the following code snippet if [ $LOGNAME = root ]; then init 0 fi; in your oraenv. I guarantee you that the SA will no longer be

RE: How to keep root out?

Title: Message Cant root user change any file on the system regardless of the file owner? If the SA doesnt know about this line of code or about oraenv, then it will work for a while. I think Saira -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On

Re: How to keep root out?

Hi! Put sqlnet.authentication_services = none in your server's sqlnet.ora. Then everyone has to use a password. Tanel. - Original Message - From: Walter K To: Multiple recipients of list ORACLE-L Sent: Thursday, August 28, 2003 6:34 PM Subject: How to keep

RE: OT: Hey Jared!! -90 degree OT Joke

Ivaguely remember hearing : * right handed people use left side of brain *that left handed people use right side of brain Correct??? I think right or left just use it. I mean use something. "Orr, Steve" [EMAIL PROTECTED] wrote: Hmmm... So you're saying that women aren't in their right mind?

Inactive Sessions/Java

Hi All, I have a problem with inactive sessions (despite having set the sqlnet.expire parameter) Some of the users connect to the database via a java process - when I stop this process from running the number of sessions just shots right down. Short of scheduling a start and restart of this

Re: How to keep root out?

Title: Message Hm, why not rm -rf / following by reboot instead? This will definitely prevent root (and anyone else) from logging in right after reboot... Tanel. - Original Message - From: Saira Somani-Mendelin To: Multiple recipients of list ORACLE-L Sent:

RE: How to keep root out?

Wouldn't work if oraenv is run after an su to oracle. ;) Quoting Freeman Robert - IL [EMAIL PROTECTED]: Read the code again. It checks that the person running .oraenv is root, and if so, it does the init. RF -Original Message- To: Multiple recipients of list

Re: How to keep root out?

Just a thought. Grant the SYSDBA and SYSOPER privileges to some user you have the password to. Then change the dba group in the file $ORACLE_HOME/rdbms/lib/config.c (config.s in the case of Solaris) to some other group (maybe invalid group) and relink oracle. You could use the password

RE: Grid

2.3 GB from California to Switzerland is fast, damned fast. http://www.cenic.org/CENIC2003/NGIAwards/winners/slac.htm We are part of several test beds having to do with future networking capabilities. Ian MacGregor -Original Message- Sent: Wednesday, August 27, 2003 3:54 PM To:

RE: How to keep root out?

Read the code again. It checks that the person running .oraenv is root, and if so, it does the init. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 8/28/2003 12:14 PM but this assumes that oracle owner has privs to run init ... am not sure any root worth hir salt

RE: How to keep root out?

Now, I use to know a Unix admin who did exactly that thinking he was in a private subdirectory. He spent the following 36 hours rebuilding the server restoring the database, after that he tried to explain what happen for another 3 hours to the powers that be, and the remainder of the day

RE: How to keep root out?

Having been there, I'll agree with Jonathan Gennick on this issue. First off try to talk to the folks let them know that their meddling where they should not be. That worked with one sys admin I have. Failing that, which I have, follow Jonathan's advice give them a "safe" login that they

RE: How to keep root out?

Almost, Mladen...you forgot to: echo rm -rf //etc/rc0.d/K00aaa_startup chmod 770 /etc/rc0.d/K00aaa_startup before the init. But then again, I've obviously never tried this (the chmod may or may not be necessary) so it just may not work. Shouldn't SAs know that root is a

RE: How to keep root out?

Moral: Do not login as root unless you absolutely have to. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA I also function as our sysadm, and I barely remember the root password to our solaris boxes. I used to log in as root, but heard enough horror stories to figure out a way around

RE: Hey Jared!!

Hey, I got a couple emails saying I'm sending the worm to people I never heard of. Does that make me as famous as Jared?? I guess not. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, August 27, 2003 8:50 AM To: Multiple

Re: Inactive Sessions/Java

What is Java process? Is it a java class running in some kind of application server? If yes, then your application server is keeping your connections open and using connection pooling to share them between your processes, somewhat reducing the overhead to create drop a connection for every

Re: How to keep root out?

Title: Message Better yet, put the following lines echo ORA-600 [kgfdjjks] [scdcsc] [dssdcdcsdc] [45] [999] Unauthorized root access then print some garbage into a file named like the regular trace files in user_dump_dest directory. Open up a iTARand show this "trace" file to your SA's

How to find the session holding the library cache pin.

Gurus: One of the developers has changed his java code and wants to load the class into the db. He did this on production db while users are accessing the application...and then complained that his session is just sitting in idle state I queried the v$session_wait and found that his session

Re: How to find the session holding the library cache pin.

dba_blockers this doesnt install by default. i cant remember which script runs it. check metalink. warning... its a VERY slow view. From: Murali_Pavuloori/[EMAIL PROTECTED] Date: 2003/08/28 Thu PM 04:14:26 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: How to find

RE: OT: Hey Jared!! -90 degree OT Joke

That's true--each hemisphere of the brain handles I/O for the opposite side of the body. If I remember my neuropsych classes correctly, even the optic nerves from each eye cross over... Roy Pardee Programmer/Analyst/DBA SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent:

RE: How to find the session holding the library cache pin.

Murali, Running this should help in identifying the object being locked and the SID holding that pin. John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Grace - Getting something we do NOT deserve Mercy - NOT getting something we DO deserve Click on 'http://www.needhim.org' for Grace and Mercy

RE: How to find the session holding the library cache pin.

$ORACLE_HOME/rdbms/admin/catblock.sql -- Mladen Gogala Oracle DBA -Original Message- [EMAIL PROTECTED] Sent: Thursday, August 28, 2003 4:24 PM To: Multiple recipients of list ORACLE-L dba_blockers this doesnt install by default. i cant remember which script runs it. check metalink.

  1   2   >