Latest

 

How to protect and unprotect Excel sheet with or without password

he tutorial shows how to protect Excel sheet with or without passwords. It also explains how to unlock Excel spreadsheet without password if you forgot or misplaced it. …

Resize Hard Disk Operation For This Format Is Not Implemented Yet

Long time VirtualBox users will know that VirtualBox doesn’t support resizing virtual hard drive via its settings. In one of our earlier posts, we discusse Source: Resize Hard Disk Operation For This Format Is Not Implemented Yet …

How to check if an email is hosted with an Office 365 account

Once a domain is added and verified into Office 365 there is a default domain appended to every tenant. You can view your tenant setup by going to Setup and Domains within the admin portal. Typically, when you do the registration most admins …

networking – What DNS servers am I using? – Unix & Linux Stack Exchange

case Source: networking – What DNS servers am I using? – Unix & Linux Stack Exchange …

Configure Static IP Address in CentOS

After installing CentOS you will wan’t to configure IP address. CentOS is mostly used as Server. So you will want to give it a static IP address. By default CentOS interface is configured to receive IP from DHCP server. Here …

Divi Code Snippets

/*** Remove Footer ***/ .bottom-nav { display: none; } …

How to Login to the Hitron-Technologies BVW-3653

Written by Rachel Bauer This page shows you how to login to the Hitron-Technologies BVW-3653 router. Find Your Hitron-Technologies BVW-3653 Router IP Address We need to know the Internal IP Address of your Hitron-Technologies BVW-3653 router before we can login to …

How to play Laz Rojas’ WolfenDoom with GZDoom port

As these wads where hard enough to get going on older Windows XP & 7, now with Windows 10 its harder. With the addition of updated or new Doom Source ports I wanted to get these wads play nice on …

Chapter 8. VBoxManage

vboxmanage-modifyvm-other Source: Chapter 8. VBoxManage …

How to load the classic workspace in AutoCAD Architecture or AutoCAD MEP | AutoCAD Architecture | Autodesk Knowledge Network

Source: How to load the classic workspace in AutoCAD Architecture or AutoCAD MEP | AutoCAD Architecture | Autodesk Knowledge Network …

How to resize a virtualbox VDI disk under windows | derekmolloy.ie

Describes how to resize a linux virtualbox vdi drive under windows host Source: How to resize a virtualbox VDI disk under windows | derekmolloy.ie …

Oracle Database Preinstallation Tasks and Setting a local repo on CentOS 6.9

Copy the ISO file into the VM (i.e. Downloads folder) and create a dir to use to mount the ISO to: mkdir -p /var/OSimage/OL6.9_x86_64 Mount the directory with ISO file to a path: mount -o loop, ro /home/oracle/Downloads/CentOS-6.9-x86_64-bin-DVD1.iso /var/OSimage/OL6.9_x86_64/ Go …

menus – Walker_Nav_Menu exeption – WordPress Development Stack Exchange

Source: menus – Walker_Nav_Menu exeption – WordPress Development Stack Exchange …

Computer wakes up from Sleep mode immediately – Microsoft Community

Source: Computer wakes up from Sleep mode immediately – Microsoft Community …

Greek | Phrases – Business | Letter

Copyright © bab.la …

How to unlock a Microsoft .docx document? – Super User

DocX is a compressed zip container file. Make a copy of the original docx file. If you unzip it, there is a subfolder named word with a file named settings.xml. You can open settings.xml with a plain text editor.Within that …

Workaround to avoid VBA passwords

How to Remove a Password Now for the difficult part, although it’s really quite straightforward once you know what you’re doing. First, we’re going to need to download a hex editor. If you don’t have one already, HxD is a …

How to Fix a Corrupted Windows 10 Installation

System corruption is the worst that could happen to your Windows installation. We show you how to get Windows 10 back on track when suffering from BSODs, driver errors, or other unexplained issues. …

Windows 10 file explorer not responding – Refresh Windows Update

I see several people are having a similar issue and none of the posted solutions I’ve tried have worked for me. I’ve deleted antiviruses, run the SFC, installed updates, rebooted several times. Source: Windows 10 file explorer not responding – …

Disable WGA Notification on Windows XP

Windows Genuine Advantage (WGA for short) is a Windows Update component rolled out to XP users long after XP was released. It is intended to validate your …

Color for current language and display languages – WPML

