oraclekenya.blogspot.com

Demystifying Oracle

Monday, July 30, 2007. How do i put my database in archivelog? SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jul 13 14:50:13 2007. SQL conn sys as sysdba. SQL select name,open mode from v$database;. SQL shutdown immediate;. ORACLE instance shut down. Total System Global Area 146800640 bytes. Fixed Size 1286220 bytes. Variable Size 71307188 bytes. Database Buffers 71303168 bytes. Redo Buffers 2904064 bytes. SQL alter database archivelog;. SQL alter database open;. OPEN MODE LOG MODE. SERVICE NAME = XE).

http://oraclekenya.blogspot.com/

OVERVIEW OF oraclekenya.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

10

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR ORACLEKENYA.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

August

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Friday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 3.3 out of 5 with 13 reviews

5 star

1

4 star

6

3 star

4

2 star

0

1 star

2

Hey there! Start your review of oraclekenya.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.4 seconds

FAVICON PREVIEW

16x16
32x32

CONTACTS AT ORACLEKENYA.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

10

SSL

EXTERNAL LINKS

0

SITE IP

172.217.11.33

LOAD TIME

0.391 sec

SCORE

6.2

PAGE TITLE

Demystifying Oracle | oraclekenya.blogspot.com Reviews

<META> DESCRIPTION

Monday, July 30, 2007. How do i put my database in archivelog? SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jul 13 14:50:13 2007. SQL conn sys as sysdba. SQL select name,open mode from v$database;. SQL shutdown immediate;. ORACLE instance shut down. Total System Global Area 146800640 bytes. Fixed Size 1286220 bytes. Variable Size 71307188 bytes. Database Buffers 71303168 bytes. Redo Buffers 2904064 bytes. SQL alter database archivelog;. SQL alter database open;. OPEN MODE LOG MODE. SERVICE NAME = XE).

<META> KEYWORDS

1 proceed as follows

2 enter password

3 connected

4 name open mode

5 xe read write

6 database closed

7 database dismounted

8 sql startup mount

9 oracle instance started

10 database mounted

CONTENT

Page content here

KEYWORDS ON PAGE

proceed as follows,enter password,connected,name open mode,xe read write,database closed,database dismounted,sql startup mount,oracle instance started,database mounted,database altered,read write archivelog,posted by,ogutu ochieng,no comments,jaduongtns =

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

Demystifying Oracle | oraclekenya.blogspot.com Reviews

https://oraclekenya.blogspot.com

Monday, July 30, 2007. How do i put my database in archivelog? SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jul 13 14:50:13 2007. SQL conn sys as sysdba. SQL select name,open mode from v$database;. SQL shutdown immediate;. ORACLE instance shut down. Total System Global Area 146800640 bytes. Fixed Size 1286220 bytes. Variable Size 71307188 bytes. Database Buffers 71303168 bytes. Redo Buffers 2904064 bytes. SQL alter database archivelog;. SQL alter database open;. OPEN MODE LOG MODE. SERVICE NAME = XE).

INTERNAL PAGES

oraclekenya.blogspot.com

1

Demystifying Oracle: Cron job to perform an rman backup

http://oraclekenya.blogspot.com/2007/07/cron-job-to-perform-rman-backup.html

Monday, July 30, 2007. Cron job to perform an rman backup. This script will perfom an rman backup of the database in redhat enterprise 3 and automatically delete archive logs and obsolete backups. Obsolete backups are determined by a retention policy. Configure controlfile autobackup on;. Backup database plus archivelog delete input;. Save the script in a file on your operating system and call it using a cron job e.g. 30 20 * * 1-5 sh /home/oracle/rmanbackup.sh. Subscribe to: Post Comments (Atom).

2

Demystifying Oracle: July 2007

http://oraclekenya.blogspot.com/2007_07_01_archive.html

Monday, July 30, 2007. How do i put my database in archivelog? SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jul 13 14:50:13 2007. SQL conn sys as sysdba. SQL select name,open mode from v$database;. SQL shutdown immediate;. ORACLE instance shut down. Total System Global Area 146800640 bytes. Fixed Size 1286220 bytes. Variable Size 71307188 bytes. Database Buffers 71303168 bytes. Redo Buffers 2904064 bytes. SQL alter database archivelog;. SQL alter database open;. OPEN MODE LOG MODE. SERVICE NAME = XE).

