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
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
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
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
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
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
LEARN ABOUT CENTOS
pmlookupindom
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)