SID:
echo $ORACLE_SID
service_name:
sqlplus / as sysdba;
show parameter instance_name;
show parameter service_names;
show parameter service;
select instance_name from v$instance;
tnsname:
netca 查看;
tnsnames.ora查看:打开network/admin下的tnsnames.ora文件:
find . –name “tnsnames.ora” ;
cat tnsnames.ora