Archive for the ‘Oracle’ Category

Oracle : Up And Down of Oracle Application And Oracle Database

December 2nd, 2015, posted in Oracle, Solaris
Share

Shutdown Oracle Application :

Go to the path :
/u88/appprodinst/apps/ListenerName_ServerName/admin/scripts

Run Command from Bash
bash-3.00$ ./adstpall.sh


Shutdown Oracle Database :

Go to the path :
/u77/oraprod/prod/db/tech_st/11.1.0/appsutil/scripts/ListenerName_serverName

bash-3.00$ ./addbctl.sh stop

If its taking to much time. You can use this command on extreme cases only :
ps -ef|grep pmon

Than Stop Listener :
bash-3.00$ ./addlnctl.sh stop ListenerName

————–

Start Oracle Database :

Go to the path :

/u77/oraprod/prod/db/tech_st/11.1.0/appsutil/scripts/ListenerName_serverName

bash-3.00$ ./addbctl.sh start

bash-3.00$ ./addlnctl.sh start ListenerName

 

Start Oracle Application :

Go to the path :
/u88/appprodinst/apps/ListenerName_ServerName/admin/scripts

Run Command from Bash
bash-3.00$ ./adstrtal.sh

Share

ORA-01153: an incompatible media recovery is active

November 16th, 2015, posted in Oracle Queries
Share

Problem :


 

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active

-----------------------------------------------------------------------------------------------------
                                          OR
-----------------------------------------------------------------------------------------------------

 

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active


Solution :

This indicates that currently running media recovery process i.e. standby active
SQL> alter database recover managed standby database cancel; --- Cancel first
Database altered. 


SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;
Database altered.

Enabling And Checking the Status of Flashback On Database,Oracle Database,Oracle DBA,Enabling Flashback On Database,Checking the Status of Flashback On Database, Status of Flashback On Database, Enable Flashback On Database, Enabling Flashback On Database,Enable Flashback On Oracle Database, Enabling Flashback On Oracle Database,ORA-01153: an incompatible media recovery is active,ORA-01153,Oracle Error,Ora Error,Oracle DBA,Oracle Database Error,Oracle Database Solution,an incompatible media recovery is active,Ora : an incompatible media recovery is active,Oracle an incompatible media recovery is active,Oracle Error Solution,Database DBA,oracle data guard,oracle data guard issues,oracle data guard error

Share

Enable Java in Google Chrome 45 : Solution for application/x-java-applet

October 11th, 2015, posted in Microsoft, Oracle, TEChNoLoGY
Share

Google released Chrome 45 on September 1, 2015. Unlike its predecessors, Chrome 45 does not support NPAPI plugins like Java and Silverlight. Although Chrome 42 to 44 provided the option for users to enable NPAPI plugins, the option was removed in Chrome 45. Quite simply, if you would like to know how to enable Java in Google Chrome 45 or later, you can’t — at least not directly.  But all hope is not lost!

Chrome users who encounter Java content will be greeted by a yellow notification bar at the top of the browser window that says, This site uses a plugin (Java TM)) that is unsupported. The notification also includes a link to more information about why Java is no longer supported by Chrome.

How to enable Java in Google Chrome 45

The Java content in the web page itself will display as a gray area with a puzzle piece. If you mouse over the puzzle piece, you will see This plugin is not supported.

How to enable Java in Google Chrome 45

If you right-click inside the Java content area, the right-click menu displays application/x-java-applet and an opportunity to Hide this plugin. It no longer includes the Run this pluginselection.

How to enable Java in Google Chrome 45

All in all, it is not tremendously helpful information apart from informing you of what is demonstrably obvious. A trip to the Java.com web site would seem to be in order. Perhaps they would know what to do.

How to enable Java in Google Chrome 45

Perhaps not. A notification confirms, “The Chrome browser does not support NPAPI plug-ins and therefore will not run all Java content.” For a deeper explanation, click the More info link to visit their Java and Google Chrome article.

View Java content in Chrome using the IE Tab extension

One method to view Java content in Chrome is to install the IE Tab extension. The “IE” in IE Tab is an abbreviation for Internet Explorer. Available for Chrome from the Chrome Web Store, IE Tab is used to emulate Internet Explorer within a Chrome browser window. The extension uses the Internet Explorer rendering engine so you can view Java content (as well as ActiveX and Silverlight content). It is easy to install, and even easier to use. It is important to note that IE Tab works on Windows only. Watch the Video.

Visit the IE Tab page in the Chrome Web Store. Click the blue Add To Chrome How to enable Java in Google Chrome 45 button. A dialog will display asking you if you want to Add IE Tab, accompanied by a list of functions it can perform. Click the Add extension button.

How to enable Java in Google Chrome 45

Once installed, the IE Tab icon How to enable Java in Google Chrome 45 will display next to the Chrome’s address bar. Click the icon to open an IE Tab. In the IE Tab, input the web address of the page that contains Java content. In the example below, we successfully verified our Java version, which uses a Java detection applet, using Google Chrome 45 using an IE Tab.

How to enable Java in Google Chrome 45

If you attempt the same verification process in a regular Google Chrome 45 tab, the notification that Chrome does not support NPAPI plugins displays instead.

How to enable Java in Google Chrome 45

View Java content using an alternate web browser

Alternatively, as suggested by Oracle, if you want to display Java content on your computer, you can also use an alternate web browser. The top-tier web browsers that support NPAPI plugins like Java are Firefox, Internet Explorer and Safari. Other alternate web browsers that continue to support Java are Opera and Torch. The web browsers that support Java are available for free. With at least five great web browsers from which to choose, your Java content is truly still readily accessible.

Share

ORA-01153: an incompatible media recovery is active On standby Database

September 24th, 2015, posted in Oracle Queries
Share
Problem

sys@standby> startup mount;Problem sys@standby> startup mount; ORACLE instance started. Total System Global Area  835104768 bytes Fixed Size                  2217952 bytes Variable Size             490735648 bytes Database Buffers          335544320 bytes Redo Buffers                6606848 bytes Database mounted. sys@standby> alter database recover managed standby database using current logfile disconnect; alter database recover managed standby database using current logfile disconnect * ERROR at line 1: ORA-01153: an incompatible media recovery is active Cause This indicates a currently running media recovery process. Action sys@standby> alter database recover managed standby database cancel; sys@standby> alter database recover managed standby database using current logfile disconnect; Note When shutting down physical standby database, firstly turn off media recovery process. Otherwise the next time when starting up redo apply again, you will encounter error ORA-01153.
ORACLE instance started.
Total System Global Area  835104768 bytes
Fixed Size                  2217952 bytes
Variable Size             490735648 bytes
Database Buffers          335544320 bytes
Redo Buffers                6606848 bytes
Database mounted.
sys@standby> alter database recover managed standby database using current logfile disconnect;
alter database recover managed standby database using current logfile disconnect
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active


Cause

This indicates a currently running media recovery process.


Action

sys@standby> alter database recover managed standby database cancel;
sys@standby> alter database recover managed standby database using current logfile disconnect;


Note

When shutting down physical standby database, firstly turn off media recovery process. Otherwise the next time when starting up redo apply again, you will encounter error ORA-01153.
Share

AC-00005: No write permissions for creating the Context file – /tmp/temp.xml

September 12th, 2015, posted in Oracle, Solaris
Share

Problem : 

While making Oracle Application Clone : 

Target System Root Service [enabled] :

Target System Web Entry Point Services [enabled] :

Target System Web Application Services [enabled] :

Target System Batch Processing Services [enabled] :

Target System Other Services [disabled] :

Do you want to preserve the Display [hooraps1:0.0] (y/n) ? : n

Target System Display [erp2:0.0] :
RC-50004: Error occurred in CloneContext:
AC-00005: No write permissions for creating the Context file – /tmp/temp.xml
Raised by oracle.apps.ad.context.AppsContext
Check Clone Context logfile /u07/appprod/apps/apps_st/comn/clone/bin/CloneContext_0908103640.log for details.

ERROR: Context creation not completed successfully.
For additional details review the file /tmp/adcfgclone_17325.err if present.

When you check log file you will get this : 

StackTrace:
java.lang.Exception: AC-00005: No write permissions for creating the Context file – /tmp/temp.xml
Raised by oracle.apps.ad.context.AppsContext
at oracle.apps.ad.context.AppsContext.getOaEnabledValues(AppsContext.java:733)
at oracle.apps.ad.context.CloneContext.setConfigHome(CloneContext.java:2306)
at oracle.apps.ad.context.CloneContext.doClone(CloneContext.java:606)
at oracle.apps.ad.context.CloneContext.main(CloneContext.java:5023)

RC-50004: Error occurred in CloneContext:
AC-00005: No write permissions for creating the Context file – /tmp/temp.xml
Raised by oracle.apps.ad.context.AppsContext
Context file creation not succesful

 

Solution :

Simply go to this path by root user /tmp/temp.xml . Give 777 rights to temp.xl .
And now login with application user and run perl adcfgclone.pl appsTier  !!

GoodLuck !! 🙂

Share