Windows :: Connect Tow Server Of Same DataFile

Nov 10, 2010

I have Tow Virtual Servers (Connect As Cluster) in the Same Computer The Files In the Drive C Different (of the Tow Servers) And Others Like (e,f,q) The Same Files

And There is Database of both Servers That Have Same Name Let say orcl and both database Have same Schema let Say sch
How I can Share The Data when i am insert to table. in the schema sch in the server A i can see Same Data That I have Inserted In the Schema sch in the server B.

View 4 Replies


ADVERTISEMENT

OLE DB :: Connect Oracle DB In Windows 2003 Server From Linux Desktop

Aug 18, 2012

I have Oracle 9i DB in windows 2003 server, I want to access this DB from Linux desktop. Is there any 'client software' is available to connect Or procedure to connect the DB.

View 0 Replies View Related

Windows ODBC :: Connect To Oracle 9i From Windows 7?

Dec 20, 2012

Database: oracle 9i sitting on a 32 bit machine.
Client: windows7 64 bit computer
installed oracle 11gr2 client

Is there a way to connect to oracle 9i database from C:WindowsSysWow64odbcad32.exe on windows 7 machine? or what is the possible way to connect to Oracle 9i database?What we need is to run crystal reports from windows 7.

View 4 Replies View Related

Windows :: Connect Oracle From Win 7 64bit

Jun 22, 2013