3

Demystifying Oracle: Trigger to backup table and send mail

http://oraclekenya.blogspot.com/2007/07/trigger-to-backup-table-and-send-mail.html

Monday, July 30, 2007. Trigger to backup table and send mail. Create or replace trigger dominic details. Before insert on system.details2 referencing old as old new as new for each row. L maicon utl smtp.connection;. Insert into details2 master values(:new.name,:new.marks);. L maicon :=utl smtp.open connection('192.168.1.119');. Utl smtp.helo(l maicon,'oracle');. Utl smtp.mail(l maicon,'dominic@isteducation.com');. Utl smtp.rcpt(l maicon,'dominic@isteducation.com');. Utl smtp.quit(l maicon);.

4

Demystifying Oracle: Sending mail using oracle smtp and plsql

http://oraclekenya.blogspot.com/2007/07/sending-mail-using-oracle-smtp-and.html

Monday, July 30, 2007. Sending mail using oracle smtp and plsql. Create the procedure below in sqlplus. Replace smtpout.kenyadba.com with your mail server. CREATE OR REPLACE PROCEDURE kenyadba send mail (. Mailserver CONSTANT VARCHAR2(30) := 'smtpout.kenyadba.com';. Crlf CONSTANT VARCHAR2(2):= CHR(13) CHR(10);. Mail conn utl smtp.connection;. Mail conn := utl smtp.open connection(mailserver, 25);. Themessage := 'Date: '. TO CHAR( SYSDATE, 'dd Mon yy hh24:mi:ss') crlf. Subject: ' mysubject crlf. Rman scri...

5

Demystifying Oracle: Cracking oracle passwords

http://oraclekenya.blogspot.com/2007/07/cracking-oracle-passwords.html

Monday, July 30, 2007. Download this tool http:/ www.toolcrypt.org/tools/orabf/index.html. And extract it in a folder C: xman. The contents of C: xman should be as shown. Generate the hashes to crack. SQL select username,password from dba users where username='HR';. Fire up dos and cd to xman. Microsoft Windows [Version 5.2.3790]. C: Documents and Settings Administrator cd. C: xman orabf 4C6D73C3E8B0F0DA:hr. Orabf v0.7.6, (C)2005 orm@toolcrypt.org. Let us give it a stronger hash for sys. Cron job to perf...

UPGRADE TO PREMIUM TO VIEW 5 MORE

TOTAL PAGES IN THIS WEBSITE

10

OTHER SITES

oraclejuice.wordpress.com

ORACLE JUICE | Piping hot shots of wisdom

Piping hot shots of wisdom. April 10, 2012. It wasn’t raining, the skies were clear. I thought there would be some smoke or storm approaching. But in the distance, as far as I can see, it is all blue and green and golden. All below me, the people dance. They are so happy with the weather, such a farce. I know I’d prefer it, if it were grey. My world has ended. I feel no anger, no betrayal, just a sharp and sudden joy. There were no consequences now. Not for me. Continue reading →. May 9, 2011. I have don...

oraclejunction.blogspot.com

Yadu's Oracle Junction

Friday, March 20, 2009. How I solved the ORA-08103: object no longer exists problem. Oracle Enterprise Edition 9.2.0.7.0. I had migrated an Oracle database from one server to another using the cold backup. The database came up clean. But the user had complaints saying his select count (*) on some tables gives the error ORA-08103: object no longer exists. But the select * for the same tables was giving the rows! I tried the following. SQL Select * from test;. SQL Select count (*) from test;. SQL SELECT db...

oraclejunctionbookshop.com

Home Page

Oracle Junction Bookshop Online. Buffalo, New York. Page 2 - Catalogs. We Make House Calls. We are a used, rare and collectible book store in the Buffalo New York area. We have been in business with a brick and mortar store for nearly 30 years, and now we are online only. We have books in all fields: Children's, First Editions, History, Architecture, Military, and more as well as ephemera items like magazines and science fiction pulps. . Search Our Inventory at ABE Books.

oraclekai.deviantart.com

oraclekai (Michael David Agard) - DeviantArt

Window.devicePixelRatio*screen.width 'x' window.devicePixelRatio*screen.height) :(screen.width 'x' screen.height) ; this.removeAttribute('onclick')" class="mi". Window.devicePixelRatio*screen.width 'x' window.devicePixelRatio*screen.height) :(screen.width 'x' screen.height) ; this.removeAttribute('onclick')". Join DeviantArt for FREE. Forgot Password or Username? Deviant for 13 Years. This deviant's full pageview. Last Visit: 3 weeks ago. This is the place where you can personalize your profile! Please, ...

