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

1. Fault description

Today, I am free to install an Oracle test server on Linux. I encountered a problem when logging in using sysdba when the installation was completed.

[oracle@Database ~] $sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Fri Aug 29 22:32:46 2014

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

ERROR:

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

two。 Malfunction analysis

Confirm ORACLE_HOME and ORACLE_SID environment variable parameters

[oracle@Database ~] $echo $ORACLE_HOME

/ u01/app/oracle/product/11.2.0/dbhome_1

[oracle@Database ~] $echo $ORACLE_SID

[oracle@Database ~] $

ORACLE_SID has no display

3. Fault resolution

Add ORACLE_SID parameter

[oracle@Database ~] $export ORACLE_SID=orcl

[oracle@Database ~] $echo $ORACLE_SID

Orcl

Test connection and log in to SYSDBA

[oracle@Database ~] $sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Fri Aug 29 22:35:08 2014

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 > exit

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.