I 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.
can 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 Relatedi have requirement to change the oracle home from /u04/....../dbhome_2 to /u03/...../dbhome_4
DB=11g
application version=R12.
From 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.
I 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 Related[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.
I 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.
I 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.
We 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 ?
I 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 RelatedI 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.
, 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 ()
Im 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 RelatedI'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 RelatedDoes windows 7 home basic support oracle 11g?
i am getting some error during installation.
I 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.
I 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 Relatedi want to create two databases with different sids on one oracle home.
how can ı handle it?
I 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 ?
after 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 RelatedSuppose 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.
APEX 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.
We'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 Related