Client Tools :: Similar To Oracle Reports Builder 6i?

Jul 14, 2011

Any good tool similar to Oracle reports builder 6i ?Which should be OPENSOURCE.

View 7 Replies


ADVERTISEMENT

Client Tools :: Oracle / Crystal Reports On Windows 7 64Bit Machine?

Feb 1, 2011

I recently got a new PC at work which is Windows 7 64 bit.

We run lots of crystal reports(1000's) that pull data from an oracle back end.

I have installed the Oracle Client 32 bit on this machine and have no problem connecting to the database and pulling back data.

However, when I use crystal to access the TNS Name it gives me the following error.

[URL]

My path variable on the PC has "C:oracleproduct10.2.0client_1BIN;".

I also tried to create and ODBC using the 32bit ODBC on the machine and that connects fine, but when you try to access the DSN from Crystal, I still get the 12154 error.

View 7 Replies View Related

Reports & Discoverer :: Use Graphic Builder To Make Chart In Report Builder?

Aug 10, 2010

i want to use Graphic builder for make a chart in report builder. how can i use them for create a chart report? i need to see some samples for create my project. put a sample of .OGD and .rdf

View 6 Replies View Related

Forms :: Oracle Builder Object Navigator Reports

Nov 16, 2011

I am using Oracle Forms Builder 6i. When you open it, in the navigator tree:

- Forms - MODULE - Reports

I want to know what is the purpose of REPORT section in the Forms Builder.

View 6 Replies View Related

Reports & Discoverer :: Oracle Report Builder 11g Stops When Destype Is File

Jul 9, 2013

In Oracle Report Builder 11g whenever i set destype to file report Builder Stops.

View 15 Replies View Related

Similar Table Structure Having Similar Indexes?

Sep 24, 2010

I do have problem with a table which have same structure of other table with indexes created being the same. Both tables have partions & subpartitions. Let us consider two tables table1 & table2. The problem i face is the index for table1 not being used when its being joined with other respective tables in a query. Whereas for table2 its working perfectly and cost is also less. I have used the explain plan and compared and query timing also takes more time. what might be causing it?

View 2 Replies View Related

Reports & Discoverer :: Convert Number From Arabic To English In Oracle Report Builder

Aug 5, 2011

how can convert number from Arabic to English in oracle report builder

View 2 Replies View Related

Client Tools :: Tools For Load Testing On Oracle - J2EE Application?

Jan 5, 2012

which are recommended Tool for load testing (for performance) on Oracle-J2EE, 3 Tier applications?

Is 'Oracle Application Test Suite' the best for such test where we can simulate numbers of users and their various actions?

Does it come with Oracle Database license or we have to buy it separately?

View 1 Replies View Related

Client Tools :: Basic Tools For Oracle Version Control

Aug 26, 2011

I'm looking for 3 simple things.

1) A reverse engineering tool that I can point to an Oracle schema and get a "baseline" script to re-create that schema from scratch, with decently formatted DDL files (1 per object) neatly organized in a directory tree (by object type) and called in the correct order. Icing on the cake would be an option to pass the tool a list of tables containing static data and get DMLs to populate (insert) those tables as part of the script.

2) a diff tool that I can point to a pair of Oracle instances (source and target) containing a given schema and get a "delta" script to alter the target schema so that it becomes identical to the source schema. If data loss occurs on the target instance (i.e. drop a column) I would like to find a warning comment inserted in the script (e.g. "-- Attention: data migration DML needed here?"). Icing on the cake would be an option to pass the tool a list of tables containing static data and get DMLs to update (delete, update and insert) the data in the target tables to become identical to the contents in the source tables *without* deleting and re-inserting all rows (or dropping, recreating and repopulating the table).

3) I would like the above two tools (that, as you will have recognized, are basic to putting your database design under version control) to be open-source, with a command-line interface and a vibrant community backing them.

View 9 Replies View Related

Client Tools :: Cannot Connect Using JDBC Oracle Thin Client With (New Method)?

Feb 21, 2013

