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
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
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
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
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
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
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
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
May 26, 2013
How to connect forms 6i with ms access.
View 1 Replies
View Related
Jun 24, 2013
How I can connect database on unix OS and windows what is the deference.
View 7 Replies
View Related
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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