Monday, May 26, 2014

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!!!.









Friday, April 4, 2014

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. 



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.






Wednesday, January 15, 2014

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;