The problem is that this connection errors when I try to connect using my SQuirreL client. My developers want to connecting using the SID or the SERVICE_NAME and by using the "New Method" syntax, not the "Old Method" syntax. According to the documentation the "New Method" syntax works with the SERVICE_NAME or the SID. The "Old Method" only works with the SID.

# Host name is vmwwin7634.na.SAS.com
# SID is sting2
# SERVICE_NAME is sting2.na.sas.com

PROBLEM using SID errors ==> jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521/sting2
THIS WORKS using SERVICE_NAME ==> jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521/sting2.na.sas.com

I am using SQuirreL Client version 3.4.0

# Here is the tnsnames.ora entry on the server.
STING2 =
(DESCRIPTION =

[code]...

# In this documentation it says, "On new syntax SERVICE may be a oracle service name or a SID."You can find this on the orafax wiki under JDBC#Thin_driver.

# I was able to connect with the "old method" using the SID only, SERVICE_NAME errors jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521:sting2.na.sas.com
(SQuirreL client error, "Unexpected Error occurred attempting to open an SQL connection.")
jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521:sting2 (this works)

# "New Method"
jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521/sting2.na.sas.com (this works)
jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521/sting2 (this errors)
(SQuirreL client error, "Unexpected Error occurred attempting to open an SQL connection.")

View 10 Replies View Related

Client Tools :: Can Use Oracle Client Version To Create A Database In That Server

Jan 13, 2011

can we use oracle client version to create a database in that server.

View 3 Replies View Related

Client Tools :: How To Connect From Client To Oracle Database In Unix

Dec 11, 2012

I have new virtual UNIX machine and I installed oracle client on /usr/lib/oracle. Also I have a oracle database and I am able to connect to this database from my desktop sql developer.

So now I am trying to connect from new UNIX machine. Where I created tnsnames.ora file under /usr/lib/oracle/network/admin and before connecting did export the following

export TNS_ADMIN=/usr/lib/oracle/network/admin
export ORACLE_HOME=/usr/lib/oracle/
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$PATH:$HOME/bin:/sbin:$ORACLE_HOME/bin
export ORACLE_SID=VFIODSD1

when I try

# sqlplus
username :xxxxxxx
password : xxxxxxx

ORA-12545: Connect failed because target host or object does not exist. Not sure what I missed here. using same tns file I am able to connect from sql developer on windows.

View 1 Replies View Related

Client Tools :: Oracle Client 32 Bit On Windows Server 2008 R2 64 Bit

Jul 20, 2012

Can i install Oracle 10g Client 32 bit on our Windows Server 2008 R2 64 bit?

View 1 Replies View Related

Client Tools :: Install Oracle To Get Latest SQL Plus Working On Client PC

Jul 11, 2012

I need to install Oracle client to get latest sql plus working on client pc as the problem is, i am not able to find out where i can download this , i just need the sql plus as i am not able use many commands because when i installed oracle forms 6i client tool , sql plus 8.0 got installed.

View 4 Replies View Related

Client Tools :: ODBC Instant Client Oracle 10g

Jun 28, 2010

The version is Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi. for Unix AIX 5

I install the ODBC Driver Manager, Basic Instant Client, ODBC Instant Client packages (libsqora.so, odbc_update_ini.sh).

The error:

[oracle@d4 oracle] $ isql OracleODBC-10g user passtemp -v
[01000][unixODBC][Driver Manager]Can't open lib '/home/oracle/instantclient_10_2/libsqora.so' : file not found
[ISQL]ERROR: Could not SQLConnect

Configuration

odbcinst.ini
[Oracle10gODBCdriver]
Description = Oracle ODBC driver for Oracle 10g
Driver = /u01/app/oracle/product/10.2.0/db_1/lib/libsqora.so
Setup =
FileUsage =
CPTimeout =
CPReuse =

The documentation explic with exists the file libsqora.so.10.1 but not exists in the ODBC Instant Client packages.

I applied ln -s libsqora.so.10.1 libsqora.so but the connection not function

odbc.ini
[oradns]
Application Attributes=T
Attributes=W
BatchAutocommitMode=IfAllSuccessful
CloseCursor=T
[code].......

View 1 Replies View Related

Reports & Discoverer :: Could Not Connect Reports Builder To Database

Jun 29, 2012

I could not connect the reports builder to the database. Im trying to connect it to the XE database. I checked the tns names and the hosts. Everything seems to be fine. But still when i try to connect the report it throws an error "ORA 12541- tns no listner"..

View 11 Replies View Related

Client Tools :: How To Connect To Oracle 7 Using Client

Dec 15, 2011

I have Oracle 7 database on Server1. I need to connect this using Oracle client from windows XP.

I have downloaded Oracle client 3.0 and when I am trying to connect it saying "Unable to connect: Unsupported Oracle version".

View 8 Replies View Related

Client Tools :: Identify Oracle Client

Oct 3, 2011

I would like to know if there is some specific file who identifies the installation of Oracle Client in some machine.

View 4 Replies View Related

Client Tools :: ORA-01034 - Oracle Not Available

Jul 13, 2013

I am trying to login to 10g sqlplus , gives below error:

ORA-01034:Oracle not available
ORA-27101-shared memory does not exist

View 23 Replies View Related

Client Tools :: Oracle 6i Application

Mar 13, 2011

i have oracle 10g db

and i make new application set on 6i

my question

on the client wt i should install developer 6i or there is client tool?

View 4 Replies View Related

Client Tools :: ORA-01034 / ORACLE Not Available

Mar 10, 2010

here is what I did actually...

C:>oradim -new -sid Test100 -srvc OracleServiceTest100 -startmode a -pfile 'c:oracleora92databaseinittest100.ora'
C:>orapwd file=c:oracleora92databasePWDtest100.ora password=sys entries=2
C:>set oracle_sid=test100
C:>sqlplus /nolog
SQL*Plus: Release 9.2.0.1.0 - Production on Wed Mar 10 22:42:43 2010
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> conn /as sysdba
ERROR:
ORA-01031: insufficient privileges

SQL> conn sys/sys as sysdba
Connected to an idle instance.
SQL> startup nomount
ORA-01031: insufficient privileges
SQL> @f:oracle estdb.sql
create database TEST100
*
ERROR at line 1:
ORA-01034: ORACLE not available

i just tried to set up a new database called Test100 manually.but i could not do anything here for these messages. my OS is winxp sp2.

View 9 Replies View Related

Reports & Discoverer :: WITH Clause In Report Builder

Jun 12, 2013

I'm trying to have RB use the following query:

WITH MY_DATASET
AS (SELECT /*+ materialize */
DISTINCT
N.NAME_ID NID,
NVL (TO_CHAR (RN.CONFIRMATION_NO), 'ACCOMPAGNATORE') CONF,
RN.RESV_NAME_ID,
MEV.TAX1_NO PARTITA_IVA,
[code]....

But although perfectly working in SQLDeveloper, RB returns an ORA-942 table does not exist error, pointing at MY_DATASET as the offending name.

View 8 Replies View Related

Reports & Discoverer :: Any Way To Pass Delimiter In Builder

Dec 15, 2010

I need to produce Excel spreadsheet from report builder.currently I am getting a format like,

ProductID;Count;CountUnique;
1001;12;16;
1002;11;6;
1004;16;666;
1006;60;86;

This format when opened in Excel does not group in separate columns resulting in all getting mixed up.I am looking a format like,

ProductID,Count,CountUnique,
1001,12,16,
1002,11,6,
1004,16,666,
1006,60,86,

This opens up clearly on excel. items like Product,Count are shown on separate columns along with the value.I am still looking into delimited formatting.

View 2 Replies View Related

Client Tools :: Migration From Postgresql To Oracle

May 31, 2010

I cant find any tools that can generate the DDL for all objects in Postgressql to migrate to oracle, I did sql developer however does not support postgresql, does any tool that can migrate postgresql to Oracle?

View 3 Replies View Related

Client Tools :: Oracle Connection To SQL Server

Mar 2, 2011

I am using dg4msql to connect to SQL server from Oracle(10.2.0.4, with AIX 5.3).

#from my laptop sqlplus (10.2.0.2)

SQL>select count(*) from table1@mssql; #works
SQL>select * from table1@mssql; #ERROR

ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Oracle][ODBC SQL Server Driver]String data, right truncation
{01004}[Oracle][ODBC SQL Server Driver]String data, right truncation {01004}

#from my laptop, TOAD
Both queries works fine.

i have compared

"select * from nls_session_parameters;" values , TOAD and sqlpus gives same result.

View 3 Replies View Related

Client Tools :: Installation Of Oracle 10g At Window 7 64 Bit?

Apr 3, 2012

can we install oracle 10g,developer 2000 at window7 64 bit

View 9 Replies View Related

Client Tools :: Oracle User Management

Oct 11, 2011

I'm looking for a basic password reset / unlock tool for use at a help desk. Environment is mixed 10 and 11G. Current procedure is log into specific database using SQL Plus and manually type out reset/unlock commands.

View 10 Replies View Related

Client Tools :: Oracle SQL Developer Connection

Feb 1, 2011

I have installed Oracle 11g R1 and have problem in connecting Oracle SQL Developer.

I have given user name: ora; pswd: ora.

In command prompt it works fine if I gave as below.
uid: ora as sysdba
pswd: ora

But when I am trying to connect to Oracle SQL Developer it says TNS listener does not know SID.

So I reinstalled this since i have doubt on myself whether I made mistake first time. Also I have doubt whether the un installation completely clears all the files from Registry. - What should I do to clear all the files from registry when un-installing.

1] What is SID. Is it session ID. If so how to find it.
2] Is there any way to confirm the values such HOST NAME: localhost, PORT: 1521, SID: (By default it has 'xe') which I gave for data base connection are correct.

