centerOS7 静默安装oracle12c后远程登陆不了

[a6687594]

静默安装后测试情况如下

但使用pl/sql登陆报错

服务器使用 lsqlplus sysdba/a12121212@SMP10 报istener does not currently know of service requested in connect

服务器环境配置如下：

服务器主机名如下：

服务器listener.ora配置如下:
LISTENER =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)
(HOST=192.168.254.252)(PORT=1521))
(ADDRESS=(PROTOCOL=ipc)(KEY=SMP10)
)
)

SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=SMP10)
(SID_NAME=SMP10)
(ORACLE_HOME=/data/app/oracle/product/12.1.1/db_home)
(PRESPAWN_MAX=20)
(PRESPAWN_LIST=
(PRESPAWN_DESC=(PROTOCOL=tcp)(POOL_SIZE=2)(TIMEOUT=1))
)
)
)
服务器tnsnames.ora配置如下：
smp10 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.254.252)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SMP10)
)
)
服务器sqlnet.ora配置如下：
NAMES.DIRECTORY_PATH= (TNSNAMES)

windowns测试客户端 tnsnames.ora配置如下:
SMP10 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.254.252)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SMP10)
)
)

求教各位大神帮帮忙查下原因非常感谢！ 本人QQ357143863 可远程最好

[minsic78]

service_name=SMP10.oracle12c 或者 service_name=pdbartemis.oracle12c 看你连哪个库了