Regular expression for DNS name or IP address.

Regular expression to validate DNS name or IP address,

^(((([0-9]|[1-9][0-9]|1[0-9]{2}|2[0-4][0-9]|25[0-5])\.){3}([0-9]|[1-9][0-9]|1[0-9]{2}|2[0-4][0-9]|25[0-5]))|((([a-zA-Z0-9]|[a-zA-Z0-9][a-zA-Z0-9\-]*[a-zA-Z0-9])\.)*([A-Za-z0-9]|[A-Za-z0-9][A-Za-z0-9\-]*[A-Za-z0-9])))$

The install has detected that the primary IP address of the system is DHCP-assigned.

Check complete. The overall result of this check is: Failed <<<<
Problem: The install has detected that the primary IP address of the system is DHCP-assigned.
Recommendation: Oracle supports installations on systems with DHCP-assigned IP addresses; However, before you can do this, you must configure the Microsoft LoopBack Adapter to be the primary network adapter on the system.  See the Installation Guide for more details on installing the software on systems configured with DHCP.

When am installing oracle 10g on my windows 7 machine am facing this issue. 

To check whether DHCP is enabled or not:
1. Open Network Sharing and center
2. Click Lan settings
3.Double click on the internet protocol version 4 (TCP/IP)
4. Click advanced button under ID address tab check whether DHCP is enabled.

If DHCP enabled ,

do the following steps to resolve the issue:
1. Open cmd prompt by run as Administrator
2. type Hdwwiz.cpl
3. In the Actions menu click "add legacy hardware"
4.click the radio button " Install the hardware that i manually select from a list"
5.click next and select Network adapters menu
6. click Microsoft under manufacturer and  under Network adapter select Microsoft lookback adapter.
7.click finish

1. Open Network Sharing and center
2. click change adapter settings
3. find the Local area connection 2 " Microsoft lookback adapter"
4.click the properties of Ipv4 .
5. use the following Ipaddress " 192.168.1.10" and subnet Mask give 255.255.255.0
6. click ok.

Now reinstall oracle.
Happy Installation!!!.

ora-12505-tnslistener-does-not-currently-know-of-sid-given-in-connect-descript

ora-12505-tnslistener-does-not-currently-know-of-sid-given-in-connect-descript

Recently I have faced this issue in Oracle 11G while connecting to a database via sql developer 4.0 

ISSUE DESCRIPTION:

I have created one database with name "test"  and password "test" and am able to connect to database using sql plus.

Initially the Host name of my "oracleservicetest" was set to localhost, so when i tried to connect with the sql developer with hostname = "172.16.xx.xx"  it throws network adapter error could not connect exception.

Then i changed the host name to "172.16.xx.xx" for database "test" using Oracle NetManager.

then i changed the listenerservice hostname to "172.16.xx.xx" 

After restarting the machine, when i tried to connect the database with sqldeveloper it throws the below exception.

"ora-12505-tnslistener-does-not-currently-know-of-sid-given-in-connect-descript"

Then i googled and found the below link. 

http://stackoverflow.com/questions/18192521/ora-12505-tnslistener-does-not-currently-know-of-sid-given-in-connect-descript

SOLUTION :

 I found that the hostname has not updated with IPaddress in tnsnames.ora file even though i have updated the listener service using oracle NetManager. It has updated the listener.ora file the hostname to "172.16.xx.xx" but  not updated the tnsnames.ora hostname.

Steps to take backup in oracle 10g.

Steps to take backup in oracle 10g.

C:\oracle>rman target\

Recovery Manager: Release 10.2.0.1.0 - Production on Sat Nov 3 14:36:55 2012

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

target database Password:
connected to target database (not started)

This is because the target database is not set to oracle_SID

How to do

RMAN> exit

Recovery Manager complete.

C:\oracle>set oracle_sid=test

C:\oracle>sqlplus/nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Nov 3 14:37:50 2012

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> conn sys/sys as sysdba

Connected to an idle instance.

SQL> startup

SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area  612368384 bytes

Fixed Size                  1250452 bytes

Variable Size             180357996 bytes

Database Buffers          427819008 bytes

Redo Buffers                2940928 bytes

Database mounted.

SQL> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Pr

oduction

With the Partitioning, OLAP and Data Mining options

C:\oracle>rman target/

Recovery Manager: Release 10.2.0.1.0 - Production on Sat Nov 3 14:40:55 2012

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: TEST (DBID=2340673584, not open)

RMAN> BACKUP DATABASE;

how to convert .63 file to zip file. 

rename filename.63 to newfilename.zip then extract to zip

How to convert .zip file to .63 file

rename newfilename.zip to filename.63 

How to install module in Strawberry perl. 

Before installing module we need to install CPAN.


Note : After installing Stawberry perl we need to reboot our system . Sometimes you cannot run perl scripts from anywhere using command prompt.

Also When i tries to install CPAN using the below command

cpan App::cpanminus

It gets failed.

C:\Perl\site\bin\dmake.exe -- NOT OK    
CPAN: YAML::XS loaded ok (v0.35)
Running make test
  Can't test without successful make
Running make install
  Make had returned bad status, install seems impossible

Resolution:  Restart the system once your Strawberry perl got installed.

Difference Between ListBox and ListPicker

ListBox

We can select only one item
Mode of selection is single.
Selected single item will list in the listbox selected item;
only one itemtemplate is available

ListPicker


We can Select multiple item.
Two Modes: 1.FullScreenonly, Expansion allowed
Multiple item selected will show seperated by comma.
Two different  item template available. 1: default item template and Full mode item template.