Re: IMP-00058: ORACLE error 1017 encountered (invalid username/password)
Date: Tue, 29 Jan 2008 02:34:34 -0800 (PST)
Message-ID: <61c9bb0c-5afe-479d-bb46-99fc674781ef@l1g2000hsa.googlegroups.com>
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! Received on Tue Jan 29 2008 - 04:34:34 CST