moving oracle database server into a new server
Hi all I will be moving oracle from one Solaris server into another Solaris server, the IP address and box name will be changed. Oracle version is 8.1.7 and O/S is 5.8 on both servers ( just different O/S patch). Does any one know what I need to do in order to get oracle up and running again on the new server. I know that I will need to change the tnsnames.ora and listner.ora, but is there anything else that I need to do? Thanks Teresa Teresa wrote: > Hi all > > I will be moving oracle from one Solaris server into another Solaris > server, the IP address and box name will be changed. Oracle version is > 8.1.7 and O/S is 5.8 on both servers ( just different O/S patch). > Does any one know what I need to do in order to get oracle up and > running again on the new server. I know that I will need to change the > tnsnames.ora and listner.ora, but is there anything else that I need > to do? > > Thanks > Teresa When I do this with windows boxes I either: #1 Install oracle on the new box, create a new database and export/import from old db to new db #2 Copy datafiles, init, sqlnet, tns.. etc over from coldbackup or shutdown old_database, startup nomount and recreate the controlfile to fit new environment. #3 Restore from online backup of old_database and apply redo logs, again recreating the controlfile to fit the new env. (I usually only do this for "practice" and for creating a development copy of a prod db) #2 ...

Oracle database Server 9.2 fails to start when Windoes 2000 Pro machine rebooted
Hi, I installed the Personal Edition of Oracle 9.2 server on my Windows 2000 Professional machine. Immediately after installation, the DB worked fine, responding to client connections and SQL queries. But after I restarted my machine, the server is not responding to client connections - giving TNS:no listener error in the net8 configuration assistant. Can any one help and point out what might eb the reason, and how to fix it? I tried creating new DBs but was unable to connect, even though there was no hiccup during installation. However, the log files seem to show the server starting when i reboot the machine. following is the contents of log trace file: Dump file c:\ora9ias\admin\mntest1\udump\mntest1_ora_1340.trc Tue Jun 01 21:54:52 2004 ORACLE V9.2.0.1.0 - Production vsnsta=0 vsnsql=12 vsnxtr=3 Windows 2000 Version 5.0 Service Pack 4, CPU type 586 Personal Oracle9i Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production Windows 2000 Version 5.0 Service Pack 4, CPU type 586 Instance name: mntest1 Redo thread mounted by this instance: 0 <none> Oracle process number: 12 Windows thread id: 1340, image: ORACLE.EXE *** 2004-06-01 21:54:52.000 *** SESSION ID:(9.1) 2004-06-01 21:54:51.000 (blkno = 0xe3, size = 276, max = 1, in-use = 1, last-recid= 0) (blkno = 0xe4, size = 56, max = 72, in-use = 1, last-recid= 1) Thread checkpoint rba:0x000007.00000002.0010 scn:0x0000.0010aaf4 On-disk rba:0x...

How do I check which Oracle Patches are appplied to an Oracle DataBase Server
I would like to know if someone could help me with this topic, I'm traying to analize and chek which Oracle Patches are appplied to an Oracle DataBase Server >chek which Oracle Patches are appplied to an Oracle DataBase Server If they were applied with oPatch, then "opatch lsinventory" should show you what's there. If you did not use oPatch, then I have no clue. ;-) BD wrote: > >chek which Oracle Patches are appplied to an Oracle DataBase Server > > If they were applied with oPatch, then "opatch lsinventory" should show > you what's there. > > If you did not use oPatch, then I have no clue. ;-) For better or worse ( we know the answer ) opatch is the tool that install patches from oracle support. "If you did not use oPatch" ... what? >"If you did not use oPatch" ... what? In my 8i environments, there are separate scripts that are run - for example, for a cpu, it would be 'install_cpu.sh'. In those cases, I really don't know how (if) one can confirm which patches have been applied to an environment. ...

Oracle 9i Database Server on Windows 2003 Server
I am wondering if we can install this Server on Windows 2003 Server without any problems. Is there anybody that did that before? Thanks in advance if someone know the answer. Yvon Bouchard, B. Sc. Computer Science Teacher http://info.cegepat.qc.ca/siteyvon I've installed it on windows 2003 enterprise ed. about 1 month ago without any problem. I've installed the version 9.2.0.1 with the patch to 9.2.0.3. 9.2.0.3 is the only version certified by oracle for win 2003. Ciao "Yvon Bouchard" <yvon.bouchard@cablevision.qc.ca> ha scritto nel messaggio news:QCLvb.21605$ZF1.2102185@news20.bellglobal.com... > I am wondering if we can install this Server on Windows 2003 Server without > any problems. > Is there anybody that did that before? > Thanks in advance if someone know the answer. > > Yvon Bouchard, B. Sc. Computer Science > Teacher > http://info.cegepat.qc.ca/siteyvon > > > Yvon Bouchard wrote: > > I am wondering if we can install this Server on Windows 2003 Server without > any problems. > Is there anybody that did that before? > Thanks in advance if someone know the answer. > Although I have not installed on Windows 2003 myself, I know of several such installations and all occurred without issue. I do note that Oracle has a separate download (CD set) for the WIndows 2003 compared to NT/2000/XP, so I suspect the install for the latter may not be ...

Oracle databases on a server
I have Oracle installation on a SUN UNIX server. I tappears that it is running Oracle 10.2 and Solaris 8. I want to find out how many databases are installed on this server. Would it be true to say that all databases installed on this server are listed in tnsnames.ora where the 'HOST' entry points to this server? On Feb 20, 9:00=A0am, p...@qantas.com.au wrote: > I have Oracle installation on a SUN UNIX server. I tappears that it is > running Oracle 10.2 and Solaris 8. > > I want to find out how many databases are installed on this server. > > Would it be true to say that all databases installed on this server > are listed in tnsnames.ora where the 'HOST' entry points to this > server? No, these might be different *services* served by the same instance. The first place to look at is /var/opt/oracle/oratab file, which should list all Oracle instances on your host. If your Oracle installation follows OFA (Optimal Flexible Architecture,) which is usually true, count $ORACLE_BASE/admin/<dbname> directories - each database should have its own directory under admin. Alternatively, you can also count spfile<SID>.ora files in $ORACLE_HOME/dbs directory. Hth, Vladimir M. Zakharychev N-Networks, makers of Dynamic PSP(tm) http://www.dynamicpsp.com On 20 Feb, 06:00, p...@qantas.com.au wrote: > I have Oracle installation on a SUN UNIX server. I tappears that it is > running Oracle 10.2 and Solaris 8. > > I want...

Importing sql server 7/2000 database into Oracle
Hi, Is it possible to import a MS sql server 7 or 2000 database into Oracle? Also, if this is possible, would it be better to just import tables and no stored procedures? thanks, Ellie Tables and indexes only surely - have you compared the stored procedures in SqlServer and Oracle! Every one I have ever seen have been quite different. Regards Kevin "E Sullivan" <ellie999nospam@nospamptd.net> wrote in message news:2LGdnUSaYJzJ66bdUSdV9g@ptd.net... > Hi, > > Is it possible to import a MS sql server 7 or 2000 database into Oracle? > Also, if this is possible, would it be better to just import tables and no > stored procedures? > > thanks, > > Ellie > > The stored procedures probably won't be needed so that's ok. I think the difference may be because mssql server uses "transact sql" which is their version of sql statements. Did we really expect MS to play nicely! Can the database be attached/imported or would I have to create a delimited text file? Thanks again. "Kevin A Lewis" <Kevin_A_Lewis@Hotmail.com> wrote in message news:UjL_b.22$mj7.1@newreader.ukcore.bt.net... > Tables and indexes only surely - have you compared the stored procedures in > SqlServer and Oracle! Every one I have ever seen have been quite different. > > Regards Kevin > > "E Sullivan" <ellie999nospam@nospamptd.net> wrote in message > news:2LGdnUSaYJzJ66bdUSdV9g@ptd.net... >...

