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

On 29 Sty, 11:34, davide.cosent..._at_gmail.com wrote:
> On Jan 29, 11:08 am, sybrandb <sybra..._at_gmail.com> wrote:
>
>
>
> > On Jan 29, 10:50 am, davide.cosent..._at_gmail.com wrote:
>
> > > 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 USERPRODUCT_OWNCASCADE;
> > > SQL>CREATE USERPRODUCT_OWNIDENTIFIED BYPRODUCT_OWNDEFAULT
> > > TABLESPACE SYSTEM TEMPORARY TABLESPACE TEMP QUOTA UNLIMITED ON SYSTEM;
> > > SQL>GRANT CREATE SEQUENCE TOPRODUCT_OWN;
> > > SQL>GRANT CREATE TABLE TOPRODUCT_OWN;
> > > SQL>GRANT CREATE VIEW TOPRODUCT_OWN;
> > > SQL>GRANT CREATE SESSION TOPRODUCT_OWN;
> > > SQL> grant dba toPRODUCT_OWN;
> > > SQL> exit
>
> > > >impPRODUCT_OWN/PRODUCT_OWN_at_PRODUCT file=/export/home/oracle/snc01.DMP fromuser=PRODUCT_OWNtouser=PRODUCT_OWNlog=/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 asPRODUCT_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 byPRODUCT_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)
> > > . importingPRODUCT_OWN'sobjects intoPRODUCT_OWN
> > > 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
>
> 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!

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_at_myhost owner=('PRODUCT_OWN') file=pr.dmp

• just tu check done one more export exp system/passsys_at_my_host owner=('PRODUCT_OWN') file=pr_sys.dmp -than i did two imports: imp product_own/product_own_at_myhost fromuser=product_own touser=product_own file=pr.dmp

imp system/passsys_at_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 Received on Tue Jan 29 2008 - 05:37:27 CST