16 bit sqlplus cannot connect to PO8i

List, i'm trying to make a connect to 8i database (installed under orawin95) from a 16 bit sqlplus (installed under orawin) i tried to configure the IPC in listener, the sqlplus in orawin95 is able to connect, but the 16 bit sqlplus returns error...(cant get server error message)

Re: V$SESSION.OSUSER returns NT-Domain\NT-User ?

Marc, This looks like bug 1741378, not yet fixed. HTH, -- Anita --- Blum, Marc [EMAIL PROTECTED] wrote: Hi, like many others we use V$SESSION.OSUSER to determine the NT-User, who is connected to the instance. At a customers site we faced the problem, that OSUSER is of the format

Re: Steve Adams's Removal

I agree with you Venkat, I'm afraid that we lost tuning expert, C.S.Venkata Subramanian [EMAIL PROTECTED] 5/28 1:15p Hi, I was not able to get head or tail out of this posting. But from the subject I figured out that Steve Adams is removed from this list. If so, Still must reconsider the

Re: Database slowdown after 100 days uptime

Hi, There is an alert (Note:118228.1) ALERT: Hang During Startup/Shutdown on Unix When System Uptime 248 Days. But, you are using NT. do you have other errors in alert.log before crash or is there core.log ? "Reardon, Bruce (CALBBAY)" wrote: Hi, We're running Oracle 8.1.5.1.1 on NT 4.

Re: Creating a sorted table

Alternately on earlier versions where the order by can't be used, is to select from the table in indexed order using a hint... hth connor --- Regina Harter [EMAIL PROTECTED] wrote: Well, it won't work in all cases, but I have on occasion used as a shortcut: INSERT INTO ... SELECT DISTINCT

RE: Steve Adams's Removal

Folks, Please stop this thread This thread started on lazydba list and is relevant on only on that list and not on ORACLE-L. We don't need to write about Steve. He is a person, who doesn't need an introduction in the world of Oracle. Steve, we know you are

Re: Creating a sorted table

There is a very good reason for having data approximately in physical order - it can dramatically improve your buffer hit rates. IOT's are great for this, but if you're on an earlier version then the occasional job to pseudo-cluster the data can be a very good thing... Cheers Connor --- [EMAIL

RE: Function based index - insufficient priveleges

hi i found this on metalink the proper privilege required to create function-based indexes. Connect as dba and provide the user with the privileges required to create a function based index. If the user is creating indexes in their own schema: SVRMGR grant query rewrite to ; If the user

Function based index - insufficient priveleges

Hi Gurus ! Please help me. I can't create function based index because it says: ERROR at line 1: ORA-01031: insufficient privileges I have a table which contains a column called lang_name. I try to create function based index on the table with the following sql statement: create index

Re: Function based index - insufficient priveleges

When in doubt, check the manual ;) Manuals are available in pdf format from metalink and in html and pdf format from http://technet.oracle.com (free registration). Per the SQL Reference manual on the create index statement: To create a function-based index in your own schema on your own table,

Re: Steve Adams's Removal

Relax, folks. Nobody has removed Steve from the ORACLE-L list. Not that I'm aware of, anyways. He's been asked to leave another completely different list. Some sort of personal clash. Because some posters here confused the address lines, we got copied on their messages: they use both lists.

Re: Musings on tuning and the optimizer

- Original Message - Have run across some interesting things while reading up on the optimizer. Same here! :-) Always thought that the RBO joins your tables in the order found in the FROM clause? Think again. Actually, I found one in Metalink that says with RBO, it's the reverse

RE: Function based index - insufficient priveleges

Thank you ! This solved the problem. Gyula -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andor, Gyula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

Buffer Hit Ratio 10% on UNIX HP/UX 11.0

Hi list, I have a curious problem with my buffer hit ratio on Oracle 8.0.5, Unix HP UX 11.0. When I run the following select, I get a hit Rati about 8 %. select sum(decode(NAME, 'consistent gets',VALUE, 0)) ConsistentGets, sum(decode(NAME, 'db block gets',VALUE, 0))DBBlockGets,

RE: Function based index - insufficient priveleges

