URGENT: Lost Connection to Database

Ora12570 TNS:PACKET READER FAILER

I need to get my tables, I reinstalled my local area network and now I have a different IP address the intional  ip address was 192.168.0.151, the router reassigned the addresss 192.168.0.198 what I need to do is to retreave the tables from the database that is called tsttpos_192.168.0.151.I need to get the tables and extract the information there are around 10 tables, with populated data. Is it possible to regain the data , if so how do I do it step by step? If I can not retreive the information is there a way to retreive at least the tables?If so how do I do that?
mathieu_cuprykAsked:
Who is Participating?
 
dramacqueenConnect With a Mentor Commented:
Hi mathieu,

First, don't worry.  If you didn't mess with the Oracle installation, you can almost certainly still get to the tables.

You need to update your TNS configuration to point the database alias at the new address.  In your Oracle home directory you will find there is a network/admin directory.  This has a file you need to update.  It is called  tnsnames.ora.  First take a copy of the files.  Then open the original to edit using Notepad and it should be obvious which network alias is pointing to the address 192.168.0.151.  Change this to 192.168.0.198.  It is possible that your alias uses the name of the host.  If so, you will see the old name of the server in these files somewhere.  You need to change this to either the new name of the server, or the new IP address.  

For example my tnsnames file holds something like:
QUEL.NET =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.208)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = JJJJ)
    )
  )

Quel.net is the alias name, while the IP address of the server is 192.168.0.208 and the instance name of the database is JJJJ.  I wouldn't recommend changing the quel.net part of it, but just the IP address part of it.

Finally, you will have to update on the server itself in the network/admin directory, the file listner.ora.  Again it should be obvious where your problem lies.

After you've done this and saved the files, try (in command prompt) a tnsping <database_alias>
eg. tnsping quel in my example above.  If you have been successful you should see something like:
Attempting to contact (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.208)(PORT = 1521))
OK (100ms).

I hope you get back in there.  Let me know if any of this isn't clear.

0
 
boriskalavskyCommented:
you can try changing  a host name (ip) in tnsnames.ora in $ORACLE_HOME/network/admin or  
%ORACLE_HOME%\network\admin (on Windows) on the client.
0
 
mathieu_cuprykAuthor Commented:
Unable to connect.
SQLstate = 08004
ORA-12154 TNS:Could not resolve service name.

I tried to use my odbc connect. Test it. I get the above error. I fix. what you said about.
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
mathieu_cuprykAuthor Commented:
Still not working.

# TNSNAMES.ORA Network Configuration File: F:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.


TSTTPOS_192.168.0.198 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.198)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = TSTTPOS)
    )
  )

ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = omegaexecutive)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

INST1_HTTP =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = omegaexecutive)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = SHARED)
      (SERVICE_NAME = MODOSE)
      (PRESENTATION = http://HRService)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

0
 
dramacqueenCommented:
mathieu_cupryk,
What happens when you tnsping TSTTPOS_192.168.0.198?
0
 
konektorCommented:
is your listener running ? type :
$> lsnrctl
lsnrctl> stat
- this command shows if listener is running
if doesn'n then :
lsnrctl> start
- check listener.ora file, if it contain your database
0
 
boriskalavskyCommented:
Can you ping the server?
ping 192.168.0.198

Can you tnsping?
tnsping tsttpos_192.168.0.151

Check value of the HOST in tsttpos_192.168.0.151 entry of tnsnames.ora (should be 192.168.0.198).

Do you have a firewall?

0
All Courses

From novice to tech pro — start learning today.