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  |
reym21
Messages: 241
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  |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
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 |
reym21
Messages: 241
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 #574316 is a reply to message #574311] |
Tue, 08 January 2013 23:42 |
reym21
Messages: 241
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 #574487 is a reply to message #574330] |
Thu, 10 January 2013 23:21 |
reym21
Messages: 241
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>>
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Sat Feb 01 21:36:17 CST 2025
|
] 
Blog
Search
Help
Members
Register
Login
Home
