sql+plus远程连接mysql_sqlplus conn远程连接

oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0

oracle.install.option=INSTALL_DB_AND_CONFIG

ORACLE_HOSTNAME=nas-ss.cc

UNIX_GROUP_NAME=oinstall

INVENTORY_LOCATION=/ocr/DBSoftware/app/oraInventory

SELECTED_LANGUAGES=en,zh_CN

ORACLE_HOME=/ocr/DBSoftware/app/oracle/product/11.2.0/dbhome_1

ORACLE_BASE=/ocr/DBSoftware/app/oracle

oracle.install.db.InstallEdition=EE

oracle.install.db.isCustomInstall=false

oracle.install.db.customComponents=oracle.server:11.2.0.1.0,oracle.sysman.ccr:10.2.7.0.0,oracle.xdk:11.2.0.1.0,oracle.rdbms.oci:11.2.0.1.0,oracle.network:11.2.0.1.0,oracle.network.listener:11.2.0.1.0,oracle.rdbms:11.2.0.1.0,oracle.options:11.2.0.1.0,oracle.rdbms.partitioning:11.2.0.1.0,oracle.oraolap:11.2.0.1.0,oracle.rdbms.dm:11.2.0.1.0,oracle.rdbms.dv:11.2.0.1.0,orcle.rdbms.lbac:11.2.0.1.0,oracle.rdbms.rat:11.2.0.1.0

oracle.install.db.DBA_GROUP=dba

oracle.install.db.OPER_GROUP=oinstall

oracle.install.db.config.starterdb.type=GENERAL_PURPOSE

oracle.install.db.config.starterdb.globalDBName=master.nas-ss.cc

oracle.install.db.config.starterdb.SID=master

oracle.install.db.config.starterdb.characterSet=ZHS16GBK

oracle.install.db.config.starterdb.memoryOption=true

oracle.install.db.config.starterdb.memoryLimit=1024

oracle.install.db.config.starterdb.installExampleSchemas=true

oracle.install.db.config.starterdb.enableSecuritySettings=true

oracle.install.db.config.starterdb.password.ALL=byRuiy.org89

oracle.install.db.config.starterdb.password.SYS=byRuiy.org89

oracle.install.db.config.starterdb.password.SYSTEM=byRuiy.org89

oracle.install.db.config.starterdb.password.SYSMAN=byRuiy.org89

oracle.install.db.config.starterdb.password.DBSNMP=byRuiy.org89

oracle.install.db.config.starterdb.control=DB_CONTROL

oracle.install.db.config.starterdb.dbcontrol.enableEmailNotification=false

oracle.install.db.config.starterdb.automatedBackup.enable=false

oracle.install.db.config.starterdb.storageType=FILE_SYSTEM_STORAGE

oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=/ocr/DBData/oradata

oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=/ocr/DBData/oradata/flash_recovery_area

/ruiy/ocr/DBSoftware/app/oraInventory/orainstRoot.sh

/ruiy/ocr/DBSoftware/app/oracle/product/11.2.0/dbhome_1/root.sh

To execute the configuration scripts:

1. Open a terminal window

2. Log in as "root"

3. Run the scripts

4. Return to this window and hit "Enter" key to continue

Successfully Setup Software

报错提示:

The listener supports no services

The command completed successfully

这样启动后远程连接会报错：

oracle ORA-12514:TNS:listener does not currently know of service requested in connect descriptor

问题原因：数据库实例没注册到listener

解决方法一：

在listener.ora里面添加了一行

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = orcl)

(SID_NAME = orcl)

)

)

注：里面的orcl根据你安装的数据库实例名确定，我用此法解决了这个报错。

解决方法二：

登录数据库：

$sqlplus / as sysdba

显示服务名：

SQL>show parameter service_names

强制注册服务：

SQL>alter system register;

查看监听状态：

$lsnrctl status