oraclekc.com

Oracle Fine Curiosities

130 W 18th St. Kansas City, MO 64108. Oracle Kansas City - Taxidermy, Skulls, Framed Insects and Natural Science Curiosities. Your Custom Text Here. A natural science curiosities shop. Located in Kansas City, MO. We specialize in sustainably sourced animal specimens, taxidermy, minerals, framed insects and butterflies. We provide workshops and classes to promote education and creativity in our fields, as well as venturing into the occult with tarot, numerology, and astrology. What we're up to right now:.

oraclekenya.blogspot.com

Demystifying Oracle

Monday, July 30, 2007. How do i put my database in archivelog? SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jul 13 14:50:13 2007. SQL conn sys as sysdba. SQL select name,open mode from v$database;. SQL shutdown immediate;. ORACLE instance shut down. Total System Global Area 146800640 bytes. Fixed Size 1286220 bytes. Variable Size 71307188 bytes. Database Buffers 71303168 bytes. Redo Buffers 2904064 bytes. SQL alter database archivelog;. SQL alter database open;. OPEN MODE LOG MODE. SERVICE NAME = XE).

oraclekerala.com

Techno Spencer Notebooks|Oracle Kerala|Notebook Dealers in Thrissur

oraclekey.blogspot.com

Oracle Supply Chain and Inventory Free Learning

Oracle Supply Chain and Inventory Free Learning. This blog is about oracle supply chain and inventory technical,functional information and learning. Wednesday, October 5, 2011. How to Define Oracle Inventory Organization. Optional step before defining inventory organization. 1 Now In Inventory responsibility navigate to. 160; Setup - Organizations - Organizations. Enter organization name and type from pre defined list. In this case this organization is defined as Master Org. Posted by Muhammad Usman.

oraclekhemsanu.com

Welcome oraclekhemsanu.com - BlueHost.com

Web Hosting - courtesy of www.bluehost.com.

oracleking.blogspot.com

Oracle pl sql King

Oracle pl sql King. Wednesday, June 29, 2011. SBL-OMS-00203: Error (null) invoking method "(null)" for Business Service "(null)". We recently implemented Siebel and keep running into a few SBL errors now and then. We were being bugged by a SBL-OMS-00203 and here is a solution that worked for SBL-OMS-00203. Saturday, May 14, 2011. ORA-00904 and ORA-01722 calls from developers. I am surprised that many of the developers cannot even solve simple oracle errors like ORA-00904. Friday, July 16, 2010. Sun Ray S...

oracleking.com

KX 澳永国际期货平台

Vul uw naam in. Vul een geldig e-mailadres in. Vul uw wachtwoord in. Vul uw wachtwoord in. Vul uw wachtwoord in. Vul uw wachtwoord in. Vul uw wachtwoord in. Vul uw wachtwoord in. Oracle FX澳瑞克是一家国际顶级外汇经纪商,全名Oracle Finace International INC. 中文名澳瑞克国际金融集团，成立于2013年，注册地澳大利亚，Oracle(澳瑞克)接受澳大利亚ASIC监管牌照号 402043 ，为不断增长的客户群体提供更优质与安全的服务。与此同时，Oracle(澳瑞克)加入Financial Ombudsman Service 澳大利亚金融申诉服务机构，FOS编号 25914。请求信息 : 2018-04-13 14:01:17 HTTP/1.1 GET : www.oracleking.com/. 查询信息 : 46 queries 16 writes. D: guojiqihuo s...