4 added 831 characters in body
source | link

I am trying to learn how to use RMAN , version is 12.2 Read Oracle documentation.... It talked about setting up a Ghost instance first... Thought I did what it supposes to do, 1. copy password file from source and rename it 2. edit listenor.ora to add a static entry for the Ghost instance 3. edit tnsnames.ora to add an entry for the Ghost instance

but when I tried to do RMAN connect to the Ghost instance

it said ORA-12560: TNS:protocol adapter error

I am not sure what did I miss any help is appreciated.

Thank you

Hi Everyone,

I kind of find the solution myself... anyhow... Oracle Documentation is pretty rough.... but they need to support so many different platforms so it is understandable... anyhow... I meant Ghost instance is like an instance which has nothing but init file and password file and folder structures...

I am in windows env

what I did is use Oracle Database configuration assistant to create a dummy instance with the same feature as the source (no Oracle Auto Naming) then I modify the init file to add the DB_FILE_NAME_CONVERT AND LOG_FILE_NAME_CONVERT parameters, then restart the instance nomount then the RMAN works successfully.... duplicating the instance.... I cannot manually create the "Ghost" instance.

I now will go to next chapter trying to do data-guard....

exact detail steps :

  1. First use Oracle Database Configuration Assistant to create a instance B12C make sure use the same feature as the source instance such as both turn off Oracle Auto Naming

1.5. setup A12C and B12C on both tsnames.ora for both source and destinations server and tested it

  1. modify parameter file add these rows :

*.DB_FILE_NAME_CONVERT=('c:\oracle\oradata\a12c','l:\oracle122\oradata\b12c') *.LOG_FILE_NAME_CONVERT=('c:\oracle\oradata\a12c','l:\oracle122\oradata\b12c')

  1. remove this line from parameter file :

*.undo_tablespace='UNDOTBS1'

  1. copy the init text file into spfile

  2. restart B12C nomount

  3. run this in dos

rman target sys/xxxxx@a12c auxiliary sys/xxxx@b12c

rman> duplicate target database to b12c from active database using backupset;

I am trying to learn how to use RMAN , version is 12.2 Read Oracle documentation.... It talked about setting up a Ghost instance first... Thought I did what it supposes to do, 1. copy password file from source and rename it 2. edit listenor.ora to add a static entry for the Ghost instance 3. edit tnsnames.ora to add an entry for the Ghost instance

but when I tried to do RMAN connect to the Ghost instance

it said ORA-12560: TNS:protocol adapter error

I am not sure what did I miss any help is appreciated.

Thank you

Hi Everyone,

I kind of find the solution myself... anyhow... Oracle Documentation is pretty rough.... but they need to support so many different platforms so it is understandable... anyhow... I meant Ghost instance is like an instance which has nothing but init file and password file and folder structures...

I am in windows env

what I did is use Oracle Database configuration assistant to create a dummy instance with the same feature as the source (no Oracle Auto Naming) then I modify the init file to add the DB_FILE_NAME_CONVERT AND LOG_FILE_NAME_CONVERT parameters, then restart the instance nomount then the RMAN works successfully.... duplicating the instance.... I cannot manually create the "Ghost" instance.

I now will go to next chapter trying to do data-guard....

I am trying to learn how to use RMAN , version is 12.2 Read Oracle documentation.... It talked about setting up a Ghost instance first... Thought I did what it supposes to do, 1. copy password file from source and rename it 2. edit listenor.ora to add a static entry for the Ghost instance 3. edit tnsnames.ora to add an entry for the Ghost instance

but when I tried to do RMAN connect to the Ghost instance

it said ORA-12560: TNS:protocol adapter error

I am not sure what did I miss any help is appreciated.

Thank you

Hi Everyone,

I kind of find the solution myself... anyhow... Oracle Documentation is pretty rough.... but they need to support so many different platforms so it is understandable... anyhow... I meant Ghost instance is like an instance which has nothing but init file and password file and folder structures...

I am in windows env