I tried with SID value:135 (I got this value by executing [Select distinct sid from V$mystat;])

3] Is there any editor for practicing sql & pl sql queries. where I can download it.

View 6 Replies View Related

Client Tools :: To Move Oracle Job From One Database To Another

Jun 15, 2011

I want to move a oracle job from one database to another database. i tried to open the job from toad by pressing f4 on it in editor , im getting message like...

"unsupported type for describe popups (Without DB admin module)

View 2 Replies View Related

Client Tools :: TOAD Not Finding Oracle 11g?

Jul 2, 2013

I am running TOAD 10.6 on Windows 7 (64-bit). I have two 64-bit Oracle 11g clients installed (all on the same machine). The first is Instant Client (client_1); the second is the Runtime client (client_2). The installation of Instant Client was a mistake, since it doesn't have a Network / Admin folder to drop a tnsnames.ora file into. The Runtime client is my desired client, which has the aforementioned folder that I subsequently dropped the file into.

On starting TOAD, it says that "No valid Oracle Client found. Please note that Toad only supports 32 bit Oracle Client installations". (This is odd, since my colleague is running the same Oracle Runtime client as me and has TOAD 11.6, and yet his is working fine. But, this is aside the point.) When, I click on the ellipsis button next to the "Connecting Using" field, TOAD says that I don't have any Oracle homes installed. I checked my registry key (via regedit) under Computer / HKEY_LOCAL_MACHINE / SOFTWARE / ORACLE. It looks like I have 2 Oracle homes (because of the 2 clients).

Also, I right-clicked on My Computer and brought up Properties, Advanced system settings, Environment Variables (on the Advanced tab). My PATH variable has both of my clients.

How to make my available clients (particularly, my client_2) show up in TOAD?

Here is what I have tried thus far:

-Alter the PATH variable to just have client_2. This didn't do anything.

-Try to uninstall client_1 and client_2 via:

a) There is a Universal Installer under Oracle Installation Products in my Runtime client. I do Deinstall Products, click on any of my Oracle homes, click on Remove, and a Warning window pops up saying to run a command at some location, but the location is truncated since I can't expand the window.

b) In my client_2, there is a deinstall Windows Batch File in the deinstall folder. When I run this, the command window sits there for a little bit, saying that some files were copied and that 1 directory was removed. It then closes on its own. This doesn't seem to do anything.

View 1 Replies View Related







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