Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production Now you've multiple ways to connect database from unix command ~]$ sqlplus ~]$ sqlplus ~]$ sqlplus ~]$ sqlplus ~]$ sqlplus ~]$ sqlplus scott/tiger Used TNSNAMES adapter to resolve the aliasĪttempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ole1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl))) home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/sqlnet.ora (ADDRESS = (PROTOCOL = TCP)(HOST = ole1)(PORT = 1521)) # Generated by Oracle configuration tools. # tnsnames.ora Network Configuration File: /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora PATH=$ORACLE_HOME/bin:$HOME/bin:$PATH export PATHĪnd Make sure tnsnames.ora file is configured properly and listener should be up and running as below. ORACLE_HOME=$ORACLE_BASE/oracle/product/11.2.0/dbhome_1/ export ORACLE_HOME Make sure you've exported all the necessary Oracle variable in your unix user path environment as below: ORACLE_BASE=/home/oracle/app export ORACLE_BASE
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |