11g - Change ORACLE Home?
Aug 30, 2011i have requirement to change the oracle home from /u04/....../dbhome_2 to /u03/...../dbhome_4
DB=11g
application version=R12.
ADVERTISEMENT
Application Express :: Menu List Look Change Between Home Page And Other Pages
May 18, 2013APEX Version : 4.2.2
Application : TRQ_APP
[URL].......
I have a menu list defined in page 0 - when the menu list is displayed in home page (Page 1) it looks fine but in others pages it displays differently
To have the menu list displayed in all pages of application as it is in page 1.
Same Home For ASM / Oracle
Dec 17, 2010can we have same asm and oracle_home? did you see any technical difficulty in having same home for database as well as asm?
View 1 Replies View RelatedOracle 11.2.0.1.0 Oradiag_oracle $HOME
Sep 13, 2010From what I read so far this directory and sub directories get created everytime a user connects to Oracle. I have a few more questions:
1) Is there any other reason why this directory is needed?
2) is there anyway to re-direct the directory to a different location other than $HOME? is so how?
3) is there any way to disable the creation of this directory, is so how?
4) If it can't be disabled, I can write a script to remove information under that directory, what is safe to remove?
BTW, I am running on AIX 6.1 box if this information is pertinent to the issue.
Restoring Oracle Home Patch Fails
Apr 29, 2011[URL]......
The oracle documents mentions this file
$ORACLE_HOME/.patch_storage/<patch-id_timestamp>/restore.sh
But what I find in that directory is
$ORACLE_HOME/.patch_storage/<patch-id_timestamp>/rolback.sh
Where is the restore.sh file that the document is talking about.
Upgrade :: DBUA On Cloned Oracle Home
May 1, 2013I am currently in the process of trying to upgrade a 10.2.0.4 database to 11.2.0.2. I am using DBUA to complete this work. I have a small issue which I cant work out and cant find anything on Google or oracle docs about it.
The home where the software for 11.2.0.2 is an ORACLE_HOME that was recently cloned from another 11g home. When im in the DBUA summary page before I kick off the upgrade the summary page lists the "TARGET" oracle home as the old 11g home and not the new "CLONED" one.
Obviously DBUA is picking up the target ORACLE_HOME from a file in the cloned home that has not been updated with the new CLONED home info. I have made sure all variables are set correctly including the PATH variable.
11g Database - Opatch Can't Find Oracle Home
Jul 15, 2011I am trying to patch an Oracle 11g database. I can see from the logs that is was patched after it was created by a consultant but I cannot get Opatch to work.
C:\app\Oracle\product\11.2.0\dbhome_1>java -version
java version "1.5.0_17"
Java™ 2 Runtime Environment, Standard Edition (build 1.5.0_17-b03)
Java HotSpot™ Client VM (build 1.5.0_17-b03, mixed mode)
C:\app\Oracle\product\11.2.0\dbhome_1>opatch>set ORACLE_HOME=C:\app\Oracle\product\11.2.0\dbhome_1
C:\app\Oracle\product\11.2.0\dbhome_1>opatch lsinventory -all
ORACLE_HOME is NOT set at OPatch invocation
The Oracle Home C:\app\Oracle\product is not OUI based home. Please give proper Oracle Home.
OPatch returns with error code = 1
OPatch failed with error code = 1
Java is set in the environment path but the Oracle home seems to be the issue. I checked the LOC parameter in the Oracle/Inventory folder and it is set correctly to C:\app\Oracle\product\11.2.0\dbhome_1.
RAC & Failsafe :: Multiple Oracle Home Machine On Two Node ENV?
Mar 6, 2012I have two node RAC database running on linux machine (Oracle10G SE), our requirnment is to install new oracle binaries for Oracle10G EE on diffrent home location.after install Oracle10G EE binaries on new oracle home , i want to point our existing database to new Oracle10G EE home to adotp a features of Oracle10G EE features.
But at the same time i dont want to deinstall our Oracle10G SE binaries.So it is possible to rollback our process to point our database back to Oracle10G SE from Oracle10G EE in case anything going wrong.
While Applying Patches In Oracle Home Space Not Sufficient
Mar 18, 2011Im applying patch which is an upgrade to 10.2.0.5 from 10.2.0.3. Its a 2 node RAC. While applying patches the installer mentioned space are sufficient, but while applying patches it throws message that in oracle home space not sufficient. Im able to apply patches in cluster home successfully. How much space required in oracle home for this patch? There is no information mentioned the document as well.
View 2 Replies View RelatedInstallation :: Does Windows 7 Home Basic Support Oracle 11g
Jun 7, 2012Does windows 7 home basic support oracle 11g?
i am getting some error during installation.
Server Administration :: Install Oracle 10g In Windows 7 Home Premium
Feb 20, 2010I need to install Oracle 10g in windows 7 home premium which version of oracle 10g will work better with Windows 7 home premium. I need to download «& install.
View 5 Replies View RelatedServer Administration :: Create Two Databases With Different Sides On One Oracle Home?
Jun 8, 2010i want to create two databases with different sids on one oracle home.
how can ı handle it?
Oracle Database Server / Client Connection Settings Between Office And Home
Jul 3, 2010Suppose my oracle database server IP is 128.1.1.100 in the office & the internet static IP is 115.118.33.100 is on that server. I want to retrieve the data by using oracle forms & report from my home's computer having different internet IP 115.118.33.25 on my home's computer.
what would be the settings on my home's computer for the same. i mean tnsname.ora file or any other setting.
Networking And Gateways :: Maintaining Single Listener In Multi-instance Database Server With 3 Different Oracle Home
Sep 29, 2011We've been administering a multiple instance production dB server with 3 different versions of Oracle installed.Currently, each of Oracle version had corresponding listener.Oracle 9i had 2 instances, 10g 6 instances & 11g 2 instances also.how I can integrate this 3 listeners into 1.
View 2 Replies View RelatedHow To Add Another Home
Aug 26, 2010I have installed oracle 10gr2(10.2.0.1) on a solaris box.But to test it and to install the patch we need to set up the ORACLE_HOME.On the same server we have oracle 11g Db as well and the existing oracle_Home is pointing to 11g Database.
Now how to set up another ORACLE_HOME on the same server so that it points to the 10g as well.Is it possible to have two Oracle Homes on the same server.
Client Tools :: How To Work With SQL From Home PC
Feb 16, 2012I want to practice Oracle SQL from home.What software i need to install. Even if i install SQL developer,SQL+ which database i can access n how.
View 10 Replies View RelatedRAC/ASM Clusterware Installation :: RAC 11g CRS Home Locked / Unlocked
Sep 10, 2012We are using Redhat Linux OS with ASM on 11.2.0.3 RAC Clusterware and DB is running on 11.2.0.3.1
I would like to know whether the CRS/GRID home is locked or unlocked...? How can we know that ?
Also with out root how can we find the Disk Size with out logging into ASM /ASMCMD ?
Networking And Gateways :: Multiple Home Listener Configuration?
Jul 29, 2011I have installed Oracle 10g in windows 2003 two times with two different homes. (D:oraclehome and E:oraclehome).Databases db01 and db02 created in these homes respectively. how to configure listener and tnsnames to aceess these databases.
View 7 Replies View RelatedForms :: Logo And Home Page Picture Quality?
Nov 29, 2012, i want to use picture on my home page (main.fmx) & logo picture on top of my oracle forms 11gR2 application.i try with 2 different ways, but i am loosing the quality of picture.
A. Form Menu - Edit - Import - Image - Even i select excellent quality
B. Through Webutil Read_Image_File ()
Application Express :: No Navigation Region On Home Page?
Sep 21, 2012I've created a new appliacation which has a home page and I've created a report page which updates a table. I want to add a link to my homepage, as a text line for example UpdateTable, and when I click the link, it goes to my report page. I've had a look in my Apex CookBook, and it says I do this by using the Navigation region in my home page. The problem is I don't seem to have a navigation region in my home page. I thought initially it meant the navigation bar, but I now realise this is the header bar. Do you know how I can create a navigation region in my home page..?
View 2 Replies View RelatedApplication Express :: Clearing Cache From Home Link
Sep 29, 2012I am using theme 4, topaz. Region_Position_06 is a home link.
I have placed a company graphic at this position on page zero, and when a user clicks it on any page, she exits that page and goes to the home page, a main menu page. So no matter how deep a user may be into the application's pages, she may always click this logo image and return directly to the main menu page.
This is convenient, but there is one problem. Clicking this logo does not clear the cache on the page the user is exiting or, for that matter, on any page in the trail of pages the user took to get to the current page. I navigate primarily with buttons and always clear the cache on a page when I exit it. I need to find a way to do this when a user clicks the logo image.
Application Express :: How To Show Alert Message In Home Page
Jun 11, 2012I have leave application form based on the LEAVE table, it has the following columns,
leave_id(primary key)
emp_name
from_date
to_date
no_of_days
Statuswhen they entered the details and submitted the form the data will be stored in LEAVE table. later on the applied leave will be approved or rejected and the STATUS column will be updated. Is this possible to show the last leave applied status as a alert message when they are logging in ?
Installation :: Reinstall Software After Uninstall With Home Using Universal Installer
Apr 29, 2013after uninstalling 10g software with home using universal installer how to re-install without deleting all components of database like the database exists i just want to put the oracle software on it and reusing x home location.
View 6 Replies View RelatedImport Oracle 9.2 Exp To 11.2 - How To Change Path
Dec 10, 2012The source server (9.2) is /oracle/data/xxx the destination will be /u02/oradata/xxx how do I get the imp to change the paths.
I know you can't do db_file_name_convert, as that only works in dataguard with rman, and it looks like you can only set compatible down to 10.2, it's a very small DB, (5Mb) but it's a live license server DB, I need it intact.
I tried a straight import, but that just barfed with "IMP-00015: following statement failed because the object already exists:" on every statement.
EDIT: it's lying, the /oracle path doesn't exist, just FYI.
Change Root / Oracle Password In Rac
Mar 16, 2012I need know the impact in my oracle database 10g R2, if i change root/oracle passwords in my Oracle RAC environment, my database using ASM and the nodes is in Red Hat 4.7.
View 1 Replies View RelatedHow To Change Oracle TNS Listener Path
Oct 29, 2010how to change this path:
F:\app\MyLAP\product\11.1.0\db_1\BIN\TNSLSNR
to this path:
d:\app\MyLAP\product\11.1.0\db_1\BIN\TNSLSNR
in the service ?
SQL & PL/SQL :: Change Oracle Database Language?
Feb 4, 2011how can i change my oracle database language
View 6 Replies View RelatedMigrate A DB ORACLE 8i To 10g (things To Change)?
Jul 14, 2010In this moment, I am migrateing a DB ORACLE 8i to ORACLE 10g.I have read that this version (10g) no need HINT SENTENCE.For this reason I am looking for a SCRIPT to remove (or disable) all of HINTS from the DB (10g), But I could not.
View 2 Replies View RelatedOracle Datapump - Table Structure Change?
Oct 19, 2010we have daily partitioned table, and for backup we are using data pump (expdp). we policy to drop partition after backup (archiving).
we have archived dump files for 1year, few days back developer made changes with table structure they added one new column to table.
Now we are unable to restore old partitions is there a way to restore partition if new column added / dropped from currect table.
Forms :: How To Change Image Resolution In Oracle 10g
Jul 9, 2013I am working on oracle forms 10g (Windows7 OS). Can we get the image resolution of an image item in oracle forms? Can we resize the image in terms of resolution? I have a requirement where user can upload only 1280x720 size images. Either i have to validate the image resolution and give them a message saying 'Only 1280x720 size images are allowed' or simply i have to convert the image to be upload to 1280x720 size and save in the database.
View 1 Replies View Related