Skip to main content

Oracle XE problems

Had a few issues when trying to connect to oracle xe installed by another user

 Getting sqlplus to work
set ORACLE_HOME=C:\oraclexe\app\oracle\product\11.2.0\server
set ORACLE_SID=XE
set PATH=C:\oraclexe\app\oracle\product\11.2.0\server\bin;%PATH%

Connecting as sysdba to change password (ORA-01031: insufficient privileges)
 Type Edit local users in your start menu search bar (Select the first one in the Control panel group)
 Click Groups
 Select ORA_DBA
 Add your user here
 sqlplus / as sysdba from the command prompt with all above variables set
 alter user SYS identified by "newpassword";
Labels:

Comments

Post a Comment

Popular posts from this blog

OJDeploy: Documentation for the tool

Real DOCS:  http://docs.oracle.com/cd/E26098_01/user.1112/e17455/deploying_apps.htm#OJDUG645 OJDeploy Documentation if you run it from the command line - I keep looking for this so I though I would post it here so I remeber. Oracle JDeveloper Deploy 11.1.2.1.0.6081 Copyright (c) 2003, 2010, Oracle and/or its affiliates. All rights reserved. Usage:   ojdeploy -profile <name> -workspace <jws> [ -project <name> ] [ <options> ]   ojdeploy -buildfile <ojbuild.xml> [ <options> ]   ojdeploy -buildfileschema Arguments:   -profile               the name of the Profile to deploy   -workspace      full path to the JDeveloper Workspace file(.jws)   -project              name of the JDeveloper Project within the .jws where the Profile can be...
4 comments
Read more

ADF: LOV Description instead of code

I keep on forgetting how to do this so this is a note to self in terms I understand (ie pictures): Add the related entiy object to yours (in the example we are adding RegionEO(list of values) to CountryEO) Now add the RegionName field from the EO and a transient attribute (I named mine RegionNameLOV) Make the transient attribute updateable and base it on the expression RegionName (the description you wish to display) Add a list of values to RegionNameLOV and map BOTH key to parent fk (region id here) AND RegionName to your transient coulmn (RegionNameLOV).  Map the transient as an Input text with List of Values. Then just drag the lov item onto the page (RegionNameLOV)
Post a Comment
Read more

java.lang.IllegalStateException: ADF_FACES-60003:Component with ID not registered for Active Data

This was hard to fix: if anyone wants the code just ask. Or if you have a better solution please post comment. Once excel export has been clicked if we navigate around using ppr to refresh the region we get this error. I was forced to create an export handler tag wich forces the export to happen in a new window. Because this page is getting some hits here is some of the code (also use this method for pdf export): Button with new listener: (xmlns:new="http://za.co.company/adf/faces/common/my" in your jsp:root) <af:commandToolbarButton text="Export" id="ctb1" immediate="true" partialSubmit="true" icon="images/excel.jpg"> <new:myExportCollectionActionListener exportedId="audTab" type="excelHTML" filename="audit.xls" title="Audit"/> </af:commandToolbarButton> TAG: import oracle.adfinternal.view.faces.export.ExportCollectionActionListener; import oracle.adfin...
9 comments
Read more