Server Administration :: Create Two Databases With Different Sides On One Oracle Home?

Jun 8, 2010

i want to create two databases with different sids on one oracle home.

how can ı handle it?

View 2 Replies


ADVERTISEMENT

Server Administration :: Install Oracle 10g In Windows 7 Home Premium

Feb 20, 2010

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 Related

Server Administration :: Migrate Two Different Databases To Oracle?

Jul 11, 2012

I have to migrate two different databases to oracle.i have made two Migration Repository for each to do the migration, migration is done.but i would like to know can it be done with one migration repository.if yes then with one is best way to do it.data of two databases is different but table and sp are 99% same.

View 3 Replies View Related

Server Administration :: Change Character Set For Oracle 8i Databases?

Aug 15, 2013

How to change Character set for oracle 8i database. Is there anyway to change the Character set without affecting the current database.

View 11 Replies View Related

Server Administration :: How To Install Oracle 8i And 9i Databases On Same Server

Feb 20, 2011

How to install oracle 8i and 9i databases on same server for example i want that both type of databases run on same server.

View 7 Replies View Related

Server Administration :: Multiple 11g Databases

Dec 5, 2010

I have Oracle 11g installed on AIX and I want to install another 11gR2 single instance in a different oracle home, will it be possible?

View 3 Replies View Related

Server Administration :: How To Know Currently Running Databases In Single Server

Jul 30, 2010

I have installed three database in MY Linux server. I have started Instance for all database and started database also .

No I want to check my databases status or currently running database How can I know . Or which Dynamic View or Database dictionary I should use ?

View 2 Replies View Related

Oracle Database Server / Client Connection Settings Between Office And Home

Jul 3, 2010

Suppose 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.

View 5 Replies View Related

Server Administration :: Identifying Two Databases Involved In Distributed Transaction?

Oct 24, 2013

I am on Oracle 11.2.0.3 on Linux. In my production database, I am getting this alert, in the alert log:

--the below two lines are from alert log.
Error 604
trapped in 2PC on transaction 50.73.546578. Cleaning up.

--query from a data dictionary view
SQL> select count(*) from DBA_2PC_PENDING;
COUNT(*)
----------
1

When I query the production database I see that there is one row in the DBA_2PC_PENDING view. But I dont' know how to identify which are the databases that are involved in this distributed transaction. That is my first issue - how to identify which are the two databases that are involved in the distributed transaction?

View 10 Replies View Related

Server Administration :: Modified Objects - Compare Two Users On Different Databases

Oct 2, 2012

I want to compare two users on different databases, actaully there are two users one in user a on database a and another user b on database b they have same tables, and everytime when a table or object is created on user a (database a) i will take the table name ,procedure or any other object from user_objects based on ddl_created date and then i need to recreate the same on user b on database b, is there a way to find out tables which are not only created but also i need to check whether if there is any column added or any change in procedure or any other objects.Is there a way to generate the scripts based on list of objects selected from user_objects.
all i want is.

a)Find out the list of objects added along with creation scripts
b)find out the list of objects modified along with creation scripts.

View 2 Replies View Related

Server Administration :: How To Create A Database (Oracle 10g)

Jul 6, 2012

How to create own database in oracle 10g. I want to create new database in oracle.

View 10 Replies View Related

Networking And Gateways :: Maintaining Single Listener In Multi-instance Database Server With 3 Different Oracle Home

Sep 29, 2011

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

Server Administration :: How To Create Best Profile For Huge User In Oracle Database

Mar 5, 2013

how to create best profile for huge user in oracle database user which take lagre uga memory.

View 5 Replies View Related

Server Administration :: Create / Drop User / Schema In Another Oracle Database Through Apex

Jul 7, 2012

Through an Oracle Apex application I need to create/drop a user/schema in another Oracle database. i.e., create/drop user remotely using an Oracle Apex application.

View 12 Replies View Related

List Exiting Databases In Oracle Server Using SQL Plus Command?

Feb 14, 2013

I am using Oracle database server and I want to show existing databases on that server. Are there any SQL plus command to list all databases there in the server?

View 1 Replies View Related

SQL & PL/SQL :: Indexes With Wild Card At Both Sides?

Sep 2, 2010

optimising the below query ....

SELECT
CBU_CD,
MKTG_SUB_SEGMENT_A_NM,
BILLG_SYSTEM_ID,
BILLG_ACCT_NO,

[code]...

View 3 Replies View Related

SQL & PL/SQL :: Create Stored Procedure Where Tables Of Two Different Databases Are To Be Used?

Feb 22, 2012

I want to create a stored procedure where tables of two different databases are to be used.

View 4 Replies View Related

Server Administration :: Create Tablespace For Administration

Nov 29, 2010

i'm a student currently learning database administration security.

I need to create a tablespace for administration of database but i don't know what datafile settings are best suited for admin usage.

I have attached the schema that was given to me for this assignment.

View 12 Replies View Related

Same Home For ASM / Oracle

Dec 17, 2010

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 Related

Server Administration :: Create Multiple Database In Single Server

Apr 18, 2011

I have database in single server. I already have ORACLE_SID=stagedb. So i want to create new sid and named as proddb.Is it possible have multiple db in single server? This server not running as RAC. It run as single only.

View 1 Replies View Related

11g - Change ORACLE Home?

Aug 30, 2011

i have requirement to change the oracle home from /u04/....../dbhome_2 to /u03/...../dbhome_4

DB=11g
application version=R12.

View 1 Replies View Related

Oracle 11.2.0.1.0 Oradiag_oracle $HOME

Sep 13, 2010

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.

View 2 Replies View Related

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.

View 1 Replies View Related

Upgrade :: DBUA On Cloned Oracle Home

May 1, 2013

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.

View 4 Replies View Related

11g Database - Opatch Can't Find Oracle Home

Jul 15, 2011

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.

View 3 Replies View Related

Server Administration :: How To Use LV To Create ASM Disk

Jul 27, 2012

How can use the LV to create a ASM disk in Red Hat Linux As 5

#lvcreate -n lv01 -L 200g myvg

View 3 Replies View Related

Server Administration :: How To Create Db_link

Mar 16, 2012

if i set the global_names to True, how to create a db link to another machine?

SQL> select * from global_name;

GLOBAL_NAME
------------------------------------------------------
LNK_62

SQL> show parameters global_name;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
global_names boolean TRUE

View 2 Replies View Related

RAC & Failsafe :: Multiple Oracle Home Machine On Two Node ENV?

Mar 6, 2012

I 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.

View 1 Replies View Related

While Applying Patches In Oracle Home Space Not Sufficient

Mar 18, 2011

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 Related

Installation :: Does Windows 7 Home Basic Support Oracle 11g

Jun 7, 2012

Does windows 7 home basic support oracle 11g?

i am getting some error during installation.

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved