Monthly Archives: February 2012

i effort to try recover my Oracle DB and i got “ORA-00310”

Posted on by

0

ORA-00310:
archived log contains sequence string; sequence string required

Cause:
The archived log is out of sequence, probably because it is corrupted or the wrong redo log filename was specified

Action:
Specify the correct redo log file; then retry the operation.

😦

i tried to recover my Oracle DB with my archivelogs with :

recover database until cancel

and oracle forced me to recover my oracle DB with backup control file

so i did that :

recover database using backup controlfile

and i got :

ORA-00279: change 15264915 generated at 02/24/2012 07:30:43 needed for thread 1
ORA-00289: suggestion :
/media/data1/backup_KANTIN/archivelogs/1_410_739018536.dbf
ORA-00280: change 15264915 for thread 1 is in sequence #410
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

I tried with using  AUTO mode but my oracle redo log sequence had not find the archived file.

1_410_739018536.dbf

My archived file just till 1_409_739018536.dbf.

Here i knew there were some things wrong with my redo log sequence . . . . . .

After browsing and browsing . . . . in my case,

I just need to recover my corrupted redo log file . . . .  with :

find INACTIVE redo log status.

SELECT a.group#,a.status, a.member, b.bytes  FROM v$logfile a, v$log b WHERE a.group# = b.group#;

try again to recover my database and type the INACTIVE redo log file:

shutdown immediate;

startup mount;

recover database using backup controlfile

ORA-00279: change 15264915 generated at 02/24/2012 07:30:43 needed for thread 1
ORA-00289: suggestion :
/media/data1/backup_KANTIN/archivelogs/1_410_739018536.dbf
ORA-00280: change 15264915 for thread 1 is in sequence #410

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

/media/data1/oracle/oradata/orcl/redo01.log

Log applied.
Media recovery complete.

alter database open resetlogs;
Database altered.

and finally, there happily ever after . . . . . .

enjoy friends! hope my review has helped your problem.

 source :

#http://myoracledba.blogspot.com

#http://www.ardentperf.com/2007/05/09/controlfile-recovery-requires-resetlogs/

 

 

Epson LX-300,LX800, else dot matrix printers on ubuntu? How?

Posted on by

0

Ok, now day i ll share “how to install dot matrix printers driver on Ubuntu?” . . . .

There re many peoples scared with ubuntu, because it’s so strange and difficult. . . . .? is it?

Of course not!! for example i ll demonstration about this one!!!

In ordinary, ubuntu was detecting many printers at first time plugged. . .

but not all printers could.

For particular printer needs  to add dependency installed, or driver  installed. . . . .

In this case U have to install dependency or driver required . . . . . .

for “how to install dot matrix printers”

here it’s :

1. You have to download Epson-Dot_Matrix-epson.ppd

download here

2. Go to :

System >Administration >Printing

Click Add :

and then U ll see New Driver, on the Tab Devices choose LPT #1 Port ( if necessary, adjust it with port dot matrix printer device  )

and Ubuntu will find your dot matrix printer driver (do not close the window, keep it searching)

3. Involve your Epson-Dot_Matrix-eposn.ppd

On Tab Chose Driver choose provide PPD file.

browse and find your Epson-Dot_Matrix-eposn.ppd file

4. Forward >>Apply>> and Test Print

just simple, not difficult. . . . .

do not give up with ubuntu . . . . there re many things are fabulous on ubuntu stuff . . . .

#source : http://imgos-belajarlinux.blogspot.com

 

 

 


 

Oracle PLSQL named system exceptions

Posted on by

0

Oracle Exception Name Oracle Error Explanation :

DUP_VAL_ON_INDEX

ORA-00001

You tried to execute an INSERT or UPDATE statement that has created a duplicate value in a field restricted by a unique index.

TIMEOUT_ON_RESOURCE

ORA-00051

You were waiting for a resource and you timed out.

TRANSACTION_BACKED_OUT

ORA-00061

The remote portion of a transaction has rolled back.

INVALID_CURSOR

ORA-01001

You tried to reference a cursor that does not yet exist. This may have happened because you’ve executed a FETCH cursor or CLOSE cursor before OPENing the cursor.


NOT_LOGGED_ON

ORA-01012

You tried to execute a call to Oracle before logging in.

LOGIN_DENIED

ORA-01017

You tried to log into Oracle with an invalid username/password combination.

NO_DATA_FOUND

ORA-01403

You tried one of the following:

1. You executed a SELECT INTO statement and no rows were returned.
2. You referenced an uninitialized row in a table.
3. You read past the end of file with the UTL_FILE package.

TOO_MANY_ROWS

ORA-01422

You tried to execute a SELECT INTO statement and more than one row was returned.

ZERO_DIVIDE

ORA-01476

You tried to divide a number by zero.

INVALID_NUMBER

ORA-01722

You tried to execute an SQL statement that tried to convert a string to a number, but it was unsuccessful.

STORAGE_ERROR

ORA-06500

You ran out of memory or memory was corrupted.

PROGRAM_ERROR

ORA-06501

This is a generic “Contact Oracle support” message because an internal problem was encountered.

VALUE_ERROR

ORA-06502

You tried to perform an operation and there was a error on a conversion, truncation, or invalid constraining of numeric or character data.

CURSOR_ALREADY_OPEN

ORA-06511

You tried to open a cursor that is already open.

 

The syntax for the Named System Exception in a procedure is:

DECLARE

[anonymous]

BEGIN

executable_section

EXCEPTION
WHEN exception_name1 THEN
[statements]

WHEN exception_name2 THEN
[statements]

WHEN exception_name_n THEN
[statements]

WHEN OTHERS THEN
[statements]

END [procedure_name];

How to set your Oracle Database to “Archivelog Mode”

Posted on by

0

 

 

Type this command on oracle mysql> :

shutdown immediate;

startup mount;

alter database flashback on;

alter database archivelog;

alter database open;

If you want to change your default archive destination, type and run this command on oracle mysql> :

description :

the startup command will use a temporary file as pfile with the following init.ora parameters :

alter system set log_archive_dest_10 = “location=your_archive_destination  optional reopen=300″ scope=spfile;

mine :

alter system set log_archive_dest_10 = “location=/media/data2/madinah_backup/arcivelog/  optional reopen=300” scope=spfile;

A bit share “How to install Netbean On Ubuntu…”

Posted on by

0

What is Netbean ?

The NetBeans IDE is an award-winning integrated development environment available for Windows, Mac, Linux, and Solaris. The NetBeans project consists of anopen-source IDE and an application platform that enable developers to rapidly create web, enterprise, desktop, and mobile applications using the Java platform, as well as JavaFX, PHP, JavaScript and Ajax, Ruby and Ruby on Rails, Groovy and Grails, and C/C++.

How to install Netbean?

1. Download netbean+jdk here :

http://www.oracle.com/technetwork/java/javase/downloads/jdk-netbeans-jsp-142931.html

2. Run this command to install netbean :

sh netbeans-6.9rc2-ml-linux.sh

3. Following the step by step next>>next>>next until finish

and you will see Netbean on menu Applications > Programming > Netbeans.

hope that was helped U!!!

enjoy . . . . and see yaa!

 

I tried to connecting my Mysql ODBC with my php mysql DB and i got . . .

Posted on by

0

🙂 Hi friends nice to see U!

emmmm smile like trouble . . . . .

OK let’s talking about my trouble,

it’s “i tried to connecting my “Mysql ODBC”(VBOX) with my php Mysql DB”(UBUNTU).

and at first time i tried, i got  :

“[MySQL][ODBC 3.51 Driver]Can’t connect to MySQL server on ‘172.16.8.13’ (10061)“

Ok why? I thought it just about my “Mysql DB connection’s setting”

And my guess was correct!

1. i opened my web-mint at “http://localhost:10000” then

2. MySQL Database Server >> MySQL server listening address >>  i had 2 options here “127.0.0.1” and  “Any” with default “127.0.0.1”  option.

i changed it  on “Any ” option.

and then i tried again to connecting . . . . . . woooooo i got an other kind of error :

“[MySQL][ODBC 3.51 Driver]Host ‘172.16.8.63’ is not allowed to connect to this MySQL server“

T.T

Why? What kinds of trouble again?

😦 after just googling at my whole day, the trouble was  simple, it was about privileges of Mysql DB.

You just need adding “Any Host privileges”  to your Mysql DB.

1. open web-mint at “http://localhost:10000” then

2. MySQL Database Server >>User Permissions>>Create new user

Username : root

Password : your_password

Host : Any

Permissions : Shift and select all options on there

Save your “Create New User” and i tried again : alhamdulillah it was connecting.

🙂  if U have some trouble like me, hope my reviewed could help U, of course!

Have a nice day and see yaa!

 

How to install Google Chrome on Ubuntu :)

Posted on by

0

 

After vacuum,there re no internet,no blog, no twitter,no FB,etc.

Now, i ll share how to install my best browser ever. it calls GC(Google chrome)!

There re many reason why people change fire Fox to Google chrome instead.

But the exactly  one. . . . on many2 research,with a lot of tabs and many numbers of plugins has installed.

Then the browsing experience is horrible. On the other hands, GC has decent speed performance!

GC is faster on speed or stability.

Installing Google Chrome on Ubuntu

1 Get the debian package of chrome from :

Download Google Chrome

2. Type this script to install GC :

sudo dpkg -i file_name.deb
>
sudo dpkg -i google-chrome-stable*.deb

If any dependency error occurs then run the following command(s)

sudo apt-get install -f

or you can install dependent libraries/program manually like this :

sudo apt-get install libnspr4-0d sudo apt-get install libcurl3

enjoy!! let’s browsing with GC

 

source : http://www.noobslab.com

ice cream factory lable!

Posted on by

0

 ICE CREAM  CROWN !

i have no reason, why i have build something like this one! . . . . but enjoy it!

 

NEW NAME, NEW PASSION!

that was my first posting in my new domain, enjoy friends . . . . .

 

@asmanadia was said to me :

do not be shy to write,

just write something,

all from your heart and make sniper tactics,

it’s #no excuse’!

just do it man!