Re: EXP-00056: ORACLE error 1017 encountered

Yes you should be able to do it that way.

Maybe search
http://tahiti.oracle.com
for any special factors when using OS authentication with exp ( and imp as well, I imagine )

froliol_at_yahoo.com (Louis Frolio) wrote:

>Yes I have:
>lisg039 :/u01/home/oracle> exp "/as sysdba" file=myfile.dmp
>log=myfile.log full=y rows=n
>LRM-00108: invalid positional parameter value 'sysdba'
>
>EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help
>EXP-00000: Export terminated unsuccessfully
>
>The exp utility cannot parse the "/as sysdba" portion of the login? I
>should just be able to do the "exp / " and that will be recognized as
>"sysdba."?
>
>Louis.
>
>TurkBear <john.greco_at_dot.state.mn.us> wrote in message news:<d1dlbv8v088dg2t7350kp2c73dasf27drs_at_4ax.com>...
>> froliol_at_yahoo.com (Louis Frolio) wrote:
>>
>> >Greetings All, I am trying to do a database export with the following
>> >sytax:
>> >exp / file=myfile.dmp log=myfile.log full=y rows=n
>> >
>> >I am logged in as the unix user "oracle" who's primary group is "dba".
>> > This is the user that owns the database install. I am running 64 bit
>> >Enterprise Edition 8.1.7.4 RDBMS.
>> >
>> >When I execute the above query I am prompted with the error messages
>> >listed above in the subject line of this post.
>> >
>> >I can successfully use sqlplus logging in as "/as sysdba"?:
>> >sqlplus "/as sysba"
>> >
class="quotelev3">>> >SQL>
>> >
>> >I have a password file set up and "remote_login_passwordfile =
>> >exclusive" is in the init.ora file. The orapwSID file has the user
>> >"sys" in it and the password for the passoword file is the same as the
>> >password for the database user "sys".
>> >
>> >When I look at the view v$pwfile_users:
>> >SQL> select * from v$pwfile_users;
>> >
>> >USERNAME SYSDB SYSOP
>> >------------------------------ ----- -----
>> >INTERNAL TRUE TRUE
>> >SYS TRUE TRUE
>> >
>> >SQL>
>> >
>> >and this is correct.
>> >
>> >Any ideas why I cannot do an export without supplying a username and
>> >password would be greately appreciated.
>> >
>> >Louis.
>>
>> Have you tried
>>
>> exp "/as sysba" file=myfile.dmp log=myfile.log full=y rows=n
>>
>> Only sysdba can do a full export, so you need to 'enable' that role on login...
>>
>>
>>
>> ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
>> http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
>> ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---

----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Received on Fri May 09 2003 - 15:41:50 CEST