How does the linux Server export data from the oracle database?
Solution to EXP-00056: ORACLE error 12154 encountered:
Some users asked this question: How do I escape the @ symbol in the password during the export operation?
Because the default Oracle will parse the strings after the @ symbol as the service name, it will not work without processing.
Some enterprises Add the @ symbol to their passwords because of security rules.
Assume that the user password is as follows: SQL> alter User eygle identified by "eygle @ com"; user altered. if the default export fails, the following error occurs: [oracle @ jumper oracle] $ exp eygle/eygle @ com file = eygle. dmp tables = test
Export: Release 9.2.0.4.0-Production on Fri Jan 4 11:17:48 2008
Copyright (c) 1982,200 2, Oracle Corporation. All rights reserved.
EXP-00056: ORACLE error 12154 encountered
ORA-12154: TNS: cocould not resolve service name
EXP-00000: Export terminated unsuccessfully escape, can be successfully exported: [oracle @ jumper oracle] $ exp eygle/\ "eygle @ com \" file = eygle. dmp tables = test Export: Release 9.2.0.4.0-Production on Fri Jan 4 11:12:10 2008 Copyright (c) 1982,200 2, Oracle Corporation. all rights reserved. connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0-Production With the Partitioning option JServer Release 9.2.0.4.0-Production Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
About to export specified tables via Conventional Path...
.. Exporting table TEST 4136 rows exported
-The End
The statement for exporting data from the database is: exp osoadata/888888 @ fxc file = e: \ osoa. dmp owner = osoadata: exp osoadata/\ "888888 @ fxc \" file = e: \ osoa. dmp owner = osoadata select 'alter table' | table_name | 'allocate extent; 'from user_tables where num_rows = 0
Exp username/password @ database name file = D: \ dmp \ exp_sms20110224.dmp log = D: \ dmp \ exp_smsrun.log
Exp osoadata/888888 @ fxc file = e: \ osoa. dmp owner = osoadata
Exp osoadata/\ "888888 @ fxc \" file = e: \ osoa. dmp owner = osoadata
Exp osoadata/sdjzkhdb! @ Orcl file =/srv/bak_ceshi/osoadata. dmp owner = osoadata log =/srv/bak_ceshi/exp_osoadata.log
Exp certCMSUser/sdjzkhdb! @ Orcl file =/srv/bak_ceshi/certCMSUser. dmp owner = certCMSUser log =/srv/bak_ceshi/exp_certCMSUser.log
The. add export NLS_LANG = "SIMPLIFIED CHINESE_CHINA.ZHS16GBK" to the bash_profile file. bash_profile takes effect. Export normal imp certCMSUser/certCMSUser @ orcl file =/srv/certCMSUser. dmp fromuser = certCMSUser touser = certCMSUser log =/srv/imp_cert.log imp osoadata/888888 @ orcl file =/srv/osoadata. dmp fromuser = osoadata touser = osoadata log =/srv/imp_osoa.log