FBackup Silent Install params
This information is included in help too. These are the parameters accepted by the FBackup installer via command line: /SILENT, /VERYSILENT …
How to Disable UAC in Windows 10? Here Are Four Simple Ways!
reg.exe ADD HKLMSOFTWAREMicrosoftWindowsCurrentVersionPoliciesSystem /v EnableLUA /t REG_DWORD /d 1 /f Source: How to Disable UAC in Windows 10? Here Are Four Simple Ways! …
How to install TP-Link Print Server by using Standard TCP/IP port in Windows Vista and Windows 7
You ever connected directly a printer to your computer by a USB cable or a parallel cable, and installed the printer driver. Now you want to use a print server to share the printer through your network. You need to …
Create a Google Keep desktop shortcut
Right click the desktop and select New, Shortcut. Click the Browse button and find and select Chrome. It will be in: C:Program Files (x86)GoogleChromeApplicationchrome.exe or C:Program FilesGoogleChromeApplicationchrome.exe Add a space and then the –app=https://keep.google.com to the end of the path …
Doom II Cheats
IDDQD – God Mode IDKFA – All Ammo + Keys IDFA – All Ammo No Keys: IDCLEV## – Level Select (Replace ## with number of level) IDBEHOLD# – Power Up (Example: IDBEHOLDS gives you Berserk) IDCLIP – No-Clip: (You can …
How to add router TL-WR841N via WiFi to existing WiFi Modem/Broadband
Adding a router to the broadband modem may be just a matter of adding the Ethernet link to one of the modem ports and you’re done. What if you want to connect your router to the modem via WiFi AND …
Making an SD Card as Permanent Storage in Windows 10
To be able to mount the SD Card as a Permanent Storage it must be formatted to the same file system as your computer’s main storage file system. For Windows 10 case the main file system is NTFS… Making an …
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 …
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 …
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 …
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 …
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 …
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 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’, :ohp) ; –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 …