verity oracle version

  • Permalink
  • submit to reddit
  • Email
  • Follow


i'm using HPUX 10.20...how cai retrive oracle version that install in the server....what command can i used to verufy the version..TQ

-- 
Message posted via http://www.oraclemonster.com
0
Reply forum3242 (75) 12/22/2004 5:51:36 AM

See related articles to this posting


Mohamed Shamry via OracleMonster.com wrote:
> i'm using HPUX 10.20...how cai retrive oracle version that install in the server....what command can i used to verufy the version..TQ
> 



select * from v$version;

Regards
HJR
0
Reply hjr (2065) 12/22/2004 6:12:31 AM

error message shows....

su: Syntax error: `from' is not expected

-- 
Message posted via http://www.oraclemonster.com
0
Reply forum3242 (75) 12/22/2004 9:51:45 AM

Mohamed Shamry via OracleMonster.com wrote:
> error message shows....
> 
> su: Syntax error: `from' is not expected
> 


Try it again -only this time, type what I actually wrote.

There is nothing wrong with the suggested syntx.

Select * from v$version;

And if you get an error, use cut and paste to show me what you typed and 
what the exact response is.

HJR
0
Reply hjr (2065) 12/22/2004 9:58:49 AM


Mohamed Shamry via OracleMonster.com wrote on 22.12.2004 10:51:

> error message shows....
> 
> su: Syntax error: `from' is not expected


You did run this using SQL*Plus, did you?

0
Reply NNGNVRDSJEBN (74) 12/22/2004 10:11:41 AM

i just login in oracle and type the command that you give but cant...do i have to used SQL Plus...how do i to do that....i'm just in this environment accually...so hopefully you can teach me step by step...thank you

-- 
Message posted via http://www.oraclemonster.com
0
Reply forum3242 (75) 12/24/2004 1:56:36 AM

Mohamed Shamry via OracleMonster.com wrote:

> i just login in oracle and type the command that you give but cant...do i have to used SQL Plus...how do i to do that....i'm just in this environment accually...so hopefully you can teach me step by step...thank you

I doubt anyone here has the time or the bandwidth to teach you basic
Oracle skills. Yes you need SQL*Plus, or an equivalent third-party
product. But more importantly you need to take a class from a local
college, university, or from Oracle Ed.

-- 
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)


-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
   http://www.newsfeed.com       The #1 Newsgroup Service in the World!
-----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =-----
0
Reply DA 12/24/2004 5:15:36 AM

Mohamed Shamry via OracleMonster.com wrote:
> i just login in oracle

No. You ran some sort of application first, otherwise you can't log in. 
What application was it?


> and type the command that you give but cant...

Explain "can't". Show what you typed, and what responses you got back. 
Otherwise all is guesswork. Practice those cut-and-paste skills.

> do i have to used SQL Plus...

No, but you have to recognise a SQL command when one is offered to you, 
and it therefore follows that you have to know how to issue one when needed.


>how do i to do that....

You first of all stop wasting everyone else's time. And then you invest 
some of your own time in learning the absolute basics of how to work 
with, interact with, and manage an Oracle database.

Go visit http://tahiti.oracle.com, select whatever you think might be 
your version, and then select the list of Books. Find the one called 
"concepts guide", and read it. Don't ask any more questions until you do.

> i'm just in this environment accually...so hopefully you can teach me step by step...

I charge about $750 a day for doing so. No-one here will teach you 
step-by-step for free. Invest a minimum amount of effort yourself in 
reading the basic Oracle literature, then come back and ask meaningful 
questions.

I don't want to sound unduly harsh, but your statements are a bit like 
saying "I can't get Windows to work. How do I switch my PC on?" You are 
a long way behind, and need to catch up. Visit that website and spend 
the next few days doing precisely that.

Regards
HJR




thank you
> 
0
Reply hjr (2065) 12/24/2004 10:40:33 AM
comp.databases.oracle.server 21520 articles. 10 followers. Post

7 Replies
108 Views

Similar Articles

[PageSpeed] 38


  • Permalink
  • submit to reddit
  • Email
  • Follow


Reply:

Similar Artilces:

How to export from a higher Oracle version and import into a lower Oracle version
How to export from a higher Oracle version (10) and import into a lower Oracle version (9) "dead" <OVOIZBACI-vlasic@vodatel.net> schrieb im Newsbeitrag news:ce5o4i$kbi$1@sunce.iskon.hr... > How to export from a higher Oracle version (10) and import into a lower > Oracle version (9) how about trying to use the exp/imp tools that ship with oracle ? > > On Tue, 27 Jul 2004 16:16:33 +0200, "dead" <OVOIZBACI-vlasic@vodatel.net> wrote: >How to export from a higher Oracle version (10) and import into a lower >Oracle version (9) > Use the...

Versions and Patch info for Oracle and Oracle Forms...
Morning all, I need to add Oracle to our unit testing scripts. Does anyone know how to get the version numbers of Oracle Server and Oracle Forms (and patches) from the command line (as in, scriptable)? Specifically, I need to know the exact version of Oracle Server, the exact version of Oracle Forms, and whether patch 13 for Oracle Forms has been installed. Is there a file with this information buried in it? Thanks, Wyatt ...

oracle jdbc driver version vs database version
I always thought that, for avoiding communication problems, the Oracle JDBC Driver version should match the Oracle Database version (at least the first 2 digits). Then I encountered this assertion: <<< Another very important conclusion: the versions of the Oracle JDBC driver and the Oracle database are not tied together. Oracle JDBC Driver 10gR2 can be used with any supported database version so there is no good reason for not using the latest version of the JDBC drivers, even for organisations working with 8i or 9i databases . >>> (source: http://technology.amis.nl/blog/?...

Oracle client version and oracle developer 6.0
Hi All If you have 2 oracle products installed in the same folder, say you have oracle 733 client and oracle client 8.0.5 on the same machine, installed into the same folder and at the same time you have Forms6.0 installed. How can you tell what client the Forms 6 is using to connect to the db if your db is 9i? Also how can you change forms to use a particular client to connect to the db? Thanks Mike On 13 Feb 2004 21:53:11 GMT, malomo0220@aol.com (MAlomo0220) wrote: >Hi All > >If you have 2 oracle products installed in the same folder, say you have oracle >73...

oracle versions
is older oracle version 8i similar to 9i i think it seems pretty similar could u prompt on the new features? also the ora navigator seems to do things pretty simple way so what's the need for the sql+ for inserting the table values In article <1110884663.503363.293370@f14g2000cwb.googlegroups.com>, mahimajulka@gmail.com says... > is older oracle version 8i similar to 9i > i think it seems pretty similar > could u prompt on the new features? > also the ora navigator seems to do things > pretty simple way so what's the need for > the sql+ for inserting the tabl...

Oracle version
Hello everybody. Is there an SQL command telling me if there is installed Standard or Enterprise version of Oracle 9.2 installed on a windows 2000 server? If there isn't, how can I know it? Where must I look for? I found the key ORACLE_BUNDLE_NAME in the registry, but I don't know if this is correct. thank's a lot. Sam. gigione wrote: > Hello everybody. > Is there an SQL command telling me if there is installed Standard or > Enterprise version of Oracle 9.2 installed on a windows 2000 server? > > If there isn't, how can I know it? Where must I look for? &...

oracle version
does anyone know SAP R/3 suppors the latest oracle release? ...

New Major version for Oracle JDeveloper and the Oracle Application Server
Oracle released today a major upgrade to its Java stack including new versions of the Oracle Application Server, Oracle JDeveloper, and Oracle TopLink. Some of the new features include: Oracle JDeveloper - The Free IDE * JSF Development - Visual layout editor, page flow diagram, ADF Faces - over 100 JSF components with AJAX capabilities. * EJB 3.0 support - DB to Entity Beans and Session Fa=E7ade generation. * Revamped IDE and coding environment -new L&F, over 35 refactoring, code assist, easy code navigation and much more. * More than just Java - XML, UML, Tuning, Database...

Can Oracle client dynamically link to Oracle shared libraries if the versions are different ?
Hi: We are writing an Oracle client application in C. We are using PRO C to generate the C code. We can compile both dynamic and static versions of our Oracle client. Our question is: is it possible to compile a dynamically linked Oracle client in say version 8.1.7.0 and actually run the application against say version 10.1.0.2 environment ? That is, can an Oracle client dynamically link to the Oracle shared libraries if the versions are different ? Thanks JL ...

Problem selecting Data with Object-Studio from Oracle-Database with Oracle-Client-Version 9.0.1 installed
Hi All! Here are my Details: While trying to Select Data from a Table in an Oracle-Database we encountered problems. We have to (!) use an Oracle 9.0.1 Client on Windows XP Pro! We start an unchanged Object-Studio 6.8. From the "Load Application"-Dialog we choose "Oracle 9.2". In an Object-Studio-Workspace we execute the following Code: | mydb result | mydb := OracleDatabase logOnServer: #MYORACLE user: #SCOTT password: #TIGER alias: #MYORACLE. "mydb inspect." "(OracleDatabase accessName: #MYORACLE) inspect." "(mydb active) inspec...

ORA-01571: redo version 9.2.0.0.0 incompatible with ORACLE version 8.1.7
Hye, While running an upgrade from 8.1.7 to 9.2.0.4 I finished the upgrade successfully I started the database and wanted to change undo tablespace management to be automatic So I offline the rollback segs, offline the tablespace that holds then and drop it. I want to create a new tablespace UNDO but I got the error the the parameter compatible is set to a lower value which is true because I have 8.1.7. I disconnect, delete the compatible entry from the file and want to log again. And here's the surprise ORA-01571: redo version 9.2.0.0.0 incompatible with ORACLE version 8.1.7 I have the...

Oracle development versions
Anybody knows if there is something like the MSDE for the Oracle database server? I want to learn Oracle, but it seems there are at least three CDs to install and my PC is a bit old. Thanks in advance. Guillermo Uriarte wrote: > Anybody knows if there is something like the MSDE for the Oracle > database server? > > I want to learn Oracle, but it seems there are at least three CDs to > install and my PC is a bit old. > > Thanks in advance. 10g is the latest version, and comes on just one CD. There is a companion CD which contains some things you might find of use, ...

Oracle versioning discovery
Does anyone know a reliable way to find out 1) whether a Oracle version is installed and 2) if so, what version (x.x.x at least, ideally x.x.x.x.x) of Oracle is installed? This is on the Windows platform. If there are multiple Oracle Homes, I want to find out all the versions of each home. Is there a Windows tool/utility to check this? Just right click on the oracle.exe and look at the version tab, it doesn't tell you that. The only exception is v9204. Maybe Oracle is moving to that direction. But I need to discover all the v7.x.x and v8.0.x and v8.1.x etc. The registry doesn't tell yo...

Retrieve Oracle Version
Hello. I am a Unix administrator, learning Oracle. I'd like to have a Perl script run and collect the Oracle version from numerous servers, all running HP-UX. I know that I can log in via sqlplus as the system user and run "SELECT * FROM V$VERSION" however, I was wondering if there was a way to get the Oracle version without accessing the system views. Ideally, I'd like to do this without connecting to the DB at all. I appreciate any help. Tom use /etc/oratab. You'll have the SID and the home directory in that file. Won't capture databases not listed in the ora...

Oracle version detail
NOT CONNECTIING to the database, How to find out ON THE OS side Oracle version detail ? thanks On Nov 17, 2:38 pm, "klabu" <noone_at_gmail_dot_com> wrote: > NOT CONNECTIING to the database, > How to find out ON THE OS side Oracle version detail ? > > thanks Use OPatch klabu wrote: > NOT CONNECTIING to the database, > How to find out ON THE OS side Oracle version detail ? > > thanks Parse a file in the bdump or udump directory. Charles Hooper PC Support Specialist K&M Machine-Fabricating, Inc. "klabu" <noone_at_gmail_dot_c...

Oracle Version from SAS
Is there a command or function to find the Version of Oracle DB from SAS, we connect to Oracle through SQL pass through. We running SAS 9.1.3 on Windows 2000.\ TIA, Jeff __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Query the Oracle table that contains that info, see http://www.lazydba.com/oracle/0__34642.html, don't know how correct it is, but certainly looks like the data is available. -----Original Message----- From: owner-sas-l@listserv.uga.edu [mailto:owner-sas-l@listser...

Oracle versions #2
hi. can somebody point me out to any reasource that I can see Oracle compare Standard vs Enterprise vs Standard One? I search over Oracle.com and some search engine could not find anything good enough. On 16 Dec 2006 15:30:29 -0800, joe1977@tlen.pl wrote: >hi. can somebody point me out to any reasource that I can see Oracle >compare Standard vs Enterprise vs Standard One? I search over >Oracle.com and some search engine could not find anything good enough. "Oracle Database 10g Product Family (PDF)" on http://www.oracle.com/technology/products/database/oracle10g/index.ht...

Oracle form version
How can I tell the Oracle forms version of an .fmb file? 4.5, 5.0, 6.0, 6i or 9i ? jhavero@gmail.com (JR) wrote in message news:<123a5c0.0504201046.15446a0e@posting.google.com>... > How can I tell the Oracle forms version of an .fmb file? > 4.5, 5.0, 6.0, 6i or 9i ? Can't think of any way of telling from the .fmb file, other than to try opening it in various versions of the Forms Builder tool. If you try to open it in a version of Forms Builder that's earlier than the one the form was built in you will get an error message. The error message will vary with d...

checking Oracle version
How can I check Oracle version? If I execute procedure with 'select version from v$instance' I get error that 'table or view not exists' because I'm not SYS user. Is any way to check it? Thanks, Jarek Jarek wrote: > How can I check Oracle version? > If I execute procedure with 'select version from v$instance' I get error > that 'table or view not exists' because I'm not SYS user. Is any way to > check it? > > Thanks, > Jarek You can use, dbms_utility.db_version(version => :version, ...

How could I find oracle version?
OK, oracle instance version is in v$instance. What about the database? I have dbf files which I don't have idea what version they are. I would recreate control files but what upgrade script am I supposed to run? Speaking of manageability wouldn't it be wonderful to have a unified script so that it would be oracle who would have to figure out from what version to upgrade, not poor me? "Mikito Harakiri" <mikharakiri@ywho.com> wrote in message news:umQ2b.14$533.253@news.oracle.com... > OK, oracle instance version is in v$instance. What about the database?...

Free Oracle version
Hi, I've heard about a free Oracle database version (that could be a "lite" version or something else). Is that true ? Does anyone know more about it ? Thanks in advance :) - AureL - "AureL" <aurela@ifrance.com> wrote in message news:p9tRd.15716$dZ.715189@news20.bellglobal.com... > Hi, > > I've heard about a free Oracle database version (that could be a "lite" > version or something else). > > Is that true ? > Does anyone know more about it ? > > Thanks in advance :) > > - AureL - ...

Oracle and Version Control
Hello all, Say I have a worst case scenario in my development environment where our production server and our version control are out of sync. We know that the production server code is complete and accurate, and what needs to be in version control. Does anyone have any suggestions for automating the export of the source code, triggers, tables, functions, and packages that consist of the applicaiton I'm trying to sync up into version control? --Thanks in advance, CW Redrobot5050 wrote: > Hello all, > > Say I have a worst case scenario in my development enviro...

Trial version of Oracle?
Hi Folks: I'm starting a job in a few weeks. Part of the duties is to write PL/SQL in addition to the Java coding. I'm experienced with Java and JDBC. I don't know PL/SQL but have a book. I know SQL and have worked in an Oracle environment. Just not with packages and such... Is there such a thing as a "trial-trimmed" down version of Oracle that I might be able to load on my PC at home? Just enough for me to learn how to write some basic PL/SQL procedures? I would like to create a simple test database with 1 or 2 test tables and then play around wi...

Oracle Client versions and upgrading
I have currently Oracle 8.0.5 installed with the standard Oracle Client provided with this version. I tried to use the OracleClient ADO.NET Data provider which require OraOleDb provided in version 8.1.7.3 . Here is my current config for oracle INVENTAIRE DE (inf02/10.0.1.52) : DEFAULT_HOME Oracle Installer 3.3.1.0.0C Oracle TCP/IP Protocol Adapter 8.0.5.0.0 Oracle Named Pipes Protocol Adapter 8.0.5.0.0 Oracle8 Utilities 8.0.5.0.0 Required Support Files 8.0.5.0.0 Oracle Net8 Client 8.0.5.0.0 SQL*Plus 8.0.5.0.0 Oracle Net8 Assistant 8.0.5.0.0 Oracle Docume...