OraFAQ Forum: Forms » Error in Export ORACLE error 12154 encountered

Home » Developer & Programmer » Forms » Error in Export ORACLE error 12154 encountered (Developer 6I ,database 10g )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Error in Export ORACLE error 12154 encountered [message #414453]

Wed, 22 July 2009 04:18

shahzaib_4vip@hotmail.com
Messages: 410
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

Report message to a moderator

Re: Error in Export ORACLE error 12154 encountered [message #414458 is a reply to message #414453]

Wed, 22 July 2009 04:37

Littlefoot
Messages: 21808
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.

Report message to a moderator

Re: Error in Export ORACLE error 12154 encountered [message #414461 is a reply to message #414453]

Wed, 22 July 2009 04:58

shahzaib_4vip@hotmail.com
Messages: 410
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

Report message to a moderator

Re: Error in Export ORACLE error 12154 encountered [message #414474 is a reply to message #414461]

Wed, 22 July 2009 05:27

Littlefoot
Messages: 21808
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)?

Report message to a moderator

Re: Error in Export ORACLE error 12154 encountered [message #414613 is a reply to message #414453]

Wed, 22 July 2009 23:29

shahzaib_4vip@hotmail.com
Messages: 410
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

Report message to a moderator

Re: Error in Export ORACLE error 12154 encountered [message #414614 is a reply to message #414453]

Wed, 22 July 2009 23:31

shahzaib_4vip@hotmail.com
Messages: 410
Registered: December 2008
Location: karachi

Senior Member

Is there is any other way to make Backup ?

Regards

Shahzaib ismail

Report message to a moderator

Re: Error in Export ORACLE error 12154 encountered [message #414621 is a reply to message #414614]

Thu, 23 July 2009 00:34

Littlefoot
Messages: 21808
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"?

Report message to a moderator

Re: Error in Export ORACLE error 12154 encountered [message #414655 is a reply to message #414453]

Thu, 23 July 2009 02:00

shahzaib_4vip@hotmail.com
Messages: 410
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

Report message to a moderator

Re: Error in Export ORACLE error 12154 encountered [message #414676 is a reply to message #414655]

Thu, 23 July 2009 03:13

Littlefoot
Messages: 21808
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.

Report message to a moderator

Re: Error in Export ORACLE error 12154 encountered [message #414694 is a reply to message #414453]

Thu, 23 July 2009 03:59

shahzaib_4vip@hotmail.com
Messages: 410
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

Report message to a moderator

Re: Error in Export ORACLE error 12154 encountered [message #414709 is a reply to message #414694]

Thu, 23 July 2009 04:40

Littlefoot
Messages: 21808
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.

Report message to a moderator

Re: Error in Export ORACLE error 12154 encountered [message #414890 is a reply to message #414453]

Thu, 23 July 2009 23:37

shahzaib_4vip@hotmail.com
Messages: 410
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

Report message to a moderator

Re: Error in Export ORACLE error 12154 encountered [message #414905 is a reply to message #414890]

Fri, 24 July 2009 00:20

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 14:09:05 CDT 2024