Can’t initialize OCI. Error -1

It appears when connect to Oracle and make login fail. The solution to try is to check where is ORACLE HOME and TNS ADMIN location

error 2114: The Server service is not started

Suddenly, my share folder didn’t share files so I go to:
Computer Management > Shared folders > Shares , but i receive this error message:

The following error occurred while reading the
list of shares for Windows clients:
Error 2114: The Server service is not started.

To fix it, try start  go to Administrative Tools > Services > Server, then click Start Service to start it.

OCI.dll could not be loaded in PHP-Apache

I’ve installed XAMP 1.6.6a  and running of apache 2.2.8 and PHP 5.2.5 versions. I also install oracle instant client 10.2.0.1.0 so i want to connect to oracle via php using oci.  I got this message when i start apache

Apache.exe
This application has failed to start because oci.dll was not found. Re-installing the application may fix this problem.

I had try to set these variable

ORACLE_HOME, ORACLE_SID, NLS_LANG

and uncomment the following lines in php.ini file

;extension=php_oracle.dll
;extension=php_oci8.dll;
also
;extension=php_pdo_oci.dll
;extension=php_pdo_oci8.dll

but error message would not dissapear

Then I copy oci.dll to folder apache\bin and restart apache, it works fine now. But make sure your oci.dll from Oracle 10, older version will not work.

You can test it using php.exe -m, if you can’t find any error or warning and you see oci8 in list then congratulations!! you succeed to setup oracle extension.

If another error message, such as

The procedure entry point OCIStmtPrepare2 could not be located in the dynamic link library OCI.dll,

then copy oci.dll to php directory and restart apache and test again

KOKORO NO TOMO – Soulmates

These are the lyrics

ANATA KARA KURUSHIMI O UBAETA SONO TOKI
WATASHI NIMO IKITEYUKU YUUKI NGA WAITE KURU
ANATA TO DEAU MADE WA KODOKU NA SASURAI-BITO
SONO TE NO NUKUMORI O KANJI SASETE

Chorus 1:

AI WA ITSUMO RARABAI
TABI NI TSUKARETA TOKI
TADA KOKORO NO TOMO TO
WATASHI O YONDE

SHINJIAU KOTO SAE DOKOKA NI WASURETE
HITO WA NAZE SU’NGITA HI NO SHIAWASE OIKAKERU
SHISUKA NI MABUTA TOJITE KOKORO NO DOA O HIRAKI
WATASHI O TSUKANDARA NAMIDA HUITE

Chorus 2:

AI WA ITSUMO RARABAI
ANATA NGA YOWAI TOKI
TADA KOKORO NO TOMO TO
WATASHI O YONDE

AI WA ITSUMO RARABAI
TABI NI TSUKARETA TOKI
TADA KOKORO NO TOMO TO
WATASHI O YONDE

The translate,

kokoro no tomo

In Indonesian

KOKORO NO TOMO (Teman Hati)

Kala itu mampu kulepaskan kepedihan dari hatimu
Semangatku pun bergelora menapaki jalan hidup ini
Sebelum bersua denganmu, kesepian aku berkelana
Biar kurasakan hangatnya jemarimu

Chorus 1:

Cinta senantiasa meninabobokkan
Tatkala lelah dalam perjalanan Ingatlah diriku sebagai teman hati
Bahkan hati yang saling percaya terlupa entah di mana
Mengapa orang-orang mengejar kebahagiaan yang telah berlalu
Pejamkan matamu perlahan dan singkapkan jendela hatimu
Raih tanganku dan usap air matamu

Chorus 2:

Cinta senantiasa meninabobokkan
Tatkala lelah dalam perjalanan
Ingatlah diriku sebagai teman hati

Get flv from IE

Here the similar steps to save YouTube videos on your computer from Opera cache, try the following steps:

1. Watch full Youtube video in IEbrowser.

2. Don’t close the IE browser, watch till the end of video.

3. In the Internet Explorer click [Tools] – [Internet Options…] – [Temporary Internet files] – [Settings…] – [View Files…].

4. Sort the files based on Size, find the file that probably that you watch.

5.  Choose the proper file

6. Copy and paste it to your desktop

7. Rename the extension to .flv

8. You can download the free FLV Player from brothersoft.com

9. Now play that flv file with the FLV Player

Get flv from Opera

Here the similar steps to save YouTube videos on your computer from Opera cache, try the following steps:

1.  Watch full Youtube video in Opera browser.

2.  Don’t close the Opera browser, watch till the end of video.

3.  Locate the cache file at following folder C:\Program Files\Opera\profile\cache4

4.  Sort the files based on Size, find the file that probably that you watch.

5.  After the streaming has completed, go back to the Opera cache folder at C:\Program Files\Opera\profile\cache4. Note: Do not close the tab in which you viewed the YouTube video. There should be a large tmp file in the folder

6.  Copy and paste it to your desktop

7.  Rename the extension to .flv

8.  You can download the free FLV Player from brothersoft.com

9.  Now play that flv file with the FLV Player

Get flv from Firefox

