Connect to Oracle DB using sqlplus

Question

I am using below command in Unix environment to connect to Oracle database   sqlplus test test   DESCRIPTION  ADDRESS LIST  ADDRESS  PROTOCOL TCP  HOST hostname com   PORT 1521    CONNECT DATA  SID mysid      But I am getting below error   Use SQL Plus to execute SQL  PL SQL and SQL Plus statements   Usage 1  sqlplus -H   -V      -H             Displays the SQL Plus version and the                    usage help      -V             Displays the SQL Plus version   Usage 2  sqlplus     lt option gt     logon    nolog     lt start gt         lt option gt  is   -C  lt version gt    -L   -M   lt options gt     -R  lt level gt    -S    Please help me where I am doing mistake in using the command

User · Answer

Easy way  using XE    1   Configure your tnsnames ora  XE      DESCRIPTION        ADDRESS    PROTOCOL   TCP  HOST   HOST DOMAIN COM  PORT   1521        CONNECT DATA          SERVER   DEDICATED         SERVICE NAME   XE              You can replace HOST DOMAIN COM with IP address  the TCP port by default is 1521  ckeck it  and look that name of this configuration is XE  2   Using your app named sqlplus   sqlplus SYSTEM XE   SYSTEM should be replaced with an authorized USER  and put your password when prompt appear  3   See at firewall for any possibilities of some blocked TCP ports and fix it if appear

User · Answer

tnsping xe --if you have installed express edition tnsping orcl --or if you have installed enterprise or standard edition then try to run --if you get a response with your description then you will write the below command sqlplus  --this will prompt for user hr --user that you have created or use system password --inputted at the time of user creation for hr  or put the password given at the time of setup for system user hope this will connect if db run at your localhost  --if db host in a remote host then you must use tns name for our example orcl or xe try this to connect remote hr pass    orcl or hr pass    xe --based on what edition you have installed

User · Answer

sqlplus username password database   Eg      sqlplus hr hr orcl

User · Answer

try this   sqlplus USER PW   hostname 1521 SID

User · Answer

if you want to connect with oracle database   open sql prompt connect with sysdba for XE- conn   as sysdba for IE- conn sys as sysdba then start up database by below command startup     once it get start means you can access oracle database now  if you want connect another user you can write  conn username password  e g  conn scott tiger  it will show connected

User · Answer

As David Aldridge explained  your parentheses should start right after the sqlplus command  so it should be   sqlplus  test test  DESCRIPTION  ADDRESS LIST  ADDRESS  PROTOCOL TCP  HOST hostname com   PORT 1521    CONNECT DATA  SID mysid

User · Answer

Different ways to connect Oracle Database from Unix user are    oracle OLE1     sqlplus scott tiger   oracle OLE1     sqlplus scott tiger orcl   oracle OLE1     sqlplus scott tiger 192 168 244 128 1521 orcl   oracle OLE1     sqlplus scott tiger   192 168 244 128 1521 orcl   oracle OLE1     sqlplus  scott tiger  DESCRIPTION  ADDRESS  PROTOCOL TCP  HOST ole1  PORT 1521   CONNECT DATA  SERVER DEDICATED  SERVICE NAME orcl       Please see the explanation at link  https   stackoverflow com a 45064809 6332029  Thanks

User · Answer

it would be something like this  sqlplus -s  nolog   lt  lt -  connect   ORACLE UID    ORACLE PWD    ORACLE DB   whenever sqlerror exit sql sqlcode  set pagesize 0  set linesize 150  spool  lt query output dat gt  APPEND    lt input query dat gt  spool off  exit      here   ORACLE UID  lt user name gt  ORACLE PWD  lt password gt  ORACLE DB    lt host gt   lt port gt   lt DB name gt

[oracle] Connect to Oracle DB using sqlplus

Examples related to oracle

Examples related to unix

Examples related to sqlplus