Oracle Database tutorial backup
I copied the database folder in "d: oracleoradata" and the database folder in "d: oracleadmin" from machine a to the corresponding folder in machine B, and then changed the listener. ora, tnsnames. ora File
The listener. ora file is
# Listener. ora network configuration file: d: oracleora92networkadminlistener. ora
# Generated by oracle configuration tools.
Listener =
(Description_list =
(Description =
(Address_list =
(Address = (protocol = ipc) (key = extproc0 ))
)
(Address_list =
(Address = (protocol = tcp) (host = wangpei) (port = 1521 ))
)
)
)
Sid_list_listener =
(Sid_list =
(Sid_desc =
(Sid_name = plsextproc)
(Oracle_home = d: oracleora92)
(Program = extproc)
)
(Sid_desc =
(Global_dbname = jiegou)
(Oracle_home = d: oracleora92)
(Sid_name = jiegou)
)
(Sid_desc =
(Global_dbname = jiegou2)
(Oracle_home = d: oracleora92)
(Sid_name = jiegou2)
)
)
Tnsnames. ora File
# Tnsnames. ora network configuration file: d: oracleora92networkadmintnsnames. ora
# Generated by oracle configuration tools.
Jiegou =
(Description =
(Address_list =
(Address = (protocol = tcp) (host = wangpei) (port = 1521 ))
)
(Connect_data =
(Service_name = jiegou)
)
)
Instanchttp =
(Description =
(Address_list =
(Address = (protocol = tcp) (host = wangpei) (port = 1521 ))
)
(Connect_data =
(Server = shared)
(Service_name = modose)
(Presentation = http: // hrservice)
)
)
Extproc_connection_data =
(Description =
(Address_list =
(Address = (protocol = ipc) (key = extproc0 ))
)
(Connect_data =
(Sid = plsextproc)
(Presentation = ro)
)
)
Jiegou2 =
(Description =
(Address_list =
(Address = (protocol = tcp) (host = wangpei) (port = 1521 ))
)
(Connect_data =
(Service_name = jiegou2)
)
)
Here, jiegou2 is a new database created by myself, which should not be affected.
But with plsql login error ora-12500: tns: Listeners cannot start dedicated server process
There are two problems: ① It is reasonable to say that this method is correct. It is estimated that I did not have a ing relationship in oracle. I don't know if anyone has encountered a similar problem, discuss whether this method can be implemented
② Ora-12500 this error I also checked on the Internet