RE: Multiple Oracle Instances on NT
Hello Lisa... I have been handling Oracle on NT last 6 months - and I much prefer UNIX. Here are some things I learnt the hard way... - can you run multiple instances of Oracle on one NT machine yes u can. Another lister has replied to u about this - how one uses oradim80 to create instances/SID's Note that the default SID can be set in the registry - so that u dont have to do set ORACLE_SID= everytime Note that there is no oraenv in NT For every SID there will be 2 services in NT - one called OracleServiceURSID and another OracleStartURSID. If u keep the latter as start automatically - ur db will come up auto when NT boots up. The former is always required. U can alter the settings by recreating the instance using oradim - if so, what do I need to look out for (ie. what things are differentthat a Unix installation) - are any of the processes, etc. drastically different - ie. security,networking, logging Dont foreget to create the oradba group. Also Oracle runs as a single process - there are no different shadow processes. So everything is clumped in one. The TaskManager might show u how many threads are running in one process (it does not break up for each app on the machine - so if only the Oracle server is running - the figure u see should correspond to the number of Oracle related processes) Further note that Oracle runs as user system - thats an internal hidden system mode in NT. So there might be occassions when u change permissions on some orcale related directory and then find that oracle cant access the files - thats cause u removed systems access. Just give required permission to system on those files/directory - what type of system requirements (ie. memory, CPU) are needed on NT Well that depends on ur requirements. Try to configure ur NT box so that its dedicated to the job of being a database server. U can find some notes on metalink on this. Ensure that ur NT box does not double as a PDC (primary domain controller). Finally reboot machine as often as u can - I have found memory being allocated and not being released. Keep LOTS of memory - I have seen the NT box freezing and refusing connections when it no longer had memory to create a shadown process. (only soln - crash boot the machine) Further dont use copy command to do ur hotbackups - use the ocopy command instead. Thats all I can think of now.. regards, ~aslam (PS: I had enough of NT - migrating to Solaris in a months time) -Original Message- From: Yttri, Lisa [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 26, 2001 1:46 AM To: Multiple recipients of list ORACLE-L Subject:Multiple Oracle Instances on NT Hi everyone - I have worked exclusively with Oracle on Unix, but not at all with Oracle on NT. Our users have come to us with a requirement to run an application with their database on NT. They want to build both a test and production environment on the same NT box. I would like to know some basics about running Oracle on NT - can you run multiple instances of Oracle on one NT machine - if so, what do I need to look out for (ie. what things are different that a Unix installation) - are any of the processes, etc. drastically different - ie. security, networking, logging - what type of system requirements (ie. memory, CPU) are needed on NT Thanks for any help you can give me! Lisa File: ATT00326.html application/ms-tnef
RE: Multiple Oracle Instances on NT
Hello Lisa... I have been handling Oracle on NT last 6 months - and I much prefer UNIX. Here are some things I learnt the hard way... - can you run multiple instances of Oracle on one NT machine yes u can. Another lister has replied to u about this - how one uses oradim80 to create instances/SID's Note that the default SID can be set in the registry - so that u dont have to do set ORACLE_SID= everytime Note that there is no oraenv in NT For every SID there will be 2 services in NT - one called OracleServiceURSID and another OracleStartURSID. If u keep the latter as start automatically - ur db will come up auto when NT boots up. The former is always required. U can alter the settings by recreating the instance using oradim - if so, what do I need to look out for (ie. what things are differentthat a Unix installation) - are any of the processes, etc. drastically different - ie. security,networking, logging Dont foreget to create the oradba group. Also Oracle runs as a single process - there are no different shadow processes. So everything is clumped in one. The TaskManager might show u how many threads are running in one process (it does not break up for each app on the machine - so if only the Oracle server is running - the figure u see should correspond to the number of Oracle related processes) Further note that Oracle runs as user system - thats an internal hidden system mode in NT. So there might be occassions when u change permissions on some orcale related directory and then find that oracle cant access the files - thats cause u removed systems access. Just give required permission to system on those files/directory - what type of system requirements (ie. memory, CPU) are needed on NT Well that depends on ur requirements. Try to configure ur NT box so that its dedicated to the job of being a database server. U can find some notes on metalink on this. Ensure that ur NT box does not double as a PDC (primary domain controller). Finally reboot machine as often as u can - I have found memory being allocated and not being released. Keep LOTS of memory - I have seen the NT box freezing and refusing connections when it no longer had memory to create a shadown process. (only soln - crash boot the machine) Further dont use copy command to do ur hotbackups - use the ocopy command instead. Thats all I can think of now.. regards, ~aslam (PS: I had enough of NT - migrating to Solaris in a months time) application/ms-tnef
How does Oracle use the parameter GLOBAL_DBNAME in listener.ora ?
How does Oracle use the parameter GLOBAL_DBNAME in listener.ora ? I faced this problem: Note: The SERVICE_NAMES parameter was set to SFA in the init.ora file File listener.ora is SID_LIST_JLISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = SFA) (ORACLE_HOME = /home6/sfa/app/oracle/product/8.1.5) (SID_NAME = SFAPP) ) ) File tnsnames.ora on client is SFTEST.IN.TATAINFOTECH.COM = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 163.122.32.59)(PORT = 2521)) ) (CONNECT_DATA = (SERVICE_NAME = SFAPP) ) ) When I tried to connect from client I got a error : Unable to resolve service name. When I commented out GLOBAL_DBNAME = SFA - the connection worked !!! I am trying to understand what was going worng - since the tnsnames and listener was generated by Oracle utilities. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: TAG DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
io size of Unix machine
How can I find the logical or physical I/O size on a Sun Solaris machine ? Thanks, ~aslam application/ms-tnef
interpreting ses_actions in dba_audit_object
I enabled all auditing on a table. After doing a select, insert and delete I have one row in dba_audit_object which shows the following for ses_actions column: ---S--S--S-- I know that I have to tie this up with audit options in dba_obj_audit_options to get a more readable report like : Object TEST was SELECTED, INSERTED etc etc I am planning to use decode and some string functions to test for S in the above string and determine whether a certain action happenned or not. Does anyone have any better ideas (or better still a read made script ? :-) Regards, dbatag -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: TAG DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
auditing entire schema
I want to audit ALL objects in the database - we have a lot of objects lying around and even the developers dont know whether some of them are being used or not. I dont think there is any way by which I can audit all objects in the database (thats by issuing a single stmt). I tried to audit by schema : audit all on TRAVEL by session; but that does not work. Currently I am doing this : spool audit_all select 'audit all on '||owner||'.'||segment_name||' by session;' from dba_segments where owner not in ('SYS','SYSTEM'); spool off Any better ideas ? regards, ~dbatag -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: TAG DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Problem with many (160 - 170) sessions in the database on
I agree with Goulet. In contrast to ur rather powerful machine my NT server handles abuot 200 connections on a single database with just 1 CPU and 512 MB RAM. Ofcourse preformance is pathetic - but what can one do with Windows anyways ?? I asked management to junk the machine and in a months time we will migrate to a brand new Sun Solaris Server !! The only way we survive with the NT machine is boot it once a week !! Regards -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 10:51 PM To: Multiple recipients of list ORACLE-L Subject:Re:Problem with many (160 - 170) sessions in the database on Jonas, Solution, dump Windows and get onto Linux or buy a real Unix machine. Your asking a toy to do a man/woman's job. Dick Goulet Reply Separator Author: Jonas A Wetterberg [EMAIL PROTECTED] Date: 5/29/2001 8:50 AM Hello We are running into a little problem with an Oracle installation. The server OS is Windows NT, SP6, and the version of Oracle is 7.3.4.5.0. The server have 4 processes, we have about 1,7 G primary memory and about 2 G of memory on swap disk. We have 4 processes in the machine. One of these is reserved for the OS, and Oracle uses the other 3. We we reach around 170 sessions in the database, the database sometimes goes down and we have to perform a restart. The 3 process Oracle use are all at about 100% in task manager. The memory use is somewhere around 1,3 G. Then we can run the database for aboout 4 more hours, then we have to restart. Sometimes we have to restart around lunch everyday. Now I have heard the Windows NT have a limit of how much memory one process might use, and that limit is somewhere around 1,7 G, and that that might be our problem. We are planing to upgrade to Oracle 8.1.7 and to Windows NT 4 Enterprise Edition or to Windows 2000 Advanced Server. Does anyone know if this can help? Should we put more memory or more processes in the machine? Any help is appreacheated Regards /Jonas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonas A Wetterberg INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). application/ms-tnef