Visit Counter

Wednesday, July 24, 2019

ORA-00119: invalid specification ORA-00132: syntax error






bash-4.2$ ./sqlplus /nolog

SQL*Plus: Release 12.1.0.2.0 Production on Wed Jul 24 18:36:32 2019

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup pfile='/u01/oracle/VIS/12.1.0/dbs/initVIS.ora';
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'VIS'




bash-4.2$ pwd
/u01/oracle/VIS/12.1.0/dbs
bash-4.2$ ls
arch1_112_899608883.dbf  initVIS.ora   RMANinit.ora
hc_VIS.dat initVIS.ora.org  VIS_ebs1_ifile.ora
initVIS_noaq.ora lkVIS   VIS_ifile.ora


bash-4.2$ vi initVIS.ora

#################
# Service Parameters
#################

loca



bash-4.2$ ./sqlplus /nolog

SQL*Plus: Release 12.1.0.2.0 Production on Wed Jul 24 18:40:35 2019

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 2147483648 bytes
Fixed Size     2926472 bytes
Variable Size   452987000 bytes
Database Buffers 1677721600 bytes
Redo Buffers    13848576 bytes
Database mounted.
Database opened.
SQL> exit

LSNRCTL> start
Starting /u01/oracle/VIS/12.1.0//bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Log messages written to /u01/oracle/VIS/12.1.0/log/diag/tnslsnr/EBS1/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=EBS1.localdomain)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date                24-JUL-2019 18:41:47
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         /u01/oracle/VIS/12.1.0/log/diag/tnslsnr/EBS1/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=EBS1.localdomain)(PORT=1521)))
The listener supports no services
The command completed successfully
LSNRCTL>