| Oracle9i Export Utility [message #73500] |
Wed, 12 May 2004 06:49  |
John Satchell
Messages: 3
Registered: May 2004
|
Junior Member |
|
|
I'm a newbie so please be patient if this is a stupid question. That said, can the exp utility be run remotely from a client workstation? Whenever I try, I get the following:
EXP-00056: ORACLE error 12560 encountered
ORA-12560: TNS:protocol adapter error
EXP-00000: Export terminated unsuccessfully
I am setting the oracle_sid and have tried every connect string I can think of. Provided my command line syntax is acceptable, the above error is as far as I get. I can connect to the same instance using the same ID and service name but am having no luck with exp.
Server is 9i r2 on Win2000, client is XP.
Thanks in advance.
|
|
|
|
| Re: Oracle9i Export Utility [message #73501 is a reply to message #73500] |
Wed, 12 May 2004 10:37  |
croca
Messages: 50
Registered: January 2004
|
Member |
|
|
Could you please describe the exact statement to connecto to DB (sqlplus command) and export command?
Let me see if i can help you.
C.J.
want to see your backup's details? www.otools.com.ar
|
|
|
|
| Re: Oracle9i Export Utility [message #73507 is a reply to message #73501] |
Wed, 12 May 2004 11:04 |
John Satchell
Messages: 3
Registered: May 2004
|
Junior Member |
|
|
Here are screenshots of both sqlplus and exp.
SQL*Plus
C:>sqlplus /nolog
SQL*Plus: Release 9.2.0.4.0 - Production on Wed May 12 15:05:11 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect sys/password@testdb as sysdba
Connected.
SQL> show parameter instance_name
NAME TYPE VALUE
------------------------------------ ----------- -------------------
instance_name string testdb
SQL>
======================================================
EXP
C:>set oracle_sid=testdb
C:>echo %oracle_sid%
testdb
C:>exp sys/password@testdb
Export: Release 9.2.0.4.0 - Production on Wed May 12 14:57:58 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
EXP-00056: ORACLE error 28009 encountered
ORA-28009: connection to sys should be as sysdba or sysoper
Username: sys as sysdba
Password:
EXP-00056: ORACLE error 12560 encountered
ORA-12560: TNS:protocol adapter error
EXP-00000: Export terminated unsuccessfully
C:>
|
|
|
|
| Re: Oracle9i Export Utility [message #73509 is a reply to message #73507] |
Wed, 12 May 2004 11:56 |
croca
Messages: 50
Registered: January 2004
|
Member |
|
|
That's the problem!
you are trying
exp sys/password@testdb
SYS is a SYSDBA account, you can connect sqlplus because you can use connect sys/pwd@testdb as sysdba
but you cannot do export specifying SYSDBA.
Try to do export with SYSTEM account:
exp system/pwd@testdb
Regards.
|
|
|
|
| Re: Oracle9i Export Utility [message #73515 is a reply to message #73509] |
Thu, 13 May 2004 09:03 |
John Satchell
Messages: 3
Registered: May 2004
|
Junior Member |
|
|
|
That works but it presents another question. Can I get one of my users connected from his workstation without having to create another login account and password for him to remember? He's in the ora_dba group on the server and I was hoping he would be able to use something like "/ @dbname". I appreciate your help.
|
|
|
|
| Re: Oracle9i Export Utility [message #73521 is a reply to message #73515] |
Fri, 14 May 2004 05:03 |
croca
Messages: 50
Registered: January 2004
|
Member |
|
|
I don't know how to do that on windows machine, i know hot to do it on UNIX machines.
But you can create a new user in your DB, just a common user..let's say:
create user export_user identified by export_user;
grant create session to export_user;
and grant a super export ROLE !..i dont remember, i think you must grant somethin like:
grant full_export to export_user;
i dont rememer, check you dictionary:
select role from dba_roles;
This way, that DB user will only have the privilege to do exports, and your end users can use that DB user to do exports.
Let me know if it is clear enough....
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
