C:\APLM\app\infodba\product\11.2.0\dbhome_1\BIN>lsnrctl status

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 26-JUL-2016 13:59
:26

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=TEAMCENTER.amwasia.com)(
PORT=1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   64-bit Windows Error: 61: Unknown error

# listener.ora Network Configuration File: C:\APLM\app\infodba\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\APLM\app\infodba\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\APLM\app\infodba\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = TEAMCENTER.amwasia.com)(PORT = 1521))
)
)
ADR_BASE_LISTENER = C:\APLM\app\infodba

# tnsnames.ora Network Configuration File: C:\APLM\app\infodba\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
PEP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = TEAMCENTER.amwasia.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PEP)
)
)
TCRA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = TEAMCENTER.amwasia.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TCRA)
)
)
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
SQLNET.AUTHENTICATION_SERVICES = (NONE)

lsnrctl start

sc stop OracleOraDb11g_home1TNSListener
sc delete OracleOraDb11g_home1TNSListener
lsnrctl start listener

C:\APLM\app\infodba\product\11.2.0\dbhome_1\NETWORK\ADMIN>sc stop OracleOraDb11g
_home1TNSListener

SERVICE_NAME: OracleOraDb11g_home1TNSListener
        TYPE               : 10  WIN32_OWN_PROCESS
        STATE              : 3  STOP_PENDING
                                (STOPPABLE, NOT_PAUSABLE, IGNORES_SHUTDOWN)
        WIN32_EXIT_CODE    : 0  (0x0)
        SERVICE_EXIT_CODE  : 0  (0x0)
        CHECKPOINT         : 0x0
        WAIT_HINT          : 0x0

C:\APLM\app\infodba\product\11.2.0\dbhome_1\NETWORK\ADMIN>sc delete OracleOraDb1
1g_home1TNSListener
[SC] DeleteService SUCCESS

C:\APLM\app\infodba\product\11.2.0\dbhome_1\NETWORK\ADMIN>lsnrctl start listener


LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 28-JUL-2016 11:54
:30

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

Starting tnslsnr: please wait...

Failed to open service <OracleOraDb11g_home1TNSListener>, error 1060.
TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
System parameter file is C:\APLM\app\infodba\product\11.2.0\dbhome_1\NETWORK\ADM
IN\listener.ora
Log messages written to c:\aplm\app\infodba\diag\tnslsnr\TEAMCENTER\listener\ale
rt\log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=TEAMCENTER.amwasia.com)(
PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=TEAMCENTER.amwasia.com)(
PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     listener
Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
ction
Start Date                28-JUL-2016 11:55:22
Uptime                    0 days 0 hr. 5 min. 58 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   C:\APLM\app\infodba\product\11.2.0\dbhome_1\NETWORK\AD
MIN\listener.ora
Listener Log File         c:\aplm\app\infodba\diag\tnslsnr\TEAMCENTER\listener\a
lert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=TEAMCENTER.amwasia.com)(PORT=1521)))

Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "TCRA" has 1 instance(s).
  Instance "TCRA", status READY, has 1 handler(s) for this service...
The command completed successfully

C:\APLM\app\infodba\product\11.2.0\dbhome_1\NETWORK\ADMIN>