Importing sql server 7/2000 database to Oracle
Hi, Is it possible to import a MS sql server 7 or 2000 database into Oracle? Also, if this is possible, would it be better to just import tables and no stored procedures? thanks, Ellie E Sullivan wrote: > Hi, > > Is it possible to import a MS sql server 7 or 2000 database into Oracle? > Also, if this is possible, would it be better to just import tables and no > stored procedures? > > thanks, > > Ellie What do you mean by "import"? If you mean dump the data as a delimited text file and use SQL*Loader. Yes. But do keep in mind you will need to translate some data types and autonumbering columns do not exist. -- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan@x.washington.edu (replace 'x' with a 'u' to reply) Thanks, Daniel. Yes, that is what I want. Now about the autonumbering columns: as long as we aren't going to add to the database and expect autonumbering, I can still have that column, right? That's what it sounds like. thanks again. "Daniel Morgan" <damorgan@x.washington.edu> wrote in message news:1077639180.433784@yasure... > E Sullivan wrote: > > > Hi, > > > > Is it possible to import a MS sql server 7 or 2000 database into Oracle? > > Also, if this is possible, would it be better to ju...

SqlSpec
Do you wish you had comprehensive, easily navigable documentation for your SQL Server, Oracle, Analysis Server, MySQL, and Access databases? Are you a SQL Developer or DBA that just inherited a huge, complex database with no supporting docs and don't know where to start learning how it's put together? Are you an independent contractor working with SQL Server, Oracle, Analysis Server, MySQL, or Access? Your clients would LOVE you if you could provide comprehensive documentation about the databases you build. Are you a Project Manager who is tired of developers making changes to databases on live servers and not updating the corresponding spec? SqlSpec will make sense of it all and generate easy-to-read docs for you for any database on the following platforms: * SQL Server 2000/2005 * Oracle 9i (and above) * MySQL 5.0 (and above) * Analysis Server 2005 * Access 97/2000/XP/2003 SqlSpec generates documentation in two formats: HTML or CHM. HTML is useful for publishing your documents on the web or an intranet site. CHM is useful if you want a single, compact file containing all your documentation about one or more databases. The CHM is indexed so it is easily searchable for any keyword. This way you can easily determine which objects reference the "EmployeeID" column, for example. You can download a fully featured trial version here: http://www.elsasoft.org ...

Oracle 8i and 9i Database concurrently on Windows 2000 Server
I am trying to install Oracle 8i and 9i Database server on same machine , but I am getting getting various errors.. I cannot start TNSListener servive of both 8i and 9i simultaneously. If i try to login to 8i Database using scott / tiger or try to create a database , I get "Tns protocol error". Cannot complete Net8 configuration and Database configuration while installing 8i Database server. Please help me for same as i tried installing 8i for many times. I have kept different home names for both 8i and 9i. Forms 6i and D2k 4.5 is already installed on the M/c. Is there any sequence for these installations. "Mayura" <mayura.jadhav@gmail.com> ha scritto nel messaggio news:1140675978.019512.31510@z34g2000cwc.googlegroups.com... >I am trying to install Oracle 8i and 9i Database server on same machine > , but I am getting getting various errors.. > > I cannot start TNSListener servive of both 8i and 9i simultaneously. > If i try to login to 8i Database using scott / tiger or try to create a > database , I get "Tns protocol error". Check MetaLink Note 306905.1. Regards, Dimitre Mayura wrote: > I am trying to install Oracle 8i and 9i Database server on same machine > , but I am getting getting various errors.. > > I cannot start TNSListener servive of both 8i and 9i simultaneously. > If i try to login to 8i Database using scott / tiger or try to create a > database , I get "Tns protocol erro...

