blog.hilandco.com
Hil & Co IT Solutions: April 2015
http://blog.hilandco.com/2015_04_01_archive.html
Thursday, 2 April 2015. SOA, OSB Schema Names And Versions. Select * from schema version registry;. Subscribe to: Posts (Atom). Tweets von https:/ twitter.com/ras hi3/lists/oracle-middleware. BI Publisher 11g create new user. Oracle 10g Backup Recovery Poster. About Oracle VM server/manager. Oracle Server Architecture and Metrics. Frameworks: Modeling Tables and Components. Database Development with JDeveloper. XMLType and Namespace problem. Searching for Resources Using Oracle Text.
blog.hilandco.com
Hil & Co IT Solutions: June 2011
http://blog.hilandco.com/2011_06_01_archive.html
Tuesday, 14 June 2011. Increase wls startup time on linux. Export JAVA HOME="/oracle/product/FM/jdk1.6.0 22". Vi $JAVA HOME/jre/lib/security/java.security. Replace securerandom.source with. Subscribe to: Posts (Atom). Tweets von https:/ twitter.com/ras hi3/lists/oracle-middleware. BI Publisher 11g create new user. Oracle 10g Backup Recovery Poster. About Oracle VM server/manager. Oracle Server Architecture and Metrics. Frameworks: Modeling Tables and Components. Database Development with JDeveloper.
blog.hilandco.com
Hil & Co IT Solutions: May 2011
http://blog.hilandco.com/2011_05_01_archive.html
Sunday, 29 May 2011. Backup the WLS Domain. Tar –cvf $DOMAIN HOME`date %y%m%d`.tar $DOMAIN HOME. Mv $DOMAIN HOME/security/DefaultAuthenticatorInit.ldift /tmp/. Run the Java command:. Java weblogic.security.utils. AdminAccount weblogic pwd $DOMAIN HOME/security. Ls –l $DOMAIN HOME/security. Delete the contents inside the file [boot.properties] under. Ls -l $DOMAIN HOME/servers/. Ls -l $DOMAIN HOME/servers/. Ls -l $DOMAIN HOME/servers/. Sqlplus "sys/password as sysdba". Component id= 'MRC',. Privilege = 'c...
oracledba-vinod.blogspot.com
Oracle Database Administration: October 2009
http://oracledba-vinod.blogspot.com/2009_10_01_archive.html
Sunday, October 11, 2009. You can force the log switches using the following statements,. SQL Alter System Switch LogFile;. SQL Alter System Archive Log Current;. A number of DBAs also confuse with the following statement,. SQL Alter System Archive Log all;. The above statement will not issue a log switch. It will archive all the non-archived log files. If you have no logfiles that are unarchived, then issuing the above statement returns the error message,. ORA-00271 there are no logs that need archiving.
oracledba-vinod.blogspot.com
Oracle Database Administration: August 2013
http://oracledba-vinod.blogspot.com/2013_08_01_archive.html
Thursday, August 1, 2013. What is a Latch. Oracle SGA consists of numerous data structures such as Buffer Cache, Shared pool, Library cache, Dictionary cache, redo log buffer etc. Many oracle processes need to access these SGA data structures concurrently. Though these SGA components are shared, only one process must be able to modify it at any particular point in time. Oracle achieves this by protecting the SGA data structures with latches. When do Oracle Process obtain a latch? A process acquires a lat...
blog.hilandco.com
Hil & Co IT Solutions: August 2012
http://blog.hilandco.com/2012_08_01_archive.html
Friday, 17 August 2012. Wordpress behind Apache proxy. ProxyPass /wp http:/ 127.0.0.1:81/wordpress. ProxyPassReverse /wp http:/ 127.0.0.1:81/wordpress. Subscribe to: Posts (Atom). Tweets von https:/ twitter.com/ras hi3/lists/oracle-middleware. BI Publisher 11g create new user. Oracle 10g Backup Recovery Poster. About Oracle VM server/manager. Oracle Server Architecture and Metrics. Frameworks: Modeling Tables and Components. Database Development with JDeveloper. XMLType and Namespace problem.
blog.hilandco.com
Hil & Co IT Solutions: June 2012
http://blog.hilandco.com/2012_06_01_archive.html
Wednesday, 27 June 2012. Alter system set local listener='(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521) ';. Alter system register;. Tuesday, 26 June 2012. CREATE USER hqagent IDENTIFIED BY pwd; GRANT CONNECT TO hqagent; GRANT SELECT ANY DICTIONARY TO hqagent;. ORACLE HOME=/oracle export ORACLE HOME PATH="${ORACLE HOME}/bin:${PATH}" export PATH. Vi /hyperic/agent-4.6/conf/agent.properties. Platform.name=em platform.fqdn=em.hilandco.com. Hyperic Server Installation (oracle). Install jdk 1.6. Simple te...
blog.hilandco.com
Hil & Co IT Solutions: April 2011
http://blog.hilandco.com/2011_04_01_archive.html
Friday, 29 April 2011. Start Stop Script Oracle Fusion Middleware. Vi $DOMAIN HOME/servers/AdminServer/security/boot.properties. Vi $DOMAIN HOME/servers/wls ods1/security/boot.properties. MW HOME=/oracle/product/FM;export MW HOME. DOMAIN HOME=$MW HOME/user projects/domains/IDMDomain;export DOMAIN HOME. INSTANCE HOME=$MW HOME/oid11inst;export INSTANCE HOME. WL HOME=$MW HOME/wlserver 10.3;export WL HOME. ORACLE HOME=$MW HOME/oid11;export ORACLE HOME. ORACLE INSTANCE=$INSTANCE HOME;export ORACLE INSTANCE.
oracledba-vinod.blogspot.com
Oracle Database Administration: April 2009
http://oracledba-vinod.blogspot.com/2009_04_01_archive.html
Friday, April 10, 2009. To monitor the temporary Segment Usage. SELECT A.tablespace name tablespace, D.mb total,. SUM (A.used blocks * D.block size) / 1024 / 1024 mb used,. Dmb total - SUM (A.used blocks * D.block size) / 1024 / 1024 mb free. FROM v$sort segment A,. SELECT B.name, C.block size, SUM (C.bytes) / 1024 / 1024 mb total. FROM v$tablespace B, v$tempfile C. WHERE B.ts#= C.ts#. GROUP BY B.name, C.block size. WHERE A.tablespace name = D.name. GROUP by A.tablespace name, D.mb total;. Switching undo...
oracledba-vinod.blogspot.com
Oracle Database Administration: February 2010
http://oracledba-vinod.blogspot.com/2010_02_01_archive.html
Thursday, February 25, 2010. The following are the commands you can type from the RMAN prompt. Posted by Vinod Dhandapani. Thursday, February 25, 2010. RMAN List Command queries the target control file or the recovery catalog for the historical information on the backups. The various options you can use with List command and their uses are discussed below,. A new incarnation of the database is created when you perform the open resetlogs. Operation. To view the list of database incarnations,. RMAN List Ba...