Recently i have installed oracle 10g.2 in my laptop under Win-7 64bit. But cannot connect oracle from Windows form [C#], Office application[Excel] and odbc. Showing error[Tns could not resolve the connect identifier specified Drivers SQLSetconnectAttr failed ]

Though I can connect oracle from toad and sqlplus and form 6i.

View 17 Replies View Related

Windows XP SP3 And Oracle XE10.2g Connect

Aug 24, 2010

I am having a problem understanding the relationship between users and databases within Oracle. I have a user "big" that logs on successfully on another machine to database "s7s" but on a different machine fails to connect.
The following may be interesting:-

<?php
$SGMDBUsername = "big";
$SGMDBPassword = "big";
$SGMDBName = "s7s";
$conn=OCILogon($SGMDBUsername, $SGMDBPassword, $SGMDBName);
[code].......

If I on the new machine issue the command sqlplus big/big. I successfully connect and see the tables I am looking for.

View 12 Replies View Related

Windows / .NET :: Unable To Connect Database From SQL Dev

Nov 21, 2012

Am getting the following error while connecting db from sql dev "network adapter could not establish connection vendor code 20"

FYI - database is up and running fine in sqlplus, and am not able to find the service in lnsrctl. As am using OIM db as service name while its showing CLRExtProc.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Prod
ction
Start Date 21-NOV-2012 20:28:48
Uptime 0 days 0 hr. 27 min. 32 sec
Trace Level off
[code].....

View 2 Replies View Related

Windows :: Connect To 8i Database Via Oracle 9.02 ODBC

Sep 17, 2002

I am attempting to connect to an Oracle 8i database via the Oracle 9.02 ODBC driver and I am receiving the following error message upon testing the connection in WinXp's ODBC Data Source Administrator dialog box: "Unable to connect SQLState=IM004 [[Microsoft]][[ODBC Driver Manager]] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed" .

I am running Oracle Client 9.2 on a P4 machine running winXP.

View 28 Replies View Related

Windows :: Unable To Connect SQLState IM004

Jan 10, 2007

I installed 10.2 client on Windows 2000 Terminal Server. I created the system dsn odbc connection. When connected to the terminal server via RDP as a domain administrator, the odbc connection functions appropriately. When connected to the terminal server console as a standard user, the odbc connection functions appropriately.When connected to the terminal server via RDP as a standard user, I get the error: "Unable to connect SQLState= IM004 [[Microsoft]][[ODBC Driver Manager]] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed"

I have reviewed the numerous other posts regarding this error and I've executed the following recommendations: My oracle_home is defined first in my path environment variable (path - c:oracleclientin;). I select my folder options (there is no security tab, windows 2000) I select sharing, then permissions. I allow 'Everyone' and 'Authenticated Users' full control, change & read permissions. I reboot the server.

View 4 Replies View Related

Windows :: Connect Forms 6i With MS Access Database

May 26, 2013

How to connect forms 6i with ms access.

View 1 Replies View Related

Client Tools :: Connect Database On Unix And Windows

Jun 24, 2013

How I can connect database on unix OS and windows what is the deference.

View 7 Replies View Related

Can Application Connect With Windows Authentication To Oracle 11.2.0.3 Database

Jul 16, 2013

Can application connect with windows authentication to oracle 11.2.0.3 database? if so then how can i set it up! 

View 3 Replies View Related

Windows / .NET :: Procedure To Connect To Oracle Database From MS Access?

Nov 29, 2012

let me know the procedure to connect to Oracle Database from Ms-Access.

We are using Windows as Operating System.

View 1 Replies View Related

Windows / .NET :: Oracle ODBC Drive In Linux Client To Connect With Mono Application

Aug 6, 2012

I am creating a cross platform database application using Mono. It uses oracle database as back end. I used ODBC drive to connecting database. I can connect to database using this following connection string in my windows machine

Driver={Oracle in OraDb11g_home1};Server=localhost;Uid=system;Pwd=manager

For Linux I uses Linux Oracle OS for Database server. I installed oracle client in my fedora OS. and cofigure the client using net cofiguration assistant tool with oracle client. client connection working OK. Then I try to connect with my mono application using the following connection string

Driver={Oracle ODBD Drive};Server=orcl;Uid=system;Pwd=manager

but the above connection string not worked.I am using Oracle 11g version. Do I need to install any other ODBC driver to access oracle database

View 1 Replies View Related

Server Administration :: How To Drop Datafile

May 25, 2012

I can not drop datafile in a tablespace, how can i do?

SQL> Alter Database Datafile '/u02/app/oracle/oradata/oracl/hxl06.dbf'
Offline 2
3 /

Database altered.

SQL> Alter Tablespace tps_hxl
Drop Datafile '/u02/app/oracle/oradata/oracl/hxl06.dbf'; 2
Alter Tablespace tps_hxl
*
ERROR at line 1:
ORA-03264: cannot drop offline datafile of locally managed tablespace

View 5 Replies View Related

Server Administration :: How To Drop A Datafile

Dec 31, 2011

How to drop a datafile of tablespace.

SQL> alter database datafile '/u01/app/oracle/oradata/oracl/hxl01.dbf' offline drop;

Database altered.The command success,but the dic view show the datafile also.

SQL> select file_name,tablespace_name from dba_data_files;
FILE_NAME TABLESPACE_NAME
--------------------------------------------- ------------------------------
/u01/app/oracle/oradata/oracl/users01.dbf USERS
/u01/app/oracle/oradata/oracl/sysaux01.dbf SYSAUX
/u01/app/oracle/oradata/oracl/undotbs01.dbf UNDOTBS1
/u01/app/oracle/oradata/oracl/system01.dbf SYSTEM
/u01/app/oracle/oradata/oracl/hxl02.dbf TPS_TEST
/u01/app/oracle/oradata/oracl/hxl01.dbf TPS_TEST
6 rows selected.

View 5 Replies View Related

Server Administration :: Duplicate Datafile Name

Feb 29, 2012

I have oracle 10g running on Solaris with file system and some one created database files with same name but in different directories for example data01.dbf in two different directories, say /u01/oradata/data01.dbf and /u02/oradata/data01.dbf. Now, I want to find out the duplicate datafiles (data01.dbf in this case) sitting in different directories, is there anyway to find this out?

View 11 Replies View Related

Server Administration :: Resize Datafile

Mar 21, 2011

Today i am facing an error when going to rezise the datafile its fixed size is 19000M abut after truncating all tables it is 112M, but when i am going to resize its datafile to 500M its get me an error ora-03297 file contain used data beyond requested size values.

I have done the same before a week without any error.But this time i got the error

View 5 Replies View Related

Server Administration :: Move Datafile To Another Tablespace

Feb 16, 2012

Erroneously created datafile, re: "/path/../large_rbs_03.dbf" was created under the SYSTEM tablespace which is supposedly be in the LARGE_RBS tablespace.

How do I make the said datafile be under LARGE_RBS?

View 3 Replies View Related

Server Utilities :: CSV File As Datafile In SQL Loader

Sep 5, 2010

1) can we use a CSV file as a Data file in any format (fixed, delimited...) of Sql loader. I tried, but not succeeded.

2) if not then tell me the reason for it....

3) Also tell me is there any restriction on using the file format for a datafile?

View 18 Replies View Related

Server Administration :: ORA-01157 / Cannot Identify Datafile 1

Jun 28, 2010

I have a database of branch A whose files are located in E: Drive. I want to download it in branch B.I placed all the files of Branch A in D: Drive of Branch B. When i start the database i was getting controlfle error. I made required corrections in initorcl.ora. Now when i start the Database,its mounted, but I am getting ORA-01157: Cannot identify datafile 1. I tried to rename the file, but the "alter database rename file1 to file2;" option is not working.

