Skip to main content

Posts

Showing posts with the label Oracle

The Exadata move

The move to Exadata and Cloud at Customer - Database:  Why Exadata:  Performance - Exadata is engineered to run the Oracle database, and we can now eliminate hardware as a cause of performance problems, eliminate storage latency issues. Every feature of the Oracle Database - enough said. Why Cloud at Customer:  Alleviates problems with hardware and avoiding patching and hardware problems seems like a big win to me. Data security: Unfortunately we have some very important information stored in our system and the cloud was not an option Scalability: With PAAS we will be able to meet our horizontal scalability needs. Interesting findings and other notes: 1) Maximum 8 VM's on the Exadata 2) Active / Active and RAC Database conversion: 1) Character Set Conversion:  https://docs.oracle.com/database/121/NLSPG/ch11charsetmig.htm#NLSPG983  there is a document and a utility ( DMU ), color me surprised. ( https://www.oracle.com/technetwork/database/dat...
Post a Comment
Read more

MDS: Update script - NOT RECOMMENDED

For my use only don't use this without understanding what you are doing. I had a bunch of old MDS features in my menu which was causing our menu to collapse on login. (The collapse feature was set to not persist so the users had no way of fixing this). Instead of writing code or purging all settings from MDS for that page I decided on a data fix. Forgive my sql skills this was a quick and dirty. SCHEMA: ???_MDS TABLE :  MDS_ATTRIBUTES - this is where all the mds configuration is kept for each item and attribute. TABLE :  MDS_PATHS - this is where the file name for the resource you are looking for is kept. (ie page.jsff) you can also find the user in the path so you can do this for a specific user. DECLARE     v_content_id MDS_PATHS.PATH_CONTENTID%TYPE;     v_col_seq MDS_ATTRIBUTES.ATT_COMP_SEQ%TYPE;     CURSOR v_path_cursor IS       SELECT pa.PATH_CONTENTID FROM MDS_PATHS pa WHERE pa.PATH_PARTITION_ID = 3 AND PA....
Post a Comment
Read more

Adding a custom attribute WebCenter menu...

Find the schema section in your menu xml --> ie default-navigation-model.xml Add a descriptor:     <descriptor shortLabelKey="TITLE.SHORT_PROMPT_KEY" multivalue="false"                 attributeId="NewAtrr" labelKey="TITLE.PROMPT_KEY"                 endUserVisible="true" searchable="true"                 xmlns="http://xmlns.oracle.com/adf/rcs/catalog"/> Note: you can change the  shortLabelKey and labelKey by adding a resourceBundle="..." but that is another post.... Looks a bit like this: <schema resourceBundle="oracle.adf.rc.attribute.nls.AttributeBundle"           xmlns="http://xmlns.oracle.com/adf/rcs/catalog">     <descriptor shortLabelKey="TITLE.SHORT_PROMPT_KEY" multivalue="false"                 attributeId="Title" labelKey="TITLE.PROM...
Post a Comment
Read more

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";
Post a Comment
Read more