Discoverer Desktop - Installed Software - Cannot Login?

Apr 27, 2012

.I am trying to install Discoverer Desktop 9.0.4 on a windows 7 x86 machine. I know the product is obsolete, but this is only temporary as we transition to a new platform.

I am able to install the software just fine; what I cannot do is log in. I keep getting

Unable to connect to: discov_user@op012
Failed to connect to database - ORA-02248: invalid option for ALTER SESSION

The NLS_LANG for the database is at AMERICAN.AMERICA.WE8MSWIN1252
I have set it on the client to match
I have deleted it from the registries
I have created a system variable

Nothing works. I know the tnsnames.ora file is correct as the exact same load works fine on a XP machine.

View 6 Replies


ADVERTISEMENT

Forms :: Modifying Form On UNIX Server Using Builder Installed On Windows Desktop

May 20, 2010

We are using Oracle Applications hosed on UNIX servers. There is a custom form in XXX_TOP/forms/US folder that I need to modify.

My Windows desktop has Forms Builder 10g installed. I ft pied fmb file over from UNIX server to my Windows desktop and tried opening it. I get an error FRM-18108:

Failed to load the following objects: APPSTAND, etc etc.

Obviously I am not doing it right. What is the correct way of modifying a form file sitting on UNIX server, using Forms Builder installed on Windows desktop? Do I need to copy all dependent objects to Windows desktop along with fmb file?

View 2 Replies View Related

Oracle Installed In Workgroup - Not Able To Login Database

Oct 15, 2011

I am new in oracle I have installed Oracle in work group, while i work group it is working fine. But latter I have change the server from work group to domain. At that time Oracle was not working , not able to connect.

After that I change the Domain to work group again. And same problem exist. But I found that lsnrctl is working fine. But OracleServiceXXX is not able to startup in services.msc

View 1 Replies View Related

Reports & Discoverer :: Create Password In Oracle Desktop

Oct 16, 2010

How user can change password in oracle discoverer desktop ?

View 1 Replies View Related

Reports & Discoverer :: How To Change Database Login At Runtime

Feb 15, 2011

I want to change database login in report at runtime.

For Example. I have created and run a menu by using database login "ABC/xxx" and want to run a report through this menu directly (Without using form) by different data base login i.e "xyz/ddd".

what is the sol. except passing user id at report call i.e rwrun60 parameter.

View 1 Replies View Related

Restrict User To Login On Primary Database Using Discoverer

Dec 14, 2012

We are using Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 and Oracle Discoverer 9i desktop & Administrator,We have configured a physical standby database. We have ask users to connect to standby thru discoverer thru a different tns entry, but user can also connect on primary db.

We want to restrict the specified users to connect on primary database thru discoverer.

View 5 Replies View Related

Capture Login Of Terminal In Audit Trail When Login Through Grid?

May 15, 2013

I am trying to understand how to enable some audit so we can capture OEM logins as well.

Here is my setup. Lets say my DB that i am auditing is called audit_db (audit trail set to DB) sitting on host called host_db. and we have grid control agent on this box.now my grid control is as this. Lets say my OMS and repository is on host called OMS_host.

we run query aginst dba_audit_session to get info as to who tried failed login attemps and stuff.

Now to the part that is not working.

-- this is the good part When i intentionaly login to the audit_db with sqlplus client from my laptop with wrong username/password that is captured. we get the username,os_username,userhost,terminal.

here is the sample output

username is the wrong user that i tried to login as
os_username is the my local username(ad account)
userhost is my_laptop_name
terminal is laptop_name

from above we can figure who was trying to login(failed).

-- this is the bad part But lets say i try to login to audit_db through grid control and use wrong username/password.that gets captured too(but not all of it). we get the username,os_username,userhost,terminal.

here is the sample output

username is the wrong user that i tried to login as
os_username is the user of OMS repository db(oracle)
userhost is oms_host
terminal is unknown

Now with the above info, we cannot figure out who tried to login with bad login credential.

View 8 Replies View Related

Forms :: Pop-up Or Alert On Desktop?

Nov 10, 2012

i am using .dot net frame work to show a pop up on desktop like reminder , can i do that using any oracle tools i am using oracle 10g along with forms 6i , i am using one query for this.

View 4 Replies View Related

Application Express :: Ext JS Desktop Integration

Sep 18, 2012

It's possible to use Ext JS Desktop in apex . I put it in simple application ... what's the next step ?

[URL]..........

user:maie
password:123

View 6 Replies View Related

Client Tools :: How To Activate Desktop Panel

May 14, 2010

Desktop panel is not activated in toad... i.e. i am not able to execute editor script .

View 1 Replies View Related

Forms :: Test Custom Jar Files With 6i From Desktop?

Dec 18, 2010

I want to test custom Jar files with Forms 6i from my desktop, but I cannot get the Run Form->Web to work. Is it possible for the run time to load the just jars for PJC when you do Run Form -> Client/Server? So far, when I have done this, it does not execute any PJC.

View 2 Replies View Related

Forms :: Tracking Remote Desktop Access Using Oracle?

Sep 27, 2013

I have a form developed using Oracle 10g Forms Builder. It is deployed on server. I need to track who is remotely accessing the desktop and running this form. How can we track this. Are there any webutil commands to trace the application used to access the desktop? What is the work around for this?

View 2 Replies View Related

RAC & Failsafe :: Create Shared File System Between Two Desktop PC?

May 14, 2013

We are setting RAC between two machines(Desktop PC connected wirth LAN ....have storage Local to them and no Shared storage..Only NFS).We have shared the mount point by NFS.We do not have any shared storage but we need to share the RAW files to setup the OCR and VOTING DISKS.

The problem is:

1. We need to keep the RAW devices for OCR and voting disk common to the machines (Desktop PC..both Linux OELU5). I am able to create the raw file systems but that is local to one machine. I am not able to understand how to share the raw devices between two machines.

2. Tried to use ISCSI utility but that did not work. (How_to_use_iSCSI_Targets_on_Linux)

Scenario : One Machine has 500 GB Storage. Second machine has 80 GB Storage. Made private and public networks(Used two Network cards in LAN). All are communicating.

Problem : Need to make the storage 300GB (Out of 500 GB) of Machine 1 as shared storage. How can we do that? (Do we need any virtual software...ex .. vmware for that?)

View 3 Replies View Related

Application Express :: Creating App That Works On Both Desktop And Mobile?

Nov 14, 2012

I know that there is now an option in the shared components to set the home page/theme for Desktop display as well as for Mobile display. So the app would automatically know what interface should be rendered based on the device running on. Do I need two versions of each app page (just like the login page) in order to have the app work on BOTH desktop and Mobile ? the reason I am asking is that an AEPX page can have one and only one template/theme. So if I have an app (desktop app) of 10 pages , should I replicate those 10 pages and make them mobile pages. If yes then how do I tell the to navigate differently (branch from page to page) based on the used device ?

View 3 Replies View Related

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

Client Tools :: Create Shortcut On Desktop To Have SQLPLUS (command Line)

Sep 6, 2010

The way to create a short cut on desktop to have an sql*plus (command line).

i.e. I want to have an short cut on desktop when I click that short cut that would connect me to a specific database with a username and password (which i supply while creating the shortcut-I would provide the database name, username and password)

View 7 Replies View Related

Can Oracle 9 / 10 And 11 Be Installed On Same PC

Nov 4, 2010

I have new PC going to be used for Oracle 9, 10 & 11. It has Windows 2008, system processor - Intel® Xeon® CPU, Installed memory 2.00 GB and it is 64-bit operating system. My question is if it is possible to have 3 different versions of Oracle on the same box. I want to make sure that they are not going to create any problem! If it is ok to install all three on the same box then should i start installing from the lowest version (9)?

View 4 Replies View Related

Oracle 11g R2 Installed With Zero Bytes On IBM AIX

Dec 27, 2012

I have installed 11g r2 using silent mode. but all the executable like lsnrctl, expdp, sqlldr,impdp etc.... installed with 0 (zero) bytes.

couldn't trace out what the problem is,

View 1 Replies View Related

Forms :: Installed 10g - Not Able To Run Form?

Jan 6, 2011

I installed forms and built a simple form using EMP table.I was able to compile the form successfully but when I run the form it opens IE and says IE has stopped working and closes the program.I have Windows Vista OS and IE7.

View 6 Replies View Related

Installed Oracle11g - How To Build Demo

Jul 28, 2010

I installed oracle11g on my computer ,when im going to build demo its not working.its giving a error like this.

sys>conn u1/u1
error accesing PRODUCT_USER_PROFILE
warning product user profile information not loaded
you may need to run PUPBLD.SQL AS SYSTEM
connected
u1>@?/sqlplus/demo/demobld unable to open file "/oraeng/app/oracle/product/11.1.0/sqlplus/demo/demobld.sql"

View 1 Replies View Related

SQL & PL/SQL :: ORA-24248 - XML DB Extensible Security Not Installed?

Mar 29, 2012

When i try to gather server information by running the below query , i get error.

