Home » Developer & Programmer » Forms » Error in Export ORACLE error 12154 encountered (Developer 6I ,database 10g )
Error in Export ORACLE error 12154 encountered [message #414453] Wed, 22 July 2009 04:18 Go to next message
shahzaib_4vip@hotmail.com
Messages: 376
Registered: December 2008
Location: karachi
Senior Member
Hi all

When i run Exp and write userid/password@servicename this message appear what can i do ?

My Sqlplus is working fine i can connect with sqlplus,form,report but its not working on export

Regards

Shahzaib
Re: Error in Export ORACLE error 12154 encountered [message #414458 is a reply to message #414453] Wed, 22 July 2009 04:37 Go to previous messageGo to next message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Perhaps EXP's TNSNAMES.ORA doesn't see the database. Search the board for use of the TNS_ADMIN system variable; it might help.
Re: Error in Export ORACLE error 12154 encountered [message #414461 is a reply to message #414453] Wed, 22 July 2009 04:58 Go to previous messageGo to next message
shahzaib_4vip@hotmail.com
Messages: 376
Registered: December 2008
Location: karachi
Senior Member
i set my Tns_admin

Set Tns_admin=d:\oracle\product\10.0.1\db_1 



But still the same error


Regards

Shahzaib ismail
Re: Error in Export ORACLE error 12154 encountered [message #414474 is a reply to message #414461] Wed, 22 July 2009 05:27 Go to previous messageGo to next message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Does this directory (d:\oracle\product\10.0.1\db_1) contain TNSNAMES.ORA file? Is it not in ...\network\admin (by default)?
Re: Error in Export ORACLE error 12154 encountered [message #414613 is a reply to message #414453] Wed, 22 July 2009 23:29 Go to previous messageGo to next message
shahzaib_4vip@hotmail.com
Messages: 376
Registered: December 2008
Location: karachi
Senior Member
My tnsnames.ora File look like This

# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

LIVE =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = Shahzaib)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = Live.ss64.com)
    )
  )




And i Set Tns_admin in d:\oracle\product\10.0.1\db_1


Regards

shahzaib ismail
Re: Error in Export ORACLE error 12154 encountered [message #414614 is a reply to message #414453] Wed, 22 July 2009 23:31 Go to previous messageGo to next message
shahzaib_4vip@hotmail.com
Messages: 376
Registered: December 2008
Location: karachi
Senior Member
Is there is any other way to make Backup ?


Regards

Shahzaib ismail
Re: Error in Export ORACLE error 12154 encountered [message #414621 is a reply to message #414614] Thu, 23 July 2009 00:34 Go to previous messageGo to next message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Please, try to understand what's being written.

Your TNSNAMES.ORA file says:
Quote:
# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora


Quote:
And i Set Tns_admin in d:\oracle\product\10.0.1\db_1


Quote:
Is there is any other way to make Backup

Backup? This is the first time you've ever mentioned backup. Export is not a backup. Moreover, it appears that this topic is misplaced - it has nothing to do with Forms. So, where would you want it to be moved? "Server Utilities" (which deal with Export problems) or "Backup & Recovery"?
Re: Error in Export ORACLE error 12154 encountered [message #414655 is a reply to message #414453] Thu, 23 July 2009 02:00 Go to previous messageGo to next message
shahzaib_4vip@hotmail.com
Messages: 376
Registered: December 2008
Location: karachi
Senior Member
Well i don't need to backup my form and report i need to Backup my All Database and i know only Export to backup my database entry

thats why i told is there is any way to make database backup


by the way how can i change my Tnsnames.ora File ? i rename Tnsnames.ora to tnsnamesold.ora and make new Local_Net_configuration_assistant but its show again same Tnsnames.ora ?


Whats you recommend To change my tnsnames or tns_admin


Regards


Shahzaib
Re: Error in Export ORACLE error 12154 encountered [message #414676 is a reply to message #414655] Thu, 23 July 2009 03:13 Go to previous messageGo to next message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Export utility is fine for moving data around; for backup, you might want to check what RMAN (Recovery Manager) offers. For more information, read Introduction to backup and follow links suggested in that document.

As for TNSNAMES.ORA: I have created a directory in the root directory of my C drive and put TNSNAMES.ORA file in there. Then I have set TNS_ADMIN environment variable to point to that directory.

I maintain TNSNAMES.ORA file manually, using a simple text editor (such as Notepad). I don't use Net Configuration Assistant.
Re: Error in Export ORACLE error 12154 encountered [message #414694 is a reply to message #414453] Thu, 23 July 2009 03:59 Go to previous messageGo to next message
shahzaib_4vip@hotmail.com
Messages: 376
Registered: December 2008
Location: karachi
Senior Member
So What is the Solution of This Error i Change my Tnsnames.ora File Manually?

Every thing working fine how this happen i don't know ?


Regards


Shahzaib ismail
Re: Error in Export ORACLE error 12154 encountered [message #414709 is a reply to message #414694] Thu, 23 July 2009 04:40 Go to previous messageGo to next message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Perhaps you should leave it for a day, just to clear your mind.

Then re-read everything we've said, including topics you've found on the Forum (and, perhaps, elsewhere).

Then start over.

Because, no - solution is not changing some file manually. This is how I maintain my TNSNAMES.ORA file, which doesn't mean that everyone else must do that as well.
Re: Error in Export ORACLE error 12154 encountered [message #414890 is a reply to message #414453] Thu, 23 July 2009 23:37 Go to previous messageGo to next message
shahzaib_4vip@hotmail.com
Messages: 376
Registered: December 2008
Location: karachi
Senior Member
Well Today its a new day


Thanks for your Advice and i done it

Export is working fine whenever i set my TNS_ADMIN path to TNS_NAMES path

But when i exit from DOS prompt its not working and again i want to set my TNS_ADMIN file

Why TNS_ADMIN file is not saved ?

Any way Little Foot

Thanks for your great Help (You are Genius)


Regards

Shahzaib
Re: Error in Export ORACLE error 12154 encountered [message #414905 is a reply to message #414890] Fri, 24 July 2009 00:20 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Because you didn't issue the command in such a way that it is saved for future sessions.

Search this forum for 'tns_admin' and you will see that you need to set it through the environment handler.

If in doubt, use the windows help facility.

David
Previous Topic: reset validate_from_list property to its design time value
Next Topic: moving objects
Goto Forum:
  


Current Time: Wed Dec 07 10:32:08 CST 2016

Total time taken to generate the page: 0.09777 seconds