1

Topic: I ask to help with start Listener

Kind time of days!
Re-read like as all branch, but the decision did not find.
The problem fell down unexpectedly - ceased to be launched . Probably beginner-administrator experimented something, or failure any happened, there could not correct by own strength in any way not less (applying the decisions published in this subject). As with affliction I recognize that Linux and Orakl for me a dark planned to learning. If can help - I will be grateful.
listener.ora

# listener.ora Network Configuration File: /u01/app/oracle/product/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME=iwtm)
(ORACLE_HOME =/u01/app/oracle/product/db_1)
(SID_NAME=iwtm)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP) (HOST = u5300-app045.regions.tax.nalog.ru) (PORT = 1521))
)
)

tnsname.ora

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
IWTM =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = u5300-app045.regions.tax.nalog.ru) (PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = iwtm)
)
)

Errors from log

Copyright (c) 1991, 2011, Oracle. All rights reserved.
Starting/u01/app/oracle/product/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.3.0 - Production
System parameter file is /u01/app/oracle/product/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/u5300-app045/listener/alert/log.xml
Listening on: (DESCRIPTION = (ADDRESS = (PROTOCOL=ipc) (KEY=EXTPROC1521)))
Error listening on: (DESCRIPTION = (ADDRESS = (PROTOCOL=TCP) (HOST=u5300-app045.regions.tax.nalog.ru) (PORT=1521)))
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist
Listener failed to start. See the error message (s) above...
<msg time = ' 2017-09-05T16:24:40.685+03:00 ' org_id ='oracle ' comp_id ='tnslsnr'
type ='UNKNOWN ' level = ' 16 ' host_id ='u5300-app045.regions.tax.nalog.ru'
host_addr ='UNKNOWN '>
<txt> Listening on: (DESCRIPTION = (ADDRESS = (PROTOCOL=ipc) (KEY=EXTPROC1521)))
</txt>
</msg>
<msg time = ' 2017-09-05T16:24:40.686+03:00 ' org_id ='oracle ' comp_id ='tnslsnr'
type ='UNKNOWN ' level = ' 16 ' host_id ='u5300-app045.regions.tax.nalog.ru'
host_addr ='UNKNOWN '>
<txt> Error listening on: (DESCRIPTION = (ADDRESS = (PROTOCOL=TCP) (HOST=u5300-app045.regions.tax.nalog.ru) (PORT=1521)))
</txt>
</msg>
<msg time = ' 2017-09-05T16:24:40.687+03:00 ' org_id ='oracle ' comp_id ='tnslsnr'
type ='UNKNOWN ' level = ' 16 ' host_id ='u5300-app045.regions.tax.nalog.ru'
host_addr ='UNKNOWN '>
<txt> TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist
</txt>
</msg>
<msg time = ' 2017-09-05T16:24:40.689+03:00 ' org_id ='oracle ' comp_id ='tnslsnr'
type ='UNKNOWN ' level = ' 16 ' host_id ='u5300-app045.regions.tax.nalog.ru'
host_addr ='UNKNOWN '>
<txt> No longer listening on: (DESCRIPTION = (ADDRESS = (PROTOCOL=ipc) (KEY=EXTPROC1521)))
</txt>
</msg>

2

Re: I ask to help with start Listener

p.s. There is a doubt in, whether that the database is live. Because the services connected to it too are not launched.

[root@u5300-app045 bin] # service iw-trafmon status
Status iw_warpd: [RUNNING]
Status iw_adlibitum: [NOT RUNNING]
Status iw_sniffer: [DISABLED]
Status iw_messed: [DISABLED]
Status iw_deliverd: [DISABLED]
Status iw_smtpd: [DISABLED]
Status iw_expressd: [RUNNING]
Status iw_proxy ICQ: [DISABLED]
Status iw_proxy HTTP: [DISABLED]
Status iw_proxy SMTP: [DISABLED]
Status iw_icap: [DISABLED]
Status iw_dbloader: [NOT RUNNING]
Status iw_updater: [NOT RUNNING]
[root@u5300-app045 bin] #

3

Re: I ask to help with start Listener

Dobrosvet;

Connect failed because target host or object does not exist
host_id ='u5300-app045.regions.tax.nalog.ru

To you writes that there is no such host u5300-app045.regions.tax.nalog.ru

4