Oracle manual states that in order to use function based indexes in queries the query_rewrite_enabled parameter needs to be set to 'true', and the query_rewrite_integrity parameter to 'trusted', apart from granting the query rewrite privilege. rgds amar -Original Message- Sent:

Re: Function based index - insufficient priveleges

You need to set a couple of parameters in the init.ora, these are query_rewrite_enabled = true query_rewrite_integrity = trusted and you need to grant the privilege QUERY_REWRITE to the user. HTH. Zabair _ Get Your

Re: Steve Adams's Removal

PLEASE stop bringing this up on this list. Steve Adams is a valuable resource on this list, and in no way shape or fashion has he been removed, nor have I even contemplated removing him. Jared Still ( the list owner ) On Sunday 27 May 2001 23:10, C.S.Venkata Subramanian wrote: Hi, I was

How can I query the SID name from the database

Hi, can I query a database's server's maschine name and SID (not database name) through SQL*Plus? TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

Re: 16 bit sqlplus cannot connect to PO8i

If by 16 bit sqlplus you mean version 1 of SqlNet, you can't connect to an 8i database with it. Some version numbers here would help. platform: version of platform: version of Oracle: etc... Jraed On Monday 28 May 2001 00:40, Rahul wrote: List, i'm trying to make a connect to 8i database

redo copy latch low??

Hi Friends My redo copy latch showing 16.7% (Hit Ratio). How can I increase this one?? Any suggestions?? I got this from utlb/utle stats. Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at

Re: Musings on tuning and the optimizer

On Monday 28 May 2001 04:45, Nuno Souto wrote: Always thought that the RBO joins your tables in the order found in the FROM clause? Think again. Actually, I found one in Metalink that says with RBO, it's the reverse order of the FROM clause. Which I was aware of. But it also says: if

RE: 16 bit sqlplus cannot connect to PO8i

Hey Jraed, Why did you change your name? Sorry, I am bored. Management decided to move us around so I am unpacking. -Original Message- Sent: Monday, May 28, 2001 10:20 AM To: Multiple recipients of list ORACLE-L If by 16 bit sqlplus you mean version 1 of SqlNet, you can't connect to

Re: How can I query the SID name from the database

machine_name is found in v$session. You can't query the server for the SID, as it is simply an environment variable. Jared On Monday 28 May 2001 10:10, Szecsy Tamas wrote: Hi, can I query a database's server's maschine name and SID (not database name) through SQL*Plus? TIA, Tamas

Re: 16 bit sqlplus cannot connect to PO8i

On Monday 28 May 2001 11:00, Kimberly Smith wrote: Hey Jraed, Why did you change your name? Sorry, I am bored. Management decided to move us around so I am unpacking. I should change it, as I find Jread much easier to type than Jared. Jraed -Original Message- Sent: Monday, May

Re: redo copy latch low??

Take a look at this article from Steve Adams: http://www.ixora.com.au/tips/tuning/redo_latches.htm Jared On Monday 28 May 2001 10:25, Raghu Kota wrote: Hi Friends My redo copy latch showing 16.7% (Hit Ratio). How can I increase this one?? Any suggestions?? I got this from utlb/utle

RE: How can I query the SID name from the database

THNX Tamas -Original Message- Sent: Monday, May 28, 2001 8:20 PM To: Multiple recipients of list ORACLE-L machine_name is found in v$session. You can't query the server for the SID, as it is simply an environment variable. Jared On Monday 28 May 2001 10:10, Szecsy Tamas wrote:

RE: redo copy latch low??

Just pulled up this info from Oracle Docs Well, If you could give some inputs as to the performance issues that u r facing bacause of this - it would be useful. Also, what type of application are u running? Here is the info: * Reducing Contention for Redo Copy Latches

Re: redo copy latch low??

Thanks jared!! and who responded. From: Jared Still [EMAIL PROTECTED] To: [EMAIL PROTECTED], Raghu Kota [EMAIL PROTECTED] Subject: Re: redo copy latch low?? Date: Mon, 28 May 2001 10:22:41 -0700 Take a look at this article from Steve Adams:

Re: How can I query the SID name from the database

Concerning the SID, which I tend to find synonymous with instance name (trying hard to figure out a way to have an instance name different from the SID, but cannot come out with anything), 8i contains a column NAME in V$INSTANCE (which has nothing in common but the name with the Oracle7

Re: How can I query the SID name from the database

This is correct - $ORACLE_SID is a host environmental variable and cannot be obtained from the data dictionary. However, you can get the instance name from v$instance.instance_name in 8.x or from v$thread.instance in v7. -Don Granaman [certifiable OraSaurus] - Original Message - To:

Ray Lane on 9i

http://www.oracle.com/features/9ibetahigh.html http://www.oracle.com/features/9ibetahigh.html If you click on the discussion thread at the bottom of this URL, you will see that Ray Lane (who left Oracle) put in a plug for 9i. Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin

Re: Ray Lane on 9i

Ray Lane (who left Oracle) put in a plug for 9i. Ray Lane said: Oracle database is number one and will remain number one. I can say that from my experience with Oracle. But then again, there's a short message posted from Larry Ellison too: My company rocks ! The Big L Me thinks someone is

Error Message - Database is Already Up

After Installing Additionally Only the PQO Component of ORA 7.3.4.5 , When Finally Attempting to RE-Link the Oracle Exe , Following Error Message ( of sorts ) is Displayed :- Database is Already Up . Shut it Down First . Hence Re-Link of Oracle Exe Failing NOTE - 1) NO Database whatsoever

Re: Error Message - Database is Already Up

Hello Vivek, Check followings: - If I'm not wrong there should be lk* file 7.3.3 and onwards. remove it. - check shared memory/semaphores by ipcs. if They still exist, remove them by ipcrm if problem still exist, you are most probably hitting a bug. - debug your process by truss/trace in OS

Oracle and Red Hat

All, Over the past few days, there have been postings which stated that Oracle had withdrawn certification for Red Hat Linux. The first indicated that Oracle had withdrawn certification for Apps 11i on Red Hat Linux. Subsequent postings further indicated that Red Hat would not be a supported

Re: Buffer Hit Ratio 10% on UNIX HP/UX 11.0

For one thing, which you did not mention, when was the last time this instance was restarted? It is normal to see low cache hit ratios shortly after a startup. Second did someone do something, like select * from the largest table, that could have caused the cache to completely flush? Also

OT

Jared (Still the list owner) - I hope this one is correct :-) - Bhat -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 1:26 AM To: Multiple recipients of list ORACLE-L

RE: 16 bit sqlplus cannot connect to PO8i

Jkstill, i'm using sql*net 2, and can connect to other 8i database on the AIX machine, but then i installed PO 805 (in another home) , and cannot use the sqlplus to connect to the local DB. (the sqlplus installed under the same home as the database can connect without problems) Regards PS:

RE: redo copy latch low??

Can I know how can I get the ratio redo copy latch from TOAD ? -Original Message- Sent: Tuesday, May 29, 2001 2:20 AM To: Multiple recipients of list ORACLE-L Take a look at this article from Steve Adams: http://www.ixora.com.au/tips/tuning/redo_latches.htm Jared On Monday 28 May

RE: 16 bit sqlplus cannot connect to PO8i

Try using TCP protocol and then connect. I have connected so many times using the same. -- On Mon, 28 May 2001 19:45:54 Rahul wrote: Jkstill, i'm using sql*net 2, and can connect to other 8i database on the AIX machine, but then i installed PO 805 (in another home) , and cannot use the

Re: How can I query the SID name from the database

U can get the instance name from V$instance and v$database. If u have set the instance name and sid as same in init.ora, then instance name is the SID. BTW SID=system identifier for the OS to identify the Oracle to allocate resource. U can have multiple instance running in same OS. HTH --

Re: Musings on tuning and the optimizer

On Monday 28 May 2001 04:45, Nuno Souto wrote: And a few others. I found out the problem I reported a while ago with CBO suddenly going South on hash scan joins and completely ignoring nested loops or indexes is actually an introduced problem due to a change in CBO rules after 8.0.4. It