automate startup /shutdown oracle database server 9i on redhat advance server 3.0
how i automate the oracle database 9i on RedHat Advance server 3.0 automatic startup and shutdown database in linux advance server 3.0 On Mon, 2 Aug 2004 17:06:37 +0500, "Kashif Hameed" <kashifh@shoa.net> wrote: >how i automate the oracle database 9i on RedHat Advance server 3.0 automatic >startup and shutdown database in linux advance server 3.0 > as usual: just read the documentation http://download-uk.oracle.com/docs/pdf/A96167_01.pdf (and please do so prior to posting as to avoid this type of questions) -- Sybrand Bakker, Senior Oracle DBA ...

Restoring Oracle 9.0.1 database from original files (server was rebuilt)
Here's my issue ... our database server was rebuilt but all the original files were backed up before the server was rebuilt. The server was shutdown correctly so I'm not worried about a bad shutdown but I've never done this before. It's on a Windows2000 box. I've reconfigured the server to the same way it was before, but I'm unsure which files and I should exclude and/or include to get the box running the way it was before. Can anyone point me in the right direction to an article that outlines how to do this? I'm more a developer than DBA, but I set up the original box and it ran great. Thanks, Joe On Mar 5, 7:01 pm, sandoval....@gmail.com wrote: > Here's my issue ... our database server was rebuilt but all the > original files were backed up before the server was rebuilt. The > server was shutdown correctly so I'm not worried about a bad shutdown > but I've never done this before. It's on a Windows2000 box. I've > reconfigured the server to the same way it was before, but I'm unsure > which files and I should exclude and/or include to get the box running > the way it was before. > > Can anyone point me in the right direction to an article that outlines > how to do this? I'm more a developer than DBA, but I set up the > original box and it ran great. > > Thanks, > Joe Define 'all the original files'. If these include your controlfiles you should be set, and ...

it's compatible oracle 8i client, compatible whith oracle 9i server (or oracle 10g server)
Hi all, I have a client/server application that work on the client with oracle 8i client connected to oracle 8i server, Im going to upgrade the server to oracle 9i (or oracle10g) , and I wonder if the client will work fine without upgrade version. Thanks Angel R. wrote: > Hi all, > I have a client/server application that work on the client with oracle 8i > client connected to > oracle 8i server, Im going to upgrade the server to oracle 9i (or oracle10g) > , and > I wonder if the client will work fine without upgrade version. > > Thanks If you have access to the metalink then check the connect matrix at http://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=207303.1 Regards /Rauf ...

oracle database 9.2.0.8 32bit and windows server 2003 64bit
Hello! What about configuration like in subject... What about memory limits on 32bits? Can i rise sga more then 2GB? on 64 bit system but using 32 bit database? Any suggestion? Regards - MJ On 15 apr, 11:16, "hehehe" <m...@m.ccc> wrote: > Hello! > > =A0 =A0 What about configuration like in subject... What about memory lim= its on > 32bits? Can i rise sga more then 2GB? on 64 bit system but using 32 bit > database? Any suggestion? > > Regards - MJ Obviously, with only a little bit of thinking, you would have reached the conclusion, limits are determined by the OS of the database server. -- Sybrand Bakker Senior Oracle DBA thx. I will check Uzytkownik "sybrandb" <sybrandb@gmail.com> napisal w wiadomosci news:b5d54371-bf21-439b-85c3-ae21dafc21be@3g2000yqk.googlegroups.com... On 15 apr, 11:16, "hehehe" <m...@m.ccc> wrote: > Hello! > > What about configuration like in subject... What about memory limits on > 32bits? Can i rise sga more then 2GB? on 64 bit system but using 32 bit > database? Any suggestion? > > Regards - MJ Obviously, with only a little bit of thinking, you would have reached the conclusion, limits are determined by the OS of the database server. -- Sybrand Bakker Senior Oracle DBA On Apr 15, 5:16=A0am, "hehehe" <m...@m.ccc> wrote: > Hello! > > =A0 =A0 What about configuration like in subject... What about memory lim= its on &g...

How to copy table from oracle database to sqlserver database ?
Hello, I need to copy a table from an 8i oracle database to a sqlserver 2000 database. Is it possible to use the command "COPY FROM ... TO ..." ? So, what is the correct syntax ? Thanks for your help Cyril "Cyril" <jewelk@free.fr> wrote in message news:cd38c3d6.0408100617.6f7b9f3e@posting.google.com... > Hello, > > I need to copy a table from an 8i oracle database to a sqlserver 2000 database. > > Is it possible to use the command "COPY FROM ... TO ..." ? > So, what is the correct syntax ? > > > Thanks for your help > &...

How to copy table from oracle database to sqlserver database ?
Hello, I need to copy a table from an 8i oracle database to a sqlserver 2000 database. Is it possible to use the command "COPY FROM ... TO ..." ? So, what is the correct syntax ? Thanks for your help Cyril On 10 Aug 2004, jewelk@free.fr wrote: > Hello, > > I need to copy a table from an 8i oracle database to a > sqlserver 2000 database. A few options exist. If this is one-off, just use sqlldr to drop the data to a file and then bcp to get it into SQLServer. > Is it possible to use the command "COPY FROM ... TO ..." ? > So, what is the correct syntax ? Well, I'm sure SQLServer has connectivity to Oracle? If you want to go this route, use that and do this from SQLServer. -- Galen Boyer On 10 Aug 2004 07:15:16 -0700, jewelk@free.fr (Cyril) wrote: >Hello, > >I need to copy a table from an 8i oracle database to a sqlserver 2000 database. > >Is it possible to use the command "COPY FROM ... TO ..." ? >So, what is the correct syntax ? > > >Thanks for your help > >Cyril Read up on using the Heterogeneous Gateway to Sqlserver. -- Sybrand Bakker, Senior Oracle DBA "Cyril" <jewelk@free.fr> wrote in message news:cd38c3d6.0408100615.6371b40e@posting.google.com... > Hello, > > I need to copy a table from an 8i oracle database to a sqlserver 2000 database. > > Is it possible to use the command "...

tcl database connection for Oracle MySQL PostgreSQL Sybase "Microsoft SQL Server 2000 Desktop Engine" DB2 Interbase/Firebird SQLite Microsoft Access
Hello everyone, There are many people that are looking for/missing the support for their database within TCL. Somehow this was overlooked: http://sqlrelay.sourceforge.net/index.html It has native TCL API and supports most popular databases. One problem: It doesn't have production ready support on Windows, but for the lucky people who use Linux/Unix, it seems to be an excellent solution, while TDBC is being developed. One small correction, the TCL part of the db connection will work just fine on Windows connecting to sqlrelay running on Linux/Unix (which, in turn, can connect to the database running on Windows :) ). What doesn't have production ready support (according to developers) is sqlrelay running on Windows. ...

