1

Info

 connection name: ziv 
 username:sys
 password: xxxxxxx
 connection type: basic 
 role: sysdba 
 host name : localhost.localdomain
 port: 1522
 sid: ziv

The QUAST is to connect to the database ziv using Sql Developer.

This database was created using dbca.

I am new to both Linux and oracle.

What I need to do... ora-12505 ^^

I think the problem is at bash

  [oracle@localhost Desktop]$ tnsping ziv1

   TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 
   09-DEC-2015 12:38:44

   Copyright (c) 1997, 2009, Oracle.  All rights reserved.

   Used parameter files:
   /u01/app/oracle/product/11.2.0/db_1/network/admin/sqlnet.ora


   Used TNSNAMES adapter to resolve the alias
   Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS =   
  (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1523)))   
  (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME =  
   ziv1.localdomain)))
   OK (0 msec)
   [oracle@localhost Desktop]$ lssnrctl services
   bash: lssnrctl: command not found
   [oracle@localhost Desktop]$ lsnrctl services

   LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 09-DEC-2015 
   12:39:59

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

   Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP) 
  (HOST=localhost.localdomain)(PORT=1521)))
   The listener supports no services
   The command completed successfully

lsnctl status:

I got a 3 LISTENER name LISTENER port 1521 ziv port 1522 ziv1 port 1523

lsnrctl start listener:

 [oracle@localhost Desktop]$ lsnrctl start listener
 LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 10-DEC-2015  
 02:15:16
 Copyright (c) 1991, 2009, Oracle.  All rights reserved.
 TNS-01106: Listener using listener name LISTENER has already been  
 started
 [oracle@localhost Desktop]$ lsnrctl status ziv
 LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 10-DEC-2015    
 02:15:32 
 Copyright (c) 1991, 2009, Oracle.  All rights reserved.
 Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)  
 (HOST=localhost.localdomain)(PORT=1522)))
 STATUS of the LISTENER
 ------------------------
 Alias                     ziv
 Version                   TNSLSNR for Linux: Version 11.2.0.1.0 -  
 Production
 Start Date                10-DEC-2015 02:05:28
 Uptime                    0 days 0 hr. 10 min. 4 sec
 Trace Level               off
 Security                  ON: Local OS Authentication
 SNMP                      OFF
 Listener Parameter File   /u01/app/oracle/product/11.2.0/db_1/network  
 /admin/listener.ora
 Listener Log File         /u01/app/oracle/diag/tnslsnr/localhost  
 /ziv/alert/log.xml
 Listening Endpoints Summary...
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1522)))
 The listener supports no services
 The command completed successfully

OK what now?

0
1

Did you:

  • configure listener properly with service-name...,
  • then start your listener with ~]# lsnrctl start <listener-name>;
  • and then check status of listener using ~]lsnrctl status <listener-name> ?
0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.