C:\APLM\app\infodba\product\11.2.0\dbhome_1\NETWORK\ADMIN>lsnrctl status

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 28-JUL-2016 12:22
:04

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=TEAMCENTER.amwasia.com)(
PORT=1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   64-bit Windows Error: 61: Unknown error

C:\APLM\app\infodba\product\11.2.0\dbhome_1\NETWORK\ADMIN>

where lsnrctl

whoami /groups

C:\APLM\app\infodba\product\11.2.0\dbhome_1\NETWORK\ADMIN>where lsnrctl
C:\APLM\app\infodba\product\11.2.0\dbhome_1\BIN\LSNRCTL.EXE

C:\APLM\app\infodba\product\11.2.0\dbhome_1\NETWORK\ADMIN>whoami /groups

GROUP INFORMATION
-----------------

Group Name                                                    Type             S
ID                                          Attributes

============================================================= ================ =
=========================================== ====================================
===========================
Everyone                                                      Well-known group S
-1-1-0                                      Mandatory group, Enabled by default,
 Enabled group
NT AUTHORITY\Local account and member of Administrators group Well-known group S
-1-5-114                                    Mandatory group, Enabled by default,
 Enabled group
TEAMCENTER\ora_dba                                            Alias            S
-1-5-21-1693983369-53828479-2588551842-1001 Mandatory group, Enabled by default,
 Enabled group
BUILTIN\Administrators                                        Alias            S
-1-5-32-544                                 Mandatory group, Enabled by default,
 Enabled group, Group owner
BUILTIN\Users                                                 Alias            S
-1-5-32-545                                 Mandatory group, Enabled by default,
 Enabled group
NT AUTHORITY\REMOTE INTERACTIVE LOGON                         Well-known group S
-1-5-14                                     Mandatory group, Enabled by default,
 Enabled group
NT AUTHORITY\INTERACTIVE                                      Well-known group S
-1-5-4                                      Mandatory group, Enabled by default,
 Enabled group
NT AUTHORITY\Authenticated Users                              Well-known group S
-1-5-11                                     Mandatory group, Enabled by default,
 Enabled group
NT AUTHORITY\This Organization                                Well-known group S
-1-5-15                                     Mandatory group, Enabled by default,
 Enabled group
NT AUTHORITY\Local account                                    Well-known group S
-1-5-113                                    Mandatory group, Enabled by default,
 Enabled group
LOCAL                                                         Well-known group S
-1-2-0                                      Mandatory group, Enabled by default,
 Enabled group
NT AUTHORITY\NTLM Authentication                              Well-known group S
-1-5-64-10                                  Mandatory group, Enabled by default,
 Enabled group
Mandatory Label\High Mandatory Level                          Label            S
-1-16-12288                                 Mandatory group, Enabled by default,
 Enabled group

C:\APLM\app\infodba\product\11.2.0\dbhome_1\NETWORK\ADMIN>

C:\>sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Thu Jul 28 12:51:41 2016

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

Enter user-name: infodba
Enter password:

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

SQL> connect infodba/infodba as sysdba
Connected.
SQL>

C:\> sqlplus infodba/infodba@pep as sysdba

C:\>sqlplus infodba/infodba@PEP as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Jul 28 15:32:39 2016

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

ERROR:
ORA-12541: TNS:no listener


Enter user-name: infodba
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Process ID: 0
Session ID: 0 Serial number: 0


Enter user-name:

C:\> set | sort

C:\>set | sort
ALLUSERSPROFILE=C:\ProgramData
APPDATA=C:\Users\infodba\AppData\Roaming
BOOKSHELF=C:\IFOR\WIN\BIN\EN_US
CLIENTNAME=AMW-WS-141
CommonProgramFiles(x86)=C:\Program Files (x86)\Common Files
CommonProgramFiles=C:\Program Files\Common Files
CommonProgramW6432=C:\Program Files\Common Files
COMPUTERNAME=TEAMCENTER
ComSpec=C:\Windows\system32\cmd.exe
FMS_HOME=C:\APLM\Siemens\TEAMCE~1\fcc
FP_NO_HOST_CHECK=NO
HELP=C:\IFOR\WIN\BIN
HOMEDRIVE=C:
HOMEPATH=\Users\infodba
I4_INSTALL_DRIVE=C:
I4_LANG=EN_US
IPF_PATH32=C:\IFOR\WIN\BIN\EN_US
JAVA_HOME=C:\Program Files\Java\jdk1.6.0_07
LOCALAPPDATA=C:\Users\infodba\AppData\Local
LOGONSERVER=\\TEAMCENTER
NLSPATH=C:\IFOR\LS\MSG\%L\%N
NUMBER_OF_PROCESSORS=16
ORACLE_HOME=C:\APLM\app\infodba\product\11.2.0\dbhome_1
ORACLE_SID=PEP
OS=Windows_NT
Path=C:\APLM\app\infodba\product\11.2.0\dbhome_1\bin;C:\Windows\system32;C:\Wind
ows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\APLM
\Siemens\Teamcenter8.3\Visualization\Products\Mockup\ClearanceDB;C:\Program File
s\Java\jdk1.6.0_07\jre\bin;C:\Program Files (x86)\7-Zip;C:\APLM\Siemens\NX7.5\UG
II;C:\IFOR\WIN\BIN;C:\IFOR\WIN\BIN\EN_US;C:\Program Files (x86)\Dell\SysMgt\oma\
bin;C:\Program Files (x86)\Dell\SysMgt\idrac
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
PROCESSOR_ARCHITECTURE=AMD64
PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 44 Stepping 2, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=2c02
ProgramData=C:\ProgramData
ProgramFiles(x86)=C:\Program Files (x86)
ProgramFiles=C:\Program Files
ProgramW6432=C:\Program Files
PROMPT=$P$G
PSModulePath=C:\Windows\system32\WindowsPowerShell\v1.0\Modules\
PUBLIC=C:\Users\Public
SESSIONNAME=RDP-Tcp#0
SystemDrive=C:
SystemRoot=C:\Windows
TC_ROOT=C:\APLM\Siemens\Teamcenter8
TCVIS_CLUSTER_PATH=C:\APLM\Siemens\Teamcenter8.3\Visualization\Products\Mockup\V
isView.exe
TEMP=C:\Users\infodba\AppData\Local\Temp\2
TMP=C:\Users\infodba\AppData\Local\Temp\2
TNS_ADMIN=C:\APLM\app\infodba\product\11.2.0\dbhome_1\NETWORK\ADMIN
UGII_BASE_DIR=C:\APLM\Siemens\NX7.5
UGII_LANG=english
UGII_ROOT_DIR=C:\APLM\Siemens\NX7.5\UGII\
UGS_LICENSE_BUNDLE=NX13300N;P1
UGS_LICENSE_SERVER=28000@amwnx,28000@TEAMCENTER,28000@amwcae
USER_FILE=C:\APLM\AMW_ENV\TC\AMWSave.dll
USERDOMAIN=TEAMCENTER
USERNAME=infodba
USERPROFILE=C:\Users\infodba
windir=C:\Windows