Sponsored Content
Full Discussion: Moving Oracle database
Special Forums UNIX and Linux Applications Moving Oracle database Post 302609163 by quimera on Monday 19th of March 2012 11:22:36 AM
Old 03-19-2012
Hi,

If you want to move a instance Oracle to new o.s., use "exp" program to create a file with all structure and data, after you must create a new instance in new o.s. and to use "imp" to import the structure and data to new instance.

..:quimera.
 

5 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Moving data from one database to other

Dear All, I have 2 databases, There is a lot of data in both the databases, i would like to move some data from one database to the other. I would like to accept 2 parameters from the user, i.e. emplyee id & dept, on entering the 2 i will unload all the data from the tables to the flat files.... (6 Replies)
Discussion started by: lloydnwo
6 Replies

2. Shell Programming and Scripting

Moving a database from one server to another

I hope I'm posting this in the correct section. I'm trying to move a database from one server to another. This is the code I'm using... tar czf - vbdatabase.sql | ssh username@full.domain.com 'cat > /home/cpanelusername/vbdatabase.tar.gz ... but all I'm getting is a ">" and then nothing... (4 Replies)
Discussion started by: Chimpie
4 Replies

3. Programming

Oracle Database Query

How can i modify the below to search for the things i'm looking for during a certain time frame? select Node, NodeAlias, Summary, Tally, AlertKey, AlertGroup, Manager, Agent from mrtg_alerts where LastOccurrence > '5-Dec-2010' order by Manager desc; In this particular case, this query is... (3 Replies)
Discussion started by: SkySmart
3 Replies

4. Solaris

Can't create database after Oracle Database installation

I installed Oracle 10 software on Solaris 11 Express, everything was fine execpt I can't create database using dbca.rsp file. I populated file with following options. OPERATION_TYPE = "createDatabase" GDBNAME = "solaris_user.domain.com" SID = "solaris_user" TEMPLATENAME = "General... (0 Replies)
Discussion started by: solaris_user
0 Replies

5. UNIX and Linux Applications

Identify a specific environment Oracle variable to connect a remote Oracle database ?

Good evening I nned your help pls, In an unix server i want to connect to a remote oracle databse server by sqlplus. I tried to find out the user/passwd and service name by env variable and all Ive got is this: ORACLE_SID_REPCOL=SCL_REPCOL ORACLE_SID=xmeta ORACLE_SID_TOL=SCL_PROTOLCOL... (2 Replies)
Discussion started by: alexcol
2 Replies
PMLOOKUPINDOM(3)					     Library Functions Manual						  PMLOOKUPINDOM(3)

NAME
pmLookupInDom - translate an instance name into an instance identifier C SYNOPSIS
#include <pcp/pmapi.h> int pmLookupInDom(pmInDom indom, const char *name); cc ... -lpcp DESCRIPTION
For the instance domain indom, in the current Performance Metrics Application Programming Interface (PMAPI) context, locate the instance with the external identification given by name, and return the internal instance identifier. Only the leading non-space characters of name will be used to identify the instance. The value for the instance domain indom is typically extracted from a pmDesc structure, following a call to pmLookupDesc(3) for a particu- lar performance metric. pmLookupInDom will return a positive instance identifier on success. SEE ALSO
PMAPI(3), pmGetConfig(3), pmGetInDom(3), pmLookupDesc(3), pmLookupInDomArchive(3), pmNameInDom(3), pcp.conf(5) and pcp.env(5). DIAGNOSTICS
PM_ERR_INDOM indom is not a valid instance domain identifier PM_ERR_INST The external instance name is not known for the instance domain indom in the current PMAPI context Performance Co-Pilot PCP PMLOOKUPINDOM(3)
All times are GMT -4. The time now is 02:47 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy