How did I come to the ALTER USER RENAME command? Just a lucky punch due to my customer. My customer were trying to rename an user in an Oracle Database with several objects (tables, view, functions, types and so) by simply updating the sys.user$ table :-) The result were better than (more...)
Many times DBA's have to rename / copy complete users/schemas from the current name to a new name within one database. Since several years DBA's are asking for a simple method inside Oracle to execute something like "ALTER USER RENAME".
Common approaches to rename users/schemas are:
IMPDP with REMAP_SCHEMA
update of sys.user$
For the option "update of sys.user$", which is in my opinion a really bad choice, see Tom Kyte's comment
Since 19th January 2016 the Critical Patch Update for January 2016 is out. In case you are trying to apply the CPUJan2016 against an Oracle WebLogic Server 12.1.2 you may run into following error:
Verifying the update... [ Error during Update inventory for apply Phase]. Detail: There are 1 copy files under ORACLE_HOME that are not patched. Files check failed: Some files under ORACLE_HOME are not patched. Please see logfile for details. [ (more...)
As everybody already know that the latest version of Oracle Enterprise Manager 13c (220.127.116.11) has been released yesterday (see also my post from 18th December 2015), Oracle has uploaded several interesting presentations around the new Oracle Enterprise Manager 13c.
The presentations are covering various topics around the Oracle Enterprise Manager 13c (some presentations are also still covering Enterprise Manager 12c):
With the latest release of Oracle WebLogic Server 12.2.1 came quite a lot of enhancements for the RESTful Management Services. The enhancements are really impressive, you are able to monitor (GET) or to modify (POST) your WebLogic environment in detail with a simple URL call either via Browser or via Command Line Tools like cURL. The response time for such REST calls are really impressive compared to the classical way with WLST scripts (more...)
Within the new release of Oracle WebLogic Server 12.2.1 is a really cool new feature for Data Source System Properties.
In case you have mutliple data sources defined within your Oracle WebLogic Server pointing to the same Oracle Database and mostly using the same Oracle Database user, you have currently limited chances to identify in your v$session, which session belongs to which WebLogic Server Data Source.
Normally end users would like to have a simple URL access for Oracle Business Intelligence Enterprise Edition (OBIEE) 11g like http://webhost:7777 and than to be automatically redirected to their Dashboard, instead of typing endless complex URL's.
Assuming you have following standard implementation of an OBIEE environment which contains an Oracle HTTP Server (OHS) configured with mod_wl_ohs to be proxied to point to your WebLogic Server hosting OBIEE and an OBIEE Server, you can simply use (more...)
During the official announcement of Oracle WebLogic Server 12c on 1st December 2011, Oracle also announced the new Oracle Traffic Director.
Oracle Traffic Director 11g is a high-performance caching HTTP proxy server. It is designed to take advantage of the unique engineered systems features of Oracle's Exalogic computing platform, providing (more...)
In the last days I was fighting with a nice behaviour of the asmcmd non-interactive mode in MS-DOS batches.
I wanted to delete several files located in ASM within a MS-DOS batch:
REM Script: asm_cleanup_DB112.cmd
asmcmd rm -f +TEMP/db112/temp_01. (more...)