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.