| moving rman backup and restore on new server [message #690230] |
Fri, 13 December 2024 16:37  |
patdev
Messages: 74
Registered: August 2008
|
Member |
|
|
Hello
I am trying to create the clone or test clone of the db.
I have RMAN full backup of the db.
I have copied, pfile,spfile, pwfile,controlfile backup, and db backup to the location.
I have created the pfile and changed the path for log, controlfile, base, adump, dest etc.
then i ran the oradim -new -sid newdb1210 -startmode manual -pfile "L:/pfilelocation"
instance was created
but when i try to do sqlplus / as sysdba it is asking me for userid and password.
what am i doing wrong. and how to solve it.
thanks
|
|
|
|
| Re: moving rman backup and restore on new server [message #690233 is a reply to message #690230] |
Sat, 14 December 2024 00:50  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Here are a few things to check:
Is the Oracle Service running:
get-service OracleService*
Is the listener running:
lsnrctl status
Does your user belong to the ORA_DBA group:
net localgroup ora_dba
Is your ORACLE_HOME in the PATH:
echo %PATH%
Connect:
set ORACLE_SID=newdb1210
sqlplus / as sysdba
Or, after creating the TNSNAMES.ORA entry...
sqlplus /@newdb1210 as sysdba
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
