OraFAQ Forum: Unix » UNIX Commands for SQLPLUS utility

Home » Infrastructure » Unix » UNIX Commands for SQLPLUS utility (Unix - oracle 10.2.0.1.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

UNIX Commands for SQLPLUS utility [message #490988]

Fri, 28 January 2011 06:33

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi All,

I am struggling to get UNIX commands for SQLPLUS environment,
please someone help me...

Regards:
Muktha

Report message to a moderator

Re: UNIX Commands for SQLPLUS utility [message #490990 is a reply to message #490988]

Fri, 28 January 2011 06:36

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

SQL> !date
Fri Jan 28 13:36:40 NFT 2011

Regards
Michel

Report message to a moderator

Re: UNIX Commands for SQLPLUS utility [message #491039 is a reply to message #490988]

Fri, 28 January 2011 09:35

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I am struggling to get UNIX commands for SQLPLUS environment,

it works for me.

bcm@bcm-laptop:~$ uname -a 
Linux bcm-laptop 2.6.32-28-generic #55-Ubuntu SMP Mon Jan 10 23:42:43 UTC 2011 x86_64 GNU/Linux
bcm@bcm-laptop:~$ sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Fri Jan 28 07:34:56 2011

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

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: UNIX Commands for SQLPLUS utility [message #491071 is a reply to message #491039]

Fri, 28 January 2011 22:44

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi Michel\Blackswan,

I meant, i want to practice oracle DBA\PLSQL in unix's sqlplus window...
Eg - while creating tablespace, how to copy(Drag) the path for the datafile.....
please guide me

Regards:
Muktha

Report message to a moderator

Re: UNIX Commands for SQLPLUS utility [message #491077 is a reply to message #491071]

Fri, 28 January 2011 23:32

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Are you really asking how to copy and paste a string?

Report message to a moderator

Re: UNIX Commands for SQLPLUS utility [message #491084 is a reply to message #491071]

Sat, 29 January 2011 00:54

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Please explain in details what you want to (maybe through an example), we are unable to understand your question.

Regards
Michel

Report message to a moderator

Re: UNIX Commands for SQLPLUS utility [message #492319 is a reply to message #491084]

Sat, 29 January 2011 06:15

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi Michel,

Yes,
1) How to copy the os path while specifying DATAFILE(can we drag the path).
2) I have one script file based on windows, how to run it in UNIX platform.

Thanks & Regards:
Muktha

Report message to a moderator

Re: UNIX Commands for SQLPLUS utility [message #492330 is a reply to message #492319]

Sat, 29 January 2011 09:00

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

1) "Are you really asking how to copy and paste a string?"
2) a SQL script is platform independant (but for file names)

Regards
Michel

Report message to a moderator

Re: UNIX Commands for SQLPLUS utility [message #492523 is a reply to message #492330]

Mon, 31 January 2011 23:19

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi All,

Thanks for your reply,

1) CREATE SPFILE FROM PFILE =<path/filename.ora>
How to copy and past the path of the PFILE into SQLPLUS window in unix.
2) Also guide for running DBCA in UNIX.

Regards:
Muktha

Report message to a moderator

Re: UNIX Commands for SQLPLUS utility [message #492532 is a reply to message #492523]

Tue, 01 February 2011 01:03

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

1) In the same way as usual
2) Type "dbca"

Regards
Michel

Report message to a moderator

Re: UNIX Commands for SQLPLUS utility [message #492534 is a reply to message #492532]

Tue, 01 February 2011 01:08

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi Michel,

Thanks for the reply,

please guide me on the below issues.
Questions:
1) Just typing DBCA is not allowing me to create a new database.
2) How to edit the SQLPLUS window, as we do in windows - ed (then notepad will open).

Regards:
Muktha

Report message to a moderator

Re: UNIX Commands for SQLPLUS utility [message #492535 is a reply to message #492534]

Tue, 01 February 2011 01:11

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

1) Yes it does if you are in the OS dba group
2) This is meaningless

You have to use more words to explain what you are trying to do, no one is understanding you.

Regards
Michel

[Updated on: Tue, 01 February 2011 01:12]

Report message to a moderator

Re: UNIX Commands for SQLPLUS utility [message #492591 is a reply to message #492535]

Tue, 01 February 2011 06:14

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>2) How to edit the SQLPLUS window, as we do in windows - ed (then notepad will open).
You need to define your editor.
No notepad in unix. All unix will have vi.
All can be configured for vim/emacs/pico.
http://download.oracle.com/docs/cd/B19306_01/server.102/b15658/admn_sqlpls.htm#sthref258

[Updated on: Tue, 01 February 2011 06:15]

Report message to a moderator

Re: UNIX Commands for SQLPLUS utility [message #493021 is a reply to message #492591]

Fri, 04 February 2011 05:40

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi Mahesh,

Thanks for your reply

The command to get this is:
DEFINE_EDITOR=VI

Report message to a moderator

Re: UNIX Commands for SQLPLUS utility [message #493093 is a reply to message #493021]

Fri, 04 February 2011 15:16

LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL

Senior Member

muktha_22 wrote on Fri, 04 February 2011 06:40

Hi Mahesh,

Thanks for your reply

The command to get this is:
DEFINE_EDITOR=VI

Perhaps it actually is:

export EDITOR=vi #<- ksh/bash
EDITOR=vi; export EDITOR #<- sh

PS: To copy and paste a string in a unix window, it may depend on the terminal emulator you are using. Normally it would be to select the string using the cursor to copy and then right-click where you want to paste.

[Updated on: Fri, 11 February 2011 07:55] by Moderator

Report message to a moderator

Re: UNIX Commands for SQLPLUS utility [message #493099 is a reply to message #493093]

Fri, 04 February 2011 17:12

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

EDITOR=vi; export EDITOR #<- sh/ksh/bash

Report message to a moderator

Previous Topic:	MAILX
Next Topic:	Sun Solaris Unix Freeware && Oracle 10g for Single User

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 22:20:10 CST 2024