RE: oracle digest: November 19, 2002

-----Original Message-----
From: Oracle digest [mailto:[email protected]]
Sent: Wednesday, November 20, 2002 1:03 AM
To: oracle digest recipients
Subject: oracle digest: November 19, 2002


-----------------------------------------------
When replying to the digest, please quote only
relevant material, and edit the subject line to
reflect the message you are replying to.
-----------------------------------------------

The URL for this list is:
http://p2p.wrox.com/list.asp?list=oracle
ORACLE Digest for Tuesday, November 19, 2002.

1. Help- connect as sysdba from client
2. Re: Slow Oracle Connection
3. Re: How to access oracle server from machines without oracle client?
4. Re: How to access oracle server from machines without oracle
 client?
5. Help:Connecting to an Oracle database in Visual Studio .NET
6. Re: Help:Connecting to an Oracle database in Visual Studio .NET
7. problem with discoverer 4.0
8. How to get latest inserted record in a table

----------------------------------------------------------------------

Subject: Help- connect as sysdba from client
From: "andi" <[email protected]>
Date: Tue, 19 Nov 2002 16:54:33 +0800
X-Message-Number: 1

Hi All,
I'm using oracle 8i, win2k,
and set the parameter remote_login_passwordfile=exclusive

SQL> select * from v$pwfile_users;

USERNAME                       SYSDB SYSOP
------------------------------ ----- -----
INTERNAL                       TRUE  TRUE
SYS                            TRUE  TRUE

But when I tried to login from client(sqplus release 8.0.6.0.0 from oracle
developer 6i), and the error occured:

SQL> connect sys/change_on_install as sysdba
ERROR:
ORA-01031: insufficient privileges

How to solve the problem?
TIA


----------------------------------------------------------------------

Subject: Re: Slow Oracle Connection
From: "Fakhrudiin" <[email protected]>
Date: Tue, 19 Nov 2002 12:06:08
X-Message-Number: 2

> 
Hi,

Had you run out of memory?\
No i am not running short of memory.

Had you run out of 66% disk space?
No i am not running 66% disk space.

Had you defined properly the tablespaces?
Yes i had defined properly the tablespaces(initially yes)but later i 
changed it to the default table space i.e 'system'.

Had you set properly the .ora files and parameters?
Can u explain your this point in breif i didnt understand it.I had 
enabled the tracing in init.ora but coult not find anything.Enabling it 
slows down the 7th site and all the other sites too .
Porras, Carlos


Business Quality Web Email,
Group Scheduling, & Team Tools
http://www.norada.com/save


----------------------------------------------------------------------

Subject: Re: How to access oracle server from machines without oracle
client?
From: "Darrell Pitzer" <[email protected]>
Date: Tue, 19 Nov 2002 13:25:43
X-Message-Number: 3

> But the problem is how to do the same, on machines without Oracle 
> client installed? TNS will give error here.? how to do solve the 
> problem. plz help.
> -arun

You *must* have the Oracle client software installed to access an Oracle 
database. No matter which "path" you try to take (e.g., ODBC, MS ADO 
Oracle driver, etc.), they all end up "talking" to the Oracle server via 
the Oracle client software.

-- Darrell Pitzer
----------------------------------------------------------------------

Subject: Re: How to access oracle server from machines without oracle
 client?
From: "Darren Collard" <[email protected]>
Date: Tue, 19 Nov 2002 14:20:41 +0000
X-Message-Number: 4

Whilst what you say is correct, there are a couple of workarounds that I 
have used in the past.

The first is to intall Oracle onto a Citrix server and run any Oracle 
systems through Citrix. This works well and we have transatlatic users quite

happily running our Oracle applications.

The other method that I am just starting to look at involves writing an ASP 
on a web server containing the Oracle client and supplying the data through 
HTTP as XML.

This is still in the early stages at the moment but works well for read-only

access to Oracle databases.

Regards,

Darren Collard


>From: "Darrell Pitzer" <[email protected]>
>Reply-To: "Oracle" <[email protected]>
>To: "Oracle" <[email protected]>
>Subject: [oracle] Re: How to access oracle server from machines without 
>oracle client?
>Date: Tue, 19 Nov 2002 13:25:43
>
> > But the problem is how to do the same, on machines without Oracle
> > client installed? TNS will give error here.? how to do solve the
> > problem. plz help.
> > -arun
>
>You *must* have the Oracle client software installed to access an Oracle
>database. No matter which "path" you try to take (e.g., ODBC, MS ADO
>Oracle driver, etc.), they all end up "talking" to the Oracle server via
>the Oracle client software.
>
>-- Darrell Pitzer
>---
>Change your mail options at http://p2p.wrox.com/manager.asp or
>to unsubscribe send a blank email to %%email.unsub%%.


_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. 
http://join.msn.com/?page=features/virus


----------------------------------------------------------------------

Subject: Help:Connecting to an Oracle database in Visual Studio .NET
From: "Jon King" <[email protected]>
Date: Tue, 19 Nov 2002 16:26:52
X-Message-Number: 5

I am new to Oracle, I have worked with SQL Server and interbase with 
little trouble, but all my attempts to connect to a recently installed 
Oracle database have failed.
This is my setup:
database name: guru.xxxxxxx.xxxx.edu
SID: guru
my connection string: "Data Source=guru;User Id=SYS;Password=xxxx"

I am not sure if Oracle is set up right or not, I just ran the setup and 
left everything at the default, giving the database the name above. I can 
see the database in Enterprise Manager on my remote computer and can 
connect to port 7778 and 443 on the web, I just cant access it via .NET, 
programming in C#.

Any assistance would be greatly appreciated

Jon King
----------------------------------------------------------------------

Subject: Re: Help:Connecting to an Oracle database in Visual Studio .NET
From: "Jon King" <[email protected]>
Date: Tue, 19 Nov 2002 19:55:24
X-Message-Number: 6

I figured it out, The client wasnt configured correctly


> Jon King
----------------------------------------------------------------------

Subject: problem with discoverer 4.0
From: Prasanna Ambrose <[email protected]>
Date: Tue, 19 Nov 2002 11:53:50 -0800 (PST)
X-Message-Number: 7


Hi
I am using discoverer version 4.0. When I created a report it didn't show
the date fields. Only the date field is invisible and all other fields are
visible. 

I would like to know what is the cause for this and how can I rectify this? 
I appreciate your help!
prasanna 



---------------------------------
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site

----------------------------------------------------------------------

Subject: How to get latest inserted record in a table
From: "sridhar" <[email protected]>
Date: Tue, 19 Nov 2002 21:34:06
X-Message-Number: 8

Hello,
   It would be great help if you could answer the following problem.
I have a table with a colomn type date and some other coloumns. There is 
no primary key for this table i.e There is no way of uniquely identifing a 
row. For a same date and time there might be 100's of records inserted. 
Only discrimination between rows can be done if there is milliseconds part 
in date column. But I found that there is no milliseconds part in date 
coloumn in Oracle.
 I need to find latest record  for specific date from the table.
I prefer not to do any DDL operations.

Thank you,
Sridhar.


---

END OF DIGEST

---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to %%email.unsub%%.

---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].