moving oracle database server into a new serverHi 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 ...
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
...
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...
Oracle 9i Database Server on Windows 2003 ServerI 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 serverI 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...
SqlSpecDo 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
...
automate startup /shutdown oracle database server 9i on redhat advance server 3.0how 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
...
Best way to check oracle database server / services is alive using JavaHi,
I am looking for the best way to check whether several oracle (or any
database) databases is running or not.
At the moment I just attempt to connect to the server IP using Socket
and conclude the database is not running if connection timed out.
Which is a silly way of doing it.
Appreciate any help.
Best regards.
On Apr 3, 9:56 pm, harishas...@gmail.com wrote:
> Hi,
>
> I am looking for the best way to check whether several oracle (or any
> database) databases is running or not.
> At the moment I just attempt to connect to the server IP using Socket
> and conclude...
WINODS NT SERVER OracleI have Oracle database running on a Windows NT server. I am accessing
the server using Remote Desktop ( A Microsoft Terminal Service
Client). Somone told me that there are limitations in remote desktop,
i.e.,
one cannot start Oracle. I want to know why as well as the
workarounds.
Instead of running everything from the WINDOWS NT server console
wjhich is painful, what are the workraounds. Do same problem exist
with pcAnywhere, VNC desktop, Citrix client.
Thanks,
Prem
On 19 Feb 2004 18:38:10 -0800, premmehrotra@hotmail.com (Prem K
Mehrotra) wrote:
>I have Oracle database running on a Windows NT server. I am accessing
>the server using Remote Desktop ( A Microsoft Terminal Service
>Client). Somone told me that there are limitations in remote desktop,
>i.e.,
>one cannot start Oracle. I want to know why as well as the
>workarounds.
Because Microsoft is Microsoft and Microsoft doesn't support the BEQ
protocol used by Oracle for this purpose.
The only lousy workaround is to use
set local=<tns service name>
prior to connecting to sql*plus in a cmd window.
Also you can't use the lsnrctl program to start and stop the listener
for the same reason. You need to bounce the service.
>
>Instead of running everything from the WINDOWS NT server console
>wjhich is painful, what are the workraounds.
OEM? It works! Need to save the init.ora on the Oracle Enterprise
Management Server, using OEM, but that is about there is.
Or dump Microsux T...
from sql server to oracle to ANOTHER oracleI have a linked server to a oracle db, that works.
I have to write a query from sql server that connecto to the oracle
server, and the use a database link from that oracle db to another
oracle db. I'm not able to find the syntax.
I try to write something like
SELECT * FROM
LINKTOORACLE..mm510TAL.CSHDET@ORAGATE2
but it does not work
questions
1) is is possible to use nested dblinks ?
2) if so, how ?
thank you!
On Nov 10, 10:57=A0am, Alberto Marchi <alberto.rol...@gmail.com> wrote:
> I have a linked server to a oracle db, that works.
>
> I have to write a query from sql server that connecto to the oracle
> server, and the use a database link from that oracle db to another
> oracle db. I'm not able to find the syntax.
>
> I try to write something like
>
> =A0SELECT * FROM
> =A0 LINKTOORACLE..mm510TAL.CSHDET@ORAGATE2
>
> but it does not work
>
> questions
> 1) is is possible to use nested dblinks ?
> 2) if so, how ?
>
> thank you!
use a synonym that points to the second linked table?
On Nov 10, 9:27=A0pm, onedbguru <onedbg...@yahoo.com> wrote:
> On Nov 10, 10:57=A0am, Alberto Marchi <alberto.rol...@gmail.com> wrote:
>
>
>
>
>
> > I have a linked server to a oracle db, that works.
>
> > I have to write a query from sql server that connecto to the oracle
> > server, and the use a database link from that oracle db to another
> > oracle db. I...
How to write shell script to export oracle 8.1.6 database to import oracle 10g databaseHi,
I am trying to write or understand the conj process for export the data
from oracle 8i to oracle 10g database. I have constraint that the
previous loaded data into oracle10g should not be deleted or replace by
newly imported database.
Regards
Nikhil
...
snap servers and suitability for oracle databaseshi
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 ...
install oracle database server at homeHi
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
...
Sun server with Oracle Database crashedHi 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 linkhttp://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 --
...
Strange Network Error on Oracle Database ServerHi 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...
Sqlserver 2000 database on Oracle 9 serverHi!
how could I link a sqlserver 2000 database on a oracle 9 server.
or
how could I import a sqlserver 2000 database in oracle 9 server.
Thanks
Hubert Mayr wrote:
> Hi!
>
> how could I link a sqlserver 2000 database on a oracle 9 server.
> or
> how could I import a sqlserver 2000 database in oracle 9 server.
>
> Thanks
>
Oracle Transparent Gateway.
Heterogeneous services.
ASCII files.
--
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)
Daniel Morgan <damorgan@x.washington.edu> wrote in message news:<1073922683.284194@yasure>...
> Hubert Mayr wrote:
>
> > Hi!
> >
> > how could I link a sqlserver 2000 database on a oracle 9 server.
> > or
> > how could I import a sqlserver 2000 database in oracle 9 server.
> >
> > Thanks
> >
>
> Oracle Transparent Gateway.
> Heterogeneous services.
> ASCII files.
I have read some articles about this, but I am a little confused about
the difference between "Oracle Transparent Gateway" and "Heterogeneous
services".
I want to create a database link so that the application (logging on
to Oracle) will not know whether the table is actually stored in
Oracle or in SQL Server.
Do I need Oracle Transparent Gateway to make this possible or ...
How to migrate my oracle database to another server, plsHi everyone,
I need to migrate an oracle database to another server, but keeping all
equal, like a mirror, i have my original db in Solaris server, need to
change it to windows 2000 server but, like i said, keeping all, table
spaces, data....
how can i do this?, or where can i find information about it?,
I appreciate ur help,
thx
Plactoon
Plactoon wrote:
> Hi everyone,
>
> I need to migrate an oracle database to another server, but keeping all
> equal, like a mirror, i have my original db in Solaris server, need to
> change it to windows 2000 server but, like i said, keeping all, table
> spaces, data....
>
> how can i do this?, or where can i find information about it?,
>
> I appreciate ur help,
>
> thx
>
> Plactoon
And the version and size are irrelevant? ;-)
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
On 1 Aug 2006 15:18:38 -0700, "Plactoon" <elsersupremo@hotmail.com>
wrote:
>Hi everyone,
>
>I need to migrate an oracle database to another server, but keeping all
>equal, like a mirror, i have my original db in Solaris server, need to
>change it to windows 2000 server but, like i said, keeping all, table
>spaces, data....
>
>how can i do this?, or where can i find information about it?,
>
>I appreciate ur help,
>
>thx
>
>Plactoon
That would be an inadvisible ...
sql command to list all databases in the oracle serverHi,
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 ...
[Oracle 9i Personal Edition] Start oracle database...Hi, I've installed the Oracle 9i Personal Edition on my Windows 98
machine.
I've choosed to install only the software and to skip the creation of
a database during installation procedure.
I've restarted the machine and I've made next step to create a
database manually (following the "Oracle 9i Administration Guide":
1. I've created a Password File with the command orapwd in the
$oracle_home directory
The password I've choosed is "secret".
2. I've created an initialization file in the oradata directory with
the name init$db_name.ora
3. I connect with the command sqlplus as user "sys/secret as SYSDBA"
to launch the command "create database"
B U T
at this point when i insert a usr/pwd (i have tryed with
sys/change_on_install as sysdba, system/manager, sys/secret,
scott/tiger, all...) in Windows98 appears a dialog box (the same
obtained clicking on the menu voice "Start Oracle database") that ask
for a password: not a username/password, only a password. I've
inserted the same passed to the orapwd command and all known password
but it say that it's incorrect.
After this I've disinstalled all and reinstalled responding "yes" when
Universal Installer ask to install a database. In this way all run
correctly.
Probably in Windows98 u have to permit the installation of a db to use
oracle.
Probably the installation of ...
Free Ebook Oracle Database & Oracle 9iFree Ebook Oracle Database
Free Oracle 9i Complete Reference Book
http://www.downloadfreepdf.com
On Mar 24, 6:53 am, "steveo" <selectcm...@yahoo.co.uk> wrote:
> Free Ebook Oracle Database
>
> Free Oracle 9i Complete Reference Book
>
> http://www.downloadfreepdf.com
It's all free over at http://tahiti.oracle.com also
...
Mastering Oracle Scheduler in Oracle 11g DatabasesI am proud to be able to tell that finally my book "Mastering Oracle
Scheduler in Oracle 11g Databases" is released. The book tries to fill
the gap between the oracle manuals and the real world by providing
real explanations and examples.
see <http://www.packtpub.com/mastering-oracle-scheduler-in-oracle-11g-
databases> for a detailed description of the book.
Ronald.
...
Mastering Oracle Scheduler in Oracle 11g DatabasesI am proud to be able to tell that finally my book "Mastering Oracle
Scheduler in Oracle 11g Databases" is released. The book tries to fill
the gap between the oracle manuals and the real world by providing
real explanations and examples.
see <http://www.packtpub.com/mastering-oracle-scheduler-in-oracle-11g-
databases> for a detailed description of the book.
Ronald.
...
Patching Oracle Databasehello
I apply patch on Oracle database 11.2.0.4.0 (Patch 18522509)
during patching system ask for creating new ORACLE_HOME (because of
patch conflicts,
so I created it in /ora/app/oracle/product/11.2.0/dbhome_2
I also aply post patch script
but in some places I have old oracle home for example:
-----
select * from dba_libraries where library_name = 'DBMS_SUMADV_LIB' or
library_name = 'ORDIMLIBS'
-----
select * from dba_directories
-----
- Why is that patching proces didn't change that paths to new one?
- Did I made mistake to apply patch...