Oracle 11g Ora-12514:tns: The listener does not currently recognize the requested service in the connection descriptor

Create a database test

1. Open the Oracle Net Manager

2. Service Naming: Test

TCPIP Host: 127.0.0.1 Port: 1521

3. Listening programs

Select a listening location

Network address: localhost

Port: 1521

Select Database Service

Global database name Sid:test

4. Stop the monitoring service to start the monitoring service

# Listener.ora Network Configuration file:e:\app\administrator\product\11.1.0\db_1\network\admin\listener.ora# Generated by Oracle configuration tools. Sid_list_listener =  (sid_list = (    Sid_desc =      (global_dbname = Test) (      sid_name = test)    )    (sid_ DESC =      (global_dbname = NBS)      (sid_name = NBS)    )  ) LISTENER =  (DESCRIPTION = (    ADDRESS = ( PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))  

2 Database Services A test, a NBS, a public listener

# Tnsnames.ora Network Configuration file:e:\app\administrator\product\11.1.0\db_1\network\admin\tnsnames.ora# Generated by Oracle configuration tools.test=  (DESCRIPTION = (    address_list = (      ADDRESS = (PROTOCOL = TCP) ( HOST = 127.0.0.1) (PORT = 1521))    (connect_data =      (SERVER = dedicated)      (service_name = Test  )) NBS =  (DESCRIPTION = (    address_list = (      ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521))    ) 
     (Connect_data =      (SERVER = dedicated)      (service_name = NBS)    )  )

Oracle 11g Ora-12514:tns: The listener does not currently recognize the requested service in the connection descriptor