database open

classic Classic list List threaded Threaded
15 messages Options
Reply | Threaded
Open this post in threaded view
|

database open

Roshan
Hi,

I have done a restore of backup on a test instance. It is taking time to open.
Capture.PNG
alert_UAT.log

Regards,
ROshan
Reply | Threaded
Open this post in threaded view
|

Re: database open

ErmanArslansOracleBlog
Administrator
Wait a little man.
It tries to open.
There are things to do while opening the database to read write. It brings the database to a consistent state. The stuff like undo , and changes that need to be taken back, for example..
Consistency is the most important of them.
Reply | Threaded
Open this post in threaded view
|

Re: database open

Roshan
The kernel memory was too high. I decreased it and it was ok.

When starting weblogic, I am now getting
Exception in thread "Thread-45" java.lang.OutOfMemoryError: unable to create new native thread
        at java.lang.Thread.start0(Native Method)
        at java.lang.Thread.start(Thread.java:693)
        at oracle.apps.ad.util.TimedProcess$TimedProcessProcess.run(TimedProcess.java:976)
        at java.lang.Thread.run(Thread.java:724)

do i need to increase oacore memory?

Regards,
Roshan
Reply | Threaded
Open this post in threaded view
|

Re: database open

ErmanArslansOracleBlog
Administrator
How much memory do you have in your application server now?
What are the heap sizes of the weblogic managed servers (oacore, adminserver , oafm and everything)
Reply | Threaded
Open this post in threaded view
|

Re: database open

ErmanArslansOracleBlog
Administrator
You may need to decrease the heaps.. (not increase)
Also if it is a new server, ensure that the limits.conf is appropriate.
Reply | Threaded
Open this post in threaded view
|

Re: database open

ErmanArslansOracleBlog
Administrator
there is no detail about the memory area, for the out of memory error is produced.
So it seems like it is native memory.

Decrease the heap and see.
(dont decrease too much... If you decrease too much , then you may get javaoutofmemory(heap size) this time.

Reply | Threaded
Open this post in threaded view
|

Re: database open

Roshan
I  decreased it from 1024 to 512. Still same issue. Do you think there is a kernel parameter i need to change?

forms-c4ws_server1.log

Reply | Threaded
Open this post in threaded view
|

Re: database open

Roshan
Only forms_server1 and forms-c4ws_server1 are failing to start.

Capture.PNG
Reply | Threaded
Open this post in threaded view
|

Re: database open

ErmanArslansOracleBlog
Administrator
What are their heap sizes?
Send me the all heap size values and the OS physical memory size.

2016-08-02 9:05 GMT+03:00 Roshan [via Erman Arslan's Oracle Forum] <[hidden email]>:
Only forms_server1 and forms-c4ws_server1 are failing to start.

Capture.PNG


If you reply to this email, your message will be added to the discussion below:
http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/database-open-tp1223p1230.html
To start a new topic under Database, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML



--

Erman Arslan 

Applications and Database Operations Manager


Oracle Certified Expert

Certified Exadata Administrator

Certified Linux Administrator

Author for Apress

MBA


Blog:      ermanarslan.blogspot.com

Forum:  http://ermanarslan.blogspot.com/p/forum.html

 

M: 05301567803

Reply | Threaded
Open this post in threaded view
|

Re: database open

Roshan
Please find attached below(context file and server start parameter):
Capture.PNG

UAT_erpuat.xml
Reply | Threaded
Open this post in threaded view
|

Re: database open

ErmanArslansOracleBlog
Administrator
What is your OS memory? Physical memory of your application server?
Reply | Threaded
Open this post in threaded view
|

Re: database open

Roshan
In reply to this post by Roshan
When I do adspall, I am getting the error below:

[appluat@erpuat scripts]$ ./adstpall.sh apps/apps

You are running adstpall.sh version 120.22.12020000.7


Enter the WebLogic Server password: #
# A fatal error has been detected by the Java Runtime Environment:
#
#  SIGSEGV (0xb) at pc=0x00000000, pid=33969, tid=4151733104
#
# JRE version: 7.0_25-b15
# Java VM: Java HotSpot(TM) Server VM (23.25-b01 mixed mode linux-x86 )
# Problematic frame:
# C  0x00000000
#
# Failed to write core dump. Core dumps have been disabled. To enable core dumping, try "ulimit -c unlimited" before starting Java again
#
# An error report file with more information is saved as:
# /u01/oracle/UAT/fs2/inst/apps/UAT_erpuat/admin/scripts/hs_err_pid33969.log
#
# If you would like to submit a bug report, please visit:
#   http://bugreport.sun.com/bugreport/crash.jsp
#
./adstpall.sh: line 332: 33968 Done                    { echo $unpw; echo $WLSPASSWORD; }
     33969 Aborted                 (core dumped) | /u01/oracle/UAT/fs2/EBSapps/comn/util/jdk32/jre/bin/java -classpath "/u01/oracle/UAT/fs2/FMW_Home/Oracle_EBS-app1/oui/jlib/srvm.jar:${CLASSPATH}:${JAVA_TOP}:/u01/oracle/UAT/fs2/FMW_Home/oracle_common/modules/oracle.xdk_11.1.0/xmlparserv2.jar" oracle.apps.ad.autoconfig.ServiceControl -e /u01/oracle/UAT/fs2/inst/apps/UAT_erpuat/appl/admin/UAT_erpuat.xml -m $STOP $SKIPNM $SKIPADMIN -l $LOGFILE -debug -promptmsg hide $nodbchk $params

adstpall.sh:Exiting with status 134

adstpall.sh: check the logfile /u01/oracle/UAT/fs2/inst/apps/UAT_erpuat/logs/appl/admin/log/adstpall.log for more information ...

Reply | Threaded
Open this post in threaded view
|

Re: database open

ErmanArslansOracleBlog
Administrator
In reply to this post by ErmanArslansOracleBlog
You cant even start your environment properly, so why are you talking about adstpall problem?
Focus on starting your env first.
Reply | Threaded
Open this post in threaded view
|

Re: database open

Roshan
I have followed the steps in http://ermanarslan.blogspot.com/2014/11/ebslinux-fork-retry-resource.html

I changed the user from * to appluat. It is now ok.

Thanks,
Roshan
Reply | Threaded
Open this post in threaded view
|

Re: database open

ErmanArslansOracleBlog
Administrator
Good! :) as I already mentioned it in one of my previous response:
"You may need to decrease the heaps.. (not increase) Also if it is a new server, ensure that the limits.conf is appropriate."

 it might be the case, so it is..