Question on Oracle Server 10g Install (.../oracle/oracle/.....
I am in the last stages of installing Oracle Server 10gR2 Enterprise Edition on a UNIX AIX server. When window "Execute Configuration Scripts" comes up it tells me to execute "/u01/app/oracle/oracle/product/10.2.0/db_1/root.sh". The ".../oracle/oracle/..." stops me cold. I look back in my notes and everything I wrote suggests I had entered ".../oracle/product/....." for my ORACLE_HOME. I look at the install log in /u01/app/oracle/oraInventory/logs and see: "INFO: Setting variable 'ORACLE_HOME' to '/u01/app/oracle/oracle/product/10.2.0/d b_1'. Received the value from the command line." Did I really key /oracle/oracle/ instead of /oracle/ or did the OUI change the path for some reason????? Thank you, Bill bfogarty@gaports.com wrote: > I am in the last stages of installing Oracle Server 10gR2 Enterprise > Edition on a UNIX AIX server. When window "Execute Configuration > Scripts" comes up it tells me to execute > "/u01/app/oracle/oracle/product/10.2.0/db_1/root.sh". > > The ".../oracle/oracle/..." stops me cold. I look back in my notes and > everything I wrote suggests I had entered ".../oracle/product/....." > for my ORACLE_HOME. I look at the install log in > /u01/app/oracle/oraInventory/logs and see: > "INFO: Setting variable 'ORACLE_HOME' to > '/u01/app/oracle/oracle/product/10.2.0/d > b_1'. Received the valu...

Sun server with Oracle Database crashed
Hi All, My Sun server which is running Oracle database 10.2.0.3.0 got hung and the server had also crashed. The /DBATSTDB01/oracle mount point which is mounted on slice c1t0d0s3 is 100%. It is reflecting /var/adm/messages: Aug 31 15:40:43 blrtstdba02 ufs: [ID 845546 kern.notice] NOTICE: alloc: /DBATSTDB01/oracle: file system full The root slice " / " is occupied 82 %. After the crash, although the /DBATSTDB01/oracle slice is 100% full, the system hasn't hung so far. Is the /DBATSTDB01/oracle slice is causing the system to hang or should I check for hardware issues? Filesystem kbytes used avail capacity Mounted on /dev/dsk/c1t0d0s0 11093692 9000920 1981836 82% / /devices 0 0 0 0% /devices ctfs 0 0 0 0% /system/ contract proc 0 0 0 0% /proc mnttab 0 0 0 0% /etc/mnttab swap 2547944 1088 2546856 1% /etc/svc/ volatile objfs 0 0 0 0% /system/object /platform/sun4u-us3/lib/libc_psr/libc_psr_hwcap1.so.1 11093692 9000920 1981836 82% /platform/sun4u-us3/lib/libc_psr.so.1 /platform/sun4u-us3/lib/sparcv9/libc_psr/libc_psr_hwcap1.so.1 11093692 9000920 1981836 82% /platform/sun4u-us3/lib/sparcv9/libc_psr.so. 1 /dev/dsk/c1t0d0s5 6050982 1646347 4344126 28% /var swap 2554304 7448 254685...

databases.oracle.server job link
http://www.jobbankdata.com http://www.jobbankdata.com/index.htm http://www.jobbankdata.com/type-of-jobs.htm http://www.jobbankdata.com/find-job.htm http://www.jobbankdata.com/result.htm http://www.jobbankdata.com/create-app.htm http://www.jobbankdata.com/create-cv.htm http://www.jobbankdata.com/interview.htm http://www.jobbankdata.com/site.htm On Mar 12, 10:29 am, "good_online_jobs" <good_online_j...@yahoo.com> wrote: > http://www.jobbankdata.comhttp://www.jobbankdata.com/index.htmhttp://www.jobbankdata.com/type-of-jobs.htmhttp://www.jobbankdata.com/find-job.htmhttp://www.jobbankdata.com/result.htmhttp://www.jobbankdata.com/create-app.htmhttp://www.jobbankdata.com/create-cv.htmhttp://www.jobbankdata.com/interview.htmhttp://www.jobbankdata.com/site.htm Would you please stop violating the newsgroup terms of use by posting this useless non-Oracle related crapola. Sites supported by such unethical postings are not work visiting. -- Mark D Powell -- ...

install oracle database server at home
Hi I am thinking of setting up an oracle database on my home computer - possibly Oracle 9i. I am wondering what spec (in terms of RAM especially) I would need. Any assistance would be appreciated. Cheers B. Baz wrote: > Hi > > I am thinking of setting up an oracle database on my home computer - > possibly Oracle 9i. I am wondering what spec (in terms of RAM > especially) I would need. Any assistance would be appreciated. > > Cheers > B. Practical minimums: - Pentium 600 - 512M Ram - 5G free disk - NOT Windows "Home" edition (XP Home, ME ...) - Prefer Linux or perhaps Windows 2000 Pro, XP Pro It is theoretically possible to go dn to 256M RAM but that becomes more an exercise in frustration. /Hans ...

snap servers and suitability for oracle databases
hi I'm looking at purchasing a snap server 18000, but i'm getting conflicting messages with regards to its suitability for providing oracle storage. I'd have another machine with the oracle installation connecting to the storage either iscsi or nfs . Has anyone used any of the snap range for oracle databases ? I don't need super high perfornance, just a decent environment for development. Elaine On 4 Jan 2006 04:23:16 -0800, cmappy@hotmail.com wrote: >hi >I'm looking at purchasing a snap server 18000, but i'm getting >conflicting messages with ...

Oracle server 9.2.0.1.0, Client 9.2.0.4.0, Red Hat Linux enterprise advanced server 2.1
Hi Everybody, My Database server is running on Red Hat Linux enterprise advanced server 2.1, And my Oracle version is 9.2.0.1.0. My Client mechine also Red Hat Linux enterprise advanced server 2.1 , Oracle client version is 9.2.0.4.0. I am running a web application. Our application is in Magic edeveloper. I connect to Oracle using oracle gateway to my application. My Problem is my application is is becoming slow. I am not able to trace where the problem is. Before our application was running fine. recently i upgraded Oracle client version to 9.2.0.4.0. My Oracle client & server versions are different. I am getting error on my client mechine, it showing all memory address on the screen and the part of error is, arg register addr=83498cc .... Dump of memory from 0x83988c to 0x83499cc .... -- End of Call stack trace -- I am not able to trace where the problem is.Any insight please... Thanks, Ssreddy. ...

sql command to list all databases in the oracle server
Hi, could u help me, what is the sql command to list all existing databases in a oracle server? dalu.gelu@gmail.com wrote: > Hi, > > could u help me, what is the sql command to list all existing databases > in a oracle server? Please read the Oracle Concepts Manual. There are Instances and Databases and Schemas. There is no such thing as multiple databases in a single instance. There are multiple schemas! (select distinct owner from dba_tables) Multiple instances can only be listed on O/S level. -- Sybrand Bakker Senior Oracle DBA only one database in oracle server, see v$database view sybrandb wrote: > dalu.gelu@gmail.com wrote: > > Hi, > > > > could u help me, what is the sql command to list all existing databases > > in a oracle server? > > Please read the Oracle Concepts Manual. > There are Instances and Databases and Schemas. > There is no such thing as multiple databases in a single instance. > There are multiple schemas! (select distinct owner from dba_tables) > Multiple instances can only be listed on O/S level. > > -- > Sybrand Bakker > Senior Oracle DBA dalu.gelu@gmail.com wrote: > could u help me, what is the sql command to list all existing > databases in a oracle server? Depends what you mean by "database" and "server". If "server" means a physical, computer server and you want to see all the Oracle instances ("databases"), on most ...

Strange Network Error on Oracle Database Server
Hi Oracle Gurus, We are experiencing a strange Oracle database server(Windows 2003) behaviour When we try to start Oracle database from services -- It does not start the database and in Oradim.log we see following error -- ORA-12560: TNS:protocol adapter error and in sqlnet.ora -- Fatal NI connect error 12560, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\oracle\ora90\bin\oradim.exe)(HOST=host02)(USER=SYSTEM)))) However, If I try to manually start the database by login in as sys, it gets started. I have already tried following (a) Recreate the service using Oradim.exe (b) Removed sqlnet.ora file from C:\Oracle\Ora90\network\ADMIN What can be the possible reason(s) for this. Thanks If you can connect to the database instance, even if it is "idle", the service must have started. Without the service having started, you cannot connect via sqlplus.exe even on the server console (on win32). Perhaps it is taking a relatively long time for the database instance to be completely open - and the error message that you show above is a timed out connection attempt? Is the ORACLE_SID of interest "ORCL"? When you re-created the OS Service, did you set the startmode to auto or manual? Is there an init.ora in the %ORACLE_HOME%\database folder that has an IFILE entry to the real parameter file? Is the service owned by a...