When you watch youtube video in firefox and you want to get FLV file of that video, but you don’t know how to get it in easy way. No need to download youtube video from other websites.  You just have to find the file in cache folder of firefox Here is the step by step process.

1.  Watch full Youtube video in Firefox bowser.

2.  Don’t close the Firefox browser, watch till the end of video.

3. Locate the cache file at following folder  C:\Documents and Settings\ADMIN (your Admin login)\Local Settings\Application Data\Mozilla\Firefox\Profiles (one by one),

4. Click single folder there you will get folder “Cache”. click on it. You will find a lots of unknown type files in this folder.

5.  Sort the files based on Size, find the file that probably that you watch.

6.  The file is stil unknown type, so first, copy the file to another folder, such as on desktop

7.  Rename it with FLV extension, something like movie.flv.

Cannot drop Jobs because SYS.DBMS_INTERNAL_LOGSTDBY error

ORA-04063: package body “SYS.DBMS_INTERNAL_LOGSTDBY” has errors
ORA-06508: PL/SQL: could not find program unit being called: “SYS.DBMS_INTERNAL_LOGSTDBY”
ORA-06512: at “SYS.DBMS_IJOB”, line 522
ORA-06512: at “SYS.DBMS_JOB”, line 171
ORA-06512: at line 2

I check this package, i got this error “PL/SQL: ORA-00942: table or view does not exist” but i can’t find what table because this package body wrapped. So i want to find what table that in use in this package. Here the sql to find what table that used in SYS.DBMS_INTERNAL_LOGSTDBY (you must run in 2 server to find what table doesn’t exists) :

SELECT owner, object_type, object_name, object_id, status
FROM SYS.dba_objects
where object_name = ‘DBMS_INTERNAL_LOGSTDBY’;

OWNER OBJECT_TYPE        OBJECT_NAME                                 OBJECT_ID  STATUS
SYS        PACKAGE                   DBMS_INTERNAL_LOGSTDBY 4339               VALID
SYS        PACKAGE   BODY    DBMS_INTERNAL_LOGSTDBY 7300             INVALID

———————————————————————————————————–

SELECT B.*
FROM PUBLIC_DEPENDENCY A, SYS.DBA_OBJECTS B
WHERE A.OBJECT_ID = 7300 AND A.REFERENCED_OBJECT_ID = B.OBJECT_ID AND OBJECT_TYPE = ‘TABLE’
ORDER BY OWNER, OBJECT_NAME;

On my server i have 24 object_name, such as :

AUD$
AUDIT_ACTIONS
COL$
DUAL
FGA_LOG$
IND$
INDPART$
JOB$
OBJ$
TAB$
TS$
USER$
LOGMNR_DICTSTATE$
LOGMNR_LOG$
LOGMNR_SESSION$
LOGMNR_UID$
LOGSTDBY$APPLY_MILESTONE
LOGSTDBY$EVENTS
LOGSTDBY$HISTORY
LOGSTDBY$PARAMETERS
LOGSTDBY$SCN
LOGSTDBY$SKIP
LOGSTDBY$SKIP_SUPPORT
LOGSTDBY$SKIP_TRANSACTION
Now, try to find what table doesn’t exist, copy the script to create table from another server which have the table.  After there are no table miss, compile DBMS_INTERNAL_LOGSTDBY again.

‘javac’ is not recognized as an internal or external command

1. Go to http://java.sun.com and download the latest Version of Java SDK or any Jave SDK that your requirement and install on your system.

2. Accept all of the defaults and suggestions, but make sure that the location where Java will be installed is at the top level of your C: drive.
Click on “Finish.” You should have a directory (folder) named C:\j2sdk1.5.0_04, with subfolders C:\j2sdk1.5.0_04\bin and C:\j2sdk1.5.0_04\lib

3. Modify your system variable called “PATH” (so that programs can find where Java is located).
To do this for Windows 2000 or XP, either right-click on the My Computer icon or select “System” on the control panel.
When the window titled “System Properties” appears, choose the tab at the top named “Advanced.”
Then, click on “Environment Variables.”
In the bottom window that shows system variables, select “Path” and then click on “Edit…” Add C:\j2sdk1.5.0_04\bin as the first item in the list.
Note that all items are separated by a semicolon, with no spaces around the semicolon. You should end up with a path variable that looks something like
C:\j2sdk1.5.0_04\bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\system32\Wbem

For Windows 98 or ME, open the file AUTOEXEC.BAT in Notepad. You should find a line in this file that begins
SET PATH=…
Modify this line to add C:\j2sdk1.5.0_04\bin; immediately after the equals sign.

4. Modify or create a system variable called “CLASSPATH,” as follows.
In the lower “System Variables” pane choose “New…”
and type in Variable Name “CLASSPATH” and value (note that it begins with dot semicolon).;C:\j2sdk1.5.0_04\lib

5. To test Java to see if everything is installed properly, open a command window (a DOS window)
and type the command “javac” The result should be information about the Usage of javac and its options.
If you get a result that “‘javac’ is not recognized as an internal or external command, operable program or batch file” then there is a problem
and Java will not work correctly.