blog.dbauniversity.com
DBA University BlogDBA University blog.
http://blog.dbauniversity.com/
DBA University blog.
http://blog.dbauniversity.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Saturday
LOAD TIME
9.6 seconds
PAGES IN
THIS WEBSITE
19
SSL
EXTERNAL LINKS
16
SITE IP
172.217.6.83
LOAD TIME
9.57 sec
SCORE
6.2
DBA University Blog | blog.dbauniversity.com Reviews
https://blog.dbauniversity.com
DBA University blog.
blog.dbauniversity.com
DBA University Blog: November 2014
http://blog.dbauniversity.com/2014_11_01_archive.html
MS SQL Server DBA Training. Oracle ASM RAC Data Guard Training. Big Data with Hadoop Training. Sunday, November 23, 2014. Oracle tablespace export expdp - Tips and Restrictions. In a previous post. We have explained about Oracle tablespace export using the export data pump utility (expdp). In this post, we will add more details to provide information on some restrictions and tips using the tablespace export data pump option. Oracle does not export tablespace metadata. Tablespace export data pump operatio...
DBA University Blog: February 2015
http://blog.dbauniversity.com/2015_02_01_archive.html
MS SQL Server DBA Training. Oracle ASM RAC Data Guard Training. Big Data with Hadoop Training. Sunday, February 22, 2015. How to fix VNC Viewer black screen. Have you seen your VNC Viewer showing a black screen intermittently? We have a fix for it. This issue has been occurring in our lab servers for a few students intermittently since the past few months on Oracle Linux server 6.5 release. Her mouse on the VNC Config icon. On the top left hand corner. This issue happens even if this icon is minimized.
DBA University Blog: March 2015
http://blog.dbauniversity.com/2015_03_01_archive.html
MS SQL Server DBA Training. Oracle ASM RAC Data Guard Training. Big Data with Hadoop Training. Monday, March 23, 2015. Big Data with Hadoop Training. The training topics include the Hadoop core components viz. The Hadoop File System (HDFS) and the Map Reduce computation paradigm. All the other major sub projects of the Hadoop solution such as Apache Sqoop, Hive, Pig, Impala, Flume and Spark are also included in this training course. Most of the topics have lab exercises too. 2) Training will contain.
DBA University Blog: February 2014
http://blog.dbauniversity.com/2014_02_01_archive.html
MS SQL Server DBA Training. Oracle ASM RAC Data Guard Training. Big Data with Hadoop Training. Sunday, February 2, 2014. Oracle RAC, ASM and Data Guard Training. We have some exciting news for you. Michelle Malcher will be conducting the Oracle RAC, ASM and Data Guard course. Click here to watch Michelle's video about this course. 1) About 40 hours course for 5 weeks. 2) Training will contain Oracle RAC, ASM and Data Guard topics. In Oracle 12c version. 4) DBA University's e-Book will be provided. 3) Cli...
DBA University Blog: April 2013
http://blog.dbauniversity.com/2013_04_01_archive.html
MS SQL Server DBA Training. Oracle ASM RAC Data Guard Training. Big Data with Hadoop Training. Thursday, April 18, 2013. DBMS RANDOM to generate random numbers and strings. Oracle offers a free to use Oracle Express Edition. Create table emp (emp name varchar2(20),emp number number);. For i in 100000.500000 loop. Insert into emp values(dbms random.string('U',20),round(dbms random.value(40000,400000) );. If one wants to gain advanced skills such as knowing about BULK PROCESSING operations (BULK COLLECT, F...
TOTAL PAGES IN THIS WEBSITE
19
Simply Oracle @RahulG : January 2009
http://onlineerpdba.blogspot.com/2009_01_01_archive.html
Wednesday, January 14, 2009. The Function Is Not Available Under The Responsibility. This issue is caused by launching the menu item before the Compile Security has completed. When a function is added to a menu , a concurrent program 'Compile Security' is submitted which. Loads the data in Fnd Compiled Menu Functions table. Whenever a function is accessed, security code checks Fnd Compiled Menu Functions table to. Loaded with stale data and the reported error message is thrown. 3) Restart Middle tier.
Simply Oracle @RahulG : August 2009
http://onlineerpdba.blogspot.com/2009_08_01_archive.html
Thursday, August 20, 2009. FND Debug Log - Debugging Oracle Apps code. Refernce : http:/ oracle.anilpassi.com. There was a time when every individual Oracle Applications module used its own debugging technique. But this is changing now, thanks to FND Logging. I have been using FND Logging for over one year now, ever since 11.5.10 was released, hence I would like to share knowledge on this topic. What is the use of FND Debug Log? Where is the debug message stored, once the logging is turned on? LEVEL EVEN...
Simply Oracle @RahulG : December 2008
http://onlineerpdba.blogspot.com/2008_12_01_archive.html
Sunday, December 7, 2008. Auditing ddl on a database DDL trigger. Conn / as sysdba. 15:53:53 SQL CREATE TABLE perfstat.STATS$DDL LOG. 15:55:30 3 USER NAME VARCHAR2(25 BYTE),. 15:55:30 4 DDL DATE DATE,. 15:55:30 5 DDL TYPE VARCHAR2(25 BYTE),. 15:55:30 6 OBJECT TYPE VARCHAR2(25 BYTE),. 15:55:30 7 OWNER VARCHAR2(25 BYTE),. 15:55:30 8 OBJECT NAME VARCHAR2(30 BYTE),. 15:55:30 9 TERMINAL NAME VARCHAR2(40 BYTE),. 15:55:30 10 IP ADDRESS VARCHAR2(30 BYTE). 15:55:30 11 );. 15:55:38 SQL conn apps. 15:56:21 20 owner,.
Simply Oracle @RahulG : September 2008
http://onlineerpdba.blogspot.com/2008_09_01_archive.html
Monday, September 15, 2008. ORA-27211: Failed to load Media Management Library. RMAN-00571: = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =. RMAN-00569: = = = = = = = = ERROR MESSAGE STACK FOLLOWS = = = = = = = =. RMAN-00571: = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =. RMAN-03009: failure of allocate command on t1 channel at. ORA-19554: error allocating device, device type: SBT TAPE, device name:. ORA-27211: Failed to load Media Management Library. Oracle process number: 20.
Simply Oracle @RahulG : January 2010
http://onlineerpdba.blogspot.com/2010_01_01_archive.html
Wednesday, January 27, 2010. How to rename a file with junk characters. In our case file name /u42/oradata/ilproddata/a txn ind364.dbf; is having the junk character. Find the name of the junk character file. Select name from v$datafile where name like '%/u42/oradata/ilproddata/a txn ind364%';. U42/oradata/ilproddata/a txn ind364.dbf;. B) On the mount point. Ls -ltr a txn ind364*. A txn ind364.dbf;. Now shutdown the database. Now copy the file to the new name. A txn ind364.dbf* a txn ind364.dbf. Responsib...
Simply Oracle @RahulG : October 2009
http://onlineerpdba.blogspot.com/2009_10_01_archive.html
Sunday, October 25, 2009. ORA-00997: illegal use of LONG datatype. I got this error " ORA-00997: illegal use of LONG datatype" while creating the backup of table with long datatype . SQL create table test as select * from csn user;. Create table test as select * from csn user. ERROR at line 1:. ORA-00997: illegal use of LONG datatype. But above solution is not possible , if tables is highly accessible . In that case , you can go for solution2. Take the export of the table. Username: / as sysdba. Table in...
Simply Oracle @RahulG : Compile INVALIDS of any SCHEMA
http://onlineerpdba.blogspot.com/2010/12/compile-invalids-of-any-schema.html
Friday, December 10, 2010. Compile INVALIDS of any SCHEMA. Earlier to this, I used the following commands to compile INVALID objects of any database. 2 exec utl recomp.recomp parallel(threads= 5). 3 alter package/ procedure compile . comand. I found one more utility that will help us to compile the invalids of any particular schema. Exec dbms utility.compile schema('. Exec dbms utility.compile schema('SCOTT', FAlSE);. We used “FALSE” as we have to compile invalids only not the whole schema. Apps 11i / 12i.
Simply Oracle @RahulG : September 2009
http://onlineerpdba.blogspot.com/2009_09_01_archive.html
Wednesday, September 16, 2009. ORA-29342: user APPS does not exist in the database ; During transport tablesapce option. Plantopiadb:oraperf] /home/users/oraperf imp transport tablespace=y file=/perf/dump/perfdump.dmp log=/perf/dump/perfdump. Import: Release 9.2.0.7.0 - Production on Fri Sep 11 15:45:06 2009. Username: / as sysdba. Connected to: Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production. With the Partitioning, OLAP and Oracle Data Mining options. Importing SYS's objects into SYS.
Simply Oracle @RahulG : May 2009
http://onlineerpdba.blogspot.com/2009_05_01_archive.html
Thursday, May 28, 2009. Alert log monitoring scripts. Export ORACLE HOME=/u11/app/ilproddb/9.2.0. Cd /u11/app/ilproddb/9.2.0/admin/ILPROD ilerpdb01/bdump. Tail -100 alert ${SID}.log $DIR/alert ${SID}.hist. Cat $DIR/alert ${SID}.hist grep ORA- grep -v "ORA-01001: invalid cursor" grep -v "17281" grep -v "ORA-000060: Deadlock de. If [ `cat $DIR/alert.err wc -l` -gt 0 ]. Mailx -s "${SID} ALERT : ORA- ERRORS" erpdba@lgezbuy.com. Posted by Rahul Gupta. Subscribe to: Posts (Atom). Alert log monitoring scripts.
Simply Oracle @RahulG : June 2009
http://onlineerpdba.blogspot.com/2009_06_01_archive.html
Saturday, June 13, 2009. Hi Friends , After monitoring a lot . Finally , I got some solution for this . Now autoconfig time has been reduced by 50 minutes on our site . Try this on your site also , if you've been facing the same problem . Posted by Rahul Gupta. Saturday, June 6, 2009. ORA-12838: cannot read/modify an object after modifying it in parallel. SQL INSERT /* APPEND NOLOGGING */ INTO STATION RATE(ID,COUNTRY,CODE,PURCHASE RATE,STATION ID) SELECT. ERROR at line 1:. Cause of the Problem. Break up ...
TOTAL LINKS TO THIS WEBSITE
16
Domínio LocaWeb
Http:/ blog.dbarquitetos.com/. Este domínio pertence a LocaWeb.
blog.dbase.integralwebsolutions.co.za
dBASE and me
Tuesday, July 28, 2009. A sad day for dBASE'rs - dBASE up for sale. I've been a loyal dbase supporter for many years. Cut my teeth in programming through dBASE III . A few years ago I changed course. Decided to learn a new language, namely C#. Why? Because way back then, with all the failed promises and bad PR I saw the writing on the wall. Myself along with many others, were ridiculed by the dBASE community for leaving, or even daring to look at another language. RIP dBASE, we will miss you. Microsoft A...
DBA Security Advisor Blog – Securing your SQL Server instances at ease!
DBA Security Advisor Blog. Securing your SQL Server instances at ease! Why You Need to Secure Your SQL Server Instances. July 4, 2016. DBA Security Advisor is Now Out! June 28, 2016. Announcing DBA Security Advisor – A Security Tool for SQL Server. June 25, 2016. June 21, 2016. Welcome to DBA Security Advisor’s Blog. June 21, 2016. Why You Need to Secure Your SQL Server Instances. Figure 1: Start Page. Other examples of security risks are: using the same password as the username for SQL Logins, having &#...
Nos conseils et astuces
Nos conseils et astuces. Aller à la recherche. Lundi, juillet 26 2010. Mettre à niveau une base de données standby dans une configuration data guard. Par Bertrand le lundi, juillet 26 2010, 18:26 - disponibilité des données. Vous avez supprimé un fichier archive log avant qu'il ne soit appliqué dans la base standby de votre configuration data guard. Le fichier alert log indique un gap. Le procédé suivant vous permet de mettre la base standby au même niveau que la base principale. Lundi, mars 8 2010.
blog.DBast.com
Important condition to being a social media manager: 1000 followers on Twitter. November 12th, 2012. Social Media Manager qualification: minimum 1000 followers on Twitter. A few weeks ago I tweeted. New rule: if you want to be a social media manager, get 1000 Twitter followers first. The experience is rewarding, esp if you do it well. What the non-profit sector could learn from the tech boom & bust. October 10th, 2012. The “Potatoes” approach to organising events. September 25th, 2012. June 4th, 2012.
DBA University Blog
Saturday, August 5, 2017. How to login to SQL Server if all logins with sysadmin role are disabled. SQL Server 2016 creates a built-in login called "sa" with sysadmin server role. Additionally, several other built-in logins such as NT Service MSSQLSERVER and NT Service SQLSERVERAGENT are also created with the sysadmin fixed server role during the instance creation process (SQL Server installation). The instance id is the default instance id MSSQLSERVER. And make it part of the Administrators OS group.
blog.co.de steht zum Verkauf
Diese Domain steht zum Verkauf! Die Domain blog.co.de wird vom Inhaber im Marktplatz angeboten. Sie können diese Domain jetzt erwerben! Der Inhaber dieser Domain parkt diese beim Domain-Parking-Programm.
dbct-blog
DBC數碼電台 dbc.hk
歡迎投稿 : blog@dbc.hk. 殖民地時期的香港政府初時是實行“不干預政策”的，但到了上世紀七十年代，就發現有必要改變這政策，於是改為實行“積極不干預政策”，所謂“積極不干預”，實質上是“適度干預”。 企業簡介 市盈率 23倍 每股盈利 $0.801 市值 $760億 行業 航空業 集團主席 John Robert Slosar 大股東 太古股份有限公司 45.0% 國泰航空為一家在香港註冊，及以香港為基地的國際航空公司，提供定期客運及貨運服務往來50個國家及地區，共203個目的地。 That is for your own goodReally? 孩子需要什麼 家長，你知道嗎 為了更了解中產家長的脈搏，身為 明勢智庫 召集人的我，最近全身心投身在太古城的社區服務當中，不時在街頭派發宣傳資料或與街坊交流。 從他們書包上的廣告可見，芭蕾舞、繪畫、英語、補習….不錯，大多又是家長所安排的“充實暑假”。 That is for your own goodReally? 孩子需要什麼 家長，你知道嗎 為了更了解中產家長的脈搏，身為 明勢智庫 召集. 周易大義盡藏 乾 坤 二卦中.
:: みみよりなおはなし満載！！DBCA ブログ ::
なお、今年４月から提供している英語の３コース Canine Communication, Canine Behaviour and Training, Canine Aggression につきましても受講料は据え置きとなります。 C) 2015 無料ブログ JUGEM.
dbCasa | Blog Casa
Idee e consigli per la casa. 5 anni dopo: La badante di Condominio. Confabitare soddisfatta dei risultati – Il progetto della badante di condominio nato a Bologna su idea di Confabitare – associazione proprietari immobiliari – oggi è al suo quinto an. Segnali di ripresa dal mercato immobiliare. Iniziano a consolidarsi i primi segnali di ripresa per il mercato immobiliare italiano, durante i primi sei mesi del 2015 la richiesta di case è iniziata a crescere consolidando i primi segnali posit. Ecco una sem...
SOCIAL ENGAGEMENT