1. 添加监听器配置,listener.ora文件默认包括: LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL =TCP)(HOST = localhost)(PORT = 1521)) ) ) ADR_BASE_LISTENER = /opt/app/ora11g 为了新建监听器名称,添加如下: DCSOPEN = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(Host =...
说这个情况的原因可能是:This means Oracle Net isunable to read the filecorrectly or entry inside the file. 解决方法是:Rebuild the TNSNAMES.ORA file, using the GUI Net Manager tool, is the recommend solution. This will ensure there are no mistakes in the net admin file, for example, bracket...
Instance "dbm2", status READY, has 1 handler(s) for this service... Handler(s): "D000" established:0 refused:0 current:0 max:1022 state:ready DISPATCHER (ADDRESS=(PROTOCOL=tcp)(HOST=qr01db02.example.com)(PORT=46543)) The command completed successfully 1. 2. 3. 4. 5. 6. 7. 8....
: command not foundne 6: : command not foundne 8: : command not foundne 27: : No such file or directoryd: /ldap ': not a valid identifier export: `TMPDIR ': not a valid identifier export: `OLDMASK : command not foundne 31: '/bulkdelete.sh: line 32: syntax error near unexpecte...
(ADDRESS=(PROTOCOL=tcp)(HOST=qr01db02.example.com)(PORT=46543)) The command completed successfully 查看parameter参数 [oracle@qr01db01 ~]$ sqlplus / as sysdba SQL>show parameter remote_listener NAME TYPE VALUE --- --- --- remote_listener string qr01-scan:1521 SQL>show parameter local_list...