Home » RDBMS Server » Security » Remote connection using SYS (Oracle 10g 10.2.0.4.0/ Solaris 10)
Remote connection using SYS [message #574303] Tue, 08 January 2013 20:10 Go to next message
reym21
Messages: 178
Registered: February 2010
Location: Philippines
Senior Member

Gurus,

Good day.

Please clear things up to me. It's quite confusing while testing
SYS remote connection in our staging server. Executing the command
below is OK:

sqlplus sys/<password>@sales as sysdba

While this is mind-boggling for me...

sqlplus sys@sales as sysdba

Enter password:
ERROR:
ORA-01017: Message 1017 not found; No message file for product=RDBMS,
facility=ORA

Enter user-name:
ERROR:
Error while trying to retrieve text for error ORA-01017

What causes this? I'm very sure that I entered the correct password.
I've been simulating this for a couple of times, even tried the
copy-and-paste method.

Thank you in advance.
Re: Remote connection using SYS [message #574304 is a reply to message #574303] Tue, 08 January 2013 20:36 Go to previous messageGo to next message
BlackSwan
Messages: 22558
Registered: January 2009
Senior Member
ORACLE_HOME is not correct (likely inside listener.ora)
[oracle@localhost dbs]$ sqlplus user1/user1

SQL*Plus: Release 11.2.0.2.0 Production on Tue Jan 8 18:16:00 2013

Copyright (c) 1982, 2010, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@localhost dbs]$ unset ORACLE_HOME
[oracle@localhost dbs]$ sqlplus user1/user1
Error 6 initializing SQL*Plus
SP2-0667: Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
[oracle@localhost ~]$ oerr ora 1017
01017, 00000, "invalid username/password; logon denied"
// *Cause:
// *Action:


can you successfully login as normal, non-privileged user?
Re: Remote connection using SYS [message #574305 is a reply to message #574304] Tue, 08 January 2013 21:29 Go to previous messageGo to next message
reym21
Messages: 178
Registered: February 2010
Location: Philippines
Senior Member

Sir, many thanks for your prompt reply.
Copying what you've done, please see below:

[server1]:sales>/export/home/oracle>> sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Jan 9 10:58:05 2013
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create user user1 identified by user1;

User created.

SQL> grant create session to user1;

Grant succeeded.

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

[server1]:sales>/export/home/oracle>> sqlplus user1/user1

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Jan 9 10:59:08 2013
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show user
USER is "USER1"
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[server1]:sales>/export/home/oracle>> unset ORACLE_HOME
[server1]:sales>/export/home/oracle>> sqlplus user1/user1
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

Here's what inside the LISTENER.ORA

[server1]:sales>/appl1/home/oracle/10.2/network/admin>> view listener.ora
"listener.ora" [Read only] 54 lines, 1276 characters
# listener.ora Network Configuration File: /appl1/home/oracle/10.2/network/admin
/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /appl1/home/oracle/10.2)
(PROGRAM = extproc)
)
...
)
(SID_DESC =
(SID_NAME = sales)
(ORACLE_HOME = /appl1/home/oracle/10.2)
)
:q!
[server1]:sales>/appl1/home/oracle/10.2/network/admin>> cd
[server1]:sales>/export/home/oracle>>
[server1]:sales>/export/home/oracle>> echo $ORACLE_HOME
/appl1/home/oracle/10.2
[server1]:sales>/export/home/oracle>>

Re: Remote connection using SYS [message #574311 is a reply to message #574305] Tue, 08 January 2013 22:33 Go to previous messageGo to next message
BlackSwan
Messages: 22558
Registered: January 2009
Senior Member
can you successfully login as normal, non-privileged user as below?

sqlplus scott/tiger@sales

How many different DB Server systems are involved with this discussion?
Re: Remote connection using SYS [message #574316 is a reply to message #574311] Tue, 08 January 2013 23:42 Go to previous messageGo to next message
reym21
Messages: 178
Registered: February 2010
Location: Philippines
Senior Member

Sir,

This lone dB server have 3 Oracle Homes... for 9i (1 instance), 10gR2 (10 instances)
and 11gR2 (2 instances).

As per simulation:

[server1]:sales>/export/home/oracle>> sqlplus scott@sales

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Jan 9 13:29:58 2013
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Enter password:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show user
USER is "SCOTT"
SQL>
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[server1]:sales>/export/home/oracle>>
[server1]:sales>/export/home/oracle>> sqlplus scott/tiger@sales

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Jan 9 13:31:05 2013
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show user
USER is "SCOTT"
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

[server1]:sales>/export/home/oracle>> sqlplus sys@sales as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Jan 9 13:30:34 2013
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Enter password:
ERROR:
ORA-01017: Message 1017 not found; No message file for product=RDBMS,
facility=ORA

Enter user-name: ^C
Re: Remote connection using SYS [message #574330 is a reply to message #574316] Wed, 09 January 2013 01:23 Go to previous messageGo to next message
Michel Cadot
Messages: 58643
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So your password is wrong.

Regards
Michel
Re: Remote connection using SYS [message #574487 is a reply to message #574330] Thu, 10 January 2013 23:21 Go to previous messageGo to next message
reym21
Messages: 178
Registered: February 2010
Location: Philippines
Senior Member

No, Sir, I entered the correct password, thanks...

[server1]:sales>/export/home/oracle>> sqlplus sys@sales as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Fri Jan 11 13:10:08 2013
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Enter password: <p4s$w0rD>
ERROR:
ORA-01017: Message 1017 not found; No message file for product=RDBMS,
facility=ORA

Enter user-name:
ERROR:
Error while trying to retrieve text for error ORA-01017

Enter user-name:
ERROR:
Error while trying to retrieve text for error ORA-01017

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
[server1]:sales>/export/home/oracle>>
[server1]:sales>/export/home/oracle>> sqlplus sys/p4s$w0rD@sales as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Fri Jan 11 13:10:32 2013
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show user
USER is "SYS"
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[server1]:sales>/export/home/oracle>>
Re: Remote connection using SYS [message #574489 is a reply to message #574487] Fri, 11 January 2013 00:46 Go to previous messageGo to next message
Michel Cadot
Messages: 58643
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
No, Sir, I entered the correct password, thanks...


If you are sure, then file a bug to Oracle.

Regards
Michel
Re: Remote connection using SYS [message #574490 is a reply to message #574489] Fri, 11 January 2013 01:16 Go to previous message
reym21
Messages: 178
Registered: February 2010
Location: Philippines
Senior Member

Sir, thanks for this suggestion.


Regards,
Previous Topic: Oracle Auditing DBA_STMT_AUDIT_OPTS where user_name is null
Next Topic: v$session logs
Goto Forum:
  


Current Time: Fri Aug 01 20:45:08 CDT 2014

Total time taken to generate the page: 0.11089 seconds