View the Oracle Instance name

 

An error occurred while connecting to Oracle today, saying that the Oracle URL is invalid. The Oracle Instance name is depressing because it was not completed during installation. Flowers don't bloom with heart, and you don't have the intention to insert willow trees into the shade. At half past one, I forgot how to check it. Later I read many articles on the Internet intentionally or unintentionally and finally traced them to the configuration file. In fact, in the two configuration files: tnsnames. ora and listener. ora, my path is: D: \ Oracle9i_9.2 \ network \ admin. Enter the Instance name and port number of the remote connection, that is, SERVICE_NAME. In fact, there is another way of viewing, that is, using SQL statements to query. Log on to the system as an administrator and enter the "show parameter service_name;" command.

"Looking for him in the crowd, Baidu, but that person is in the dark." At this time, I really feel this way! Maybe this is the pleasure of learning. It is also the pleasure of life. You can't leave it alone. Continue Learning in the established direction ......