IMP-00058: ORACLE error 1017 encountered (invalid username/password)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

davide.cosentino@gmail.com - 29 Jan 2008 09:50 GMT

hi,
I am using Oracle for the 1st time.

I have been given the dump of a database (snc01.DMP), which was
created by means of the export command.
I have not much details about the export, apart that it was don using
an owner named:

OWNER=('PRODUCT_OWN')

I am trying to IMPORT the dump into an Oracle 10g on Solaris 10.
I have followed this procedure:

logon as root

>su - oracle

>bash

>export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/Db_4
>export ORACLE_SID=PRODUCT

>sqlplus /NOLOG

SQL>connect sys as sysdba

SQL>DROP USER PRODUCT_OWN CASCADE;
SQL>CREATE USER PRODUCT_OWN IDENTIFIED BY PRODUCT_OWN DEFAULT
TABLESPACE SYSTEM TEMPORARY TABLESPACE TEMP QUOTA UNLIMITED ON SYSTEM;
SQL>GRANT CREATE SEQUENCE TO PRODUCT_OWN;
SQL>GRANT CREATE TABLE TO PRODUCT_OWN;
SQL>GRANT CREATE VIEW TO PRODUCT_OWN;
SQL>GRANT CREATE SESSION TO PRODUCT_OWN;
SQL> grant dba to PRODUCT_OWN;
SQL> exit

>imp PRODUCT_OWN/PRODUCT_OWN@PRODUCT file=/export/home/oracle/snc01.DMP fromuser=PRODUCT_OWN touser=PRODUCT_OWN log=/export/home/oracle/snc01.log

I get the following error:

****
Import: Release 10.2.0.1.0 - Production on Tue Jan 29 11:59:24 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.

IMP-00058: ORACLE error 1017 encountered
ORA-01017: invalid username/password; logon deniedUsername:

Anyone can suggest me what to do? I have the impression that the user
has not enough privilege, but I am not sure.

If I try to logon into SQLPLUS as PRODUCT_OWN (password=PRODUCT_OWN) I
can logon with no error.
Also, I have tried to perform the import as "system" but I get the
following:

****
Export file created by EXPORT:V09.02.00 via conventional path

Warning: the objects were exported by PRODUCT_OWN, not by you

import done in US7ASCII character set and UTF8 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset
conversion)
export client uses WE8MSWIN1252 character set (possible charset
conversion)
export server uses AL16UTF16 NCHAR character set (possible ncharset
conversion)
. importing PRODUCT_OWN's objects into PRODUCT_OWN
IMP-00003: ORACLE error 1435 encountered
ORA-01435: user does not exist

Reply to this Message

sybrandb - 29 Jan 2008 10:08 GMT

On Jan 29, 10:50 am, davide.cosent...@gmail.com wrote:

> hi,
> I am using Oracle for the 1st time.
[quoted text clipped - 63 lines]
> IMP-00003: ORACLE error 1435 encountered
> ORA-01435: user does not exist

Either the service_name PRODUCT in your tnsnames.ora doesn't point to
the database PRODUCT (you would need to verify this by looking in your
tnsnames.ora)
or the CREATE USER command failed.
You would need to verify this by
select * from dba_users where username='PRODUCT_OWN' whether this
applies.

You shouldn't create users with a default tablespace of SYSTEM and a
temporary tablespace SYSTEM.

--
Sybrand Bakker
Senior Oracle DBA

Reply to this Message

davide.cosentino@gmail.com - 29 Jan 2008 10:34 GMT

> On Jan 29, 10:50 am, davide.cosent...@gmail.com wrote:
>
[quoted text clipped - 80 lines]
> Sybrand Bakker
> Senior Oracle DBA

hello Sybrand,
thanks a lot for your help.

The output of the query is:

SQL> select * from dba_users where username='PRODUCT_OWN';

USERNAME USER_ID PASSWORD
------------------------------ ----------
------------------------------
ACCOUNT_STATUS LOCK_DATE EXPIRY_DA
-------------------------------- --------- ---------
DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED
------------------------------ ------------------------------
---------
PROFILE INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ------------------------------
EXTERNAL_NAME
--------------------------------------------------------------------------------
PRODUCT_OWN 63 1C8F8D7CC9B2449B
OPEN
SYSTEM TEMP 28-
JAN-08

USERNAME USER_ID PASSWORD
------------------------------ ----------
------------------------------
ACCOUNT_STATUS LOCK_DATE EXPIRY_DA
-------------------------------- --------- ---------
DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED
------------------------------ ------------------------------
---------
PROFILE INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ------------------------------
EXTERNAL_NAME
--------------------------------------------------------------------------------
DEFAULT DEFAULT_CONSUMER_GROUP

The contents of the .ora file is:

# tnsnames.ora Network Configuration File: /ora10gr2/app/oracle/
product/10.2.0/Db_4/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = lab232006)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

PRODUCT =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = lab232006)(PORT = 1721))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = product)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

What do you think?

Thanks again!

Reply to this Message

psmithski@gmail.com - 29 Jan 2008 11:37 GMT

On 29 Sty, 11:34, davide.cosent...@gmail.com wrote:

> > On Jan 29, 10:50 am, davide.cosent...@gmail.com wrote:
>
[quoted text clipped - 157 lines]
>
> Thanks again!

Hi.
try: tnsping PRODUCT
sometimes when you have many tnsname files you may use wrong one.
But I think it will work, cause you managed to create user PRODUCT_OWN
using this TNS.

I've redone all your steps:
- created user product_own with your script
- exported its schema as product_own with parameted
exp product_own/product_own@myhost owner=('PRODUCT_OWN') file=pr.dmp
- just tu check done one more export
exp system/passsys@my_host owner=('PRODUCT_OWN') file=pr_sys.dmp
-than i did two imports:
imp product_own/product_own@myhost fromuser=product_own
touser=product_own file=pr.dmp

imp system/passsys@my_host fromuser=product_own touser=product_own
file=pr_sys.dmp

Both were succesful!

It must be something wrong with tns settings.
Try write (SERVICE_NAME = PRODUCT) intead of (SERVICE_NAME = product)
- might matter on UNIX OS

Pawel

Reply to this Message

joel garry - 29 Jan 2008 17:38 GMT

On Jan 29, 1:50 am, davide.cosent...@gmail.com wrote:

> hi,
> I am using Oracle for the 1st time.
[quoted text clipped - 42 lines]
> Anyone can suggest me what to do? I have the impression that the user
> has not enough privilege, but I am not sure.

Way too much privilege.

> If I try to logon into SQLPLUS as PRODUCT_OWN (password=PRODUCT_OWN) I
> can logon with no error.

Are you doing sqlplus product_own/product_own or sqlplus product_own/
product_own@product ? Are you doing anything remote from the server?
Why the bash after the su?

Pawel's suggestion of checking the case might be good, be sure and
check it in /var/opt/oracle/oratab as well as anywhere else you see
$ORACLE_HOME defined. You might consider using oraenv to condition
your environment. How many databases and homes are on this box? Are
some homes obsolete?

Also, could you let us know exactly how you specify the listener on
port 1721? There are a couple of different ways, maybe something is
wrong there. How many .ora files are in $ORACLE_HOME/network/admin ?

And definitely listen to Sybrand, putting user info in the system ts
is a big no-no.

> Also, I have tried to perform the import as "system" but I get the
> following:
[quoted text clipped - 14 lines]
> IMP-00003: ORACLE error 1435 encountered
> ORA-01435: user does not exist

These character sets strike me as strange, particularly the US7ASCII
for a 10g import. Please describe all platforms/versions in use, and
any NLS_* environment settings. If there is something besides the
solaris box involved, post any tnsnames.ora on the something. You may
have an inappropriately configured client, wherever it may be,
including on the server.

If you have any 8 bit data in there, it may potentially be hosed with
a 7 bit import.

jg
--
@home.com is bogus.
"Blue water Navy truism: There are more planes in the ocean than
submarines in the sky." - From an old carrier sailor

Reply to this Message

Frank van Bortel - 29 Jan 2008 18:51 GMT

> hi,
> I am using Oracle for the 1st time.

Wouldn't you rather get a professional?

[snip]

>> export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/Db_4
>> export ORACLE_SID=PRODUCT
>
>> sqlplus /NOLOG
> SQL>connect sys as sysdba

That is a LOCAL session!

>> imp PRODUCT_OWN/PRODUCT_OWN@PRODUCT file=/export/home/oracle/snc01.DMP fromuser=PRODUCT_OWN touser=PRODUCT_OWN log=/export/home/oracle/snc01.log

And THAT is a remote session, to something you like
to refer to as PRODUCT.
Why not:

imp PRODUCT_OWN/PRODUCT_OWN file=/export/home/oracle/snc01.DMP
fromuser=PRODUCT_OWN touser=PRODUCT_OWN log=/export/home/oracle/snc01.log

after you fixed what Sybrand and Joel told you to fix?

Signature

Regards,
Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up

Reply to this Message

davide.cosentino@gmail.com - 30 Jan 2008 16:21 GMT

On Jan 29, 7:51 pm, Frank van Bortel <frank.van.bor...@gmail.com>
wrote:

> davide.cosent...@gmail.com wrote:
> > hi,
[quoted text clipped - 28 lines]
>
> Top-posting in UseNet newsgroups is one way to shut me up

hello guys,
I have finally solved the problem.

Apparently, I had not created the user correctly :(

Davide.

Reply to this Message