Home > Hpux Ia64 Error > Hpux-ia64 Error 17 File Exists

Hpux-ia64 Error 17 File Exists

:: Message Navigator E-mail to friend Deallocating Memory Segments of Crashed Oracle Instance [message #432274] Mon, 23 November 2009 06:14 chetanaZ Messages: 132Registered: October 2009 Location: UK Senior Member Hi, I am having 3 database instances on a HP-UX box One of the instance crashed in last week and I had to open database by renaming the instance However the memory segments allocated for the instance are not deallocated and thus I am getting following error while mounting the instance SQL> startup nomount ORA-27100: shared memory realm already exists HPUX-ia64 Error: 17: File exists SQL> Since I am unable to mount the instance, I am unable to locate memory segments allocated to it for deallocation. I am able to find out the memory segments of other 3 databases instances Can I deallocate all the memory segments as ouputed from (ipcs -pmb) excluding memory segments of the 3 active databases instances? The Output of ipcs -pmb is as follows [email protected]:$ipcs -pmb|grep oracle m 720905 0xe63dccd4 --rw-r----- oracle dba 3241115648 13252 27246 m 1343499 0xe63dccd5 --rw-r----- oracle dba 3241115648 13250 27246 m 2162701 0x02c24068 --rw-r----- oracle dba 3241115648 3956 28689 m 3571726 0xcca6e4f4 --rw-r----- oracle dba 3241115648 10894 28206 m 1835023 0x00c8abb0 --rw-r----- oracle dba 3241115648 16219 27992 The value of 'Shmid' in the trace files of all the 3 database instances are Instance 1 3571726 Instance 2 2162701 Instance 3 1835023 These are found using following method % ps -ef | grep | grep LOCAL SQL> oradebug setospid SQL> oradebug ipc Thanks and Regards, Chetana Report message to a moderator Re: Deallocating Memory Segments of Crashed Oracle Instance [message #432298 is a reply to message #432274] Mon, 23 November 2009 08:43 BlackSwan Messages: 24945Registered: January 2009 Location: SoCal Senior Member one solution is init 6 Report message

and ORA-27100 issues If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 3 of 3 Thread: ORA-00445 and ORA-27100 issues Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 09-22-2003,09:58 PM #1 yls177 View Profile View http://www.orafaq.com/forum/t/152511/ Forum Posts Senior Member Join Date Oct 2002 Posts 391 ORA-00445 and ORA-27100 issues 1) in my alert file Fri Sep 19 12:14:25 2003 alter database open Beginning crash recovery of 1 threads Fri Sep 19 12:14:25 2003 Thread recovery: start rolling forward thread 1 Recovery of Online Redo Log: Thread 1 Group 3 Seq 10007 Reading mem 0 Mem# 0 errs 0: /oracle/SID/origlogA/redo03.dbf Mem# http://www.dbasupport.com/forums/showthread.php?38943-ORA-00445-and-ORA-27100-issues 1 errs 0: /oracle/SID/mirrlogA/mirr03.dbf Fri Sep 19 12:14:25 2003 Thread recovery: finish rolling forward thread 1 Thread recovery: 26 data blocks read, 26 data blocks written, 24 redo blocks read Crash recovery completed successfully is this a major concern? 3) in my trace file timestamp is 7am Redo thread mounted by this instance: 0 Oracle process number: 0 Unix process pid: 2402, image: ora_pmon_SID OPIRIP: Uncaught error 1034. Error stack: ORA-01034: ORACLE not available 4) in my log files of startup oracle 4.1) SVRMGR> ORA-27100: shared memory realm already exists HP-UX Error: 17: File exists SVRMGR> Server Manager complete. 4.2) SVRMGR> ORA-00445: background process "PMON" did not start after 120 seconds SVRMGR> Server Manager complete. logout 5) when i came into office, did a grep ora and found no processes at all. had to manually shutdown oracle and then restart before they are fine. i did my own analysis and the closest i could get was that i had two entries in crontab which attepmted to start the database at the same time which is at 7am and could not find out anything. however, i wanted to know why the above errors oc

is=8 characters so I changed the expanded_node_host_names=1 so that hostname length will be increased from 8 -64 characters.And did sytem restart. But while opening the http://waseemslearning.blogspot.com/2010/10/error-shared-memory-realm-while-opening.html database I got Shared memory realm error.SQL> startup Assertion failed: uname(&name) >= 0, file snlrn.c, line 395 ORA-03113: end-of-file on communication channel SQL> shutdown immediate ORA-01033: ORACLE initialization or shutdown in progress SQL> startup ORA-27100: shared memory realm already exists HPUX-ia64 Error: 17: File exists The uname_eoverflow kernel parameter is by default set to 1 and when I changed the expanded_node_host_names value hpux-ia64 error to 1 we started facing the above issue.If anyone takes a first look on this error, it seems that there is still shared memory occupied by previous Oracle Sessions and try to clean it up using ipcs and ipcrm commands. uname_eoverflow: The setting of this boolean parameter determines what happens when uname gets a long hostname (and it isn't set up for long hpux-ia64 error 17 hostnames). If this kernel tunable is true (1), then generate an error EOVERFLOW; if the tunable is false (0), then silently truncate the host name before returning it in the uname system call.expanded_node_host_names: The setting of this boolean parameter affects whether long host names (and node names) are supported. If this tunable is set to true (1), then the host and node names can be up to 255 characters (actually, 255 bytes); if set to false (0), then the limits are 8 bytes and 64 bytes for the host and node names respectively. The actual current host name (or node name) is unaffected, no matter the setting.If both parameter values will be 1 then they will conflict each other and it will create issue to resolve HOSTNAME, which in our case was happening. So afterwards when we changed the parameter value of uname_eoverflow to 0, above issue resolved and our database and application started smoothly. Posted by Waseem Showkat Ganaie at 11:24 AM Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest No comments: Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) Bl

 

hpux-ia64 error 6 no such device or address

Hpux-ia Error No Such Device Or Address p Things Small and Medium Business Service Providers All Solutions Services Advise Transform and Manage Financing and Flexible Capacity IT Support Services Education and Training Services All Services Products Integrated Systems Composable Systems Converged Systems Hyper Converged Systems Blade Systems Infrastructure Management Software Application Lifecycle Management Application Delivery Management Big Data Analytics DevOps Enterprise Security Hybrid and Private Cloud Information Governance Information Management IT Service Management Operations Management Server Management Software as a Service SaaS Software-Defined Data Center Storage Management All Software Servers Rack Servers Tower Servers Blade Servers Density Optimized Mission Critical

hpux-ia64 error 23

Hpux-ia Error p Things Small and Medium Business Service Providers All Solutions Services Advise Transform and Manage Financing and Flexible Capacity IT Support Services Education and Training Services All Services Products Integrated Systems Composable Systems Converged Systems Hyper Converged Systems Blade Systems Infrastructure Management Software Application Lifecycle Management Application Delivery Management Big Data Analytics DevOps Enterprise Security Hybrid and Private Cloud Information Governance Information Management IT Service Management Operations Management Server Management Software as a Service SaaS Software-Defined Data Center Storage Management All Software Servers Rack Servers Tower Servers Blade Servers Density Optimized Mission Critical Servers Servers for Cloud Server