Re: Connect string for Forms 3, Sqlmenu50 running on Oracle 7.33

From: Cynthia Tan <shinteia_at_yahoo.com>
Date: 23 Jul 1998 02:42:27 GMT
Message-ID: <01bdb5e4$1588cde0$a07015a5@pc160>

Hi Julio,
Thanks alot. Your suggestion works. It's cleared a big headache of mine. Thanks !!!!!!
I have another question. I posted this question before but haven't had good news ....

If I am being identified internally, what connect string should I use in the SQLMENU50, say using Two_Task variable ?

        sqlplus :un/:passwd @sqlfile
Both :un and :passwd variable is recognise within Oracle only?

Alternatively, in SQLMENU50, if I execute an UNIX file which contains some sqlplus command, how could I pass the password info from Oracle? How shall my script file look like?
Would appreciate your help and thanks in advance.

Cheers!

Julio <julio.negueruela_at_si.unirioja.es> wrote in article <35B329E4.2A9D6B99_at_si.unirioja.es>...
Cynthia, Tan escribió:
>
> Hi,
>
> I am running the above configuration and and I cannot connect connect
using
>
> sqlplus / (when identified externally)
> In this case, I can no longer identify my password externally.
>
> I need to specify sqlplus usename/password_at_nodename, is there a
workaround
> for this?

Have you tryed with the TWO_TASK env var. For instance for, an instance called example wich has a TNS alias exampleal, you should do:

TWO_TASK="exampleal"
ORACLE_SID=example
export TWO_TASK ORACLE_SID

Hope this help.
--
Julio Negueruela
DBA Servicio Informático

Universidad de La Rioja      -      Spain
Telf: 941-299179     Fax: 941- 299180

mailto:julio.negueruela_at_si.unirioja.es

---

Received on Wed Jul 22 1998 - 21:42:27 CDT