Re: EXP-00056: ORACLE error 1017 encountered

I appreciate the link to Oracle docs but I looked there already. I found the solution to the problem. In the solaris environment the command should look like: exp "'/ AS SYSDBA'". The "/ AS SYSDBA" part needs to be wrapped in single quotes, the single quotes need to be wrapped in double quotes.

Thanks again. Louis.

TurkBear <john.greco_at_dot.state.mn.us> wrote in message news:<7obnbv8so1fj1tosbdbjfgd6pmp5js9vi0_at_4ax.com>...
> 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"
> >> >
> >> >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 - 22:24:21 CEST