need to know how to connect remote database (ie my office oracle database) from my personal laptop. Using TOAD Software. me with the step by step procedure, and what software's I have to download.
View 26 RepliesI am trying to import a dump into my oracle 10.2.0.3.0 database on my win 7 professional laptop. The dump is exported from my win xp desktop pc running Oracle 10.2.0.1.0
Below is the error i get:
Import: Release 10.2.0.3.0 - Production on Fri Nov 12 15:57:52 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Username: system/password@orcl
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
Import file: EXPDAT.DMP > F:PersonalDPISIMBA.dmp
Enter insert buffer size (minimum is 8192) 30720>
Export file created by EXPORT:V10.02.01 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
List contents of import file only (yes/no): no >
Ignore create error due to object existence (yes/no): no >
Import grants (yes/no): yes >
Import table data (yes/no): yes >
Import entire export file (yes/no): no >
Username:paymaster
Enter table<T> or partition<T:P> names. NULL list means all tables for user
Enter table<T> or partition<T:P> name or . if done:
when I press enter key, the console hangs and a window appears with "Console Window Host has stopped working" then the console closes prematurely.
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.
I was considering a solution to maintain a replicated copy of a database in a remote office. However we are using SE One edition of oracle, so native support for dataguard is not available. There definitely should be some scripting solutions for this task, but I can't find any to date.
View 7 Replies View RelatedI would like to develop a system with Oracle 9i as the database and PHP 4/5 as the front end. I am not able to establish the connectivity to the database. What should I do now ?
View 3 Replies View RelatedWe have a requirement to connect from 9.2.0.8 database on AIX to MS SQL 2008R2 .
Source :
----------
Oracle : 9.2.0.8 (64 bit)
OS : AIX - 4.3.3.0/5.3.0.0 (64-bit)
Target :
----------
MS SQL : 2008R2
OS : Windows 2008 (64-bit)
1] Can we use - Database Gateway for SQL Server for the above set up ? If so , does this require a separate license ?
2] Where Do we need to install the "Database Gateway for SQL Server " -- soruce or target server ?
3] Is there any other solution apart from using "Database Gateway for SQL Server " ?
we have a database available in UNIX machine A which can be connected from client in UNIX machine B through port 1521.
If we give ping command from UNIX machine A to B or B to A, 0% packet loss, means connection established properly through firewall in port 1521.
Now we are setup one more UNIX machine C and installed a client here. This machine is available in different group, means if i give ping command from machine C to A, 100% packet loss. But from machine A to C, connection established with 0% packet loss.Because of this, when we tried to connect to a database from client in Machine C to database in Machine A, we got "time out" error.
My query is:
1. Is this because of not opening of port 1521 through firewall?
2. If so, is it enough to open port 1521 through firewall when we connect from machine C to A?
3. Any additional setup is required in firewall apart from opening of ports?
Environment:
Oracle 11.2.0.3
UNIX AIX 5.3/6.1
I am having a application which is on Widows NT Operating system.I am using Oracle 10g Database, Developer suite 10g And 10g Application server.
My application uses Run_report_object to generate reports.Run_Report_Object is called in forms and Report server is configured in the same Application server where FMX are placed.
The report generation was working fine as long as oracle default login was used. When i created a form to handle login on my own, Report server is throwing "Unable to connect to database" error. My login forms takes the parameters from user and calls default logon command in on_Logon trigger.
I have installed unixodbc 2.3.1, postgres odbc driver (psqlodbc-07.03) and dg4odbc 11.2..On querying : select sysdate from dual@dblink_postgresql, the following error occurs:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[unixODBC][Driver Manager]Can't open lib '/oracle/psqlodbc/lib/libpsqlodbc.a' : file not found {01000}
ORA-02063: preceding 2 lines from DBLINK_POSTGRES
Similar error appears in the trace file as well.
[unixODBC][Driver Manager]Can't open lib '/oracle/psqlodbc/lib/libpsqlodbc.a'
$ isql -v postgresql postgres postgres@2012
[01000][unixODBC][Driver Manager]Can't open lib '/oracle/psqlodbc/lib/libpsqlodbc.a' : file not found
[ISQL]ERROR: Could not SQLConnect
However the file is present in the location and has no permission related problems.
$ pwd
/oracle/psqlodbc/lib
$ ls -lrt
total 2952
-rwxr-xr-x 1 oracle oinstall 663 Mar 25 15:28 psqlodbc.la
-rw-r--r-- 1 oracle oinstall 731419 Mar 25 15:28 libpsqlodbc.a
-rw-r--r-- 1 oracle oinstall 12215 Mar 25 22:11 win_md5.o
-rw-r--r-- 1 oracle oinstall 18100 Mar 25 22:11 options.o
[code]....
I am using oracle 11g express edition and MY Sql database How to establish database link between them using ODBC gateway. I am using ODBC gateway Mysqlodbc connector.
View 1 Replies View Relatedi developed my system at my laptop and it works well...i installed a windows server 2008 at another pc (as a server for testing)..and i run the application on the other pc (windows server 2008) and it works well...
my Qs. is:
how can i run the application in other pc from my laptop...i make a configre on the other pc (as server pc), and i run the oc4j on it, the link is:[URL]...
but nothing happend (Internet Explorer cannot display the webpage)...
Is it possible to install and execute Developer 2000 in a laptop using windows 7 64 bits?
View 1 Replies View RelatedI'm using Oracle10.0 as database for my project and I have installed Toad as front end tool for the Oracle. Now I want to access the database in the network using the Toad.
My question is, is it compulsory that oracle should be installed in every system to access Toad or any thing can I change in the server system to access the database from other systems in the Network.
how to connect to sql server databases via toad. I have used toad to connect to oracle databases, but never to a sql server database. To connect to an oracle database, we first install the client and then add the tnsentry of the database to the tnsnames.ora file and then we can directly connect to the oracle database right?So I was wondering if there are any steps like that to be followed to connect to the sql server databases.
View 2 Replies View RelatedWe plan to migrate the databases to Oracle 10gR2 from Oracle 9i. know whether Toad 8.5 works fine with Oracle 10gR2 or not?
View 4 Replies View Relatedthere is a problem , related to toad. when i try to connect with my database through toad then it throws an error-"Can't initialize OCI. Error -1", how to sort out of this problem. and i am using toad 9.2.7.1 on widows server2008.
View 9 Replies View RelatedMy primary objective was to compare objects in schemas in two different databases and find out the differences, Execute DDL's in the database where objects are missing and syn schemas in two different databases. So I need to compare schemas in databases. make a comparison of database objects existing in schemas in two different databases. I'd like to see if I can get a list of pro and cons between Toad and SQL Developer for comparing schemas pros and cons. navigation in SQL Developer to compare schemas.
Connect to Source
Connect to Target
Compare schemas with different object types
Find out differences
Generate DDL's for the missing objects or for the objects in difference report
Run them in missing instace(Source/Target)
Make sure both are in sync.
want to load data from an excel file to a database table in Oracle. I am using Oracle 11 and the excel file has 3 columns as compared to 5 columns in the destination table. I want to generate sequential nos also for the table.
View 7 Replies View RelatedI was handed a folder that consists of all the files (Datafiles, controlfiles,spfiles, backupsets etc) for a database. The SID is Oracle.
So now I have two options:
1. Attach the Datafiles
2. Restoring the Database with the Backupsets.
Option 1:I tried with working with the control files but didnt get anywhere because I did not understand how to attach the datafiles (I tried modifying the control file, to no avail).
I tried replacing the spfiles and pfile then copying the datafiles (replacing the existing ones)...but I could not create the control file as well...
Option 2:I do not know how to make RMAN see the backupsets of the Old database; despite they are in the same location as those of the new database.
Are there any good information about on how to move a 10g database to a new server? We will keep the same disks on the SAN, but make a new installation on the new server.
View 3 Replies View RelatedI want a copy of data from oracle database in Production to my local machine as upgrade is going to be there soon. How can I do that so that I may check my old data later irrespective of upgrade?
View 9 Replies View RelatedI download a pdf file,but I want to use it in the office word,who knows how to convert it?
View 11 Replies View RelatedI need a query to display the office and count(*)
where rownum > 6 i.e
here is the data
office
------
hq
hq
hq
hq
hq
hq1
hq1
[code]....
I need a query to display the top 3 counts and the 4 row should be sum of count of other offices.
my result should look like this
office count(*)
--------- --------
hq 5
hq1 4
hq2 3
other 10
I am trying to read/write Open Office scalc.exe(which is replacement of Excel file) file using DDE Package as like Excel File. But it is giving me non oracle Exception Error when it focused or initiate.
View 2 Replies View RelatedI am trying to export data into excel (office 2007 and above- .xlsx) using the calls mentioned below, but i am getting an error. i am able to upload data and open the document in IE succesfully using office 2003 format(.xls)
The following are the calls made in the package and it works for .xls format
OWA_UTIL.MIME_HEADER('application/vnd.ms-excel');
The following are the calls made in the package and it is not working even thow i can see that the document getting opened .xlsx format
OWA_UTIL.MIME_HEADER('application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
And i alos added the call in the httpd.conf file in Apache/windows server 2003
AddType application/vnd.openxmlformats .docx .pptx .xlsx
The MS Office 'NETWORK DAYS' function allows you to subtract one date from another and return the number of 'workdays' between them. So it ignores Sat & Sun. There is an additional parameter that allows you to ignore holidays as well.
I'd like to subtract a 'Request Date' from SYSDATE and get just the number of 'workdays'.
How to Print Customer Copy / Office Copy in rports 6i for example i want to print two copies of any report i want that on first copy of report shows CUSTOMER COPY and second copy of shows OFFICE COPY and report may be on multiple pages.
View 1 Replies View Related I have this pdf (2 Volumes) from Oracle University courses, "Oracle Fusion Middleware 11g: Build Applications with Oracle Forms" In order to read the examples you must have "Summit Office Supply Schema" fmbs, mmb, pll, tables.(dmp)
indicatively some tables (not confuse it with other summit user)
customers,
departments,
warehouses,
orders,
employees,
order_items,
product_information,
inventories
I m trying to open Report in Microsoft Office Excel format with below code.
declare
v_report_nameVARCHAR2(100) := 'F:IrfanNewReportsCurrency.rdf';
v_formatVARCHAR2(12):= 'SPREADSHEET';
begin
Web.Show_Document([URL]......);
end;
when my report run I received one message window File download after that this below error window appear & data can't show in proper format.
What are the steps required to change an ORACLE stored procedure (on a AIX/UNIX machine) using OTG to connect to a DB2 database, to an ORACLE stored procedure that uses ODBC or JDBC connectivity?
All I need to do in the stored procedure is a simple insert statement into a DB2 table.
What kind of ODBC/JDBC driver do I need on the UNIX machine? unixODBC?
What would be different in the ORACLE stored procedure for it to use ODBC connectivity rather than OTG.