Hello,
I am relatively new to Oracle. Have an issue on a server when tried to login to connect to a database.
Here are the details.
***Moderator note (timo): obfuscated user name, password and ip address from your post as they are considered private data which you should not share here in this public space.***
I am trying to connect to sqlplus as registry user
-bash-4.1$ sudo su - oracle
-bash-4.1$ whoami
oracle
-bash-4.1$ export ORACLE_SID=brix
-bash-4.1$ sqlplus xxx/xxx@brix
SQL*Plus: Release 11.2.0.3.0 Production on Tue Apr 11 15:20:29 2017
Copyright (c) 1982, 2011, Oracle. All rights reserved.
ERROR:
ORA-12537: TNS:connection closed
Enter user-name:
I can actually connect if I do it this way by typing the user id and password when prompted as below. Only I cannot connect if I supply the login and password with sqlplus command as above.
Enter password:
-bash-4.1$ sqlplus
SQL*Plus: Release 11.2.0.3.0 Production on Tue Apr 11 15:22:21 2017
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Enter user-name: registry
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
---------------
Here is the tns ping output on 172.xx.xx.xx. I notice there is no parameter file listed.
-bash-4.1$ tnsping brix
TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 11-APR-2017 16:28:03
Copyright (c) 1997, 2011, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.xx.xx.xx(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = brix)))
OK (0 msec)