what I did is use Oracle Database configuration assistant to create a dummy instance with the same feature as the source (no Oracle Auto Naming) then I modify the init file to add the DB_FILE_NAME_CONVERT AND LOG_FILE_NAME_CONVERT parameters, then restart the instance nomount then the RMAN works successfully.... duplicating the instance.... I cannot manually create the "Ghost" instance.

I now will go to next chapter trying to do data-guard....

exact detail steps :

  1. First use Oracle Database Configuration Assistant to create a instance B12C make sure use the same feature as the source instance such as both turn off Oracle Auto Naming

1.5. setup A12C and B12C on both tsnames.ora for both source and destinations server and tested it

  1. modify parameter file add these rows :

*.DB_FILE_NAME_CONVERT=('c:\oracle\oradata\a12c','l:\oracle122\oradata\b12c') *.LOG_FILE_NAME_CONVERT=('c:\oracle\oradata\a12c','l:\oracle122\oradata\b12c')

  1. remove this line from parameter file :

*.undo_tablespace='UNDOTBS1'

  1. copy the init text file into spfile

  2. restart B12C nomount

  3. run this in dos

rman target sys/xxxxx@a12c auxiliary sys/xxxx@b12c

rman> duplicate target database to b12c from active database using backupset;

3 added 794 characters in body
source | link

I am trying to learn how to use RMAN , version is 12.2 Read Oracle documentation.... It talked about setting up a Ghost instance first... Thought I did what it supposes to do, 1. copy password file from source and rename it 2. edit listenor.ora to add a static entry for the Ghost instance 3. edit tnsnames.ora to add an entry for the Ghost instance

but when I tried to do RMAN connect to the Ghost instance

it said ORA-12560: TNS:protocol adapter error

I am not sure what did I miss any help is appreciated.

Thank you

Hi Everyone,

I kind of find the solution myself... anyhow... Oracle Documentation is pretty rough.... but they need to support so many different platforms so it is understandable... anyhow... I meant Ghost instance is like an instance which has nothing but init file and password file and folder structures...

I am in windows env

what I did is use Oracle Database configuration assistant to create a dummy instance with the same feature as the source (no Oracle Auto Naming) then I modify the init file to add the DB_FILE_NAME_CONVERT AND LOG_FILE_NAME_CONVERT parameters, then restart the instance nomount then the RMAN works successfully.... duplicating the instance.... I cannot manually create the "Ghost" instance.

I now will go to next chapter trying to do data-guard....

I am trying to learn how to use RMAN , version is 12.2 Read Oracle documentation.... It talked about setting up a Ghost instance first... Thought I did what it supposes to do, 1. copy password file from source and rename it 2. edit listenor.ora to add a static entry for the Ghost instance 3. edit tnsnames.ora to add an entry for the Ghost instance

but when I tried to do RMAN connect to the Ghost instance

it said ORA-12560: TNS:protocol adapter error

I am not sure what did I miss any help is appreciated.

Thank you

I am trying to learn how to use RMAN , version is 12.2 Read Oracle documentation.... It talked about setting up a Ghost instance first... Thought I did what it supposes to do, 1. copy password file from source and rename it 2. edit listenor.ora to add a static entry for the Ghost instance 3. edit tnsnames.ora to add an entry for the Ghost instance

but when I tried to do RMAN connect to the Ghost instance

it said ORA-12560: TNS:protocol adapter error

I am not sure what did I miss any help is appreciated.

Thank you

Hi Everyone,

I kind of find the solution myself... anyhow... Oracle Documentation is pretty rough.... but they need to support so many different platforms so it is understandable... anyhow... I meant Ghost instance is like an instance which has nothing but init file and password file and folder structures...

I am in windows env

what I did is use Oracle Database configuration assistant to create a dummy instance with the same feature as the source (no Oracle Auto Naming) then I modify the init file to add the DB_FILE_NAME_CONVERT AND LOG_FILE_NAME_CONVERT parameters, then restart the instance nomount then the RMAN works successfully.... duplicating the instance.... I cannot manually create the "Ghost" instance.

I now will go to next chapter trying to do data-guard....

2 Added the [oracle] and [oracle-12c] tags
| link
1
source | link