View 3 Replies View Related

Server Administration :: When Did A Datafile Auto-extend

Dec 21, 2010

Is there a way to find out when a datafile for an undo tablespace with autoextend enabled actually extended? I've done a few tests, and nothing is written to the alert log or any trace file that I've found. I can't find any V$ or DBA view that will give me the history of a file's size.

View 5 Replies View Related

Server Utilities :: Imp / Exp - Max Size Assigned To Datafile?

Jul 22, 2010

i have exp dump of size 1gb but when i tried to imp ,it showing error of space , it asking for space of 4gb. But i have 1gb on c: drive and 32gb on d: ,can i add datafile on d: locaion and what is max size i can assign to that datafile .

View 4 Replies View Related

Server Administration :: How To Find When The Datafile Was Resized

Jan 17, 2012

We need to find when any datafile was resized ( if at all)in a tablespace. Actually, by noting the created date from v$datafile , we used to know the data growth in a tablespace. Now as the number of datafiles have increased, we want to resize them. This diagnostinc have to be done without changing/adding anything in DB.

View 12 Replies View Related

Server Utilities :: Terminators And Datafile Of Sql Loader?

Jan 28, 2011

below query:

1) What are the terminators we can use and cant be used, except ','. eg - '|' - this shows error.

2) What are the file format can be used in DATAFILE other than txt file. Eg - excel, word... And how to terminate the values in that files...

View 3 Replies View Related

Windows :: Installing 10g Database Software On Windows 2008 Server?

Sep 28, 2010

I've tried to install Oracle 10gR2 (10.2.0.4.0) on Windows server 2008 (64 bit). I just click on installer and a message appears:

Checking Operating system version: must be 5.0,5.1,5.2 or 6.0

Actual 6.1

FAILED <<<<

Exiting Oracle Universal Installer

Press any key to Exit.

View 12 Replies View Related

Server Administration :: Move File System Datafile To ASM

Oct 23, 2012

I mistakenly added a datafile to a tablespace which is asm, however the datafile was created in a default location and not the asm location:

alter tablespace pdaiidata1 add datafile '<filename>' size 2048M;

What I should have done:

alter tablepsace <tablespace_name> add datafile '+DATA1' size 2048M;

Is there any way to move this filesystem datafile into the asm tablespace? In previous Oracle versions, I've taken a tablespace offline, moved a datafile, renamed it, then brought the tablespace back online. Can I do something similar here in this situation?

View 4 Replies View Related

Server Administration :: Trying To Change Tablespace And Datafile Properties On Fly

Aug 21, 2011

This facility has one last 10g database and a very problematic tablespace and last datafile associated with it. The tablespace was set up with INITIAL_ EXTENT of 131,072 (128K) instead of the more 'normal' 4,194,304 (4M) and NEXT_EXTENT of 262,144 (256K) instead of 4,194,304 (4M).

More worryingly, the datafile has INCREMENT_BY set to 1 (8K) instead of 1,280 (10M) or 2,048 (16M).Has anyone ever updated sys.ts$.dflinit and sys.ts$. dflincr to modify the INITIAL_EXTENT and NEXT_EXTENT, and sys.file$.inc to modify the INCREMENT_BY?

View 7 Replies View Related

Server Administration :: Renaming Datafile - Change Name In OS Level Also

Nov 3, 2012

While renaming the datafile.

1) ALTER TABLESPACE .... OFFLINE;

2) CHANGING THE DATAFILE NAME IN OS LEVEL;

3) ALTER TABLESPACE .... RENAME DATAFILE 'FILE_OLD' TO 'FILE_NEW';

4) ALTER TABLESPACE .... ONLINE;

In the above steps, I HAD FORGOTTON TO FOLLOW THE 2ND STEP.

At the step of 3rd, i got error message, now i am not able to change the name in OS level Also.

View 19 Replies View Related

Server Administration :: How To Offline Datafile In No Archive Mode

Oct 31, 2011

I want to drop a datafile in my test db which is in no archive mode,at first, i want to offline the datafile,but it failed,is there any way to do it?

SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 3237
[code].......

View 8 Replies View Related

Server Utilities :: Added A Datafile In Undo Tablespace

Apr 28, 2011

When I am importing, I get these errors

IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (XXXXXXXXXXXXXXXX) violated
Column 1 2
Column 2 OFFLINE
[code]....

I added a datafile in undo tablespace (its an ASM database). I doubt that since I added the datafile to undo tablespace, I am getting this error.

View -1 Replies View Related







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