Re: I ask to help with start Listener

irbis_al;
Nevertheless, he sees such host. It  as on IP, and by name.

[root@u5300-app045 log]
# hostname
u5300-app045.regions.tax.nalog.ru

5

Re: I ask to help with start Listener

irbis_al;
If I remove from Listener.ora this piece it without problems is launched.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME=iwtm)
(ORACLE_HOME =/u01/app/oracle/product/db_1)
(SID_NAME=iwtm)

6

Re: I ask to help with start Listener

Dobrosvet;
With the rights were not played?
Updates of packets and OS libraries any were rolled?

7

Re: I ask to help with start Listener

1. To check up/etc/hosts
There it is registered?
2. Instead of a name to deliver 0.0.0.0 - will listen to all interfaces if it does not contradict a policy of the party.

8

Re: I ask to help with start Listener

Dobrosvet wrote:

If I remove from Listener.ora this piece

ls-l $ORACLE_BASE/diag/rdbms

9

Re: I ask to help with start Listener

Dobrosvet;
And the second question and from whom you launch ? From root? Or from  ?

10

Re: I ask to help with start Listener

env;
Unfortunately, I do not know. Transferred the server "by right of succession". Initially there was a preinstalled system with all adjustments.  is not present :-(

11

Re: I ask to help with start Listener

Dobrosvet wrote:

env;
Unfortunately, I do not know. Transferred the server "by right of succession". Initially there was a preinstalled system with all adjustments.  is not present :-(

You read through a line?

12

Re: I ask to help with start Listener

Q.Tarantino;

hosts [B--] 0 L: [1 + 0 1/4] * (0 / 206b) 0049 0x031
10.153.200.45 u5300-app045.regions.tax.nalog.ru
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
:: 1 localhost localhost.localdomain localhost6 localhost6.localdomain6
[root@u5300-app045 etc] # ls-l $ORACLE_BASE/diag/rdbms
total 4
drwxrwxr-x 3 oracle oinstall 4096 Oct 31 2014 iwtm
[root@u5300-app045 etc] #

:: And the second question and from whom you launch ? From root? Or from  ?
Most likely under . At least in the console I work under .
:: you read through a line?
I do not know as all to answer in one window.

13

Re: I ask to help with start Listener

Dobrosvet wrote:

:: And the second question and from whom you launch ? From root? Or from  ?
Most likely under . At least in the console I work under .

The wrong approach.
it is necessary to start under the owner  (at you it is the user oracle)

14

Re: I ask to help with start Listener

Dobrosvet;
Under root start it is bad...
If at you not XE (and apparently e you not XE) it is necessary to launch from  the user (as a rule ' it oracle)
But now so  too from  can it will not be launched for broad gulls created from  can beat out process on . it is necessary to delete. To (move)

15

Re: I ask to help with start Listener

irbis_al wrote:

But now so  too from  can it will not be launched for broad gulls created from  can beat out process on . it is necessary to delete. To (move)

Still is chown...

16

Re: I ask to help with start Listener

Q.Tarantino;
Tried. Did not help.

[root@u5300-app045 etc] # su - oracle
[oracle@u5300-app045 ~] $ lsnrctl stop
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 06-SEP-2017 10:57:35 AM
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL=IPC) (KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 2: No such file or directory
Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL=TCP) (HOST=u5300-app045.regions.tax.nalog.ru) (PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
[oracle@u5300-app045 ~] $ lsnrctl start
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 06-SEP-2017 10:57:39 AM
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Starting/u01/app/oracle/product/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.3.0 - Production
System parameter file is /u01/app/oracle/product/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/u5300-app045/listener/alert/log.xml
Listening on: (DESCRIPTION = (ADDRESS = (PROTOCOL=ipc) (KEY=EXTPROC1521)))
Listening on: (DESCRIPTION = (ADDRESS = (PROTOCOL=tcp) (HOST=u5300-app045.regions.tax.nalog.ru) (PORT=1521)))
TNS-01201: Listener cannot find executable/u01/app/oracle/product/db_1/bin/oracle for SID iwtm
Listener failed to start. See the error message (s) above...
[oracle@u5300-app045 ~] $

It is possible to check up DB presence somehow? At me simply raises the doubts its presence or integrity...

17

Re: I ask to help with start Listener

Dobrosvet;

wrote:

cannot find executable/u01/app/oracle/product/db_1/bin/oracle

The rights check also presence of files

18

Re: I ask to help with start Listener

Dobrosvet wrote:

irbis_al;
If I remove from Listener.ora this piece it without problems is launched.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME=iwtm)
(ORACLE_HOME =/u01/app/oracle/product/db_1)
(SID_NAME=iwtm)

It is launched and listens SID_NAME (GLOBAL) =iwtm
Then launch and hammer on those lines.
I too do not have these lines. (Autoregistration)

19

Re: I ask to help with start Listener

env;
Yes like as access is
[oracle@u5300-app045 oracle] $ ls-lh
total 40K
drwxrwxr-x 3 oracle oinstall 4.0K Oct 31 2014 admin
drwxrwxr-x 6 oracle oinstall 4.0K Oct 31 2014 cfgtoollogs
drwxrwxr-x 2 oracle oinstall 4.0K Oct 31 2014 checkpoints
drwxrwxr-x 11 oracle oinstall 4.0K Oct 31 2014 diag
drwxrwxr-x 4 oracle oinstall 4.0K Oct 31 2014 fast_recovery_area
drwxrwxr-x 3 oracle oinstall 4.0K Oct 31 2014 oradata
drwxrwxr-x 3 oracle oinstall 4.0K Sep 1 23:59 oradiag_iwtm
drwxrwxr-x 3 oracle oinstall 4.0K Sep 2 00:01 oradiag_oracle
drwxrwxr-x 3 oracle oinstall 4.0K Nov 17 2014 oradiag_root
drwxrwxr-x 3 oracle oinstall 4.0K Oct 31 2014 product
[oracle@u5300-app045 oracle] $
> It is launched and listens SID_NAME (GLOBAL) =iwtm
Then launch and hammer on those lines.
I too do not have these lines. (Autoregistration)
On Linux the virtual machine is torn still . If I will delete - there will be no problem with connection?

20

Re: I ask to help with start Listener

Dobrosvet wrote:

[oracle@u5300-app045 oracle] $ ls-lh

Well it would be logical to type

ls-l/u01/app/oracle/product/db_1/bin/oracle

21

Re: I ask to help with start Listener

Checked up. If to delete a line in Listener.ora/Now beats such error:

Connecting... ORA-12514: TNS: at present has no data about the service requested in a descriptor of connection
The test did not succeed.
Some of the information you provided may be incorrect.
Click Back to review the information provided for net service name, or Change Login to change username.

22

Re: I ask to help with start Listener

Dobrosvet wrote:

Checked up. If to delete a line in Listener.ora/Now beats such error:

Connecting... ORA-12514: TNS: at present has no data about the service requested in a descriptor of connection
The test did not succeed.
Some of the information you provided may be incorrect.
Click Back to review the information provided for net service name, or Change Login to change username.

And here now it is necessary it will be convinced that the basis is launched (she is registered in )

sqlplus
connect/as sysdba

23

Re: I ask to help with start Listener

irbis_al wrote:

it is passed...
And here now it is necessary it will be convinced that the basis is launched (she is registered in )

sqlplus
connect/as sysdba
Though when the basis is extinguished ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
12505 arises instead of 12514

24

Re: I ask to help with start Listener

irbis_al;
It is not connected, the type is not present . As though and where to check up its presence?

[root@u5300-app045 oradata] # su - oracle
[oracle@u5300-app045 ~] $ sqlplus
SQL*Plus: Release 11.2.0.3.0 Production on Wed Sep 6 0:20:40 PM 2017
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Enter user-name: oracle
Enter password:
ERROR:
ORA-12545: Connect failed because target host or object does not exist

25

Re: I ask to help with start Listener

Dobrosvet wrote:

irbis_al;
It is not connected, the type is not present . As though and where to check up its presence?

[root@u5300-app045 oradata] # su - oracle
[oracle@u5300-app045 ~] $ sqlplus
SQL*Plus: Release 11.2.0.3.0 Production on Wed Sep 6 0:20:40 PM 2017
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Enter user-name: oracle
Enter password:
ERROR:
ORA-12545: Connect failed because target host or object does not exist

I wrote to you

Enter user-name:/as sysdba

Exactly one to one as it is written/as sysdba
To work (to type sqlplus) you should under linux user oracle