Oracle Database Commands and Practical Examples

SYSDBA Connection Fails With ORA-01017 and ORA-17503 (Doc ID 2474161.1)

SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
oracle@sgdcplm01:~> sqlplus sys/sxxxxxxx@smrrac as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Mon Sep 30 16:08:51 2019

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

ERROR:
ORA-01017: invalid username/password; logon denied
ORA-17503: ksfdopn:2 Failed to open file
+DATA/SMRRAC/PASSWORD/pwdsmrrac.256.1020157701
ORA-12536: TNS:operation would block

Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied

Enter user-name:

ERROR:
ORA-01017: invalid username/password; logon denied

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
oracle@sgdcplm01:~>
oracle@sgdcplm01:~> sqlplus sys/sxxxxxxxx@smrrac as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Mon Sep 30 16:09:02 2019

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

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options

SQL> @d

NAME INSTANCE_NAME DB_UNIQUE_NAME OPEN_MODE DATABASE_ROLE CURRENT_SCN FAILOVER_SCN
--------- ---------------- ------------------------------ -------------------- ---------------- ------------------ ----------------------------------------
SMRRAC smrrac2 smrrac READ WRITE PRIMARY NO 0

SQL> @d

NAME INSTANCE_NAME DB_UNIQUE_NAME OPEN_MODE DATABASE_ROLE CURRENT_SCN FAILOVER_SCN
--------- ---------------- ------------------------------ -------------------- ---------------- ------------------ ----------------------------------------
SMRRAC smrrac2 smrrac READ WRITE PRIMARY NO 0

SQL> @tablespace

NAME OPEN_MODE DATABASE_ROLE DB_UNIQUE_NAME
--------- -------------------- ---------------- ------------------------------
SMRRAC READ WRITE PRIMARY smrrac

Tablespace Allocated Current Used Available %Used (vs)
Name Size(GB) Size(GB) Size(GB) Size(GB) (Allocated)
------------------------------ ------------ ------------ ------------ ------------ ------------
SYSAUX 32.00 .83 .79 31.21 2.48
SYSTEM 32.00 .78 .77 31.23 2.42
UNDOTBS1 32.00 .13 .01 31.99 .02
UNDOTBS2 32.00 .05 .01 31.99 .03
USERS 32.00 .00 .00 32.00 .00

SQL> sho parameter dump

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
background_core_dump string partial
background_dump_dest string /u01/app/oracle/product/12.1.0
/dbhome_2/rdbms/log
core_dump_dest string /u01/app/oracle/diag/rdbms/smr
rac/smrrac2/cdump
max_dump_file_size string unlimited
shadow_core_dump string partial
user_dump_dest string /u01/app/oracle/product/12.1.0
/dbhome_2/rdbms/log
SQL> exit

Scenario Preview:

We are getting error while starting teamcenter console below . Failed to initialize the pool manager.

Error:

sgdc:/u01/teamcenterdata #

sgdc:/u01/Dev/pool_manager/confs/dev # ./mgrstart

Siemens and the Siemens logo are registered trademarks of Siemens AG.

Teamcenter is a registered trademark of Siemens Product Lifecycle Management

Software Inc. or its subsidiaries in the United States and in other countries.

This software and related documentation are proprietary to Siemens Product

Lifecycle Management Software Inc.

Rights Reserved.

JBoss copyright notice

JBoss and its use are subject to license: pool_manager\JBoss_lgpl_license.txt

JacORB copyright notice

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

2.3.0 <www.jacorb.org>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

JacORB and its use are subject to license: pool_manager\JacORB_license.txt

THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS

"AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT

LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR

A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT

OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,

SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT

LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,

DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY

THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT

(INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE

OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

2019/10/16-13:21:58,939 UTC MLD Log init: com.teamcenter.mld version V10000.1.0.51_20160206.00 (20160216)

log.properties found at /u01/SMRDev/pool_manager/confs/minddev/log.properties

INFO - None - 2019/10/16-13:22:24,632 UTC - sgdc.abc.com - Starting Server Pool Mananger.

INFO - None - 2019/10/16-13:22:24,633 UTC - sgdc.abc.com - Found pool configuration file: /u01/Dev/pool_manager/confs/minddev/serverPool.properties

INFO - None - 2019/10/16-13:23:04,808 UTC - sgdc.abc.com - Attempting to establish teamcenter environment ...

INFO - None - 2019/10/16-13:23:04,891 UTC - sgdc.abc.com - Teamcenter Environment established

INFO - None - 2019/10/16-13:24:45,213 UTC - sgdc.abc.com - Mux Address is http://sgdc.abc.com:8087

INFO - None - 2019/10/16-13:24:45,213 UTC - sgdc.abc.com - Found TreeCache configuration file: /u01/SMRDev/pool_manager/confs/dev/TreeCacheTCP.xml

INFO - None - 2019/10/16-13:24:45,295 UTC - sgdc.abc.com - TreeCache Configuration:

TreeCache Cluster Name=Cluster

TreeCache Mode=TCP

Local Service Port=17800

TreeCache Socket Connect Timeout=2000

TreeCache Peers=SGDCPL06[17810]

TreeCache Port Range=1

TreeCache Connection Timeout=15000

TreeCache Merge Min=5000

TreeCache Merge Max=10000

TreeCache Join Timeout=1250

ERROR - None - 2019/10/16-13:24:45,420 UTC - sgdc.abc.com - Error initializing JBoss Cache com.teamcenter.jeti.serversubpoolmanager.ServerPoolManager

org.jgroups.ChannelException: failed to start protocol stack

at org.jgroups.JChannel.connect(JChannel.java:389)

at org.jboss.cache.TreeCache.startService(TreeCache.java:1548)

at com.teamcenter.jeti.SharedStore.init(Unknown Source)

at com.teamcenter.jeti.serversubpoolmanager.ServerPoolManager.initCache(Unknown Source)

at com.teamcenter.jeti.serversubpoolmanager.ServerPoolManager.finishInit(Unknown Source)

at com.teamcenter.jeti.serversubpoolmanager.ServerManager.main(Unknown Source)

Caused by: java.lang.Exception: exception caused by TCP.start()

at org.jgroups.stack.Protocol.handleSpecialDownEvent(Protocol.java:600)

at org.jgroups.stack.DownHandler.run(Protocol.java:118)

Caused by: java.net.BindException: No available port to bind to

at org.jgroups.blocks.ConnectionTable.createServerSocket(ConnectionTable.java:342)

at org.jgroups.blocks.ConnectionTable.start(ConnectionTable.java:174)

at org.jgroups.blocks.ConnectionTable.<init>(ConnectionTable.java:84)

at org.jgroups.protocols.TCP.getConnectionTable(TCP.java:98)

at org.jgroups.protocols.TCP.start(TCP.java:62)

at org.jgroups.stack.Protocol.handleSpecialDownEvent(Protocol.java:589)

... 1 more

Failed to initialize the pool manager

org.jgroups.ChannelException: failed to start protocol stack

at org.jgroups.JChannel.connect(JChannel.java:389)

at org.jboss.cache.TreeCache.startService(TreeCache.java:1548)

at com.teamcenter.jeti.SharedStore.init(Unknown Source)

at com.teamcenter.jeti.serversubpoolmanager.ServerPoolManager.initCache(Unknown Source)

at com.teamcenter.jeti.serversubpoolmanager.ServerPoolManager.finishInit(Unknown Source)

at com.teamcenter.jeti.serversubpoolmanager.ServerManager.main(Unknown Source)

Caused by: java.lang.Exception: exception caused by TCP.start()

at org.jgroups.stack.Protocol.handleSpecialDownEvent(Protocol.java:600)

at org.jgroups.stack.DownHandler.run(Protocol.java:118)

Caused by: java.net.BindException: No available port to bind to

at org.jgroups.blocks.ConnectionTable.createServerSocket(ConnectionTable.java:342)

at org.jgroups.blocks.ConnectionTable.start(ConnectionTable.java:174)

at org.jgroups.blocks.ConnectionTable.<init>(ConnectionTable.java:84)

at org.jgroups.protocols.TCP.getConnectionTable(TCP.java:98)

at org.jgroups.protocols.TCP.start(TCP.java:62)

at org.jgroups.stack.Protocol.handleSpecialDownEvent(Protocol.java:589)

... 1 more

Solution:

Add database details in the tc_profile file.

Location : /u01/Dev/pool_manager/confs/dev

Instance SID : ddev

sgdc:/u01/Dev/pool_manager/confs/dev #

pom_schema_sgdc.abc.com_ddev

TC_BUILD_DATE=100001020130604; export TC_BUILD_DATE

TC_DB_CONNECT=xxxx:xxxxxxxxx@ddev;
export TC_DB_CONNECT

ORACLE_SID=ddev; export ORACLE_SID

TC_DB_SERVER=sgdc.abc.com; export TC_DB_SERVER

Tnsnames.ora entery

sgdc:/u01/teamcenterdata # cat tnsnames.ora

###########

# FILENAME: tnsnames.ora

# DATE : Wed May 03 15:04:46 CEST 2017

###########

XXXRAC =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = sgdc.abc.com)(PORT = 1531))

)

(CONNECT_DATA =

(SERVICE_NAME = rac)

)

XXXDEV =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST =sgdc.abc.com)(PORT = 1531))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = DDEV)

)

Start teamcenter again

sgdc:/u01/Dev/pool_manager/confs/ddev # ./mgrstart