oracledb101.wordpress.com
Oracle Database 101 | Exploring Whats Possible With DataExploring Whats Possible With Data
http://oracledb101.wordpress.com/
Exploring Whats Possible With Data
http://oracledb101.wordpress.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Wednesday
LOAD TIME
0.2 seconds
16x16
32x32
PAGES IN
THIS WEBSITE
16
SSL
EXTERNAL LINKS
17
SITE IP
192.0.78.12
LOAD TIME
0.188 sec
SCORE
6.2
Oracle Database 101 | Exploring Whats Possible With Data | oracledb101.wordpress.com Reviews
https://oracledb101.wordpress.com
Exploring Whats Possible With Data
oracledb101.wordpress.com
13 | May | 2015 | Oracle Database 101
https://oracledb101.wordpress.com/2015/05/13
Adventures in Data, Oracle and Linux. Daily Archives: May 13, 2015. May 13, 2015. Oracle On RHEL/Oracle 7 Fun. A bigger problem turned out to be Enterprise Manager. Again the agent install went fine but anytime I tried to do anything that required authenticating with the host failed with a broken pipe error message. Authentication for the OEM agent is handled by the NMO utility and it is possible to test it your self. Nmo oracle #enter password# 0 date 0 Segmentation fault. Follow Blog via Email.
13 | April | 2015 | Oracle Database 101
https://oracledb101.wordpress.com/2015/04/13
Adventures in Data, Oracle and Linux. Daily Archives: April 13, 2015. April 13, 2015. Using Snapshots on Exadata Part I. Exadata X3 or newer. 121210 storage cell software or later. 12102 Database BP 5 or later. Next Lets review the architecture of snapshotting on Exadata and its a bit different from a traditional storage array thin clone. Snapshots on Exadata introduce a new type of grid disk call sparse grid disks and a new state for a database called snapshot master. Like SAN thin clones Exadata snapsh...
Using Snapshots on Exadata Part I | Oracle Database 101
https://oracledb101.wordpress.com/2015/04/13/using-snapshots-on-exadata-part-i
Adventures in Data, Oracle and Linux. April 13, 2015. Using Snapshots on Exadata Part I. Exadata X3 or newer. 121210 storage cell software or later. 12102 Database BP 5 or later. Next Lets review the architecture of snapshotting on Exadata and its a bit different from a traditional storage array thin clone. Snapshots on Exadata introduce a new type of grid disk call sparse grid disks and a new state for a database called snapshot master. Like SAN thin clones Exadata snapshots also use copy-on-write (COW)...
31 | July | 2015 | Oracle Database 101
https://oracledb101.wordpress.com/2015/07/31
Adventures in Data, Oracle and Linux. Daily Archives: July 31, 2015. July 31, 2015. Creating 12c Far Sync Instance Part 2. In a previous post. Walked through setting up a far sync instance. Now we are going to test what happens when the far sync instance goes down. First a quick review on the redo shipping on the primary server. Below is the configuration for shipping to the far sync instance. Service=c002 far SYNC MAX FAILURE=1 DB UNIQUE NAME=c002 far ALTERNATE=LOG ARCHIVE DEST 3. DEST NAME STATUS - - -...
20 | April | 2015 | Oracle Database 101
https://oracledb101.wordpress.com/2015/04/20
Adventures in Data, Oracle and Linux. Daily Archives: April 20, 2015. April 20, 2015. Using Snapshots on Exadata Part II. In a previous post. Had an introduction with the new snapshot features for Exadata. This post will show how to setup sparse disks, sparse diskgroups and how to snapshot a PDB. Setting Up Sparse Disks. Create griddisk DATA CD 11 exa1cell01 celldisk=CD 11 exa1cell01, sparse=true. We can confirm the new grid disks are sparse grid disks with the following command. CellCLI list griddisk DO...
TOTAL PAGES IN THIS WEBSITE
16
Howto know the processor type (Power 5, power6 or power7) on AIX | Luis's Blog
https://luiscalvolopez.wordpress.com/2016/01/20/howto-know-the-processor-type-power-5-power6-or-power7-on-aix
My technical work (Oracle Database, Scripting, Linux, etc …). Howto know the processor type (Power 5, power6 or power7) on AIX. Lsattr -E -l proc0. Output should be similar to:. Frequency 3000000000 Processor Speed False smt enabled true Processor SMT enabled False smt threads 4 Processor SMT threads False state enable Processor state False type PowerPC POWER7 Processor type False. Always check the OS level (version) using:. January 20, 2016. Posted by Luis on January 20, 2016. Leave a Reply Cancel reply.
January | 2016 | Luis's Blog
https://luiscalvolopez.wordpress.com/2016/01
My technical work (Oracle Database, Scripting, Linux, etc …). All posts for the month January, 2016. How to move your ubuntu to another computer. Step 1: Store the list of installed packages. Run the following command on the source machine to store the installed packages names in. Sudo dpkg - get-selections sed "s/.*deinstall/ " sed "s/install$/ g" /pkglist. Step 2: Transfer your config. Or even a flash drive to transfer your home directory (. The source list (. From the source machine to the target one.
Luis | Luis's Blog
https://luiscalvolopez.wordpress.com/author/cen2038
My technical work (Oracle Database, Scripting, Linux, etc …). All posts by Luis. Check CRC errors on Emulex HBA. The command to check that on each HBA port:. You’ll see something like this. And watch for that Invalid CRC count to increase. This indicated either the HBA or fibre channel wire are having issues. I would start by replacing the wire…. Check http:/ www.emulex.com/files/solutions/oracle/pdfs/using-oracle.pdf. February 24, 2016. Posted in Oracle Database. Posted by Luis on February 24, 2016.
Check CRC errors on Emulex HBA | Luis's Blog
https://luiscalvolopez.wordpress.com/2016/02/24/check-crc-errors-on-emulex-hba
My technical work (Oracle Database, Scripting, Linux, etc …). Check CRC errors on Emulex HBA. The command to check that on each HBA port:. You’ll see something like this. And watch for that Invalid CRC count to increase. This indicated either the HBA or fibre channel wire are having issues. I would start by replacing the wire…. Check http:/ www.emulex.com/files/solutions/oracle/pdfs/using-oracle.pdf. February 24, 2016. Posted in Oracle Database. Posted by Luis on February 24, 2016. Enter your comment here.
NUMA related | Luis's Blog
https://luiscalvolopez.wordpress.com/2016/01/20/numa-related
My technical work (Oracle Database, Scripting, Linux, etc …). Nfob is a variable used to determine the size of numa pool size parameter. Nfob=1 ( 0.1*nprocs)*nfiles). January 20, 2016. Posted in Oracle Database. Posted by Luis on January 20, 2016. Https:/ luiscalvolopez.wordpress.com/2016/01/20/numa-related/. Ssh still ask for password in spite of a passwordless configuration. Obtain all locks and resource information from a RAC instance (also works for standalone). Leave a Reply Cancel reply. Christoph&...
Obtain all locks and resource information from a RAC instance (also works for standalone) | Luis's Blog
https://luiscalvolopez.wordpress.com/2016/01/20/obtain-all-locks-and-resource-information-from-a-rac-instance-also-works-for-standalone
My technical work (Oracle Database, Scripting, Linux, etc …). Obtain all locks and resource information from a RAC instance (also works for standalone). This will dump all information needed to locate locks and resources hold on different instances:. Sqlplus "/ as sysdba" oradebug setmypid oradebug unlimit oradebug -g all lkdebug -A res oradebug -g all lkdebug -A lock oradebug -g all hanganalyze 3 oradebug -g all dump systemstate 267 quit. Destinations for new files. Lkdebug -O 0x0 0x0 CF. Please log in ...
ssh still ask for password in spite of a passwordless configuration | Luis's Blog
https://luiscalvolopez.wordpress.com/2016/01/20/ssh-still-ask-for-password-in-spite-of-a-passwordless-configuration
My technical work (Oracle Database, Scripting, Linux, etc …). Ssh still ask for password in spite of a passwordless configuration. You are trying to configure a linux account so it can be used as RAC owner for software install. You has followed all steps:. Created the rsa and dsa keys. Added the pub keys to the authorized keys file of the current node and the rest of nodes. Checked that permissions for. Is 700 and for. However the problem persists. You try to debug the sshd client and copy. As default va...
February | 2016 | Luis's Blog
https://luiscalvolopez.wordpress.com/2016/02
My technical work (Oracle Database, Scripting, Linux, etc …). All posts for the month February, 2016. Check CRC errors on Emulex HBA. The command to check that on each HBA port:. You’ll see something like this. And watch for that Invalid CRC count to increase. This indicated either the HBA or fibre channel wire are having issues. I would start by replacing the wire…. Check http:/ www.emulex.com/files/solutions/oracle/pdfs/using-oracle.pdf. February 24, 2016. Posted in Oracle Database. Jon Adams, OCP, MCTS.
Hang Stuff: V$Wait_Chains, Procwatcher, Hanganalyze, and Systemstate Dump Levels | Luis's Blog
https://luiscalvolopez.wordpress.com/2016/01/20/hang-stuff-vwait_chains-procwatcher-hanganalyze-and-systemstate-dump-levels
My technical work (Oracle Database, Scripting, Linux, etc …). Hang Stuff: V$Wait Chains, Procwatcher, Hanganalyze, and Systemstate Dump Levels. This is taken from an email from Mike Polanski. There are many good alternatives to getting huge systemstate dumps in v11 that impact the customer’s system far less. I wanted to take this opportunity to mention some…. 8211; Troubleshooting Database Contention With V$Wait Chains. However, it turns out the reason for the excessive systemstate times at levels 266 an...
TOTAL LINKS TO THIS WEBSITE
17
oracledaypi's blog - Blog de l'oracle daypi - Skyrock.com
Blog de l'oracle daypi. 23/09/2008 at 12:43 PM. 04/05/2010 at 5:50 PM. UNE NOUVELLE BOUTIQUE S'ANONCE. Http:/ www.pepitastore.com/skyrock/confir. Soundtrack of My Life. New lewis sanguèbè l nouveau concEptE dE bAbi (Album inconnu (02/01/2009 13:5). Subscribe to my blog! UNE NOUVELLE BOUTIQUE S'ANONCE. Http:/ www.pepitastore.com/skyrock/confirmation.php? Please enter the sequence of characters in the field below. Posted on Friday, 30 January 2009 at 11:54 AM. Edited on Tuesday, 03 February 2009 at 3:45 AM.
ORACLE DBA
Wednesday, April 03, 2013. RMAN-03002: failure of recover command at. ORA-06552: PL/SQL: Compilation unit analysis terminated. ORA-06553: PLS-553: character set name is not recognized. Export NLS LANG=AMERICAN AMERICA.AL32UTF8. Restarted database with above characterset. Monday, October 15, 2012. ORA-27054: NFS file system where the file is created or resides is not mounted with correct options. ORA-19504: failed to create file "/backup/rman/01nmqsmk 1 1". Thursday, July 12, 2012. Clear the agent state.
oracledb-oem-appsserver-etc.blogspot.com
All things Oracle!
Work" that I find worth sharing with other Oracle users! Join me on LinkedIn! Join us on Facebbook! Follow Us on Twitter! Subscribe to our RSS Feed! Migrating optimizer statistics from Prod to Test database's. Create stats table using. SQL EXEC DBMS STATS.CREATE STAT TABLE(ownname= 'PROD SCHEMA', stattab= 'STATS 08JAN2016');. SQL EXEC DBMS STATS.EXPORT SCHEMA STATS(ownname = 'PROD SCHEMA',stattab = 'STATS 08JAN2016');. Export the stats table using. Scp the dump file to the destination server. Disk migrat...
Oracle Database Exchanging Experiences | Just another WordPress.com weblog but more technically oriented to Oracle Database
Oracle Database Exchanging Experiences. I’ve created this blog about four months ago. My initial intent was to challenge with english language, to open my possibilities to exchange experiences (from which the blog title) with other persons from all over the world. It is written in my mother-tongue so there i’ve written more information that here. I was inspired also by Jonathan Lewis and his Oracle Scratchpad. To view my posts on this blog you have to go. On this page named “All Postings”. That my sign o...
Oracle Database 101 | Exploring Whats Possible With Data
Exploring Whats Possible With Data. March 26, 2018. 181c New Features Part I. 181 is now available on Oracle Cloud so going to cover some of the new features. Topics like Multitentant have enough new features to warrant a dedicated post. So with that lets dive in. OCI Timeout – With using the OCI driver applications can set a time out when making DB calls. This prevents a long running call or a call that is being blocked from making it look like the application is hung. Parallel Queue Timeout – Wit...
Oracle DBA
Oracle DBA Guide
Wednesday, May 12, 2010. DIM-00014: Cannot open the Windows NT Service Control Manager. One of the most common error that user faced in using oradim utility is :. DIM-00014: Cannot open the Windows NT Service Control Manager. O/S-Error: (OS 5) Access is denied. This error is common in Windows Vista and windows 7 . So the solution is very simple ,. Just goto start wirte cmd ,cmd icon appears ,right click on it . Then click on "Run as administrator" and then create your required service . Nter any desired ...
OracleDba.In - All Article of OracleDba.In
Saturday, September 28, 2013. Finding out Last DDL and DML Activity on a Table. I received one of a mail with the query of how could we figure out Last DML and DDL time on a table. Here is a small piece of SQL Commands to get the same info. Create table t (t1 number,t2 varchar2(20),t3 date);. Here is how you could find the same. 2 (select last ddl time from dba objects where object name='T' and owner='SYS') "DDL Time",. 3 decode(maxscn,0,'N/A',scn to timestamp(maxscn) "DML Time". DDL Time DML Time. 2012-...
oracledba-interview.blogspot.com
Oracle DBA Interview
Tuesday, March 30, 2010. Oracle DBA 11g Lesson- 28 Monitoring and Tuning RMAN. Oracle DBA Interview Questions and Answers, CBT, Oracle E-books, Certifications http:/ oracledba-interview.blogspot.com. 1)This is a workshop for 11G complete each ppt in 1 days and 25 days u can become gem in oracle 11g DBA. 2)This below form is PPT so office 2003 or 2007 should be available in system to see it clearly. 3)Each PPT contain 10 to 50 slides so click the next button to see the next side. Les 10 Tune Rman. Oracle ...
CORE DBA KNOWLEDGE SOURCE
CORE DBA KNOWLEDGE SOURCE. Thursday, January 3, 2008. Oracle Application Documents Downloadable. Oracle Application release 12 Documents http:/ downloaduk.oracle.com/docs/cd/B34956 01/current/html/docset.html. Releas12 ,12,11i,11i http:/ www.oracle.com/technology/documentation/applications.html. Release 11.5.10.2 Document libraury http:/ download.oracle.com/docs/cd/B25516 18/current/html/docset.html. Tuesday, January 1, 2008. 7 Tips on becoming an ERP consultant. The beauty of this ERP is, it always keep...