/* WPML Current Menu */.current-language a { color: #00b5b5 !important; } Source: Color for current language and display languages – WPML …

Automatic Grant Permission to Make MoreLangs Work on Android 4.2+

First: Install MoreLangs First What you need Computer (Windows Only) Usb cable Connect you Phone to Computer(PC) (Windows Only)   Step 1. …

How To Add a Social Icon in Divi WordPress Theme From Elegant Themes

Learn how you can add a new Social Icon in Divi WordPress Theme From Elegant Themes. Source: How To Add a Social Icon in Divi WordPress Theme From Elegant Themes …

Solved: The driver detected a controller error on \Device\Ide\IdePort2

My son and I went through rather painful ordeal with this Event 11 that Windows quietly generates. It took us few weeks to fully work out why Windows suddenly started hanging, misbehaving or even c Source: Solved: The driver detected …

Hosted OpenEMR – OpenEMR Project Wiki

Source: Hosted OpenEMR – OpenEMR Project Wiki …

Remove Locky Files Virus (_Locky_recover_instructions)

How to Remove Locky Files Virus? A vicious ransomware named Locky which demands payment through a Tor website – all Marvel fans should be quite impressed right now. Unfortunately, this wordplay is the first and last fun experience that the …

How to Set Up VPN in Windows 7 | PCWorld

Set up a virtual private network in a few simple steps. Source: How to Set Up VPN in Windows 7 | PCWorld …

Google Docs — Support — WordPress.com

Source: Google Docs — Support — WordPress.com …

OneDrive for Business stops syncing libraries, or the icon overlays don’t appear on synchronized files and folders after you install Office 2016

PROBLEM Consider the following scenario. You upgraded to Office 2016 on your computer. When you use OneDrive for Business, your libraries stop syncing and the icon overlays don’t appear on synchronized files and folders. SOLUTION To resolve this issue, perform these …

Setting the Sent Items folder for IMAP accounts in Outlook 2013 – MSOutlook.info

Outlook 2013’s IMAP implementation has changed quite dramatically when compared to previous versions of Outlook. While it does do a better job at getting the special folders correct more often, there sadly is no more option to change it manually …

How to install Code::Blocks with a Fortran compiler

To install a Fortran compiler (gFortran) to be used within the Code::Blocks IDE editor: Go to http://www.codeblocks.org/downloads Click on “Download the binary release” Click on “Windows 2000/XP/Vista/7//8” Click on “codeblocks-13.12mingw-setup.exe” to download from SourceForge.net Once downloaded (~100MB), install Code::Blocks IDE Full …

How to add a Data Source on Oracle 11G Weblogic with JDeveloper 11gR2

To add a Data Source from JDeveloper: View > Application Server Navigator Application Servers > IntegratedWebLogicServer R-click > Launch Administrative Console… -that should be i.e. like “http://127.0.0.1:7101/console/login/LoginForm.jsp” Login with user/password From Domain Structure open Services > select Data Sources New …

How to remove a “not a member of the local group” user in Windows XP Home

You receive the following error when you try to delete a local user account in Windows XP Home: Remove Domain NameComputer Name. Error 1377: The specified account name is not a member of the local group. Error removing Domain NameComputer …

How to check a Hard Disk’s health status

You can check the health of your hard disk by using a command in Windows (S.M.A.R.T.). Start a cmd window wmic diskdrive get status This should output the following result: status ok ok   …

How to create a simple Backup script using windows HTA

Prerequisites: a notepad (I recommend: notepad++) some HTML knowledge Start a simple HTML page and add the following as the main structure:<head> <title>Backup Reminder</title> <HTA:APPLICATION APPLICATIONNAME=”Backup Reminder” ID=”myware” VERSION=”1.0″ CAPTION=”yes” BORDER=”normal” SYSTEMMENU=”yes” MAXIMIZEBUTTON=”no” MINIMIZEBUTTON=”no” ICON=”gumware.ico” SCROLL=”no” SCROLLFLAT=”yes” SINGLEINSTANCE=”yes” CONTEXTMENU=”yes”/><style> img{border: …

How to create a multiboot USB with XBoot 1.0 b14

Repartition and format the USB: Primary volume, 4k cluster size (default), FAT32 format. XBoot requires dot.NET Framework 4.0 installed on the system it will be run off Download a copy of XBoot 1.0 beta 14 and run it, not install …

How to make Firefox search from the address bar

1. Type the following in the address bar: about:config 2. In the search field type: keyword Result: keyword.URL keyword.enabled 3. Double-click “keyword.enabled” to be set to false. 4. Double-click the “keyword.URL” to set your source search engine: Bing: http://www.bing.com/search?q   …

Create a Data Generator using sequence and a loop in Oracle DB

Create a sequence (i.e. “tmp” starting with 10001) to be used in statements: CREATE SEQUENCE TMP START WITH 10001 MAXVALUE 9999999999999999999999 MINVALUE 1 Enter the following in a DB-Tool editor: begin FOR Lcntr IN 1..10000 LOOP insert into customer (surname, …

How to create a bootable usb to install Windows X

Firstly, insert your USB  (WARNING: the following steps will erase ALL DATA on selected USB!!). Open a cmd prompt and type “diskpart” to start the partitioning program: list disk # <– to list the disks on the system # Disk …

JMS error when running/debugging ADF application with JDev (10g)

If you get the following or similar error: OC4J – (SEVERE) Failed to set the internal configuration of the OC4J JMS Server with: XMLJMSServerConfig (jms.xml) You may need to delete all contents within the “persistence” folder: jdev10.1.3.5.adfjdevsystemoracle.j2ee.10.1.3.43.6embedded-oc4jpersistence …

How to Factory Restore the system for various PC models

Lenovo S10 : Lenovo OneKey Rescue System v7.0 Press the “OneKey Recovery” button on right side of display (like and upside-down U) Click on “OneKey Recovery” icon on screen Choose “Restore from initial backup” and click “Next” WARNING: ALL YOUR DATA/PARTITIONS …

How to fix VB application not running on Windows Vista, 7 or 8

Older VB application built on VB 5 or 6 may not work properly under the newer versions of Windows Vista, 7 or 8. The app may even require specific dll or other file to be registered on the system. You …

How to remove the number next to JDeveloper caused by SVN

The reason you get some numbers next to file names of JDeveloper (or IPs on project names) is because subversioning is enable in your JDeveloper’s options. To disable and continue to use your external subversioning system do as follows: From …

How to manually restore Sage Line 50 v9.x data files

This is what you need to do if your Sage Accounts application has been corrupt and you can’t open it: Save your data files directory (SageAccounts) Uninstall/completely remove the Sage installation Re-install Sage Line 50 v9.x Start Sage and complete …

How to check the version of an Oracle Database with PL/SQL

Login to the database and execute the following: select * from v$version; –OR: select * from product_component_version; Result: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – 64bit Production PL/SQL Release 11.1.0.7.0 – Production CORE    11.1.0.7.0    Production TNS for 64-bit Windows: …

How to install VB 6.0 with SP6 on Windows 7

1. Install Visual Basic 6.0 (as Administrator) Select custom install as follows: Microsoft VB 6.0 Active X Data Access Graphics 2. Skip MSDN and all other install options (Source Safe, VC++, etc). 3. Uncheck registration and complete the setup. 4. …

How to create a System Repair Disc for Windows 7

Creating a System Repair Disc can solve you a few boot problems encountered with Windows 7. Note the OS type (x32 or x64 bit) Insert an empty DVD into your drive Start > Programs > Maintenance > Create a System …

How to install Windows 7 on HP-3400 Pro PC with FreeDOS

Note: Some business-line PCs may come with pre-installed non Windows OS like FreeDOS. These systems most probably use Linux as there main boot system and this is why a typical Windows installation may not boot properly in some cases. Case: …

How to compile a single form from command-line Oracle Forms 11g

Create a batch file and enter the following: @echo off echo. echo. echo. :: set varables set FRMCMP=c:OracleMiddlewareas_1binfrmcmp.exe set FORMS_DIR=c:UsersAdministratorjavaprojectsDOMAIN_NAMEFormsReportsSystemForms set USER_PATH=c:UsersAdministrator set DEST=c:FORM_EXECUTABLES :: get input from console set /p choice=  Type the form name (w/o extension): set …

Webutil syntax for GET_FILE_NAME/CLIENT_GET_FILE_NAME function

FUNCTION GET_FILE_NAME (or CLIENT_GET_FILE_NAME) (directory_name   VARCHAR2, file_name        VARCHAR2, file_filter      VARCHAR2, message          VARCHAR2, dialog_type      NUMBER, select_file      BOOLEAN; Params descriptions directory_name = Specifies the name of the directory containing the file you want to open. The default value is NULL. If directory_name …

How to use Webutil in Oracle Forms 11g to save a file on Oracle AS 11g

Before you go into any development download and try the Webutil Demo first and see how that works in your environment! 1. Add the Webutil library to the form 2. Create a Data Block “COMMAND_LINE” 3. Create a new layout with …

How to open Oracle Forms URL and then hide its IE started window

You need to open an Oracle Forms 11g url, which in turn will open a new IE window -but you want to somehow get rid of the first IE window. 1. Create a new html file i.e. “openWindow.html”, under %ORACLE_HOME%formsjava …

How to close the internet browser window after forms 11g is called

You will need to modify your main entry form procedure and place some javascript code to close the browser window. 1. Create a new html file i.e. “closeWindow.html”, under %ORACLE_HOME%formsjava as below: <html> <body onload=”closeWindow()”> <script type=”text/javascript”> function closeWindow() { …

RegEx use in Find with PLSQL Developer

The following are supported regular expression operators for use in PL/SQL Developer by Allround Automations:a+ One or more occurrences of a a* Zero or more occurences of a a? Zero or one (i.e. optional) occurence of a a{n} Exactly n …

How to check the java version of an Oracle Database

Create a function in the DB to retrive the java properties: CREATE OR REPLACE FUNCTION get_java_property(prop IN VARCHAR2) RETURN VARCHAR2 IS LANGUAGE JAVA name ‘java.lang.System.getProperty(java.lang.String) return java.lang.String’; Then, run the following command to output the Java version: SELECT get_java_property(‘java.version’) FROM …

How to setup Webutil for forms 11g R1 (11.1.1.2.0)

Notes: – frmwebutil.jar already exists/is signed on 11g – tested with JRE version 1.6.0_25, webutil 1.0.6, jacob 1.10.1_b17 – windows 7, 32bit 1. Download webutil_1.0.6  (or from oracle’s index page) and jacob_1.10.1_b17 (or from project page) jar files. 2. Copy …

How to capture input from a command prompt / batch

Write the following in a batch file and say the input was “andreas”: @echo off echo == Capture Input === set server=192.168.1.12 SET /P Choice=Type your Username and press Enter: echo Logging on to %server% with %choice%… Output: Logging …

How to automate a commit/update with Tortoise SVN using a batch file

Your SVN project should already be checked out. Enter the following in a batch file (.bat): @echo off echo. echo. :: The two lines below should be changed to suit your system. set SOURCE=C:projectsmy_svn_project set SVN=C:Program FilesTortoiseSVNbin echo. echo. …

How to login with Windows Telnet automatically using vbs

Enter the following script and save it as a .vbs file: Set obj = CreateObject(“WScript.Shell”) obj.run”cmd” WScript.Sleep 500 obj.SendKeys”telnet your.ip.add.ress” obj.SendKeys(“{Enter}”) WScript.Sleep 500 obj.SendKeys”username”  ‘telnet username obj.SendKeys(“{Enter}”) WScript.Sleep 500 obj.SendKeys”password”  ‘telnet password obj.SendKeys(“{Enter}”) WScript.Sleep 500 …

Total Commander vs Windows Explorer

How would the typical Windows Explorer compare to alternative file manager Total Commander:  Total Commander  Windows Explorer  Two pane window view Instant view of source and destination and no scrolling via a tree-view or loose any open path Full Keyboard …

How to change the Look and Feel of Oracle Forms 11g

C:OracleMiddlewareuser_projectsdomains<domain_name>configfmwconfigserversWLS_FORMSapplicationsformsapp_11.1.1configformsweb.cfg … lookandfeel=Generic … lookAndFeel=windows The change is instant, no need to reload the services. …

How to install Oracle Application Express 4.1 with Database XE 11.2g

Download and install Oracle Database XE 11.2g Download Oracle Application Express 4.1 (APEX) Tip: In case you get an ORA-12560 error, your database listener has not started. Either start it by running “c:oraclexeapporacleproduct11.2.0serverbinStartDB.bat” or use  the “Start DB” shortcut from …

How to set forms 11g buttons to display icons

Simple way Copy your images to: c:OracleMiddlewareas_1formsjava Notes: – Icon files may not be supported. – In case of a Java security issue when using gif images, you will need to create a jar file and sign it with oracles …

How to configure a Weblogic 11g VM if moved or copied

When you move or copy a WebLogic 11g environment setup as a VM from one host PC to another, you will encounter various IP connection problems (may also be needed if you have problems debugging forms). To help make a …

How to set PL/SQL Developer or TOAD to use a different oracle instance

Whether you have an oracle home setup or not: * copy/setup PL/SQL Developer or TOAD to your system * copy/setup Oracle Instantclient to your system * add a System PATH Variable for Instantclient i.e. c:usersoracleinstantclient -if this is a 2nd …

How to tail log, trc, etc. files on Windows

Find a “tail” cmd-line program like “tail-f” or “WinTail” (gui) and load to your c: path. I’ve been using tail for windows by TriSun Software Inc. and does the job fine and its FREE! Typical usage: c:tail.exe -f c:myfile.log #log …

How to expand, shrink or do other disk operations in VMware from cmd

In most cases to utilise your vm-disk it needs to be dynamic. So if you have preallocated space for your disk then convert it to a dynamic one. # make the vm-disk from pre-alloc. to dynamic (-t 0 = dynam. …

How to install Oracle Forms and Reports 11g on Windows XP 32bit

specs: Pentium Dual 2.2 64bit, 5 GB mem, Windows XP 32bit reqs: WinXp SP2 or later, 1GB Memory, time: Oracle Weblogic: 10 min, Fusion Middleware: 40 min setup, 50 min config Download Weblogic Server 10.1.3.2 (11g) from here Tip: look …

How to quickly cancel Autologin on Windows XP

Open the Run dialog and enter the following: control userpasswords2 The User Accounts dialogue opens up and you should select the option: Users must enter a user name and password to use this computer …

How to tail live log files on Linux

To tail a file use: tail -f -v Name_of_file_*.log …

How to set PL/SQL Developer to use a different HOME and OCI library

From within PL/SQL Developer: Tools > Preferences, Under Oracle > Connection * Oracle Home… (point to where tnsnames.ora file is, under the Oracle Client Installation) c:Users<username>oracleinstantclientnetworkadmin * OCI Library… (point to where the OCI library is placed of the same …

How to install Oracle Forms and Reports 11g on windows 7 64bit

specs: Pentium Dual 2.2 64bit, 5 GB mem, Windows 7 64bit reqs: Win7 x64, 1GB Memory, Administrator time: Oracle Weblogic: 5 min, Fusion Middleware: 23 min setup, 16 min config Download Java JDK 6u25 x64 (jdk-6u25-windows-x64.exe) Download Weblogic Server 10.1.3.2 …

Trace and Alert log files on Oracle Database Server (11g)

Trace and Alert log files Root ‘log dump’ location: select value from v$parameter where name = ‘background_dump_dest’; /u01/app/oracle/diag/rdbms/db_name/trace Find the trace file path of current session use the following PL/SQL snippet: select u_dump.value || ‘/’ || db_name.value || ‘_ora_’ || …

How to build a Java app and load it into an Oracle DB

Create the Java class public class Hello2 { public static String hello() { return “Hello World.”; } public static String hello(String name) { return “Hello ” + name + “.”; } public static void main(String args) { System.out.println(Hello2.hello()); System.out.println(Hello2.hello(“Java”)); } …

How to set an Oracle DB 10g to start automatically

Login to where the Oracle DB is installed and vi as root vi /etc/oratab Edit the file, find and set the lines as follows: orcl:/u01/app/oracle/product/10.2.0/db_1:N vi cmd to type Insert key orcl:/u01/app/oracle/product/10.2.0/db_1:Y vi cmd Esc to exit editing vi cmd …

How to find the ORACLE_HOME path for Oracle DB 10g

Login to the server which you have the DB installed on sqlplus /nolog #login to SQL*Plus console From SQL*Plus console: conn user/pass as sysdba var ohp varchar2(100);  –set a variable ‘ohp’ exec dbms_system.get_env(‘ORACLE_HOME’, &#58ohp) ; –call the get_env system-procedure print …

How to create a Servlet and use it from a JSP page (ADF 10g)

Create the Servlet Right-click on the package you need it for and select New… From the new gallery select Web-Tier > Servlets on the left and on the right select HTTP Servlet Click Next and give the Servlet: Class name …

How to add a new field to an existing View Object in ADF 10g

Case: You need a new field on a table in the DB and need to use it on a jspx page in ADF 10g. After you have added the column in the relevant table in the DB, turn to the …

How to add a OutputText/InputHidden field on a jspx page (ADF 10g)

Level: Advanced Prerequisits: Model, DataControl and Backing-bean class 1. Find the page you need to add the field to i.e. CreateNewEmp.jspx 2. In the body > form of the jsp(x) page you should typically have a “panelForm” where fields are …

Check or change default port numbers of Oracle Database

Check or change the default port numbers by editing the file (in VI): vi $ORACLE_HOME/install/portlist.ini …

how to configure QEMU Manager to boot off a USB in windows

After QEMU Manager 7.0 installation: Create a new VM from Qemu Manager Type a name for the new VM > Next Select, “do not use an image” > Next Output, “QEMU Manager Default” > Finish Then under the “Advanced tab …

shorcuts to standard methods for Java IDEs

System.out.println(): Netbeans: sout -> Tab Eclipse: syso -> Ctrl + Space JDeveloper: sop -> Ctrl + Enter System.err.println(): JDeveloper: sep -> Ctrl + Enter some credits: Java-Servlet-Jsp Blog …

how to setup windows PuTTY to load x-windows via xming

Once you have XMing installed on windows do as follows: Set xming shorcut target as: ”C:Program Files (x86)XmingXming.exe” :0 -clipboard -multiwindow :0 sets the x,y stating point of the displayed window Start xming (you should see a xming icon next …

how to create a cursor to read through table rows

declare counter1 number := 0; counter2 number := 0; cursor cur_t is SELECT * from emp where e_name = \’Ptere\’; –set cursor, a select statement rec_t emp%rowtype; –defines this is a row from the database begin counter1 := 0; counter2 …

how to find specific text in oracle schema using a procedure and save to table

The following function will find any text matching the variable set within the procedure. (the output will display on screen -dbms_output) To execute: <SQL> execute update_found_records_proc; We could also add a parameter on calling the procedure as: CREATE OR REPLACE …

how to find specific text in oracle schema using a function

The following function will find any text matching the arguments given at command line. (output may not display on screen, but data will be inserted in the relevant table) To execute: select find_in_schema(‘ABC_553’) from dual; Credit:: Rene Nyffenneger on Oracle …

how to configure tnsname.ora, hosts and internet browser correctly

The following configuration should fix problems between tnsname, the hosts file and browser: tnsnames.ora (file) DBNAME_DEV = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.99.98)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ORADB1) ) ) DBNAME_PRD= (DESCRIPTION …

how to add a printer port mapped to a shared printer (win7)

How to add a printer port mapped to a shared printer (most useful windows when it gets stubburn not installing the drivers): 1. Add Printer 2. Create New Port: Local Port 3. Enter Port Name: \\serverprintShareName 4. Next: use Windows …

count a column, then count the group -oracle reports

You want to the following report output (ProdA and ProdB are within same column): Prod-Id | A | B | Subtotals 123 | 4  | 3 | 7 124 | 2 | 5 | 7 Columns: prod_id, prod_code, prod_type Group …

Show Desktop shorcut on Taskbar in Windows 7

To re-create the lost Show Desktop shortcut on previous versions of Windows and now set to the far right of the screen, follow these instructions: Create a text file and enter the following: Command=2 IconFile=explorer.exe,3 Command=ToggleDesktop Save this …

SFTP connection using Total Commander

Making SFTP connection via Total Commander: Option A, simple SFTP: download this plugin and install in TC add “sftp” dir under “pluginswfx” within TC copy the contents of the downloaded plugin to the new sftp dir from TC-options > plugins …

how to check if a solaris has ftp enabled

To check if  a Solaris machine has ftp enabled: inetadm | grep ftp #check the status inetadm -e ftp #enable inetadm -d ftp #disable …may also try: /usr/sbin/svcadm enable ftp /usr/sbin/svcadm disable ftp …

outer joins

Say we have two tables: tab1  tab2 1          2 2         3 4         4 5 select t1.col1, t2.col2 from tab1 t1, tab2 t2 where t1.col1 = t2.col2(+) –pl/sql –Informix SQL: …from tab1 t1, outer tab2 t2 Result: t1 t2 1   – …

how to install Midnight-Commander in Linux

To install Midnight-Commander (MC) in Linux: wget http://www.midnight-commander.org/downloads/mc-4.7.5.2.tar.gz tar -zxvf mc-4.7.5.2.tar.gz cd mc-4.7.5.2 ./configure make make install #to run Midnight commander use: mc Notes: – if link don’t work look for an updated link – may need to install …

useful pl/sql code snippets

Create a “New Line” within a PL/SQL formula, use the following: /* Function to calculate the retirement date of a person based on person’s date of birth Parameter: p_birthdate, date Returns: ret_date, date */ CREATE OR REPLACE FUNCTION get_retire_date(p_birthdate IN …

Get user-account and limit his/her access in FM10

Limiting access of an FM user. Set a variable and get the account name Set Variable From the script where you want the set user limitation: Perform Script //the script created in step 1 If Perform Script …

how to set from where TotalCmd reads its settings (wincmd.ini)

To let TotalCmd read the settings file from within itself: enter the following under section of the wincmd.ini file: UseIniInProgramDir=7 Save and copy wincmd.ini file to the program dir (if needed) …

how to deploy an app to a new oc4j-instance on OAS 10.1.3.1

To deploy a java/ADF app on an Oracle Application Server (10.1.3.1) and handle the datasources from there: After generating the ear and war files from within JDeveloper… Login to OAS Cluster Topology > OC4J-instance > Administration > JDBC Resources Firstly …

how to start the Oracle Application Server and Enterprise Manager (opmn)

To start the Oracle Enterprise Manager do: 1. Log in <oracle_user>/<password> 2. Start-up the instance cd $ORACLE_HOME/opmn/bin opmnctl startall #start all services opmnctl status #view the services active/down opmnctl status -l #view statuses and ports used 3. Start em console ./emctl …

Oracle AS 10g R3 (10.1.3) install on linux CentOS 5.5

Oracle Application Server 10g Release 3 (10.1.3) installation on CentOS 5.5 (2.6.18-194.el5): Using: rpm > install packages, vi > editing, cpio, unzip > unpack archives Download and extract the OAS Suite cpio to i.e. /tmp/orainstall Check that the following packages …

Import/Export an oracle db/schema

Prerequisites: Import: Oracle DB setup with default DB the username that has access to the import DB Remember to set the character set if importing Unicode Import/Export: ip-address, SID, user/pass (sysDBA) …

Using cpio to extract/create archives in Linux

Commands to create or extract cpio files in Linux. To create a cpio archive from a list of files: ls | cpio -ov > nameOfArchive.cpio usage: ls #to list the files to pack | #pipe to cpio o #create pack …

Share Linux resource via Samba for Win access

How to share a Linux folder using Samba for Windows access: (procedure using CENTOS networked on a Windows 7) System > Administration > Server Settings > Samba Preferences > Server Settings Basic tab: Workgroup = YourLocalWorkgroup Description = anything Security …

Reset local OC4J in JDeveloper 10

If you get an error message trying to start JMS-Server in JDeveloper 10.1.3.5 like: (SEVERE) Failed to set the internal configuration of the OC4J JMS Server with: XMLJMSServerConfig Firstly check whether the port (default 9127) is not used/locked by other …

Set default language for JDeveloper IDE

JDeveloper picks-up the default locale language from the OS. To change this and force JDev to a specific language: Open JDEV_HOME/jdev/bin/jdev.conf Add the following lines for English: AddVMOption -Duser.language=en AddVMOption -Duser.country=US This will show all warnings and message details in …

Useful Linux/Dos Commands

Navigation: cd /usr/local/i-net crystal-clear #use (backslash) to replace space in path ls #list dirs/files of current path, normal column-view dir #dos dir /q /a:r|h|s #to list dirs and files with attributes and owners dir /-n #to list dirs and …

how to find the java backing-bean of a jspx SQL command

Example: If I have a HistoryPage.jspx has a table which displays a list of the History records. This means -whenever the Dept. creates a new Decision, it is added to the decisions table. If we look at the config-faces.xml diagram …

how to start an Oracle Database and em console (10g)

Starting an Oracle Database and EM console (10g) login/su as the user who installed the oracle software (i.e. oracle) wins: set ORACLE_SID=sid_name  #the name SID given when creating database linx: export ORACLE_SID=sid_name sqlplus /nolog #just log onto the sqlplus console …

how to dual-run Office XP/2K3 and Office 2007

To run both versions of Office 2002/3 and Office 2007 on same machine: Set the file-types to open with relative version of Office: .doc, .docx, etc. (i.e. set .doc to open with word 2002 and .docx with 2007) Open Regedit …

how to move a JDeveloper folder correctly

To move a JDeveloper folder to a new location/machine: First find and edit the following files to the new path: path_to_new_jdev_root_folderjdevsystemoracle.j2ee.10.1.3.42.70embedded-oc4jconfigserver.xml Change all the paths referencing the old JDeveloper folder with the new path i.e. old path is: c:jdev_10.1.3.4 and …

how to find and identify duplicates

The following snippet finds all duplicates in a table and then separates them: SELECT ID, LastName, FirstName FROM (SELECT ID, LastName, FirstName, RANK() OVER(PARTITION BY LastName, FirstName ORDER BY ID) AS SeqNumber FROM Customers) WHERE SeqNumber > 1; RANK() …

how to use exception handling in PL/SQL

Exception handling is followed after an sql command, using ‘Exception’ i.e.: begin DELETE FROM TABLE1 t1 WHERE t1.table_id = variable1; EXCEPTION WHEN OTHERS THEN INSERT INTO ERR_DELETE (table_id, description) VALUES (t1.table_id, variable1); end; …

how to enable output in Oracle SQL Developer

To enable output to console window in Oracle SQL Developer (as of 2.1.1.64) From the menu go to: View > Dbms Output From the new window (popped-up in the log area) click on the plus sign to enable output Enter …

how to find duplicates/singles in PL/SQL

SELECT emp, COUNT(emp) AS NumOccurrences FROM users GROUP BY emp HAVING ( COUNT(emp) > 1 ) also, find only one record: SELECT emp FROM users GROUP BY emp HAVING ( COUNT(emp) = 1 ) …

how to install eVB 3.0 on Windows 7

To install eVB 3.0 (embedded visual basic) on Windows 7: You first need: pocket PC 2002 SDK, eVB 3.0, vb runtimes 6.0 Control Panel > User Accounts > User Accounts > Change User Account Control settings Lower the ‘Notify’ bar …

Install Win7 over existing XP (Lenovo Netbook)

The procedure is for the Lenovo Netbook but may also work with other brands in a similar way. Insert boot media and start installation When prompted, select Custom/advanced setup Install on partition where ‘Lenovo’ volume sits This will add the …

how to use jar file commands

To extract a jar file from the command-line: jar xf myapp.jar -extract a jar-file into jar-file-name-dir (within same dir) jar xf myapp.jar file1 file2 file3 -extractspecific files only jar cf myapp.jar file1 file2 dir1 -create a jar-file from a path(s) …

how to move dir/file in linux

To move a dir/file in linux: mv ./sourceDir ./destDir …this moves the current sourceDir to a destination dir …

how to delete contents of dir in linux

To delete all contents of a dir including other dirs: rm -rf ./* rm = remove -r = recursive -f = force non-emty deletion ./* = everything in current dir …

useful SQL-Plus commands via a Lunix shell/Windows cmd

In bash/shell: sqlplus /nolog #just log onto sqlplus console connect as sysdba #connect as sysdba and prompt for login connect user/passw as sysdba #log-in as a sysdba with user | default: system/manager In <bash><sql>: startup –startup a database shutdown –shutdown …

useful vi commands…

Some of the most useful vi commands: Insert (key) …edit mode Esc (key) …exit edit mode :wq or ZZ …save and exit vi (must not be in edit mode) :q! …exit vi without saving (must not be in edit mode) …

phpBB3 forum on Oracle DB

When you create a phpBB3 forum and use Oracle as the database host. make sure that you are using Oracle Database 10g or later as previous releases may cause unpredictable errors, i.e.: SELECT a.*, b.*, ac.something… FROM phpb3_forums a, phpb3_topics …

how to check the environment vars -linux

To check environment vars in a linux setup: set …this should return a list of the environment entries and can retrieve entries like: HOME # the active user’s home dir HOSTNAME # the server’s name ORACLE_HOME # the default path …

how to check if listener working from linux

When checking if a listener is active or not in Oracle: lsnrctl status This command should return something similar to the following. Check-out the Services summary: Services Summary… Service “PLSExtProc” has 1 instance(s). Instance “PLSExtProc”, status UNKNOWN, has 1 handler(s) …

create a related global list-of-values in FM10

The logic is to have the various list-of-values (or combo-values) in a related global table. in global table: create the table that will hold the values -i.e. ‘city’ in related table: add an ‘unrelated’ relationship from global of the new …

how to create a new virtual host -OAS

To create a new HTTP Virtual Host in Oracle Application Server: Adding a new port number for the HTTP VH to listen to: login to the Oracle Enterprise Manager (i.e. domain.name.com: 1810) select the application server instance (under Standalone Instances) …

how to check which db you are in -plsql

?To test/check from/in which database you are working from: select name from v$database …this will return the name of the database you are working on. …

find files/dirs with bash-shell in linux

Finding files/dirs in the bash shell: find /home -print | grep php #/home = the path to search in #-print = print output to screen #grep = what follows is the search pattern #php = the search term #| = …

look for a service status in linux

You need to look for a service in linux: ps -ef | grep crystal e = look in all processes f = display full output details grep = print lines matching a pattern crystal = the search term to check …

how to purge deleted items in Portal

When you delete items from a Portal they are not automatically purged. To save/purge your deletions: Navigator > page group > Pages > find the page > click Edit link from Editing Views: Graphical |  Layout |  List Select the pages to …

create a relationship using global var in FM10 (view or new rec)

Creating a relationship using a global variable in FM10: create the relationship in the graph of FM (i.e. person: person_pk to history: person_fk) from inside a script, if you need to view the relationship: Set Variable If Go …

how to edit pages in Oracle Portal

There are a few ways to edit a page in Portal: under ‘Build’ tab > Edit a Page > select page > click Edit Navigator > page group > select Pages > find the page > click Edit link under …

how to change object types in Portal

If you have created a ‘Page Group’ or an ‘Instant Portal’ you can quickly change an object type, do this: select the ‘Page Group’ and click edit click the ‘Configure’ tab to make changes/additions to object types You can also …

install phpbb3 forum on OAS

To install forum on Oracle Application Server: need access to OAS server (http server) log-in to OAS manager (em) and add a ‘virtual host’ under HTTP-Server -set path (Document Root:  i.e. ‘/phpbb3’ ) -set port (any available ports, i.e. ‘8888’ ) …

add ‘External Applications’ to Portal

After log-into Oracle Portal as Administrator: click Administer tab under ‘SSO Server Administration’ section, click ‘Administer External Applications’ link click ‘Add External Application’ link and fill-in the relevant information to create it When this is done, the external application is …

how to add portlet to Oracle Portal

After log-in to Oracle Portal: click on the link ‘Navigator’ in the list of ‘page groups’ find the name-group you created and click on ‘edit page root’ (this will allow you to edit the main page of the portal) clicking …

quick Oracle Instant Portal build

Build a fully-blown Portal (Instant Portal), ready to modify and use. …

how to copy text from/to PuTTY

To copy selected text within a command-line window from/to PuTTY… from PuTTY to windows: to copy the text from PuTTY, select it and right-click to paste into windows, use the normal Ctrl + V from windows to PuTTY: to copy …

Apache configuration file

The Apache configuration file is an entry point for how and what can be seen from the domain’s public url. config file is found: /home/username/Apache/Apache/conf/httpd.conf important settings: Port = the port the server will listen when not using SSL (defaults …

how to check if php is installed on linux

To check whether your linux-box has PHP installed or not: From the command-shell run: rpm -qa | grep -i php this should return something like this: php-cli-5.1.6-5.el5 php-5.1.6-5.el5 php-common-5.1.6-5.el5 php-ldap-5.1.6-5.el5 Or, you could run a test.php file within the htdocs …

how to login as different user in linux

after logged-in as some user (i.e. as root) $ type ‘su -dennis’ this should prompt you to enter the password of the user success if you see the prompt as: $ …

how to copy text from xming to windows

To copy selected text within a command-line window in xming: to copy the text, use Alt + Shift + C to paste into windows, use the normal Ctrl + V …

how to show the linux-box version

login to your linux-box enter the command i.e.:  cat /etc/redhat-release (outputs i.e. #Red Hat Enterprise Linux Server release 5) This will display the rehat version you are using. Similar is for other linux-boxes like i.e. using slackware-version instead would show …

how to connect to a RedHat server via PuTTy

download PuTTY and run it (all windowz) select Category > Session -on the left pane of PuTTY on the right-pane enter the server info: – Host name (or IP addres): the.server.ip (i.e. 192.168.10.205) – Port: the.port.number (i.e. 22) – Connection …

how to make Oracle SQL Developer load/work faster

To make Oracle SQL Developer (2.x) load/work faster: From Menu: Tools > Preferences > Extensions, uncheck: “Automatically check for updates” From Menu: Tools > Preferences > Environment, uncheck: Show splash screen at startup Autonmatically load externally modified files Check for …