Re: 32 or 64?

We are running oracle 9i on Windows 2000 Server. I recently started administering Oracle on Windows 2000 and noticed that when the oracle.exe process consumes 1450+ Mb of memory, we run into out of process memory error. We ended up recycling application servers every time this has happened and

RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

Are you sure there are no jobs running during the time you are trying to shutdown. Murali. [EMAIL PROTECTED]

Re: HP-UX 11/9iR2/Processes

It is the snp equivalent ...in 9i rel2 there is a job coordinator process and based on the job_queue_processes parameter ...that many jnnn processes. Murali.

Re: 7.3.4 on hp-ux11 upgrade problem

We ran into this error when upgrading to 8i... I think this is a linking issue. Did you try relinking? Murali. Michael Boligan

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 log into a 9.2.0 database that has a hung archiver

Shannon, I don't completely understand the reason to compress the logs. If we are trying to manage space (on archive log destination) why not archive these files to tape ...anyways that is a resource issue. My main concern is the switching of the modes The rule of thumb is Backup your db

RE: get sid (session id) and serial#?

Raj, The comments in dbmssupp.sql suggest that this object needs to be installed only when requested by Oracle supportI was just curious why our databases did not have this object... :-). Thanks Murali.

Re: How to keep root out?

Yes then you are at the mercy of hackers..;-) Murali. Tanel Poder

Re: Permissions error

Are you sure you have the ORACLE_SID set ... or it may be set to something different. Make sure it is set to the right db you are trying to connect. Murali.

Re: 64bit or 32 Bit

Use the isalist command to determine whether the machine is running the 32-bit or 64-bit operating system. If you are running the 64-bit operating system on an UltraSPARC machine, then isalist

Re: Oracle on Win2000

pcanywhere...the remote control for the windoze servers. Murali. Bala

Re: Problem querying remote table through a synonym

What version of Oracle are you running? Murali. Nelson,

RE: Oracle on Win2000

sure...will be glad to learn somethings from your experiences Murali. Niall Litchfield

RE: alert log for physical standby?--pilot error

Can we setup a physical standby on a different OS (Win 2003) than the primary db (Win 2000). Thanks in advance. Murali. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Murali_Pavuloori/[EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

How to tell if XML option is installed in the db?

Gurus: How can we find out if XML is installed in DB? I looked @ the v$option and it doesnot say. I have queried the dba_users for XDB user...is this the correct way? Please help. Thanks in advance. Murali. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET:

restriction on the number of columns in select statement.

Can someone tell me the restriction on the # of columns in the select clause of the statement.. We are running into sort key too long - ORA-01467. I am told there is no order by or group by in the query. I need to look @ the query to make sure there are no references in the statement that

how to generate unique file names on Windows.

Hello, I am trying to write a script on windows that would export the db every night. Can someone tell me how to generate unique file names on windows... What I am looking for is the windows equivalent of echo `date +%m%d%y` Thanks in advance. Murali. -- Please see the official ORACLE-L

Oracle and nfs mounted devices.

Hello Gurus: I have been asked to create datafiles (create tablespace) on disk drives that are mapped ( internal disk - attached to remote servers) When I tried creating tablespace...I get the following error message: ERROR at line 1: ORA-01119: error in creating database file

RE: Oracle and nfs mounted devices.

Thank you guys. I was finally able to create the tablespace on the mapped drive. I do realize that placing datafiles on network devices is not the right thing and is not supported by oracle. Thanks again for the help. You are the best! Murali. |-+ |

Steps to convert a RAC to a single instance.

Hello All: We had purchased RAC to provide high availability of datawarehouse to our customers. We later discovered that the way our application is designed, and because database links are not failed over in the RAC environment, we have decided to abondon RAC - atleast temporarily. Could you

RE: Steps to convert a RAC to a single instance.

Raj, we have a java application that connects to the datawarehouse that is currently setup on RAC but if for some reason one node fails, then we need to recycle the whole application server as the connection pool goes staleOracle product development stated that db links can't be failed over.

how to send mail from windows command prompt?

Hello All: I have setup some scripts that would export the db every day. Instead of looking through the logs manually every morning, is there a way to tail (windoze equivalent?) the file and send and email (mailx equivalent on windows?) I know this can be implemented in Perl, but I don't know

RE: Table Size

I think we can use dbms_space_admin package to get the accurate size of the table...not the allocated (querying the data dictionary will report the allocated space...) Murali. |-+ | | Goulet, Dick | | | [EMAIL

Re: anyone have opinions on the future of the 'grid'?

What are blade servers? Could the listers please shed some light on it thanks, Murali. |-+ | | [EMAIL PROTECTED]| | | | | | Sent by: | | | [EMAIL PROTECTED]|

Re: Redo Log (Largest size used)

Have you looked at MTTR to see if it meets the needs of the recovery scenarios at your site? Murali. |-+ | | Kirtikumar Deshpande | | | kirtikumar_deshpande| | | @yahoo.com | | |

Automatic Undo Management Memory management in 9i

Fellow Listers, Could you please share your experience with Automatic Undo Management and Automatic Memory Management. Would you recommend it? One of the Sr. DBAs here suggested not to implement automatic memory management in 9.2.0.3 but wants to implement it in 9.2.0.4. His suggestion that

Migration utility to convert 32 bit DB to 64 bit?

hello, We currently have oracle (32 bit) 9.2.0.3 db running on Win 2000. We got new itanium machines running Win 2003 (64 bit). We want to move the db running on 32 bit win 2000 server to Wiin 2003 (64 bit) server. Someone suggested that (after installing the 64 bit oracle software) we copy the

RE: Migration utility to convert 32 bit DB to 64 bit?

Thanks for the info Dick. I also found an article on metalink 62290.1 (changing between 32-bit and 64-bit word sizes). Murali. |-+--- | | [EMAIL PROTECTED]| | | tate.fl.us | | | Sent by:

RE: RE: orbitz fiasco

we implemented RAC (not me personally --but my predecessors) It did not work for us. Oracle RAC does not support TAF for sessions coming through dblinks.(Yes verified this with Oracle product development). But that is a application architecture issue. If your app does not require this feature, I

RAC == TAF not supported for sessions coming through db links.

Yong, That is the problem. It is not documented. I think that is the reason why we went down that path of designing our application. I have an email from oracle rep (RAC team member). He confirmed that with Oracle product development. We were running RAC on Tru 64. I was told that it is an

Re: Re[4]: char is going away?

Unless Oracle has plans of buying IBM and decommissioning DB2 ;-) Murali. |-+ | | Jonathan Gennick | | | [EMAIL PROTECTED]| | | .com| | | Sent by: | | |

RE: NT - Win2K causes performance degradation..

We run oracle 9.2.0.3 on Win 2000 and have observed that whenever the memory on ora.exe process reaches around 1.4G, our application runs into Listener unable to start a dedicated server process At this point no one will be able to connect to the db and we are forced to restart. We are exploring

ORA-12540: TNS: internal limit restriction exceeded

Hi All, We are running 9.2.0.4 on windoze 2000 server and this morning we were forced to restart the database server. Users complained about not able to connect to database... TNS could not start dedicated server process...So I tried to connect to db using OS authentication...(sqlplus / as

Re: ORA-12540: TNS: internal limit restriction exceeded

I apologise for the wrong error #...it was a typo on my partthe error # is 12540 Here is the error stack === TNS-12500: TNS:listener failed to start a dedicated server process TNS-12540: TNS:internal limit restriction exceeded