SQL>
SQL> select utl_inaddr.get_host_address ('Hostnamename') from dual;
select utl_inaddr.get_host_address ('Hostnamename') from dual
*
ERROR at line 1:
ORA-24248: XML DB extensible security not installed
ORA-06512: at "SYS.UTL_INADDR", line 19
ORA-06512: at "SYS.UTL_INADDR", line 40
ORA-06512: at line 1

I ran below query to see what is installed.

SQL>
SQL> select comp_name from dba_registry;

COMP_NAME
-----------------------------------------
Oracle Database Catalog Views
Oracle Database Packages and Types
Oracle Real Application Clusters

My question is do i need to install XML database to resolve this issue and is SYS user is required to perform this install?

View 17 Replies View Related

How Many Databases Were Installed In A Given Server / Machine

Apr 10, 2013

10g and 11g

SLES 10

My boss has assigned me a task to check/audit a existing PROD + other databases which was configured (in a server or servers) by previous dba who have left with no documentation.I am just given the server ip and root password.

-How do you attack this kind of task?
-How do you know how many databases were installed in a given server/machine?
-How do you get all the oracle_home being defined or used?

Is /etc/oratab enough to start with?Is oraInventory enough to know all the databases installed? Is this keyword unique, and kind be search using "find / -name "oraInventory"?Do I need to find the existent of the "oracle" exec in all "bin" since this is the unique identifier of an OracleHome?

View 6 Replies View Related

Installed Oracle 11.2.0 On Windows 7 64 Bit - Initialization Error

Mar 20, 2011

I install Oracle 11.2.0 on Windows 7 64bit and i install PL/SQL Developer.

when i run the PL/SQL and connect to Oracle i get this error:

Initialization error
Could not load "C:\app\MyComp\product\11.2.0\dbhome_1\bin\oci.dll"

OCIDLL forced to C:\app\MyComp\product\11.2.0\dbhome_1\bin\oci.dll
LoadLibrary(C:\app\MyComp\product\11.2.0\dbhome_1\bin\oci.dll) returned 0

View 7 Replies View Related

Windows :: OScanner - Java JRE Installed On Machine

Mar 16, 2011

I have recently downloaded (the zip file for) OScanner (1.0.6) and have Java JRE installed on my machine. However, I am experiencing some difficulty in running the scanner. how I should start to use this tool, once I have downloaded the zip file.

View 8 Replies View Related

Database Cloning Installed On ZFS Storage Appliance

May 14, 2013

I have an update Oracle database 11g installed on ZFS Storage, and I need to make cloning for it. HCC feature is enabled.

How can I make this?

Using RMAN backup + ZFS Snapshot + ZFS Cloning ?

View 0 Replies View Related

Clusterware :: Change Hostname / IP's On Installed GI11.2.0.3

Feb 28, 2013

Is it possible to change the Hostname/IP's nodes on installed GI11.2.0.3? Exist some notes for do this action on "GI standalone" but no for GI.

View 4 Replies View Related

Windows :: Detect Oracle Version And Platform Installed?

Mar 14, 2012

Is there a way to check which versions or oracle installed on the machine from command line?

The thing is I don't want to login to the database so I can't use SQL Plus also, till now I ran tnsping and checked the output but in case there are several versions of different platform I got only one version that was first on the path env.

View 1 Replies View Related

Server Administration :: Installed Database Oracle With Installation

Nov 17, 2011

Yesterday i installed oracle 11g r2 by default i installed database Oracle with the installation .but today i tried to create the database with the name green tat also completed successfully..the problem is in startup

export oracle_sid=green
sqlplus '/ as sysdba'
startup
database mounted

select instance_name from v$instance; But it SHowing the instance name as Oracle...i tried with the other method also

export oracle_sid=green
sqlplus /nolog
conn sys/b123 as sysdba

database mounted

select instance_name from V$parameter;

and it shows instance name as green..i tried to see the datafile location for green database

select file_name from dba_data_files; it shows the orcl datafile locations.

View 6 Replies View Related

Oracle 11gr2 64 Bit Database Software Installed - Not Register

Feb 19, 2013

1. oracle 11gr2 64 bit database software installed
2. oracle 11gr2 32 bit clinet software installed

The above software has been installed on server, Pop pup- Error messages coming during installing 3rd party software packages...on server.

Error is - igrORASPConnect412.dll not register...

what could be issues & how to resolve this problem? do we need to reinstall client software again not available this DLL file after searching on oralce home directory .

View 1 Replies View Related

Server Administration :: Information Regarding Latest Patch Installed For ORACLE_HOME

Feb 23, 2010

How do i find out the information regarding the latest patch installed for ORACLE_HOME..

OR

If given a patch number, how do i find out whether it's applied to ORACLE_HOME

View 1 Replies View Related







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