Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

connect sqlplus using ip+port+sid

762809Dec 2 2010 — edited Dec 2 2010
Hi Friendz,

Oracle DB 9i

I know I was able to connect before using this format:

$ sqlplus apps/apps@192.168.100.5:1521/oaprod
[oratrng@oracletrng ~]$ sqlplus apps/apps@192.168.100.5:1521/oaprod

SQL*Plus: Release 9.2.0.6.0 - Production on Thu Dec 2 12:17:34 2010

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where <logon>  ::= <username>[/<password>][@<connect_string>] | /
Any idea please...

Thanks a lot

MsK

Comments

920799
Done ....

My account -- > configure the device
user4531066
Hello,

Any chance you could post the instructions to create a "dashboard" device? It's not in any of th edocumentation.

Thanks!
user12068228
Hi
Did you find a solution for this? I have the same problem. I configured e-mail settings and use system subject area. Sending Agents via E-Mail is working. But sending Agents to the user homepage gives me the error: "Device (dashboard) is not set in..."
Thank you
User_5TGU6
Hi,

Can you kindly elaborate your solution.. Coz i am getting the same error and going crazy on it..
Plz do the needfull
Mark.Thompson
I guess nobody ever told him that it's nice to share.
Mark.Thompson
Throw us a bone here. How did you resolve this problem? Please tell us the steps to configure the user account so that we can send to a dashboard.
user12068228
Hi
I had the same problem in 11.1.1.6.1. In 11.1.1.6.2 BP1 it is gone.
Regards
Mark.Thompson
Not for me. I installed BP1 last weekend and I still can't send an alert to my dashboard. Did you do anything special to make it work?
user12068228
No nothing that I'd be aware of.
920799
Hi

Sorry for the delayed reply i havnt looked in to ibots for last few months...

Steps to configure device..

After login into analytics....click on ur username u used to login and select My Account..there u can Add email..

As for as i know u can do this only if u are sending ibots to few users...

we have to create SA system subject area as shown in below URL

http://oraclebizint.wordpress.com/2008/04/25/oracle-bi-ee-101332-sa-system-subject-area-autoloading-profiles-and-bursting/

please send a test mail to shekaready@gmail.com i will send u a doc with screen shots on how to add Device..


Apologies again...for the delayed reply
Mark.Thompson
I'm sorry, I don't understand why you are telling me how to add an e-mail device. Sending to e-mail isn't a problem. It's sending the alert to the dashboard that isn't working.
RockITCity
I have saw the same issue after upgrading to 11.1.1.6.2. BP1 and found the following:

http://obirockit.blogspot.com/2012/08/obi-11g-agent-messagedevice-dashboard.html
1 - 12
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 30 2010
Added on Dec 2 2010
6 comments
87,422 views