Shulou(Shulou.com)06/01 Report--

[oracle@up ~] $sql / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Sat Feb 11 15:29:31 2017

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

ERROR:

ORA-12162: TNS:net service name is incorrectly specified

The error indicates that the specified network name is incorrect

View the .bash _ profile file

Export PATH

Export ORACLE_BASE=/u01/oracle

Export ORACLE_HOME=$ORACLE_BASE/product/11.2.0

Export ORACLR_SID=ora11g

Export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin

Export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

Found ORACLE_SID variable, name writing error, correct variable name, log in again

[oracle@up ~] $sql / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Sat Feb 11 15:37:02 2017

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL >

Login succeeded

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.